update table with values from other table??

[itworks]

i made this query for a function but now i want to use it in another place but INSERT doesn't do what i want, it has to be UPDATE but i just can't get the syntax right.

here's the query:

$sql = "INSERT INTO construir(morada, cod_postal, cod_postal2, localidade) SELECT u.morada, u.cod_postal, u.cod_postal2, u.localidade FROM utilizador u WHERE u.email='$login_utilizador'";

how can i make an UPDATE on certain fields in a table with values from another table?

thanks in advance.

[sgoku01]

Why don't you make two queries?

$sql = mysql_query("SELECT u.morada, u.cod_postal, u.cod_postal2, u.localidade FROM utilizador u WHERE u.email='$login_utilizador'");
$r = mysql_fetch_row($sql);

$sql_t = mysql_query("UPDATE database SET morada='" . $r['morada'] . "', cod_postal = '" . $r['cod_postal'] . "', cod_postal2 = '" . $r['cod_postal2'], (etc) WHERE id = '1'");

You can replace or delete WHERE id = '1' from the second query 🙂

[itworks]

thanks, i followed your advice and got it fixed!

i had thought of it but i was just wondering if there would be a way to do it in just one query.

thanks.