PHP - Using assoc. arrays in SQL string

[trevHCS]

Hopefully that title doesn't put everyone off...

I want to create an SQL string such as...

$sql = "INSERT INTO client_table (ps_name) VALUES ('$input["ps_name"]')";

...which is then fed to the mysql_query(), but because the value of ps_name is coming from an associative array I'm getting a parsing error

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'

I also tried using ' quotes around the ['ps_name'] bit but that didn't work either and I tried escaping the ' within the brackets, but again failure.


I don't suppose anyone knows of a way around this? I could just drop the data out into temp variables, but I'm sure when they designed PHP4 they probably thought of this?

Cheers
Trev

[trevHCS]

I was going to edit the above, but we seem to have lost the edit button (unless I'm just missing it?).

Anyway, had a brain wave re. the above and tried using

$input[ps_name] instead of $input['ps_name'] and to my total surprise it worked, so now I can use arrays in my SQL statements.

Trev