Re: [PHP] simplicity with 2 queries..

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..

k [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 09, 2002 11:35 PM > To: php-general > Subject: [PHP] simplicity with 2 queries.. > > Hey guys and gals, > > I have the following function which accesses the following tables, now i > want to > know if there is a way to get t

[PHP] simplicity with 2 queries..

Hey guys and gals, I have the following function which accesses the following tables, now i want to know if there is a way to get the quiz_id from table quiz without runnning both these queries... thanks, Jule --tables-- mysql> describe user; ++--+--+-+---