POST fields

[ukndoit]

I see in this PHP script I am working on, a lot of variables like this:

	mysql_query( "INSERT INTO {$pre}ticket ....

There are a lot of variables with {} around them. What does that do?

Thanks!
Richard

[laserlight]

Read the PHP Manual:
http://www.php.net/manual/en/language.types.string.php

[ukndoit]

Ok, I think I get it.

Can I do this:

$statement = "INSERT INTO sometable (id, somename) VALUES ('{" . $_POST["date"] . "}', '{" . $_POST["field"] . "})";

Something like that? OR does the {} have to be directly around it?

Thanks again!
Richard

[laserlight]

Ah.

Here you're mixing up the PHP and SQL.

The braces, {}, are part of PHP's syntax, not SQL syntax.

You should use:

$statement = "INSERT INTO sometable
	(id, somename)
	VALUES ('{$_POST["date"]}', '{$_POST["field"]}')";

or

$statement = "INSERT INTO sometable
	(id, somename)
	VALUES ('" . $_POST["date"] . "', '" . $_POST["field"] . "')";

[ukndoit]

Ok, I got it now.

I think 😉

Thank you much!
Richard