Have you tried running these from the command line mysql client, to see what may be up? Maybe you have a variable in your code that's not getting re-initialized properly.
If you get the same results from the mysql client, it might be time to run myisamchk on your table. (or just dump the data, drop the table, and recreate it...) --jeff > > OK, now I'm REALLY puzzled. > > I executed this query: > > $sql = "SELECT * > FROM $table_name > ORDER BY status > "; > > Sure enough, mysql found no value in status about a third of the > time. (The table comes back with the empty status rows, then "input" > and finally "published.") This explains why WHERE status = > "published" doesn't return the same results as WHERE status <> > "input". > > But here's the rub: > > When I do an individual check on each of the "empty" status records, > every one of them has "published" in the status field and the status > shows as "published" when I sort by a different field than "status." > > How can the data be in the record when I ORDER BY "lname" (a varchar > text field) and no data be found when I ORDER BY "status" (a varchar > text field)? > > John Hughes --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
