Any help on this query would be great...

[Ansel_Tk1]

Hi - obvious noob... trying to combine 2 conditions on a query:

 

SELECT *

FROM vidsys1_programflv_list

WHERE video_pages LIKE %colname% AND vidsys1_programflv_list.video_client = colname2

ORDER BY video_order ASC

 

Where colname=$_GET['pg']

and colname2=$SESSION['kt_home_page']

 

Any help would be appreciated. tx

[bobinindia]

I assuming this is a typo:

$session should be $_SESSION.

you mention this as a table name:

vidsys1_programflv_list

Is video pages also a table name by any chance?

 

 

[Ansel_Tk1]

Hi - thanks bobinindia

 

both video_client and video_pages are fields in the table vidsys1_programflv_list

 

Dan

 

[bobinindia]

i am a beginner really myself but as no one is answering.

 

I don't think you need to mention the table twice

 

vidsys1_programflv_list.video_client  should just be video_client

 

Passing thought.

Good luck

[Barand]

use quotes round string values

$sql = "SELECT *
FROM vidsys1_programflv_list
WHERE video_pages LIKE '%$colname%' AND video_client = '$colname2'
ORDER BY video_order ASC";