mysql & php question

[sethcox]

right now I am using:

 while ($myrow = mysql_fetch_row($result))
  			 {
				 $validateun = $myrow[1]; 
				 $passwordHash = $myrow[2];
				 $email = $myrow[4];
				 $dtcgroupid = $myrow[9];	
				 $extranetApproved = $myrow[18];		
				 $downloadApproved = $myrow[19];
				 $adminLevel = $myrow[21];
				 $lastName = $myrow[22];
				 $firstName = $myrow[23];					 
				 }

I'm tired of using row numbers because it's too easy to change the db and then no code works anymore - I want to use field names.

I have tried:

$myrow[name]
$myrow["name"]
$myrow['name']

but no luck - what do i use to specify the column name, not the column number?

Thanks!!

[largo]

have a look at the mysql_fetch_array() function in the manual.

http://www.php.net/manual/en/function.mysql-fetch-array.php

hth.

[cgraz]

or if you only want to fetch an associative array (meaning words between the brackets, not numbers), use mysql_fetch_assoc

http://www.php.net/mysql_fetch_assoc

Cgraz