Can anyone tell me what i can do to fix this code?
<?
$sql = "select * from owners_contractors";
$result = mysql_query($sql);
$num = mysql_numrows($result);
echo "<script>AddressArray[0] = new Address(\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\");\n";
while ($owners = mysql_fetch_array($result)) {
$id=$owners['id'];
$name=$owners['name'];
$address=$owners['address'];
$city=$owners['city'];
$postalcode1=$owners['postalcode1'];
$postalcode2=$owners['postalcode2'];
$phonenumber1=$owners['phonenumber1'];
$phonenumber2=$owners['phonenumber2'];
$phonenumber3=$owners['phonenumber3'];
for($i=0;$i<$num;$i++)
{
echo "AddressArray[$i] = new Address(\"$name\", \"$address\", \"$city\", \"$postalcode1\", \"$postalcode2\", \"$phonenumber1\", \"$phonenumber2\", \"$phonenumber3\");\n";
}
} echo "</script>";
?>
It keeps coming out like this:
AddressArray[0] = new Address("", "", "", "", "", "", "", "");
AddressArray[0] = new Address("lanny mcdonald", "", "victoria", "", "", "", "", "");
AddressArray[1] = new Address("lanny mcdonald", "", "victoria", "", "", "", "", "");
AddressArray[2] = new Address("lanny mcdonald", "", "victoria", "", "", "", "", "");
AddressArray[3] = new Address("lanny mcdonald", "", "victoria", "", "", "", "", "");
AddressArray[4] = new Address("lanny mcdonald", "", "victoria", "", "", "", "", "");
AddressArray[0] = new Address("lori appleton", "testing street", "duncan", "v7t", "2r7", "123", "845", "7383");
AddressArray[1] = new Address("lori appleton", "testing street", "duncan", "v7t", "2r7", "123", "845", "7383");
AddressArray[2] = new Address("lori appleton", "testing street", "duncan", "v7t", "2r7", "123", "845", "7383");
AddressArray[3] = new Address("lori appleton", "testing street", "duncan", "v7t", "2r7", "123", "845", "7383");
AddressArray[4] = new Address("lori appleton", "testing street", "duncan", "v7t", "2r7", "123", "845", "7383");
AddressArray[0] = new Address("manchester", "", "victoria", "", "", "", "", "");
AddressArray[1] = new Address("manchester", "", "victoria", "", "", "", "", "");
AddressArray[2] = new Address("manchester", "", "victoria", "", "", "", "", "");
AddressArray[3] = new Address("manchester", "", "victoria", "", "", "", "", "");
AddressArray[4] = new Address("manchester", "", "victoria", "", "", "", "", "");
AddressArray[0] = new Address("farmer construction", "jdfal;dsj", "victoria", "fv8", "skd", "250", "343", "2343");
AddressArray[1] = new Address("farmer construction", "jdfal;dsj", "victoria", "fv8", "skd", "250", "343", "2343");
AddressArray[2] = new Address("farmer construction", "jdfal;dsj", "victoria", "fv8", "skd", "250", "343", "2343");
AddressArray[3] = new Address("farmer construction", "jdfal;dsj", "victoria", "fv8", "skd", "250", "343", "2343");
AddressArray[4] = new Address("farmer construction", "jdfal;dsj", "victoria", "fv8", "skd", "250", "343", "2343");
AddressArray[0] = new Address("microsoft", "123", "Victoria", "242", "424", "224", "242", "2242");
AddressArray[1] = new Address("microsoft", "123", "Victoria", "242", "424", "224", "242", "2242");
AddressArray[2] = new Address("microsoft", "123", "Victoria", "242", "424", "224", "242", "2242");
AddressArray[3] = new Address("microsoft", "123", "Victoria", "242", "424", "224", "242", "2242");
AddressArray[4] = new Address("microsoft", "123", "Victoria", "242", "424", "224", "242", "2242");