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" <[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]
--
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]
