brady.k — Sat, 06 Mar 2004 16:01:31 +0000

Yes, they are setup with the exact same fields...

I do have to restrict by date, just not limit how many results display

Sample:
{Order} {Activity} {Date} {Place} {Time}
1 Meet 2004-6-02 Mall 00:00:00
etc.

Suzanne — Sat, 06 Mar 2004 06:09:05 +0000

I'm assuming that the tables are set up with the same fields (or close)?

Chroder — Sat, 06 Mar 2004 03:09:27 +0000

Its from a different table? Thats weird, mysql should be spitting out 'unknown column' errors...

Suzanne — Sat, 06 Mar 2004 03:07:26 +0000

So you don't need to restrict it by date? And you're accessing a different table? Okay, make sure you have all that information right, then, eh?

Do you have a sample of the table data?

brady.k — Sat, 06 Mar 2004 02:29:26 +0000

Sorry...I've been busy...

Yes, I took your old one, and modified it for a new page, removing the LIMIT...different table, almost exactly the same info...40+ rows of information

Suzanne — Sat, 06 Mar 2004 01:11:14 +0000

http://www.php.net/manual/en/function.date.php on how PHP does it
http://www.mysql.com/doc/en/DATETIME.html on how MySQL does it

DATE_FORMAT(date, '%m/%d/%Y') AS date sets the date in the m/d/Y format, so to compare it to the $today variable, it should be $today = date(m/d/Y); but I thought I put a LIMIT = 6 in the query and WHERE date >= $today blah blah??

Chroder — Sat, 06 Mar 2004 00:45:21 +0000

And one more thing, how are you comparing the date string with a 'less-than or equal to' operator? Does PHP automatically convert date's or something? Not sure about that...

Suzanne — Sat, 06 Mar 2004 00:24:11 +0000

The problem I think is the same code works (or near to the same code) on other pages on the site and there ARE rows (expected and actually there) for that query? Kyle, can you confirm what you've changed? I don't see a LIMIT on there... Is this old or new code?

Chroder — Fri, 05 Mar 2004 21:36:19 +0000

A query that returns 0 results is still a perfectly valid query. So I'm guessing you were right when you said there were no rows.

Or try looking at the page source. It may look blank, but I know sometimes I've got errors but I don't see them because I've got them printed before the " ....".

Suzanne — Fri, 05 Mar 2004 21:30:03 +0000

Sorry, I just edited that, whoops!

The die() doesn't echo the error, so it's not returning anything to the browser?