jweiss

This really isn't that hard. I've built several of these for some real estate companies. If you need some guidance on it just send me a private message. -jeremy

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

Hey Frank, Insert this into your page and then highlight it and tell DW to show when there are no records [!--fonto:Courier New--][span style=\"font-family:Courier New\"][!--/fonto--][blockquote]header("Location: [a href=\"http://www.example.com");\" target=\"_blank\"]http://www.example.com");[/a][/blockquote][!--fontc--][/span][!--/fontc--] Or, if you're redirecting to another page on your site, this snip will redirect to the index page. [!--fonto:Courier New--][span style=\"font-family:Courier New\"][!--/fonto--][blockquote]header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/index.php");[/blockquote][!--fontc--][/span][!--/fontc--] If you have any problems let us know. -jeremy

MommaTC, If you could, please post the code you're currently using along with the details on the table where the information is stored. Once I see what you're working with, I'm sure we can hack out what you're needing done. -jeremy