using Variables in SQL statements?

[Anon]

I want to be able to use variables generated by form input in an ODBC SQL statement, such as:

$var = "bootz";

$Query = "UPDATE tables SET name = "$var" WHERE id = "A" ";

The outcome I want is that any record in the tables TABLE where the id field is equal to A, write bootz.

what do i need to put around ther $var in the SQL statement to make it see bootz as the input?

thx

[Anon]

Change the quotes around the $variables to apostrophes or escape them with slashes.

ex : $Query = "UPDATE tables SET name = '$var' WHERE id = 'A' ";

or

ex 2 : $Query = "UPDATE tables SET name = \"$var\" WHERE id = \"A\" ";

[techek]

What you're actually asking about is how to manipulate strings.

To use your own example, I've got two elementary examples for you :

Ex. 1 :
$sql = "UPDATE table SET name='$var' WHERE id='A';

Ex. 2 :
$sql = 'UPDATE table SET name='.$var.' WHERE id="A"';

In example 1 the variable is actually parsed and inserted into the string $sql (because of the magic qoutes ")

In example 2 the $sql-string is concatenated using "." Some people say that single-qouted strings are faster ...

The last piece of advice : Study strings next week