Jump to content


Photo

Need help in query


  • Please log in to reply
1 reply to this topic

#1 jacob

jacob
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 10 November 2005 - 06:39 AM

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();
?>



#2 jweiss

jweiss
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 November 2005 - 09:53 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users