Topic awaiting preservation: mysql "update" problem

Hi !

Im trying to get this to work:

$data = mysql_db_query("thetable", "UPDATE thetable SET row1 = '$row1', row2 = '$row2' , row3 = '$row3' WHERE id = '$id");
mysql_query($data);

:::
the $vars are
sent from a "sendpage.php" with "<form action=changepage.php>"
were the values in the "text inputs" are fetched
from the same (thetable) table...
:::
am i making myself clear, and in that case, could anyone help me ?
::.



over here----------------------------------------------------------->

well, I think you're seriously confused here.
try something along the lines of
$query = 'update ...'
and then
$result = mysql_query($query,$linkIdentifier);

or have another look at the documentation :-)

so long,
TP

Tyberius Prime

[This message has been edited by Tyberius Prime (edited 02-17-2002).]

Like TP said, you need to check the docs.

You don't use the two statements you have there together. You use either mysql_db_query() by itself (which has been depreciated BTW) or mysql_select_db() and mysql_query() together.

Check the docs for mysql_db_query() here.

-Butcher-

quote:

---

$data = mysql_db_query("thetable", "UPDATE thetable SET row1 = '$row1', row2 = '$row2' , row3 = '$row3' WHERE id = '$id");

---

you forgot to add another closing single quote to WHERE id=

btw, no need to add quote too! so just write: where id=$id

lallous >

yeah, sometimes the simplest error is the hardest to find =)

thanx !