Query Access DB and return fields

Hi

I am very new to this. I am not a programmer so I hope this makes sense.
I have run into another problem. My last questions was and if statement that returns a number depending on the statement. (here is the original post http://www.phphelp.com/forum/index.php?topic=20487.0)
What i need to do now is take that number and compare it to a field in an access database table (Test_Code). Once the field is found it needs to return the information from that row. The fields are as follows
Ag_fn
Ag_Res
ag_wo
Test_Code
Description
Active

If there are entries with the same number need a error thrown back, if there is no entry need an error, and if the active field is not checked need an error.

Here is the database connection but need to do the queries and errors.
I appreciate any help or guidance
Thanks in advance

[php]$sth = $map_dh->read_stmt(‘query to go here i think’);
$res = $sth->fetchAll(); not sure what goes after[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service