Hello all,
I am trying to pull data and then loop through the multiple results display
in seperate rows.
My database contains several tables which are all tied together by the
credit_card_id. After running the query, it ties the unique record together
by matching the credit_card_id in both tables. How would I go about
displaying the results of this query in a table with a single row for each
unique record?
Each row of the result will have 5 columns: Request ID, Date/Time Entered,
Status, Payment Type, Last Processed By.
If I assign the results of the query to variables (Such as $id =
$row['credit_card_id'];) how would I display that data?
Would it be something like this:
foreach($row as $data)
{
echo "<table>
<tr>
<td><a href=$item->link>$id</a></td>
</tr>";
echo "<tr>
<td>$dateTime</td>
</tr>
</table>";
echo "<tr> <td>$Status</td>
</tr>
</table>";
}
Below is the code I have so far.
<?php
$database = "database";
$host = "host";
$user = "username";
$pass = "password";
// Connect to the datbase
$connection = mssql_connect($host, $user, $pass) or die ('server
connection failed');
$database = mssql_select_db("$database", $connection) or die ('DB
selection failed');
// Query the table and load all of the records into an array.
$sql = "SELECT
child_support_payment_request.credit_card_id,
credit_card_payment_request.credit_card_id,
date_request_received
FROM child_support_payment_request,
credit_card_payment_request
WHERE child_support_payment_request.credit_card_id =
credit_card_payment_request.credit_card_id";
$result = mssql_query($sql) or die(mssql_error());
while ($row=mssql_fetch_array($result));
$id = $row['credit_card_id'];
$dateTime = $row['date_request_received'];
?>
