this is bullshit....bug?

[drewbie]

please tell me im a complete idiot or something, this is really pissing me off.

$link_id = db_connect($default_dbname);
$query2 = mysql_query("SELECT * FROM transactions WHERE TID='$TID'");
$myrow2 = mysql_fetch_row($query2);
echo $myrow2[SID];
echo $myrow2[RID];
echo $myrow2[BID];
echo $myrow2[TID];

ive done queries a bazillion times, and im confused. the table transactions has 4 fields: TID, BID, RID, and SID.
the above query works fine because i can echo out all fields except SID. and yes, the table is populated. im viewing it as we speak in phpmyadmin,and yes the field name is SID. the damn thing is suppsed to echo out 636f3! AHHHHHHHHHH! anyone ever have problems with mysql not returning a certain field or sumthing???

[jerdo]

The way you are trying to access the array variables doesn't match the way you are fetching them. You used this:
$myrow2 = mysql_fetch_row($query2);
That would create a numerical array.
You need to use this:
$myrow2 = mysql_fetch_assoc($query2); //gets associative array
or this:
$myrow2 = mysql_fetch_array($query2); //gets associative and standard