sandeepji1

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

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.

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

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 …

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 …

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 …

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 …

I appreciate swi2.

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. …

I Agree with rajarajan07.

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') …

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 && …

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) …

Hi, According to me you want output like that form table "SELECT id,name,sname FROM Table_name"; But I have doubt in mention query, then please mention your query in proper way,Only then I'll Help you, with efficient way.

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 …