Friday, August 29, 2008

getting values

$hostname="localhost";
$username="root";
$password="";
$database="sample";
$con = mysql_connect($hostname,$username,$password) or die(mysql_error());
mysql_select_db($database,$con) or die("could not open db". mysql_error());
$q=$_REQUEST["q"];
$getvalue="select company_name from adv_details where company_name like '$q%'";
$resvalue=mysql_query($getvalue,$con) or die(mysql_error());
//echo $getvalue;
$totalrows=mysql_num_rows($resvalue);
while($row_resvalue=mysql_fetch_assoc($resvalue))
{
echo $row_resvalue['company_name'] ."
";
}
?>

No comments: