[PHP-DB] Help: Two dimensional array from table

2006-04-07 Thread Mark Fellowes
I created an array to pull data out of one column in database. 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

[PHP-DB] Unique fields, grabbing errors

2006-04-07 Thread Jason Gerfen
I am having a problem trying to use 3 unique fields in a database table and grabbing the errors that may result, any help is appreciated. $update = @mysql_query( "UPDATE hosts SET hostname='$host', mac='$mac', ip='$ip', vlan='$vlan', group='$group' WHERE hostname=\"$host\"", $db ); $error = @m

Re: [PHP-DB] Help: Two dimensional array from table

2006-04-07 Thread Mark Fellowes
The reason I had orginally singled out one column ['usr_d'] is so I could nest it inside another loop to see if two values match. if usr_id matched returned value from first loop. The way I called it was if(!in_array(@$row_rsResults['id_subscribe'],$usrreg)) { else{ now Im not