passing queries to db

Naug

I want to transfer some data from one table, use some of it and put it into another table.I get data out of result with pg_fetch_array($result)
When puting data into second table

$query="update table2 set bla,bla,bla  where name='$row["name"]';";

As you can see I have run out of quotes. How do I go around this?

(except making $name=$row["name"] and using it instead?there are around 40 atributes so it would be sad to use this everytime I run into similar problem)

tomhath

Close the outer quote and concatenate (I find it easier to read anyway):

$query="update table2 set bla,bla,bla  where name='" . $row["name"] . "';";

jowatkins

use a pointer instead:

$query="update table2 set bla,bla,bla  where name='$row->name'";

or alternatively:

$name = $row->name;
$query="update table2 set bla,bla,bla  where name='$name'";

Naug

Weedpacket

See what the manual says about double-quoted strings.

twigletmac

Another solution would be to use curly brackets:

$query="update table2 set bla,bla,bla  where name='{$row['name']}';";

Which is sort of hidden on the page linked to above under the title 'Complex (curly) syntax'.

Mac

intenz

I use...

$query = "update table2 set bla,bla,bla where name='$row[name]'";

twigletmac

There is a caveat in using $row[name] as the PHP scripting engine first looks for a constant called name and then when it doesn't find one assumes that you meant to quote the element name. This means that the scripting engine is doing extra work which can easily be avoided by quoting element names ($row['name']). It does however mean that you have to do extra work typing 🙂 .

Mac