Query code help

[ld0121]

Hi everyone, I have a query that im trying to get working but getting stuck.

Baiscally i want to display results from a code number ($trimmed) that is done through a link to a results page that picks up up the code number and displays the results. But I also need to check against a flag code either a 1 or a 2.

so in english... if flag = 1 and ident = $trimmed show the related results....

$query = "SELECT FROM ghdata1 WHERE ident LIKE '%$trimmed%'";
$query = "SELECT FROM ghdata1 WHERE flag LIKE \"1\"";

as you can see I can easily put the queries together as separates and have either one or the other working, but cant figure out how to get them working as one query.

Help?

I hope that makes sense, any help would be great.

Thanks
Lee

[devinemke]

$query = "SELECT * FROM ghdata1 WHERE ident LIKE '%$trimmed%' AND flag LIKE '1'";

[ld0121]

Many thanks, works a treat :o)

[LoganK]

Please mark this as resolved!