Re: Newbie - Help!!!!!

Everything the errors are pointing to is the result reference returned in $result. If your query fails and you just try to read the result you will get that error. Try something like this: $result = mysql_query( "SELECT * from nctd_reviews WHERE model_year='$year' AND manufacturer_name='$make' ORDER BY 'model_year','manufacturer_name'" ); if ((!$result) || (mysql_num_rows($result) < 1)) { if (mysql_error() != "") { print ("There were no results"); } else { die ("SQL Error: " . mysql_error()); } } else { // continue, this is a valid returned result set } Let me know if this helps. -Toby ----- Original Message ----- From: "Tom Mathews" <Tom.MATHEWS@st.com> Cc: <php-windows@lists.php.net> Sent: Thursday, February 01, 2001 11:15 AM Subject: Re: [PHP-WIN] Newbie - Help!!!!! > If there was an error with the DB connection, then the 'or die' clause should > pick it up? > If nothing has changed between the IIS nad Apache implementation then I don't > know what is happenning > If however you have changed the table structure at the same time... or maybe > don't have any records on your DB? > > Tom > > Toby Miller wrote: > > > There seems to be a problem with your database connection. Can we see the > > header include? > > > > -Toby > > > > ----- Original Message ----- > > From: "Robert Trembath" <robert@ishoptech.com> > > To: <php-windows@lists.php.net> > > Sent: Thursday, February 01, 2001 10:20 AM > > Subject: [PHP-WIN] Newbie - Help!!!!! > > > > I don't understand why I getting an error on this. it ran on my IIS/PHP > > machine but on my Apache/PHP I get errors. Here the code and the results, > > Please help: > > > > <?php > > session_start(); > > include("./inc/php_header.php") > > ?> > > <font face=Arial size=2> > > <?php > > include("./mysql_connect_inc.php"); > > print "<h3>New Vehicle Search</h3><p>"; > > mysql_select_db( $db ) > > or die ( "Couldn't open $db: ".mysql_error() ); > > $result = mysql_query( "SELECT * from nctd_reviews WHERE > > model_year='$year'AND manufacturer_name='$make' ORDER BY > > 'model_year', > > 'manufacturer_name'" ); > > $rows = mysql_num_rows( $result ); > > print "There are currently $rows vehicles that match your criteria.<p>"; > > print "<table width=475 border=0 cellpadding=0 cellspacing=1>\n"; > > print "<tr bgcolor=#D0D4E8><td width=50><font > > size=2><b>Year</b></font></td>"; > > print "<td width=325><font size=2><b>Make & > > Model</b></font></td><td > > width=100><font > > size=2><b>MSRP</b></font></td></tr>"; > > while ($r = mysql_fetch_array($result)) > > { > > extract($r); > > print "<tr>\n"; > > print "<td><font > > size=2>$model_year</font></td><td><font size=2><a > > href='vehicledetail.php?id=$ID'>$manufacturer_name > > $model_name</a></font></td><td><font size=2>$ $base_price</td></font>\n"; > > print "</tr>\n"; > > $selectedyear = "$year"; > > $selectedmake = "$make"; > > } > > print "</font></table>\n"; > > mysql_close( $link ); > > include("./inc/php_footer.php") > > ?> > > > > Now the errors: > > > > Warning: Supplied argument is not a valid MySQL result resource in > > c:\apache\htdocs\ishophouston\newvehicles.php on line 12 > > There are currently vehicles that match your criteria. > > Year Make & Model MSRP > > > > Warning: Supplied argument is not a valid MySQL result resource in > > c:\apache\htdocs\ishophouston\newvehicles.php on line 17 > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > ---------------------------------------------------------------------------- ---- > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net