Use SELECT in an MYSQL UPDATE?

mrbippy

This might seem like a newbie question, but that's only because it is!

Can you use something like this in a PHP MySQL query:

$res = "UPDATE tab SET val = '$n_val' SELECT val2 WHERE stuff";
OR
$res = "UPDATE tab SET val = '$n_val' WHERE stuff SELECT val2";

If so what would be the correct syntax?

trooper

$res = "UPDATE tab SET val = '$n_val' WHERE <FIELD> = '<CONDITION>'";

HTH

Originally posted by mrbippy
This might seem like a newbie question, but that's only because it is!

Can you use something like this in a PHP MySQL query:

$res = "UPDATE tab SET val = '$n_val' SELECT val2 WHERE stuff";
OR
$res = "UPDATE tab SET val = '$n_val' WHERE stuff SELECT val2";

If so what would be the correct syntax?

mrbippy

How do I get data back from the UPDATE?
Do I have to run antoher query?

$res = "UPDATE tab SET val = '$n_val' WHERE <FIELD> = '<CONDITION>'";

This does not work:
$data = mysql_fetch_array($res);

This does:
$data_res = "SELECT val FROM tab WHERE val = '$n_val'";
$data = mysql_fecth_array($data_res);

But I was hoping I could perform the UPDATE and the SELECT
in the same query.

Is that possible?

trooper

That won't work its

$data = mysql_query($res) not what you had put in

Then you need to do a

SELECT<FIELDS> FROM <TABLE> WHERE <CONDITION> = <VALUE>

HTH

mrbippy

Ok,

So I have to do a second query on the table to get the data out.

By The Way.

I am using a query function

$res = Query_Func("SELECT .....", $link);

so..
$data = mysql_fetch_array($res);
Works for me.

But not with the UPDATE.

Thanks Your A Trooper! 🙂

trooper

put this in

$data = mysql_fetch_array($res) or die (mysql_error());

then if there is a problem you'll get an error message

HTH