if ($total is greater than 7)
{
something...
}
else
{
another thing
}

I am when total is 1 or 8 whatever is; it is going to same statement. Why?

if you want to show 3 in each row:

$index="SELECT id,image FROM myphoto WHERE userid ='$userid' and user='$user'";
$member=mysql_query($index);
$total= mysql_num_rows($member);
$count = 0;...

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 =...

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;

$qry = mysql_query("SELECT *...

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...