On Tuesday 12 April 2005 16:24, PartyPosters typed: > $sql="SELECT products.productID, products.title, products.number_per_box, > products.stock_level, products.image, users.username, users.email, > users.userID FROM users, products WHERE products.userID = $userID"; > $mysql_result=mysql_query($sql,$connection); > $num_rows=mysql_num_rows($mysql_result); You don't specify how the query should join the tables users and products. WHERE products.userID = users.userID and users.userID = $userID I'll assume you do validation on the userID ahead of time to ensure that it's the right format. -- My mind not only wanders, it sometimes leaves completely. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
