0
$sql_table_get=mysql_query("select orderline.quantity, menu.item_name, menu.price
			    from orderline, menu, orders 
			    where orderline.item_id = menu.item_id
			    and orders.order_id = orderline.order_id
			    and orders.table_num =table".'"$count"'."   // problem line
			    and orders.order_status = 0; ");

tried many combo and couldn't make it work yet.

basically i just need to know how to combine a $variable and a string inside the "mysql_query"


thanks

Edited by k2k: n/a

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by k2k
0

thanks, the $count got assiged somewhere i didn't put up the whole code.

anyway, i solved it by making a new variable

$tableName= "Table".$count

and parse just $tableName instead of messing around with concat inside the mysql_query code.

thanks

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.