jacob Posted November 10, 2005 Share Posted November 10, 2005 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(); ?> Quote Link to comment https://forums.phpfreaks.com/topic/2839-need-help-in-query/ Share on other sites More sharing options...
jweiss Posted November 14, 2005 Share Posted November 14, 2005 Hey Jacob, check this and see if it'll work for ya. I tried to add some comments. <?php 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");} //exit out of php to create table ?> <table> <?php //go back into php to start loop while (odbc_fetch_row($rs)) { //exit again to fill in values ?> <tr> <td><?php echo odbc_result($rs,"case_num"); ?></td> <td><?php echo odbc_result($rs,"case_outcome") ?></td> </tr> <?php //back in php to close out the loop } odbc_close($conn); // and back out of php again to close the table ?> </table> <?php session_destroy(); ?> -jeremy Quote Link to comment https://forums.phpfreaks.com/topic/2839-need-help-in-query/#findComment-9646 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.