Address array?
| From: | Steve Jackson | Date: | Mon, 04 Nov 2002 08:42:47 +0000 |
| Subject: | Address array? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-122637@lists.php.net to get a copy of this message | ||
I want to display an address from my database based on an orderid. Where
am I going wrong? I am still unsure how Php interacts with mySQL but am
I right in assuming it should be an array?
My code...
function get_shipping_address($address_array)
{
$conn = db_connect();
$orderid = get_order_id($orderid);
$query = "SELECT * FROM orders WHERE orderid = '$orderid'";
$row = mysql_fetch_array($query);
foreach ($address_array as $row)
{
$ship_name = $row["ship_name"];
$ship_address = $row["ship_address"];
$ship_city = $row["ship_city"];
$ship_zip = $row["ship_zip"];
$ship_country = $row["ship_country"];
}
}
Steve Jackson
Web Developer
Viola Systems Ltd.
http://www.violasystems.com
stephen.jackson@violasystems.com
Mobile +358 50 343 5159