Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    96

    Unanswered: Problem showing all records on web pages in MySQL

    Hello,
    I have recently updated to MySQL 5.0 using Navicat to manage and update content.
    I have very simple test table with two fields, testid and test, I have 6 records entered.
    Using an SQL query SELECT * FROM tbltest all records are returned, if I use the very same query on a web page (ASP) only 1 record is returned, once again the scripting is very simple and I have done it hundreds of time before, can't figure out why.
    I have done test with other tables, some show all records, some not, some just part of the records.
    Seems like a mistery to me, any idea what the problem could be? could a bug be causing this?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    To display the results on the webpage you must loop through the resultset and write each and every record separately...

    Oh and avoid SELECT * whenever possible!
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •