[SOLVED] multidimension array using mysql database

[project-nz]

hi hows it going

i have a database table which then i turn it into a array

my problem is that im trying to get a column out of the table called

'name' and specify a row number.

 

like the code below but it doesnt work

 

$row['name'][10]

 

thanks in advance

 

 

        $result = mysql_query("SELECT * FROM listtab")
        or die(mysql_error());

        $result2 = mysql_query("SELECT * FROM ordertab")
        or die(mysql_error());

$row = mysql_fetch_array( $result);

   // search array from db table
        while($row2 = mysql_fetch_array( $result2 )) {

                
                $obj = new Listings($row['name'][row2['listno']]);
                
             
        }

[wildteen88]

$row will only be a single dimensional array. You cannot return a specific row in this way. However you can with mysql_result

[project-nz]

$row will only be a single dimensional array. You cannot return a specific row in this way. However you can with mysql_result

 

thanks much appreciated