PHP + Format array to be then used inside query

Question

Let´s say i perform a query like this:

$charsnamequery = mysql_query("SELECT * FROM 'bookstable' WHERE 'bookcharactersname' = 'JHON'")

This will give back a resource that i then put in an array and use to print the results like this:

while ( $fullist = mysql_fetch_array( $charsnamequery ))
{ Print "book title: ".$fullist['id_book'] . ", book author:".$fullist['book_author'] . "
.....etc etc etc";
 }

So, lets say that now i want to do is: Search on my database for customers who have showed interest in any of those id_book in the past and gather their emails.

I know i am suposed to reformat the array in someway so that i can do a new query like:

$newquery = mysql_query("SELECT 'email' FROM 'customerstable' WHERE 'id_book_interested_in' IN ($value1,$value2,$value3....etc etc etc)"

Hope you can give me a hand with this! Thanks you in advance!

PS: I rather not join the querys even if it were possible for im trying to learn step by step.-

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — Kermit
– Kermit, Commented Apr 15, 2013 at 3:02
Thanks for the pointers! I did not know that! I guess i have been reading old tutorials =/ — Khul
– Khul, Commented Apr 15, 2013 at 3:54

Community · Accepted Answer · 2017-05-23 12:18:55Z

1

The reason why the query is not working is because you are wrapping the table name as well as column name with single quote.

SELECT * FROM bookstable WHERE bookcharactersname = 'JHON'

These are identifiers and not string literals. In this case, backticks are optional since non of them are reserved keywords.

MySQL - when to use single quotes, double quotes, and backticks?

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Apr 15, 2013 at 3:03

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Khul Over a year ago

Thanks for the info. I guess i just wrote it down badly while posting the question. My actual issue it with getting the "SOMEWAY" (highlighted on the text) done. That is the step i do not know how to perfom

Collectives™ on Stack Overflow

PHP + Format array to be then used inside query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related