[Resolved] $num=mysql_numrows($result);

[vaavi8r]

I have two different website databases set up:

The first one is running MySQL version: 3.23.56 and PHP Version: 4.2.2.

I have written the following section of php script that works just fine on this setup:

<?
$entry=$_POST['entry'];
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
mysql_select_db ($database)or die( "Unable to select database");

$query="SELECT * FROM schedule WHERE dep='$entry'";
$result=mysql_query($query);



$num=mysql_numrows($result); 
$date = date('j-m-y');  

mysql_close();

echo "<b><center>NDOKI FLIGHT SCHEDULE<br><h3>Sorted by Departure</h3></font></center></b><br>";
?>
<table width="100%" bordercolor="#B8860B" bgcolor="#F0E68C" cellspacing="2" cellpadding="2" border="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif"><center>FLT #</center></font></th>
<th><font face="Arial, Helvetica, sans-serif"><center>DEPARTURE</center></font></th>
<th><font face="Arial, Helvetica, sans-serif"><center>DESTINATION</center></font></th>
<th><font face="Arial, Helvetica, sans-serif"><center>DEPARTURE<br>TIME</center></font></th>
<th><font face="Arial, Helvetica, sans-serif"><center>AIRCRAFT</center></font></th>
<th><font face="Arial, Helvetica, sans-serif"><center>TYPE</center></font></th>
<th><font face="Arial, Helvetica, sans-serif"><center>DISTANCE</center></font></th>
</tr>

<?
$i=0;
while ($i < $num) {
$flt=mysql_result($result,$i,"flt");
$dep=mysql_result($result,$i,"dep");
$dest=mysql_result($result,$i,"dest");
$time=mysql_result($result,$i,"time");
$plane=mysql_result($result,$i,"plane");
$type=mysql_result($result,$i,"type");
$dist=mysql_result($result,$i,"dist");


?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$flt"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$dep"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$dest"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$time"; ?></font></center></td>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$plane"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$type"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><center><? echo "$dist"; ?></center></font></td>


<?
++$i;
} 
echo "</table>";

This search returns all of the variables in a table and works great.

I installed the identical script on a new server that is running MySQL version: 3.23.58 and PHP Version: 4.3.2 and the script no longer works. I am getting the following error:

"Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /var/www/html/flights/depsearch1.php on line 21"

What has changed and how can I fix this argument?

Thanks

[robert_w_ark]

Well - that usually means theres nothing in your database - I would also recommend doing this..

$query = "SELECT * FROM database";
while($row = mysql_fetch_array($query))
{
/* Your loop stuff here using the $row[] array */
}

[Roger_Ramjet]

If this is the actual script then you have a typo

// your code
$num=mysql_numrows($result);  

// should be
$num=mysql_num_rows($result);  

Surprised that it generates the error it does. Would have thought it was an undefined function or something like that.

[vaavi8r]

OK, the code as written worked on the previous setup.

But I changed it to $num=mysql_num_rows($result); and
Still getting error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/flights/depsearch1.php on line 21

[laserlight]

mysql_numrows() is deprecated (though it should still work), so you should still use mysql_num_rows().

Anyway, the error means that either your did not connect to the database server, did not select a database, or your query (as it is when actually used) is wrong.

[tsinka]

Hi,

change the code to:

mysql_connect(localhost,$username,$password) or die("Unable to connect to server");
mysql_select_db ($database)or die( "Unable to select database");

$query="SELECT * FROM schedule WHERE dep='$entry'";
$result=mysql_query($query) or die("SQL error: ".mysql_error());

The error message means that something is wrong with your SQL query or that the connection to the server or selection of the database failed.

You shouldn't get that error message if the table schedule is just empty.

Since mysql_select_db doesn't seem to fail I think that everything is ok regarding mysql_connect and mysql_select_db. Maybe there's no table schedule or something like that or the table doesn't have a column called dep.

Thomas

[vaavi8r]

OK, dont understand it. I just removed the old script and FTP'd it to the new site again and now it works??????????

Must have been a corruption in the last FTP.

Thanks guys!