Reinstall PHP and MySQL Problems

From: Date: Sat, 22 Sep 2001 20:30:11 +0000
Subject: Reinstall PHP and MySQL Problems
Groups: php.windows 
Request: Send a blank email to php-windows+get-9465@lists.php.net to get a copy of this message
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

« previous php.windows (#9465) next »