Problem retrieving data

[dbewick123]

Hi, I'm trying to query my 'books' table to return all the tags (tag1 to tag5) that are in my 'userBooks' table (so basically if a user has that book in userBooks i want to get those tags)... hopefully by putting the code it should be clearer...

 

$recommended = mysql_fetch_assoc(mysql_query("SELECT `tag1`, `tag2`, `tag3`, `tag4`, `tag5` FROM `books` WHERE `book_id` IN (SELECT `book_id` FROM `userBooks` WHERE `user_id` = '$sessionUserId')"));

 

 

Just to note my userBooks tabe just has 2 foreign keys (user_id and book_id) and one primary key. 

 

the result i get when i print_r this is just the set of tags (1 to 5) for the first book_id that matches, my problem is that i want all the tags for all the book id's that match? any advise please?

 

Thanks 

 

 

[Barand]

Don't nest mysql functions.

 

You need a query followed by several fetches.

 

 

$sql = "SELECT `tag1`, `tag2`, `tag3`, `tag4`, `tag5` 
    FROM `books` 
    INNER JOIN userbooks USING (book_id)
    WHERE `user_id` = '$sessionUserId' ";
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)) {
    echo join (',', $row) . '<br>';
}
 

[dbewick123]

 

Don't nest mysql functions.

 

You need a query followed by several fetches.

 

 

$sql = "SELECT `tag1`, `tag2`, `tag3`, `tag4`, `tag5` 
    FROM `books` 
    INNER JOIN userbooks USING (book_id)
    WHERE `user_id` = '$sessionUserId' ";
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)) {
    echo join (',', $row) . '<br>';
}
 

Thanks for this, don't worry if not but i would really appreciate it if you could explain what is happening here because it doesn't make a lot of sense to me :/ ?