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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.