php/mysql problem!!!

[ramu_rp2005]

In php scripting when using mysql, i've used a query as below

$query = "SELECT s.stream_name,s.stream_location,v.video_type,v.video_pid,a.audio_pid,a.audio_type,v.video_resolution,v.video_frame_rate from 		

streams s join video v on (v.video_sid= s.stream_id)  join audio a on(a.audio_sid=s.stream_id and a.audio_prgm_number=v.video_prgm_number) 		

and v.video_resolution like '%$string'";

Doesn't the like clause take '%string' or the like clause has to be specified with percentage at last of $string like '%$string%'. why doesn't it execute.plz help.

[bpat1434]

and v.video_resolution like '%$string'";

This should most likely be
WHERE v.video_resolution like '%$string'";
instead of AND....

[ramu_rp2005]

sory i've tried and its not working.

[iamtheironman]

maybe

and v.video_resolution like '%".$string."'";

[agudiel]

If you want to filter out the results AFTER the joins, you should add a WHERE before the last condition. If that's the case, I would write the query like this:

$query = "SELECT s.stream_name,s.stream_location,v.video_type,v.video_pid,a.audio_pid,a.audio_type,v.video_resolution,v.video_frame_rate
FROM streams s join video v on (v.video_sid= s.stream_id) join audio a on (a.audio_sid=s.stream_id and a.audio_prgm_number=v.video_prgm_number)
WHERE v.video_resolution like '%{$string}'";

I hope that helps!