[Resolved] mysql fetch array and MYSQL_ASSOC

[jlpierce]

I have created a class to define a user and various attributes, into this class I have added an array which is supposed to contain contact fetched from a contact tabe.

The problem:

When I user mysql fetch array in the default manner it only retrieves and stores in the object array numeric indices, not the field names as keys. If I supply the MYSQL_ASSOC constant to the fetch array function I get no data stored in the object array variable.

My assignment goes something like this:

for($i = 0; $i < mysql_num_rows($result); $i++)
{
$row = mysql_fetch_array($result);
$this->array[$i] = $row;
}

If I understand php arrays the above code should make $this->array[$i] a multideminsional array, and further since the default for fetch array is to create both numeric and associative keys then the object
array $this->array[1] (for example) should contain another array with the field names as keys.

I have also tried mysql fetch object which then results in no data being stored in the object array.

Any thoughts would be appreciated.

John Pierce

[eoghain]

There doesn't appear to be anything wrong with the code you are showing below. But if you are expecting to get data from $this->array[1] and your query only returns 1 row then you wouldn't get any data back out since you are only setting $this->array[0].

Maybe you should post more of your code so that we can see more of what is going on and maybe help pinpoint the problem. Also when posting code please use the php tags to that it's formatted and color coded it makes reading code so much nicer.

[jlpierce]

This is the function that I am using to fetch user contact information. Again, my understanding of the mysql fetch array function indicates that I should be getting both a numeric and associative key, I finally got it to function correctly.

	function fetch_contacts($db, $uid)
	{
		unset($this->Con_Array);
		$this->DB_Ref = &$db;
		if ($conn = $this->DB_Ref->db_connect())
		{// we made it in the db
			$query = "SELECT CONTACT_ID, TYPE, VALUE FROM USER_CON WHERE USER_ID='$uid'";
			$result = mysql_query($query);
			for ($i = 0; $i < mysql_num_rows($result); $i++)
			{
				$row = mysql_fetch_array($result, MYSQL_ASSOC);
				$this->Con_Array[$i] = $row;
			}// end for i loop
			$this->DB_Ref->db_close($conn);
			unset($this->DB_Ref);
			return TRUE;
		}// end conn if then
		else
		{
			return FALSE;
		}
	}// end of function fetch_contacts()

One reason I want to get this function down smoothly, I have 2 other tables containing user data and I was hoping that I could make this function generic in the aspect of calling it with different table names and arrays and then only require one function.

John