sun7777 Posted December 9, 2007 Share Posted December 9, 2007 not sure why it keeps on saying this Unknown column '$thisID' in 'where clause' Here is my code.... <?php include("connect.php"); $thisID = $_GET['which']; $query = 'SELECT Restaurants.ID, Restaurants.Name, Restaurants.Phone, RestAddress.Address, RestCategories.Name AS Categories FROM ((Restaurants INNER JOIN RestAddressMap ON Restaurants.ID = RestAddressMap.RestaurantID) INNER JOIN RestAddress ON RestAddress.ID = RestAddressMap.RestAddressID) INNER JOIN RestCategories ON RestCategories.ID = Restaurants.CategoryID WHERE Restaurants.ID = $thisID'; $result = mysql_query($query); if(!$result) { die("Could not query the database:<br />". mysql_error()); } $row = mysql_fetch_assoc($result); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>View Customer</title> </head> <body> <h1><?php echo $row["Name"]." ".$row["Phone"];?></h1> <ul> <li>Location: <?php echo $row["Address"];?></li> <li>Phone: <?php echo $row["Phone"];?></li> <li>Categories: <?php echo $row["Categories"];?></li> </ul> <a href="customers.php">back</a> </body> </html> <?php mysql_close($connection); ?> Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted December 9, 2007 Share Posted December 9, 2007 Try this $query = "SELECT Restaurants.ID, Restaurants.Name, Restaurants.Phone, RestAddress.Address, RestCategories.Name AS Categories FROM ((Restaurants INNER JOIN RestAddressMap ON Restaurants.ID = RestAddressMap.RestaurantID) INNER JOIN RestAddress ON RestAddress.ID = RestAddressMap.RestAddressID) INNER JOIN RestCategories ON RestCategories.ID = Restaurants.CategoryID WHERE Restaurants.ID = '$thisID'"; $result = mysql_query($query)or die(mysql_error()); Quote Link to comment Share on other sites More sharing options...
sun7777 Posted December 9, 2007 Author Share Posted December 9, 2007 Thank you so much Finally!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.