MySQL WHERE

sstonge

I am using the SELECT command to read data from my database. it looks like this.

$query = "SELECT issure_name, card_type, card_name, card_id FROM cards WHERE issure_name LIKE '" . $_SESSION["sBankName"] . "%' ORDER BY issure_name ASC, card_name ASC"; 
$result = mysql_query($query);

that works fine. but I would like to add another WHERE command for card_name to limit the results more, is there an easy way to do that with MYSQL, or do I have to write a php code to sort through it again?

thanks

eoghain

Change your query to something like this:

$query = "
SELECT issure_name,
       card_type,
       card_name,
       card_id
  FROM cards
  WHERE issure_name LIKE '" . $_SESSION["sBankName"] . "'
   AND card_name LIKE '" . $card_name . "'
 ORDER BY issure_name ASC, card_name, ASC";
$result = mysql_query($query);