get records

rbvinc

With a checkbox/submit button, I am pulling/selecting all the
following record numbers. Each record number has data associated with it.
Is there any way I can get/write sql to get results for all the
following record numbers in "one file".

Either ASP or PHP code will be helpful. (Windows 2000 and IIS).
Thank you.

Record number - 57
Record number - 183
Record number - 81
Record number - 31
Record number - 52
Record number - 53
Record number - 17
Record number - 16

thorpe

what code are you using to get these record numbers?

rbvinc

Here is the code, PHP.
<?php
$conn=odbc_connect('oracle','un','pw');
if (!$conn)
{
exit("Connection Failed: " . $conn);
}
$sql="SELECT * FROM contacts order by company";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{
exit("Error in SQL");
}
echo "<table cellpadding='0' cellspacing='0' border='1'>";
echo "<tr bgcolor='#ffff00'>";
echo "<td width='3'> Id</td>";
echo "<td width='300'> Company</td>";
echo "<td align='center' width='30'>C</td>";
echo "</tr>";
while (odbc_fetch_row($rs))
{
$recordid=odbc_result($rs,"recordid");
$company=odbc_result($rs,"company");
echo "<tr><td width='30'> $recordid</td>";
echo "<td width='300'> $company</a></td>";
?>
<td>
<INPUT type="checkbox" name="recordid[]" value="<? echo "$recordid"; ?>">
</td>
<?
echo "</tr>";
}
odbc_close($conn);
echo "";
?>

thorpe

alright then... you seem to know what your doing, and you are retrieving both the id and the company name. i dont really understand your question.

what exactly is it your trying to do?

rbvinc

When I check some checkboxs and submit, I get the following
record numbers,

Record number - 57
Record number - 183
Record number - 81
Record number - 31
Record number - 52
Record number - 53
Record number - 17
Record number - 16

On pagetwo.php this is how I am retreving the above
record numbers.

<?php
foreach($_POST['recordid'] as $value) {
echo " Record number - " . $value , "\n";
}
?>

now I want to take above each value (record number value),
and write an "individual sql" like. (I do not know
how to break and write individual sqls)

$sql="SELECT * FROM contactsNew where recordid ='57'";

$sql="SELECT * FROM contactsNew where recordid ='183'";

$sql="SELECT * FROM contactsNew where recordid ='81'";

and so, and display all the related data to each
record number.