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>
