I just reinstalled the Win2K server that I had PHP4 and MySQL installed on.
Now whenever I pull up a PHP page it doesn't actually pull data from MySQL
BUT I don't get any errors.
I've set all the MySQL stuff in the php.ini and I can otherwise connect to
and use the MySQL databases (as the user that PHP is using) I've also got
PHP set to display all errors and warnings.
I've only installed this once before (and it worked then) so I'm not sure
where to start looking.
Can anyone offer any advice?
If it makes a difference here's the script I'm using in my library database
to pull options for a form Select out of a database. When I do this it
simply ends up as a blank select with no options. but again there are no
errors at all. I've also tried paring the Select down to just SELECT Series
FROM Books, in case the query was wrong (even though it worked before) with
no luck.
<?php /*==================================================*/
$db = mysql_connect("localhost", "myuser", "mypassword");
mysql_select_db("isbn",$db);
$result = mysql_query("SELECT DISTINCT Series FROM Books WHERE Series IS
NOT NULL and Series != '' ORDER BY Series",$db);
if($myrow = mysql_fetch_array($result))
{
do {
echo ' <OPTION
VALUE="';
echo $myrow["Series"];
echo '">';
echo $myrow["Series"];
echo "</OPTION>\n";
} while ($myrow = mysql_fetch_array($result));
}
/*==================================================*/ ?>
Thanks
Matt
--
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]
