$variables in SQL query
Posted: Wed Mar 15, 2006 8:47 pm
This Produces nothing..
dont know why :/
dont know why :/
Code: Select all
mysql_connect($host,$user,$pass) or die("COULD NOT CONNECT TO DB");
mysql_select_db($db) or die("COULD NOT SELECT DB");
//run query
$query = "SELECT * FROM user_rides WHERE yearcat=".$_REQUEST['yearcat'];
if ($r = mysql_query($query) or die(mysql_error())
{
//print
while ($row = mysql_fetch_array ($r))
{
print "{$row['name']}";
}
else {die('error');
}