1 reply to this topic

[Stasonix]

for example I have a table:

CREATE TABLE `db_test`.`tb_test` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`carname` INT NOT NULL ,

`drivername` INT NOT NULL ,

`flag_test` TINYINT NOT NULL

) ENGINE = MYISAM ;

then assoc array on outside must have look like this:

$MyCar = array();

$MyCar[0] = array(

    'name' => "toyota",

    'voditel' => array("alex"),

    'dr_test' => array(1),

);

well next $MyCar[1] must have data from next record of table tb_test, how to get it in?

[gregwarner]

Use this:

$query  = "SELECT * FROM tb_test";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

mysql_fetch_assoc() returns a row from your table as an associative array using the column names as the keys. It returns null if there are no more rows to read.

If you want to read all the rows into an array, you can use a while loop like this:

$rows = array();

while ($row = mysql_fetch_assoc($result)) {

    $rows[] = $row;

}