Hi,
Asked this on the mySQL list but it seems to be more of a PHP syntax thing that a mySQL thing.
In have the following line in PHP
<?php $today = getdate();?>
I have a mySQL table which contains dates formatted as dates(xxxx-xx-xx)
I want to select all records based on a specific month.
This is my select statement
SELECT * FROM sti_tracking WHERE `date` = MONTHNAME('$today') = 'August'
Cased in php it looks like so...
<?php mysql_select_db($database_sti_tracking_DB, $sti_tracking_DB); $query_totalHitsMonth_RS_RS = "SELECT * FROM sti_tracking WHERE `date` = MONTHNAME('$today') = 'August'"; $totalHitsMonth_RS_RS = mysql_query($query_totalHitsMonth_RS_RS, $sti_tracking_DB) or die(mysql_error()); $row_totalHitsMonth_RS_RS = mysql_fetch_assoc($totalHitsMonth_RS_RS); $totalRows_totalHitsMonth_RS_RS = mysql_num_rows($totalHitsMonth_RS_RS); ?>
but this isn't working....it's returning no records which is wrong.
It's returning the correct results for your query. I'm surprised it's even running. getdate() returns an array, btw, so you're looking for ros that match this:
`date` = MONTHNAME('Array') = 'August'
You don't even need to call getdate(), just put
WHERE MONTHNAME(date) = 'August'
in your query.
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
