concatenating varibles within select function
Posted: Thu Feb 21, 2008 4:05 pm
I am having trouble writing a select function that uses a predefined variable within call.
***** PLEASE USE THE CODE TAG WHEN POSTING *****
***** PLEASE USE THE CODE TAG WHEN POSTING *****
Code: Select all
<?php
$day= date("l"); //gets current name of the day ex. Monday
$cat=strip_tags($_GET['cat']);
$type=strip_tags($_GET['type']);
$qry= "SELECT restaurants.rest_id, restaurants.name as name, [color=#FF0000]CONCAT("hours.", $day, "_open")as open, CONCAT("hours.", $day, "_close") [/color]FROM restaurants
INNER JOIN hours
ON restaurants.rest_id = hours.rest_id
INNER JOIN restaurant_info
ON restaurants.rest_id = restaurant_info.rest_id
WHERE restaurants.$cat='yes' AND restaurant_info.food_type=$type";
$result= mysql_query($qry);
Also, does this part look right?
if (!$result) {die(mysql_error());
}else{
while ($row=mysql_fetch_array($result)) {
$id=$row['restaurant.rest_id'];
echo '<p>' . $row['name'] . '</p>';
echo '<p>' . $id . '</p>';
}
}
?>