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

CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.

I have images like this:

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

Help If user voted, block them
On my Prayer request site, i let users Click a button to Pray for somone that has posted a pray, i g

PHP Game
hy i was wondering what's the best method in order to make some automatic updates in a php game
<

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

Suggestions for Functional module
Hello experts,
I Have done B.Sc(Mathematics) and MCA & have learnt SAP/ABAP but do n

Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b