Updating a record on page load

[fulhamman]

I have two tables pqcosts (with fields id, costs, ta) and pq (with fields including ta and costs)

The pqcosts table gets updated at various places but I want a page that will update the pq table when a page loads. The code I have tried so far is:

  <?php 

$query = mysql_query ("SELECT * FROM pqcosts WHERE id = ‘1’ ");

while ($row = mysql_fetch_array ($query))
{
$id = $row['id'];
$ta = $row['ta'];
$cost = $row[‘costs’];

}

mysql_query("UPDATE pq SET costs=$cost");
mysql_query("UPDATE pq SET ta='$ta'");

?>

But this doesn't work.

Can anyone help please?

[NogDog]

First, in case it's not just an error while posting here: get rid of the [FONT=Courier New]‘directional’[/FONT] quotes and only use [FONT=Courier New]'straight'[/FONT] quotes.

Second, I'm not sure what the "correct" solution would be, since I don't understand what the actual relationships are between the two tables, and whether or not the fact that they both have a "costs" column indicates some denormalization that perhaps should be addressed. In any case, it's likely it could be done with one query, once we understand the exact requirement.

[dalecosp]

And I guess we're assuming you've already connected to the database server. 😉

[Weedpacket]

I'll also make an assumption - that you don't want every record in pq to be updated to have the same values of costs and ta. With that assumption I'll point out that there should be WHERE clauses on the update statements to restrict the updates to the rows that should be updated. I have no idea what rows they'd be.