concating variables within select function

[billabong0202]

I am having trouble writing a select function that uses a predefined variable within call.

 

<?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, CONCAT("hours.", $day, "_open")as open, CONCAT("hours.", $day, "_close") 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>';

}

}

?>

 

[fenway]

It's a quoting issue... switch to single quotes for your concat.