[SOLVED] [Help] Warning: mysql_num_rows()

[Mutley]

Error:

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

 

Code:

<table align="left" width="80%">

<?php
require_once("connection.php");

$query = "SELECT id, name, surname FROM profiles ORDER BY surname, name";
$result = mysql_query($query);

if(mysql_num_rows($result)!=0) {

while(list($id, $name, $surname) = mysql_fetch_row($result)) {
?>
  <tr>
    <td align="left"><a href="profiles.php?id=<?=$id?>"><?=$surname?>, <?=$name?></a></td>
  </tr>
<?php
   }
}

else {

echo "No profiles were found";
}


?>
</table>

 

Anyone know what the problem is?

 

Thanks.

[NArc0t1c]

I don't think you can count an ordered result.

[AndyB]

if(mysql_num_rows($result)!=0) {

 

should be

 

if(mysql_num_rows($query)!=0) {

[Mutley]

if(mysql_num_rows($result)!=0) {

 

should be

 

if(mysql_num_rows($query)!=0) {

 

Nope, same error.  ???

[MemphiS]

Make life easier for your self...

 

$query = "SELECT id, name, surname FROM profiles ORDER BY surname, name";
$rows = mysql_num_rows($query);
$result = mysql_query($query);

if($rows > 0) {

[MemphiS]

<table align="left" width="80%">

<?php

require_once("connection.php");

$query = mysql_query("SELECT id, name, surname FROM profiles ORDER BY surname, name");

 

if(mysql_num_rows($query)>0) {

while(list($id, $name, $surname) = mysql_fetch_row($query)) {

?>

<tr><td align="left"><a href="profiles.php?id=<?=$id?>"><?=$surname?>, <?=$name?></a></td></tr>

<?php

}

}else{echo "No profiles were found";}

?>

</table>

 

 

Try the above...

[Mutley]

Same error, line 6 there.

 

Thanks for the help so far.

[MemphiS]

<table align="left" width="80%">

<?php

require_once("connection.php");

$query = mysql_query("SELECT id, name, surname FROM profiles ORDER BY surname, name");

$numrows = mysql_num_rows($query);

if ($numrows>0){

while(list($id, $name, $surname) = mysql_fetch_row($query)) {

?>

<tr><td align="left"><a href="profiles.php?id=<?=$id?>"><?=$surname?>, <?=$name?></a></td></tr>

<?php

}

}else{echo "No profiles were found";}

?>

</table>

[Mutley]

Same error. Line 5.  ???

 

I wonder what's causing it, something other to the code possibly?

[MemphiS]

This isnt tested... This is how i would code it..

<table align="left" width="80%">
<?php
require_once("connection.php");
$query = mysql_query("SELECT `id` , `name` , `surname` FROM `profiles` ORDER BY surname, name DESC");
$queryRows = mysql_num_rows($query);

if ($queryRows > 0){
while ($queryFetch = mysql_fetch_row($query)){
echo("<tr><td align='left'><a href='profiles.php?id=$queryFetch[0]'>$queryFetch[2], $queryFetch[1]</a></td></tr>");
}
}else{
echo("<tr><td align='center'>No Profiles Found!</td></tr>");
}
?>
</table>

 

[Mutley]

Nope, still no luck.

 

I think my head might just explode, this is really irritating, lol.

[MemphiS]

hmm.. Whats the Error msg ?

 

 

[no_one]

Try printing mysql_error() and mysql_errno() ?

 

The resource probably wouldn't be valid if the query failed. I think *cough*. 

[per1os]

Are you sure your MySQL is returning anything at all and not just throwing errors? Hmmmm =)

 

table align="left" width="80%">
<?php
require_once("connection.php");

$query = "SELECT id, name, surname FROM profiles ORDER BY surname, name";
$result = mysql_query($query) OR DIE("SQL ERROR FOR QUERY:" . $query . "<br />ERROR: " . mysql_error());

if(mysql_num_rows($result)!=0) {

while(list($id, $name, $surname) = mysql_fetch_row($result)) {
?>
  <tr>
    <td align="left"><a href="profiles.php?id=<?=$id?>"><?=$surname?>, <?=$name?></a></td>
  </tr>
<?php
   }
}

else {

echo "No profiles were found";
}


?>
</table>

 

Post the error results.

[Mutley]

It says:

SQL ERROR FOR QUERY:SELECT id, name, surname FROM profiles ORDER BY surname, name

ERROR: No database selected

 

My connection.php:

 

require_once("config.php");

$connection = mysql_connect($host, $user, $pwd) or die("&error1=".mysql_error());

mysql_select_db($db, $connection);

 

My config.php:

 

$host = "localhost";
$user = "yorkrufc_rufc";
$pwd = "";//removed
$db = "yorkrufc_rufc";

 

So it should connect.  ???

[per1os]

require_once("config.php");

$connection = mysql_connect($host, $user, $pwd) or die("&error1=".mysql_error());

mysql_select_db($db, $connection) OR DIE("Selection Error:" . mysql_error() . "<br /> For Database: $db");

 

See what that gets ya.

[Mutley]

Fixed it, my FTP was in a stupid "skip not overwrite" mode. 

 

Thanks a lot!