- Code: Select all
<?php
include("config.php");
$sql='select * from reservasi where username="'.$_SESSION['username'].'" LIMIT 1';
$sql='select * from reservasi where username="'.$_SESSION['username'].'" LIMIT 1';
$query=mysql_query($sql);
while($rows=mysql_fetch_array($query))
{?>
<font color="white" size="+1" style="arial">
<table style="margin-left:50px;">
<tr><td>ID Reservasi </td>
<td>: </td>
<td><?php echo $rows['res_id'];?></td></tr></br>
<tr><td>Username </td>
<td>: </td>
<td><?php echo $rows['username'];?> </td></tr><br>
<tr>
<td>Tanggal Reservasi </td>
<td>: </td>
<td><?php echo $rows['tanggal'];?></td></tr><br>
<tr>
<td>Paket </td>
<td>: </td>
<td><?php echo $rows['package_id'];?></td></tr>
<tr>
<td>Venue </td>
<td>: </td>
<td>
<?php
$temp=$rows1['venue_id'];
$sql1="select venue_name from venue where venue_id=$temp";
$query=mysql_query($sql);
if ($rows1== mysql_fetch_array($query)){
echo $rows1['venue_id']; ?> </td></tr>
</table></font>
<?php }} ?>
this code use to lookup a data in venue table. but in my problem, the venue name wont show up...
can someone help to correct or tell me the wrong part ?
thank you ....
