Multiple Do / While Statements?

Posted on 16th Feb 2014 07:03 pm by admin

I'm still very new to PHP, and running in to a problem when trying to execute a do/while loop inside another one.
What I'm trying to achieve is that I want to display all of the records in one table that match my SQL Query defined as 'Recordset1'.
And, while that is happening, I want to cross-reference my records in a 2nd table, and if the description in Table 2 Matches the Description in Table 1, print a results message right next to the description from 'Recordset1'.

My problem isn't setting up the SQL queries - I'm currently able to get the correct results returned to me, as long as I print the results in a separate table... my problem is getting the results message to print RIGHT NEXT TO the results of 'Recordset1', because the 'Recordset1' results are inside of do/while loop.

There is probably a very simple solution to this, and there's a good possibility that I'm approaching this the wrong way... I just can't wrap my head around it yet...

If anyone has any input, it would be very appreciated!
Thanks!
-d.


Code: [Select]<?php

do {
if(isset($row_Recordset1['description'])) { ?>
<tr>
<td> <?php echo $row_Recordset1['description']?>
<?php

do{
$R1 = $row_Recordset1['description'];
$R2 = $row_Recordset2['description'];

if ($R1== $R2) {
print("It's a Match<br />");
} else
print("No Match<br />")
}while ----????????????? ----
?>

</td>
</tr>
<?php }else break;
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

Your Answer:

Login to answer

Other forums

Need help in log in and log out?
hi there all of u. i have recently created a site for someone. i have placed log in and log out and

Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

read integers that returns a negative or prints the average
Im trying to finish this homework assignment by tommarow afternoon and I keep getting stuck.
Wr

How to know if online site made with PHP
Hello,
I see some sites that does not display extensions at all , for example:

www.site.co

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in

Changing color in GD via variable?
Hey guys, I'm new here. x)

I'm very much a noob when it comes to PHP, but I'm trying to learn

Php - mysql select?
hi, i have this code:

Code: <?php
session_start();
// dBase file
include &quo