...

View Full Version : mysql_query times two....



stevenmw
07-14-2007, 03:46 PM
$data = mysql_query("SELECT * FROM news_posts WHERE upper($field) LIKE'%$find%'");


If I want the above query to select * Form two tables at once would i just seperate them by a period?

Like so:
news_posts.comments

Mwnciau
07-14-2007, 04:19 PM
$data = mysql_query("SELECT * FROM news_posts, comments WHERE upper($field) LIKE'%$find%'");



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum