Re: Newbie - Help!!!!!
| From: | Toby Miller | Date: | Thu, 01 Feb 2001 15:52:05 +0000 |
| Subject: | Re: Newbie - Help!!!!! | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-5309@lists.php.net to get a copy of this message | ||
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