mysql_fetch_array() not working properly, missing most values

Question

Alright, so I'm trying to get an array of Key values from a mysql table and mysql_fetch_array() won;t seem to work properly. Code:

                        $x="select id from topics"
                    $set=mysql_query($x);
                    echo mysql_num_rows($set);
                    print_r(mysql_fetch_array($set));
                    $ids=mysql_fetch_array($set);
                    echo $ids[0];
                    echo $ids[1];

I've moved stuff all around but nothing seems to be changing the output:

66 //number of values in result set

Array ( [0] => 3 [id] => 3 ) //value(singular) being moved to array

4 //supposed single value of the above array

I'm really not sure what is going on here...

akatakritos · Accepted Answer · 2012-11-06 02:49:06Z

3

mysql_fetch_array brings a single row back as a PHP array, indexed by column name and by 0-based index. it DOES NOT load the whole set into a giant array, which is what you seem to be expecting.

You have to iterate over the result set in a loop, like so:

$x="select id from topics";
$set = mysql_query($x);
echo mysql_num_rows($set);
$giant_list_of_ids = array();
while ($row = mysql_fetch_array($set))
{
    echo $row[0]; //or alternatively, echo $row['id'];
    $giant_list_of_ids[] = $row[0];
}

edited Nov 6, 2012 at 2:49

answered Nov 6, 2012 at 2:37

akatakritos

9,8781 gold badge25 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user1801821 Over a year ago

oh.. well I don;t like that, not that it matters. I'm still getting the same error as below, however: Parse error: syntax error, unexpected '$set' (T_VARIABLE) //where $set is first used

akatakritos Over a year ago

If you want a giant list of ids, you have to manually add them to an array. see my update

user1801821 Over a year ago

Do I need an index to tell where to put $row[0] in the other array?

akatakritos Over a year ago

@user1801821 No, $giant_list_of_ids[] = value is idiomatic PHP for "add to the end of the array"

Collectives™ on Stack Overflow

mysql_fetch_array() not working properly, missing most values

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related