centerwork Posted November 19, 2007 Share Posted November 19, 2007 $query = "SELECT * FROM visiter_print_log, biz_info, biz_cont_info WHERE visiter_print_log.winner IS NULL & visiter_print_log.selected IS NULL & visiter_print_log.v_email != biz_info.b_email & visiter_print_log.v_email != biz_cont_info.b_cont_email ORDER BY RAND() LIMIT 1" Basically I need one entry from visiter_print_log. Where the v_email (From visiter_print_log) Does not match b_email (From biz_info) and it Does not match b_cont_email (From biz_cont_info). If looked all over and can't figure this out. Link to comment https://forums.phpfreaks.com/topic/77975-query-headache/ Share on other sites More sharing options...
nuxy Posted November 19, 2007 Share Posted November 19, 2007 I suggest you read up on mysql joins, also learn the operators to use in mysql, since & is not valid. Link to comment https://forums.phpfreaks.com/topic/77975-query-headache/#findComment-394708 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.