- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
16 Posted Topics
Re: As i know that we use "CREATE TABLE IF NOT EXISTS session_id ( attribute data type(size) CONSTRAINTS Constraints_Name CONSTRAINTS TYPE, attribute data type(size) CONSTRAINTS Constraints_Name CONSTRAINTS TYPE, attribute data type(size) CONSTRAINTS Constraints_Name CONSTRAINTS TYPE )"; Just Try with that SQL Query | |
Re: You can reduce bounce rate of a site you use following rule....... 1.Good and original content. 2.Clear and proper navigation. 3.Good Quality links. 4.Comparing. 5.Analyze bounce rate. | |
Re: Social network is very beneficial.you have the personal attention of the customer and are even able to have a two way communication with them.your network increase.you build that togetherness.your online reputation is increase. | |
what is article spinner and how can I use it. I have one already but it keeps creating really bad articles and article directories | |
Re: hi, According to me you use mysql in place of mssql and I'll modify your error code with correct code on basis of mysql, [CODE]<?php //Generally we try to run php script at localhost. $myServer = "localhost"; $myUser = "root"; $myPass = " "; $myDB = "db1"; //connection to the … | |
Re: When you Create a database then you use Structured Query Language(DDL)and Syntex is [B][CODE=sql]"CREATE DATABASE Database_name";[/CODE][/B] Hi,I just try it, Because I have no Proper Idea [CODE=sql]"CREATE TABLE Table_name( name VARCHAR(20) NOT NULL, address VARCHAR(120) NOT NULL, telephone_no INT NOT NULL, email VARCHAR(20) NOT NULL, edu_qual VARCHAR(25) NOT NULL, college … ![]() | |
Re: Hi,MySql act as Database System Software which is an open source in nature means freely available.& we need " Structured Query Language " For Accessing it, Now, According to your Query, I First Create data base [B]"CREATE DATABASE Name_of_Database";[/B] Later you create a table [B] CREATE TABLE IF NOT EXISTS … ![]() | |
Re: Hi, thanks pritaeas for sharing that info with all.But here I added some basic point that's makes that Query more understandable, 1)For Retriving data from database we use "Select * from table_name. 2)order by: by default, it's show result in ascending, or ORDER BY column_name ASC, But as we mention … | |
Re: Hi, I here mention just the point you need means how we perform the two operation together. <?php if(isset($_POST['posted'])=='true') { $connect=mysql_connect('localhost','root',''); $db=mysql_select_db('dir_db',$connect); /* fetch tha data like that $name=$_POST['dir_name']; / Now, We Perform Saving Operation. if(isset($_POST['dir_save']) == 'Save') { $query=mysql_query("INSERT INTO dir_registration(attribute1,attrrbute2) VALUES('$name','$value2')",$connect); } // Now We Perform Search Operation. … | |
Re: Hi, You Just Try That Code that Help You <?php if(isset($_POST['posted'])=='true') { $connect=mysql_connect('localhost','root',''); $db=mysql_select_db('dir_db',$connect); $user_comment=$_POST['dir_usercomment']; // Now, We Perform Saving Operation. if(isset($_POST['dir_save']) == 'Save') { $query=mysql_query("INSERT INTO dir_registration(comment) VALUES('$user_comment')",$connect); } //Now We Perform Cancel operation. if(isset($_POST['dir_cancel']) == 'Cancel') { exit(); } // Now We Perform Reset operation. if(isset($_POST['dir_reset']) == 'Reset') … | |
Re: Hi, here we mention code which solve your Login problem, Save index_dir.php that file in Root Folder, for that Problem We Use WAMP Window + Apache Server + MySql + PHP <?php if(isset($_POST['posted'])) { $name=$_POST['dir_username']; $pass=$_POST['dir_password']; $connect=mysql_connect('localhost','root',''); $db=mysql_select_db('dir_db',$connect); $query=mysql_query('SELECT * FROM dir_login',$connect); while($row=mysql_fetch_array($query)) { $column1=$row['username']; $column2=$row['password']; if($column1 == $name && … | |
Re: As we know that [I]MySql act as Database System[/I] and we need " Structured Query Language " [I]For Accessing it[/I], and as you mention that not a single column be empty, when anyone insert data in them, fro that we use Constraints Concept,like [B]CREATE TABLE IF NOT EXISTS Table_Name(NAME VARCHAR(25) … | |
Re: There is no doubt that, we use [B]Wild-character matching strategy[/B],Because in Structure Query Language for Pattern matching we use 'LIKE' command with two variation 1)% that's we use for Multiple character Matching. [B]1->(a)[/B] eg.'[U]s%[/U]' it Match all text which [B]start[/B] from 's character' [B]1->(b)[/B] eg.'[U]%s[/U]' it Match all text which … |
The End.