while($row = ) fetch row from table show not complete result..

[agphoto]

when we do mysql_query with while and mysql_num_rows( ) together then while do no show the first row from table in database..

example :
<?
$conn = mysql_connect($ DBhost,$DBuser, $DBpass) or die("Unable toconnect to database");
@mysql_select_d b("$DBName") or die("Unable to select database $DBName"); $sqlquery = "SELECT * FROM $table WHERE opinion = 'is great'";
$result = mysql_query($sq lquery,$conn);
$number = mysql_num_rows( $result); //to get the total rows

echo "Total row is " . $number ;

while($rows = mysql_fetch_ass oc($result)) //show all the values in all rows in table

{
echo $uid = $row['id'];
echo $name = $row[''name];
}
//while show not the first value in the row , to show the value in first and all other //rows we have to run the another $sql_query and that is not good idea ...
exit;
?>

please tell me how to resolve it...thanks..

[ronverdonk]

Your result set is in $rowS, while you get your values from $row (without the S).
So this statement
[PHP]while($rows = mysql_fetch_ass oc($result)) {
[/PHP]
must be changed to
[PHP]while($row = mysql_fetch_ass oc($result)) {
[/PHP]

Ronald :cool:

[agphoto]

Hello,

that was just in hurry while posting, that S, nut when i code is all right . coding is not problem, if any code wrong then , script does not run.

you try with same sql query for num rows and while(),

try it i am running all my db system, thing is if it work proper then i had not to run two different sql query...

thanks