PHP MySQL Invalid Query bool(False)

Question

I am working with a MySQL Database with two tables up and info. up has columns ID and Password and info has columns ID, FirstName, LastName, Email, and Reg and ID joins the two tables. I am working in PHP and have this query which is giving me bool(false) on var_dump when I call it

$result = $conn->query("SELECT up.Password FROM up INNER JOIN info ON info.ID = up.ID WHERE info.EMAIL = " . $email);
var_dump($result);
$row = $result->fetch_assoc();

The query works when I query mysql with that identical query and the variable $email returns a proper result when I call var_dump on it.

enclose $email with single quotes. WHERE info.EMAIL = '" . $email."'" — roullie
– roullie, Commented Feb 23, 2016 at 2:44
Oh my god thank you so much. I feel like the moron of the century. — Eli Sadoff
– Eli Sadoff, Commented Feb 23, 2016 at 2:45

Naveed Ramzan · Accepted Answer · 2016-02-23 04:59:26Z

1

Whenever we use some text string in any clause in query. Always write with quotes.

like

$query  = "SELECT up.Password FROM up INNER JOIN info ON info.ID = up.ID WHERE info.EMAIL = '".$quer."'";
$result = $conn->query($query);

answered Feb 23, 2016 at 4:59

Naveed Ramzan

3,5893 gold badges27 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

PHP MySQL Invalid Query bool(False)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related