mysql_num_row and mysql 4

[graziano]

HELLO!

I was using this script

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?>

to get mysql_num_rows , and it worked fine
with mysql 3.x

Now I have upgraded to mysql 4 and I am receiving this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Anyone can help me please ?

Graziano

[cgraz]

well that usually suggests there is something wrong with your query. You don't need to specify the $link everytime you want to run a query or the like. I'd also suggest using mysql_error() so you know what's going on

mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database");

$result = mysql_query("SELECT * FROM table1") or die(mysql_error());
$num_rows = mysql_num_rows($result);

echo $num_rows . "Rows<br>";

Cgraz

BTW, please don't double post. I deleted your other thread. You usually get better responses by only posting once, that way people can work off of other people's advice.

[Bunkermaster]

Originally posted by graziano
HELLO!

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?>

Graziano [/B]

Using select * to get row number is a bit of overkill imho 🙂

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password") or die(mysql_error()." Line ".__LINE__);
mysql_select_db("database", $link) or die(mysql_error()." Line ".__LINE__);

$result = mysql_query("SELECT count(0) as myCount FROM table1", $link) or die(mysql_error()." Line ".__LINE__);
$row = mysql_fetch_array($result);

echo $row['myCount']." Rows\n";
?>

Second thing, always try to execute your SQL queries in phpmyadmin before putting them in your code. It allows you to debug the actual SQL.

[graziano]

thanks a lot

now I am using this

$check = "test";
$sqlinterr = 'SELECT count(0) as myCount FROM  `table` WHERE 1 AND `check` =\'$check\' LIMIT 1, 90';

$res = mysql_query($sqlinterr);
$row = mysql_fetch_array($res);

but the value $check is not catched , and I receive always
0 rows .

What I have to do to insert $check inside the $sqlinterr ?

Thanks a lot

[Bunkermaster]

Originally posted by graziano

$check = "test";
$sqlinterr = 'SELECT count(0) as myCount FROM  `table` WHERE 1 AND `check` =\'$check\' LIMIT 1, 90';

$res = mysql_query($sqlinterr);
$row = mysql_fetch_array($res);

[/B]

this won't work...

$check = "test";
$sqlinterr = "SELECT count(0) as myCount FROM  `table` WHERE 1 AND `check` =\'$check\' LIMIT 1, 90";

$res = mysql_query($sqlinterr);
$row = mysql_fetch_array($res);

this will
noticed the double quotes around string? 😉