Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Long nested SELECT statement - Please help

Codes here !

Moderators: macek, egami, gesf

Long nested SELECT statement - Please help

Postby dbewick123 » Wed Mar 13, 2013 10:31 am

Ok, I am trying to do some camparisons in my tables and return results based on weather values match... i'll post the code then explain it, I think it will be easier that way

Code: Select all
/* the below method works and returns all the desired tags */

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

/* this is the method i am struggling with, I am trying to SELECT the book info (auther etc.) from the books table WHERE the $tags (from previous query, match any tags of other books in the `books` table. */

$recommended =mysql_query("SELECT `auther`, `title`, `isbn` FROM `books` 
WHERE `$tags` = (SELECT `tag1`, `tag2`, `tag3`, `tag4`, `tag5` from `books` WHERE  `book_id` NOT IN (SELECT `book_id` FROM `userBooks` WHERE `user_id` = '$sessionUserId'))");


the way i interpret this query is that it will SELECT the `auther` `title` etc. from the books table where the $tags = the tags in the `books` table WHERE book_id is not already in the `userBooks` table against that `user_id` - this obviously isnt happending because nothing is being returned.

Please can someone help/advise me with this?

Thanks

Dbewick123
dbewick123
New php-forum User
New php-forum User
 
Posts: 1
Joined: Tue Mar 12, 2013 11:28 am

Re: Long nested SELECT statement - Please help

Postby johnj » Thu Mar 14, 2013 8:01 pm

One way to do this will be to assign each of the SQL queries to variables, print it using php and then copy that SQL and take to a mySQL ui like phpmyadmin and run the query there to see if the query is doing what it should do.
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 3 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.