Tilted Forum Project Discussion Community - View Single Post

welshbyte · 09-09-2004, 06:23 AM

Not quite sure what you're trying to do but maybe something like:

PHP Code:


			
$query ="SELECT entryid, entrytext,";

$query.=" DATE_FORMAT(entrydate, '%M %d, %Y %T') AS date";

$query.=" FROM blog ORDER BY entrydate DESC LIMIT 10";

$query.=" WHERE MONTHNAME(date) = '$required_month'";

$result=mysql_query($query);

Is that what you were getting at?

09-09-2004, 06:23 AM	#3 (permalink)
welshbyte Insane Location: Wales, UK, Europe, Earth, Milky Way, Universe	Not quite sure what you're trying to do but maybe something like: PHP Code: `$query ="SELECT entryid, entrytext,"; $query.=" DATE_FORMAT(entrydate, '%M %d, %Y %T') AS date"; $query.=" FROM blog ORDER BY entrydate DESC LIMIT 10"; $query.=" WHERE MONTHNAME(date) = '$required_month'"; $result=mysql_query($query);` Is that what you were getting at? __________________ There are only two industries that refer to their customers as "users". - Edward Tufte Last edited by welshbyte; 09-09-2004 at 07:05 AM.. Reason: Didnt understand the question the first time!