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]

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

$FLD= $_POST["FLD"];

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]

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

Ok. Glad you got it working.

Markus.