Monday, November 14, 2011

Code to Select Data from MYSQL with where condition using PHP





$host="localhost"; // Host name 
$db_username="root"; // Mysql username 
$db_password=""; // Mysql password 
$db_name="sarvdev"; // Database name 
$user="user"; // Table names 


mysql_connect("$host", "$db_username", "$db_password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");


$sql="Select * from User where name='" .$name. "' ";
$result=mysql_query($sql);

No comments:

Post a Comment