Please help... MySQL problem... 1 Line

[MoonRaverX]

Ok, trying to get a number based on items purchased in 30 days.... what is wrong with this

Code: Select all

        
$total_purchased_items_30 = $db->query_first('SELECT count(*) FROM ' . ITEMS_TABLE . " WHERE item_buyer='" . $member['member_name'] .' WHERE item_date BETWEEN '.$thirty_days.' AND '.time().  "' ORDER BY item_date DESC");

all variables are correct, query seems wrong... any suggestions, o great ones?

[Micro]

my best guess is you have a problem with quoting, for example:

item_buyer='

you arnt ending that quote until ' ORDER BY item

it should read:

Code: Select all

" WHERE item_buyer='" . $member['member_name'] ."' AND item_date BETWEEN ".$thirty_days.' AND '.time().  "' ORDER BY item_date DESC");