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

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

PHP code for a proxy
I was wondering which function I could use to create an online proxy tool. I was thinking cURL would

A little help needed passing hidden values to next page
I have a page that has hidden values in a form.

example
Code: <input name='signupID

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext

ImageCreate()
When I create an image and add text to it I want my text to be replaced with a PNG image, because th

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

Retrieving Data from Two Different Databases
Hello All,

Ran into another problem and would appreciate some help! I have two datab

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can