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)); ?>
Product categories for registration
Dear all,
Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the right posted. That database is set up to keep post id, title, subject, date, and author. The only
Compare user input to flat file data
Help...Am a complete newbie to programming so my code is prolly quite long. Am trying to verify a users details entered into a login form against details stored in an existing flat file.No matter what
Re-Order by ID Number
I have a cms set up for inputting an image, thumb, title, pdf, and eps. When input the database assigns an ID number. The front end displays each upload by ID number. I'm trying to set up the back
Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as I added the timer control and ran my app, I started getting the following error:Description: An
Consuming MII WebService in Java WebDynpro
Hello,
Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter seems incredibly boring, daunting and complicated, it looks so awful that I haven't yet read it so I
mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$url', '$sitename', '$description', '$ownername', '$theme') ";mysql_query($sitedetails) or
Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gridview depends on the values entered in the dropdown list boxes. The button calls a stored procedure
Rand() help needed
Hi all,Can someone explain and give me a quick example of how I would go about this?I have 100 values in a database with colum headings of t_val and t_name. If I wanted to update all 100 of these