jkewlo Posted March 20, 2008 Share Posted March 20, 2008 have u figured it out? Quote Link to comment Share on other sites More sharing options...
mikebyrne Posted March 20, 2008 Author Share Posted March 20, 2008 Not a clue, its driving me mad Quote Link to comment Share on other sites More sharing options...
mikebyrne Posted March 20, 2008 Author Share Posted March 20, 2008 Still cant get the box to autofill with my data, cant figure out why as Im getting no error and the code looks ok to me Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted March 20, 2008 Share Posted March 20, 2008 the code as posted works perfectly for me. that leaves only a few possibilities: 1. Your connection to the database is failing 2. There is no table Products and/or no column ProductName 3. There are no records in the table Products and/or no values inserted for ProductName I suggest that you first ensure error_reporting is on by creating an error (try dividing something by zero). If you can verify that error_reporting is on, then check your HTML output using View Source, as the error may be embedded in the <SELECT> and not displayed on the page. Quote Link to comment Share on other sites More sharing options...
mikebyrne Posted March 20, 2008 Author Share Posted March 20, 2008 I viewd the html page source and noticed this Table 'admin.products' doesn't exist UNBELIVABLE!!! 2 days pulling my hair out and my SQL was $query = "SELECT ProductName FROM Products"; instead of $query = "SELECT ProductName FROM Product"; Thanks for the help guys Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.