A little jelp with sql

[weeder]

I am trying to put a country flag in mainmenu and can't get this sql query right can anyone help please

 

$ct= mysql_fetch_object(mysql_query("SELECT coun_flag FROM countries WHERE coun_id = '{$ct['country']}'")); 
echo "<center>[img={$ir[]

[Lithium]

Re: A little jelp with sql

 

I am trying to put a country flag in mainmenu and can't get this sql query right can anyone help please

 

$ct= mysql_fetch_object(mysql_query("SELECT coun_flag FROM countries WHERE coun_id = '{$ct['country']}'")); 
echo "<center>[img={$ir[]

 

a little more code would be better for someone to help... but at first glance... it seems you got $vars all messed up so it doesn't show...

[weeder]

Re: A little jelp with sql

There is no more code

what I am doing is reading a image url which is in database countries table>coun_flag. depending on which country the user is in which is stored in user table >country

[weeder]

Re: A little jelp with sql

Solved

Thank you very much for your help