Nashua558 Posted July 17, 2008 Share Posted July 17, 2008 Below is a query I'm trying to run through MySql Admin. I am new to PHP and MYSql so please for give me. I need the data from the two tables for all entries that have a date that is prior to 5/17/2007 if I take the dale limit out it returns all the record. With the date I am not getting just those priotr to the date. What am I doing wrong. Thanks SELECT phpbb_users.user_id, phpbb_users.username, phpbb_users.user_regdate, phpbb_users.user_type, phpbb_profile_fields_data. * FROM phpbb_users, phpbb_profile_fields_data WHERE phpbb_users.user_id = phpbb_profile_fields_data.user_id and phpbb_profile_fields_data.pf_date < 5/17/2007 Link to comment https://forums.phpfreaks.com/topic/115295-query-limit-help/ Share on other sites More sharing options...
realjumper Posted July 17, 2008 Share Posted July 17, 2008 What type of column is pf_date? Link to comment https://forums.phpfreaks.com/topic/115295-query-limit-help/#findComment-592788 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.