Array's doing funny things

[Slip]

Hi all,

 

This is my first post (one of many!).

 

I am having a weird problem with calling arrays when using mysql_fetch_array(). Say my array holder is $array and I want to call the column "id" from my row, I have to use $array[0] rather than $array['id'] which I have been using for sometime! It's only recently started happening. Any clues as to why PHP has switched to this method of calling arrays?

[Cosizzle]

I don't think PHP randomly switched hehe, perhaps you created another array with the same name $array?

[Ken2k7]

Could you possible post up some code?

[Slip]

Well here is some sample code...

 

$sql = "SELECT * FROM `tablename` WHERE `uid`={$uid}";
$res = mysql_query($sql, $link);

while($row= mysql_fetch_array($res)) {
    // Do something with $row['column_name']
}

 

Just checked the duplicate array variable and yes, I am using it ($row) in more than one place on the page! Silly me, thanks for pointing that out.

 

[DarkWater]

Also, just use mysql_fetch_assoc().  Saves a bit of space and makes your array smaller.

[Slip]

Also, just use mysql_fetch_assoc().  Saves a bit of space and makes your array smaller.

 

I'll have a read up on that function,

 

Thanks!

[Ken2k7]

Also, just use mysql_fetch_assoc().  Saves a bit of space and makes your array smaller.

Or mysql_fetch_array() with the optional third parameter set to MYSQL_ASSOC.

[DarkWater]

mysql_fetch_assoc() would be faster because it wouldn't need to parse the constant.  Just saying.  It's your preference though.  I like the one with less typing.

[akitchin]

from the php manual:

 

Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. mysql_fetch_assoc() is equivalent to calling mysql_fetch_array() with MYSQL_ASSOC for the optional second parameter. It only returns an associative array.

 

performance won't matter, it just depends if you ever want to switch up which indexing you want to use.