gandil

[COLOR=#000000]Can you help me to normalize Online Hotel Reservation System. In the database I will store information about the hotels (name, city, country, number of stars, room prices, total number of double rooms, total number of single rooms, number of available rooms, etc); customers (name, email, telephone, address, username, password, …

I have a db query, which show datas from mysql database. I want to do : ıf number of rows from query is bigger than x do something if small do another thing. Namely; [code=php] $qry = mysql_query("SELECT * FROM data_table WHERE page='$page'",$dbh); $total = mysql_num_rows($qry); if($total>7) { something... } …

try [code=php] $index="SELECT id,image FROM myphoto WHERE userid ='$userid' and user='$user'"; $member=mysql_query($index); $total= mysql_num_rows($member); for($i=0;$i<$total;$i++) { $row = mysql_fetch_array($member); $userid = $row['userid']; $id = $row['id']; echo"<a href= mypictures.php?id=$userid ><img src=picretrieve.php?userid=$userid width=120 height=120 border=0 alt='$id''>"; }