[RESOLVED] Trouble retrieving data

[Megahertza]

I have 3 columns in table 'softcats', 'sid' 'parent' 'name' when trying to echo out $cat_row[sid] I get nothing, but if I echo out the array key $cat_row[0] it works, Have i made a mistake preventing me using [sid]

$cat = $_GET[cat];
include 'includes/connection.php';
$cat_query = mysql_query("SELECT * FROM softcats WHERE parent = 0") or die(mysql_error());
echo "<table width='100%'>";
while ($cat_row = mysql_fetch_array($cat_query)) {
echo "<tr><td><a href='index.php?pid=software&cat=".$cat_row[sid]."'>".$cat_row[name]."</a></td></tr>";
}
echo "</table>";

[bpat1434]

As a great rule of thumb, strings should be encased in quotes (either single or double) when referencing array keys. So the call $cat[0] is fine because 0 is an integer. $cat[sid] is a string, and should be encased in quotes.

Try:

$cat_row['sid']

See if that works...

[Megahertza]

Thanks, that makes sence

[bpat1434]

Makes sense, but does it solve your problem?