[PHP-DB] RE: Help for a beginner

2009-12-23 Thread Edward Brookhouse
Just a guess, as I have not tried a full stack in windows, but in any unix if you are connecting php and mysql, you need something in the middle like DBD::mysql See if this helps: http://forums.mysql.com/read.php?51,189692,189856 -Original Message- From: Adam Sonzogni [mailto:asonzo...

RE: [PHP-DB] DATETIME

2009-10-08 Thread Edward Brookhouse
Thanks all - yes this is mysql, but not a mysql DATETIME field per se, but the issue was that I was trying to do like or equal to query the date range, and doing that will never match since whats in the db is MMDDHHMM (in timestamp format) and yet the query I would be able to send would

[PHP-DB] DATETIME

2009-10-08 Thread Edward Brookhouse
Hi All, I have a DB that is storing the date/time an event happens in DATETIME format, i.e. 1254252889, which translates to Tue, 29 Sep 2009 19:34:49 UTC I am trying to write a query in PHP that will look for any row that falls within a range of dates, i.e. between Sep 1 and Oct 1, but ther

[PHP-DB] Sorting MYSQL results Paging and column heads

2009-10-05 Thread Edward Brookhouse
Hi All, I am working on a PHP page to display results from a MySQL db and I am having a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not change the data? Any thoughts appreciated - Edward Ebrooathealthydirectionsdotcom http