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]

Reply via email to