update problem

[pacotelic]

Got a problem getting a php script to update two tables in a database. Here's the code:

$sql = "UPDATE spider SET
	file = '$file',
	first_words = '$first_words',
	path = '$path',
	update = NOW($upddate)
	WHERE spider_id=$spider_id";
$sql = "UPDATE sites SET
	site_url = '$site_url',
	update = NOW($upddate)
	WHERE site_id=$site_id";
mysql_query($sql);

'update' updates properly and successfully in both tables, but edits to things like first_words or path do not apply. I thought defining $sql twice was a little odd, but update successfully applied changes in both tables, indicating that the update worked in both places.

I am collecting these values from a form and submitting them to this query. What is the best way to update text values in two tables?

Thanks!

[nemonoman]

$sql = "UPDATE spider SET
file = '$file',
first_words = '$first_words',
path = '$path',
update = NOW($upddate)
WHERE spider_id=$spider_id";

//looks like you need this line:

mysql_query($sql); //<<<RIGHT HERE

$sql = "UPDATE sites SET
site_url = '$site_url',
update = NOW($upddate)
WHERE site_id=$site_id";
mysql_query($sql);

Also I don't know what NOW($update) is supposed to do:
Proper use of NOW() is like that -- no parameter in the parens.

I sincerely doubt that "update" column was updated by the first query, which was never executed. Maybe also you update it later or earlier in your code and just forgot you did so.