Re: [PHP] All records not displaying...

2010-12-20 Thread Ravi Gehlot
I would say enabled error_reporting(E_ALL); error_reporting(-1); Then use die(mysql_error()); with your mysql function to get some debugging data. Also use var_dump($query_name) to find out what is spits out. Debugging is your best friend here. If you don't use die() or error_reporting() then yo

Re: [PHP] All records not displaying...

2010-12-19 Thread Gary
"Tamara Temple" wrote in message news:c6993909-dd90-4f52-bf6b-ab888c281...@gmail.com... > > On Dec 19, 2010, at 9:46 AM, Gary wrote: > >> I have an issue that the first record in a query is not being displayed. >> It >> seems that the first row in alphabetical order is not being brought to >

Re: [PHP] All records not displaying...

2010-12-19 Thread a...@ashleysheridan.co.uk
I'm not sure what this line us all about: if (mysql_num_rows($result) == !'0') You're basically saying; if the number of rows is equal to the not of the string 0, what I think you may want in this case is just != 0. The next line is causing your problem though. You're grabbing the first row wi

Re: [PHP] All records not displaying...

2010-12-19 Thread Tamara Temple
On Dec 19, 2010, at 9:46 AM, Gary wrote: I have an issue that the first record in a query is not being displayed. It seems that the first row in alphabetical order is not being brought to the screen. I have run the query in the DB and it displays the correct result, so it has to be in