Re: [PHP] simplicity with 2 queries..

2002-06-09 Thread Bogdan Stancescu
SELECT quiz_id FROM $table_quiz AS q, $table_user AS u WHERE q.user_id=u.user_id AND u.username='$valid_user' AND u.password='$valid_password'"; Bogdan Jule Slootbeek wrote: > Hey guys and gals, > > I have the following function which accesses the following tables, now > i want to

RE: [PHP] simplicity with 2 queries..

2002-06-09 Thread John Holmes
Read the JOIN chapter of the MySQL manual and it'll tell you how to do it. It's not a PHP issue. (watch for line wrapping) http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #JOIN ---John Holmes... > -Original Message- > From: Jule Slootbeek [mailto:[EMAIL PROTECTE