use mysql_fetch_rows();
$result="SELECT COUNT(*) FROM pet";
$sql=mysql_query($result);
$number_of_rows = mysql_fetch_rows($sql);
while ($row=mysql_fetch_array($sql)){
$pet_name=$row['pet_name'];
echo ......;
}
Craig Roberts
"Yury B ." <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi
>
> I used to use old fashioned mysql quieries but moderm mysql
> apparently became more flexible so. I want to understand how to use
> some of the new features like COUNT(*)
>
> Let's say I have
> $result="SELECT COUNT(*) FROM pet";
> $sql=mysql_query($result);
> while ($row=mysql_fetch_array($sql)){
> $pet_name=$row['pet_name'];
> echo ......;
> }
>
> the question is how do I actually retrieve the number of rows of sql
> query result?
>
> Yury
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
