Help: Two dimensional array from table

[Mark Fellowes <Zanoni@xxxxxxxxx>]

I created an array to pull data out of one column in database.

      <?php 
//Code for registered
$usrregid = array();
do {
 $usrregid[] = $row_rs_usr_usr["usr_id"];
} while($row_rs_usr_usr = mysql_fetch_assoc($rs_usr_usr));
//end of registered
?>

However I now need a second column from the table and think a two dimensional array is the right way to go. Having a problem though in defining.  Most of the examples I found don't seem to apply to pulling the values from a db.

I tried this and while it returns no errors, it also returns no value.

<?php 
//Code for registered
$usrreg = array("id", "date");
do {
 $usrreg[] = $row_rs_usr_usr["usr_id"]["usr_date];
} while($row_rs_usr_usr = mysql_fetch_assoc($rs_usr_usr));
//end of registered
?>

Am I defining wrong or pulling the values wrong ?

TIA
Mark
__________________________________________
Organize. Communicate. Share. @ http://www.goowy.com