Updating Multiple Tables-Looping?

[badre]

Is it possible to somehow loop through $qr1 with $qr2?

$qr1 = mysql_query("SELECT * FROM hmroom_entry WHERE db_name IS NOT NULL");

$qr2 = mysql_query("UPDATE $db_name SET title='$title', info='$info', email='$email', caption='$caption', url_ad='$url_ad' WHERE mdate='$mdate'");

WITH SOMETHING LIKE....
$nrows = mysql_num_rows($qr1);

for ($i=0; $i < $nrows; $i++) {
$row = mysql_fetch_array($qr1);
(DO $qr2???)

}

Have been testing many different combinations, with no luck. Can't write a qr for each table name as they change in number, and name? Thanks, B

[bastien]

<?
//create query
$qr1 = ("SELECT * FROM hmroom_entry WHERE db_name IS NOT NULL");
//execute query
$result=mysql_query($qr1, $conn) or die ("Couldn't connect to table");
//loop through query to assign variables and run $qr2
while ($row1 = mysql_fetch_array($result)){
//assign variables
$title = $row1["title"];
$email = $row1["email"];
$mdate = $row1["mdate"];
//etc for all items that you need

//set qr2 variables
$qr2 = ("UPDATE $db_name SET title='$title', info='$info', email='$email', caption='$caption', url_ad='$url_ad' WHERE mdate='$mdate'");
//run second query
$result2 = mysql_query($qr2, $conn) or die ("couldn't perform update!");
//check result2 to see if query worked
if (!$result2) {
echo "query not completed";
}

hth

bastien

[badre]

Thanks for your reply.
I think I missed something, though...do I need to define $row1? B
<?php

require 'include.php';
mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db("$DBName");

//create query
$qr1 = ("SELECT * FROM hmroom_entry WHERE db_name IS NOT NULL");
//execute query
$result=mysql_query($qr1, $conn) or die ("Couldn't connect to table");
//loop through query to assign variables and run $qr2
while ($row1 = mysql_fetch_array($result)){
//assign variables
$title = $row1["title"];
$email = $row1["email"];
$mdate = $row1["mdate"];
$info = $row1["info"];
$caption = $row1["caption"];
$url_ad = $row1["url_ad"];

//etc for all items that you need

//set qr2 variables
$qr2 = ("UPDATE $db_name SET title='$title', info='$info', email='$email', caption='$caption', url_ad='$url_ad' WHERE mdate='$mdate'");
//run second query
$result2 = mysql_query($qr2, $conn) or die ("couldn't perform update!");
//check result2 to see if query worked
if (!$result2) {
echo "query not completed";
}

print "&results=Information has been updated.";

?>