Hi all,
I'm doing some basic php/MySQL stuff (LinuxPPC on Mac7100). I'm gettin g the
following error when I search for somthing.
========
Supplied argument is not a valid MySQL result resource in
/usr/local/apache/htdocs/bizflyer/Bizflyer_R1.php on line 32
========
Here's my relevant code:
========
<?php
mysql_connect ('pingu','root@localhost','');
mysql_select_db ('Bizplanes');
if ($Serial == "")
{$Serial = '%';}
if ($Type == "")
{$Type = '%';}
if ($Con == "")
{$Con = '%';}
$result=mysql_query ("SELECT * FROM biz WHERE
ID LIKE '%$Serial%' AND
Type LIKE '%$Type%'
Con LIKE '%$Con%'
ORDER BY ID");
?>
TABLE STUFF HERE
<?php
if ($row=mysql_fetch_array($result)) { ######### this is line 32
do {
print ("<TR><TD>");
print $row['ID'];
print ("<TD>");
print $row['Type'];
print ("<TD>");
print $row['Con'];
print ("<TD>");
print $row['Operator'];
print ("</TD></TR>");
} while ($row=mysql_fetch_array($result));
} else {print ("Sorry, no aircraft matching your criteria were found.");}
?>
=========
Any suggestions as to where I'm going wrong?
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.heron.ac.uk
================================================
programmer - A device for transmuting caffeine into code.
================================================
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]