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 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;
> +------------+------------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+------------------+------+-----+---------+----------------+
> | user_id | int(10) unsigned | | PRI | NULL | auto_increment |
> | first_name | varchar(10) | | | | |
> | last_name | varchar(20) | | | | |
> | email | varchar(100) | | | | |
> | username | varchar(16) | | | | |
> | password | varchar(32) | | | | |
> +------------+------------------+------+-----+---------+----------------+
>
> mysql> describe quiz;
> +---------+------------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +---------+------------------+------+-----+---------+----------------+
> | quiz_id | int(10) unsigned | | PRI | NULL | auto_increment |
> | user_id | int(10) unsigned | | | 0 | |
> | title | varchar(255) | | | | |
> | noa | tinyint(2) | | | 0 | |
> +---------+------------------+------+-----+---------+----------------+
>
> --function--
>
> function addquiz_get_quiz_id() {
>
> global $valid_user, $valid_password;
>
> mysql_select_db($db_glob, $link_glob);
>
> $table_user = "user";
> $table_quiz = "quiz";
> $query = "SELECT * FROM $table_user WHERE username='$valid_user'
> AND password='$valid_password'";
> $result = mysql_query($query);
> $user_info = mysql_fetch_array($result);
> $user_id = $user_info[user_id];
>
> $query = "SELECT * FROM $table_quiz WHERE user_id='$user_id'";
> $result = mysql_query($query);
> $user_info = mysql_fetch_array($result);
> $quiz_id = $user_info[quiz_id];
>
> mysql_close($link_glob);
> return $quiz_id;
> }
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
