note 121132 deleted from mysqli-result.fetch-array by peehaa
| From: | peehaa@php.net | Date: | Tue, 06 Jun 2017 10:01:46 +0000 |
| Subject: | note 121132 deleted from mysqli-result.fetch-array by peehaa | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-209121@lists.php.net to get a copy of this message | ||
Note Submitter: mr_zedx at live dot com
----
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Example</title>
</head>
<body>
<?php
require_once("dbconn.php");
$sql = "select distinct suburb, postcode from customer";
$rs = mysqli_query($dbConn, $sql)
or die ('Problem with query' . mysqli_error($dbConn));
?>
<p>Select a Suburb to list customers in the same postcode:</p>
<?php while ($row = mysqli_fetch_array($rs)) { ?>
<a href="getcustomer-b.php?pcode=<?php echo $row["postcode"]
?>"><?php echo $row["suburb"]?></a><br>
<?php }
mysqli_close($dbConn);
?>
</body>
</html>