I want to get list of table names with sql query.
::example ::
( mysql case )
> show tables;
what is informix case??
::my code::
:: please, fill in blank.. ________
<head>
<title>list</title>
</head> 
<body>
<?
$conn_id = ifx_connect("stores_demo", "informix", "informix") or die("DB 楷æ¬ 角è©!");
$res_id=ifx_query("___________",$conn_id);
if (! $res_id) {
echo("Can't get table list :");
ifx_error();
ifx_errormsg();
die;
}
?>
<绊按 府胶飘>
<?
echo "<br><br>";
ifx_htmltbl_result($res_id, "border=\"1\"");
ifx_free_result($res_id);
ifx_close($conn_id);
?>
</body>
::example ::
( mysql case )
> show tables;
what is informix case??
::my code::
:: please, fill in blank.. ________
<head>
<title>list</title>
</head> 
<body>
<?
$conn_id = ifx_connect("stores_demo", "informix", "informix") or die("DB 楷æ¬ 角è©!");
$res_id=ifx_query("___________",$conn_id);
if (! $res_id) {
echo("Can't get table list :");
ifx_error();
ifx_errormsg();
die;
}
?>
<绊按 府胶飘>
<?
echo "<br><br>";
ifx_htmltbl_result($res_id, "border=\"1\"");
ifx_free_result($res_id);
ifx_close($conn_id);
?>
</body>