Hello, currenly I am working on a query page and need help in fixing my query code. My php query scripts are located before html file so I put an echo command at the html table but what happen was that the data that shown up is only the last data in the database table (I think I should modify the query or put a loop inside echo command but I do not know how to do it). So can someone help me with the query?
As you can see below is the original code but I need to move the echo into dreamweaver table and keep it looping and showing the woled data in query and not only the last one. pleae help thanks
<?
session_start();
if (!isset($_SESSION['login']))
{
header('Location:http://localhost/wip/index.html');
}
$conn=odbc_connect('jascon','root','admin');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM user_case_data";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
while (odbc_fetch_row($rs))
{
$compname=odbc_result($rs,"case_num");
$conname=odbc_result($rs,"case_outcome");
echo "$compname";
echo "$conname";
}
odbc_close($conn);
echo "</table>";
session_destroy();
?>