01.
<?
include
"connect.php"
; ?>
02.
<?
03.
$run
=
$_REQUEST
[
'id'
];
04.
$sql
= "SELECT main_id, main_no, main_name, main_course.listmenu_id, main_course.setmenu_id, listmenu_name, listmenu_picture, list_menu.menutype_id, menutype_name
05.
FROM main_course, set_menu, list_menu, menu_type
06.
WHERE main_course.listmenu_id = list_menu.listmenu_id
07.
AND main_course.setmenu_id = set_menu.setmenu_id
08.
AND list_menu.menutype_id = menu_type.menutype_id
09.
AND main_course.setmenu_id =
'$run'
";
10.
$que
= mysql_query(
$sql
);
11.
while
(
$read
= mysql_fetch_array(
$que
)){
12.
?>
13.
<link href=
"SmallContent.css"
rel=
"stylesheet"
type=
"text/css"
>
14.
15.
16.
<table width=
"145"
height=
"166"
border=
"0"
cellpadding=
"0"
cellspacing=
"2"
>
17.
<tr>
18.
<td width=
"158"
bgcolor=
"#99CC66"
>><?
echo
$read
[
'menutype_name'
] ?></td>
19.
</tr>
20.
<tr>
21.
<td bgcolor=
"#99CC66"
>
22.
<input type=
"hidden"
name=
"txt_id"
value=
"<? echo $read['listmenu_id'] ?>"
/><?
echo
$read
[
'listmenu_name'
] ?></td>
23.
</tr>
24.
<tr>
25.
<td bgcolor=
"#99CC66"
>><img src=
"<? echo $read['listmenu_picture']; ?>"
width=
"100"
height=
"100"
/></td>
26.
</tr>
27.
28.
</table>
29.
<? } ?>