[Resolved] strange problem on sql query

[helz]

well i do a simple mysql_query on my website and then get the value of a file which is:
/downloads/test2/testint/downloads.php.txt
here is the code im using to get the info from the db:

$getdlinfo = mysql_query("SELECT dlname, dllink, isurl FROM $dltbl WHERE dlid='$dlid'") or die(mysql_error());
$getdlinfo = mysql_fetch_array($getdlinfo);
$getdlname = $getdlinfo['dlname'];
$getdllink = $getdlinfo['dllink'];
echo $getdllink.'<br>';
$dlpath = $DOCUMENT_ROOT.'/'.$getdllink;
echo $dlpath.'<br>';

$getdllink should output:
/downloads/test2/testint/downloads.php.txt
but it outputs D
and the $dlpath should output the same but with the value of document root before it,
here is what comes up
$getdllink = D
$dlpath = /home/user~2/public_html/directory~3/D

[LordShryku]

Ya sure you're not pointed at the wrong database again?

Try doing a print_r($getdlinfo) after the query....

[helz]

tis is alright, just played a bit of ut2k3 and now ive seen the error of my ways.

when i first wrote the query i was only getting one field from it so i used the same variable to define what the field was:
$getdlname = $getdlname['dlname'];

so then when i added more fields after it, it was trying to get the field: dllink inside the dlname. the first letter of the dl name being D 🙂

[LordShryku]

"Nothing like a rocket launcher to clear the mind" tis what I always say 😃

[helz]

yup, decided to do the campaign again, upto that one where you draft a team then you have to beat em. ive lost twice now 🙁 i hate phobos 2 map lol