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); ?> Link to comment https://forums.phpfreaks.com/topic/80930-solved-help-unknown-column-thisid-in-where-clause/ 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()); Link to comment https://forums.phpfreaks.com/topic/80930-solved-help-unknown-column-thisid-in-where-clause/#findComment-410568 Share on other sites More sharing options...
sun7777 Posted December 9, 2007 Author Share Posted December 9, 2007 Thank you so much Finally!! Link to comment https://forums.phpfreaks.com/topic/80930-solved-help-unknown-column-thisid-in-where-clause/#findComment-410572 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.