MySQL select gives doubled results

[ghjr]

Trying to get results from a table that has one row with 8 columns on it.

$query = "select * from bra_links where id = '".$id."'";
$result = mysql_query($query,$db_conn);
$row = mysql_fetch_array($result); 

print count($row);

Trouble is, when I try to print out the number of the array it turns out 16, instead of 8. Also, when I try doing some loop to print the results, it's print each result twice.

Any idea of what I'm doing wrong here? Thanks!!

[chyan]

try change it like this

$query = "select * from bra_links where id = '$id' ";
$result = mysql_query($query,$db_conn);
$count = mysql_num_rows($result);

echo $count;

[xblue]

ghjr,

if you are after the number of colums (not rows) don't use mysql_fetch_array() - it returns the array both numerically and indexed associative, thus duplicating the number of items.

instead either
mysql_fetch_assoc() -> associative only
or
mysql_fetch_row() -> numerically only

[ghjr]

Thanks guys, that solved it!! Got it now. 😃

Cheers.