There seems to be a problem with your database connection. Can we see the
header include?
-Toby
----- Original Message -----
From: "Robert Trembath" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
