<?
$db_user = "user"; // username for db $db_password = "password"; // password for db $db = "database@server"; // db to use
$db_query = "select id, product from catalog";
$conn_id = ifx_connect("$db", "$db_user", "$db_password"); $result = ifx_query($db_query, $conn_id);
if ($result) {
echo "These were in the catalog table:<ul>";
while ($r = ifx_fetch_row($result)) {
// reformat output
$id = $r["id"];
$product = $r["product"];
echo "<li>$id, $product";
}
echo "</ul>";
} else {
echo "No data.";
ifx_errormsg();
} ifx_free_result($result); ?>
|
|