How do I include a conditional in my mysql query?

You will usually need to apply some logic to the query that you apply to a table, and this is easily done with the WHERE keyword.

This will be followed by a fieldname, or list of them, and then the condition you want to be met.

Thus if you want to select only rows from a table WHERE the user is called Quentin you would do the follow:


<?php

$peeps = mysql_query("SELECT * FROM users WHERE firstname = 'Quentin'");

?>

Categories

PHP Functions

More PHP

How do I include a conditional in my mysql query?

More mysql PHP Questions