4.0.4-beta-max-n/php 4.3.0RC1.bug or wrong code?

[kosmidd]

$Query=mysql_query($sql);
$Rows=mysql_fetch_row($Query);
echo count($Rows)."==".mysql_num_rows($Query);

Assign to $sql a Mysql Query like :$sql="SELECT * FROM table";
$Rows are different than mysql_num_rows!!!!!!!!!!!!
What is that??????????????

[maxsslade]

Have you actually connected to the database??

SELECT the MYSQL database

and try this query:

 
$query = "SELECT * FROM users";

$result = mysql_query($query);

$query_data = mysql_fetch_rows($result);

while($query_data = mysql_fetch_rows($result)) {

 echo $query_data[1];

}

[kosmidd]

OFCOURSE I have connected to the database.
If I try this without the connection it won't return numbers like 6==46.The queries will fail.
It will return a warning saing that the supplied argument for both mysql_fetch_row and mysql_num_rows in not valid.....
The function is mysql_fetch_row and not mysql_fetch_rows and the table in Mysql is user and not users.
Anyway the code you gave me is working but it shows nothing intresting because you call only ONE line (echo $query_data[1]😉

Try the code bellow and compare :

$db = mysql_pconnect("localhost", "USER", "PASS");
mysql_select_db("mysql",$db);
$sql="SELECT * FROM user";
$Query=mysql_query($sql);
$Rows=mysql_fetch_row($Query);
echo "FROM mysql_fetch_row:".count($Rows)."<br>FROM mysql_num_rows:".mysql_num_rows($Query);

[kosmidd]

My mistake.
mysql_fetch_row returns an array with every element a field value of one row.
I thought it returned all the rows in an array
Sorry!!!