First of all, remove the *, add column name instead, for better practice:
example:
SELECT * FROM tbl_;
SELECT COL_1, COL_2,...,COL_3 FROM tbl_;
mysql_fetch_array()[
^] returns both 0 base indexing and column name indexing. On the other hand
mysql_fetch_assoc()[
^]
I prefer mysql_fetch_assoc, (one less indexing)
For understanding why your are not getting why you are missing column,
use
print_r($row);
further suggestion, Stop using mysql_* functions, try mysqli_*; better yet use
mysqli class[
^]
try using
mysqli::prepare[
^]. SQL injection is a real problem.
Take a look at SQL injection