retrieve multiple record data from mysql database and store it on separate dynamic cr
I have multiple records in mysql database,but i need to fetch all the records from db and store it on seperate dynamic created form.please help me guyz its urgent..
Code:
id name
1 aaa
2 bbb
3 ccc
4 ddd
<?php
$sql = "select * from table";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query))
{
id=$row[id];
name=$row[name];
}
how to