echoing results

[timtom3]

Hi

on here [a href=\"http://members.lycos.co.uk/timtom1111/script.txt\" target=\"_blank\"]http://members.lycos.co.uk/timtom1111/script.txt[/a] my script isn't displaying the information, the SQL statement does work when carried out in the databse?

I know i am doing something stupid as I have it working without the last bit on just displaying one record but I need to display it when username is present

[php_b34st]

can you show us some code?

I just looked at the link and it is the code, my error

[php_b34st]

try:

[code]$username =  $HTTP_GET_VARS['username'];

$result = $connector->query("SELECT * FROM cmsusers cu, cmscourses cc WHERE cu.username = cc.username AND cu.username = '$username'");[/code]

[timtom3]

[!--quoteo(post=351905:date=Mar 5 2006, 05:30 PM:name=php_b34st)--][div class=\'quotetop\']QUOTE(php_b34st @ Mar 5 2006, 05:30 PM) [snapback]351905[/snapback][/div][div class=\'quotemain\'][!--quotec--]
can you show us some code?

I just looked at the link and it is the code, my error
[/quote]


hi doesn't give any errors just doesn't display the data

[a href=\"http://members.lycos.co.uk/timtom1111/admin/profiletest.php?username=mkandola\" target=\"_blank\"]http://members.lycos.co.uk/timtom1111/admi...ername=mkandola[/a]

[timtom3]

[!--quoteo(post=351911:date=Mar 5 2006, 05:46 PM:name=timtom3)--][div class=\'quotetop\']QUOTE(timtom3 @ Mar 5 2006, 05:46 PM) [snapback]351911[/snapback][/div][div class=\'quotemain\'][!--quotec--]
hi doesn't give any errors just doesn't display the data

[a href=\"http://members.lycos.co.uk/timtom1111/admin/profiletest.php?username=mkandola\" target=\"_blank\"]http://members.lycos.co.uk/timtom1111/admi...ername=mkandola[/a]
[/quote]


:( still not displaying anything