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

blank page.... nothing is happening.
I'm new to a lot of this but in the last 24hrs have learned a lot.
Installed latest version of my

AutoChoosing a CSS file based on URL
Hey everyone,

I have a site that has multiple URLs and CSS files.

Based on the URL tha

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

How to schedule the a job?
Hi,
I have prepared a task ( i.e. a procedure is prepare the file and send the same to con

login to other site by sending post variables
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us

adding 0 to numbers
Hey guys i need to create a 00001 number in a loop. Is there a better way of forcing a 5 digit numbe

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w