additional sql WHERE condition

[geraldjr30]

hi,

i have the following:

$sql="SELECT admitday, shift, infocount FROM qry_sum WHERE admitday ='".$count."'";
 

i would like to know how i can add an additional AND WHERE code = html form field. i am just not sure of the syntax.

thanks in advance,
geebee

[Markus]

Simply add AND to your SQL, like so:

 
$query = "SELECT `row1` FROM `tbl1` WHERE `row2` = 0 AND `row3` = 1";
 
 

Hope this helps,
Markus.

[geraldjr30]

thanks.. i figured it out... you also need the following to remember the form field upon form posting:

$FLD= $_POST["FLD"];
 

[Markus]

@geraldjr30
What does that have to do with your question?

[geraldjr30]

i noticed that without it the page does not remember the posted form value to be used in the WHERE clause

[Markus]

@geraldjr30
Ok. Glad you got it working.

Markus.