Read and insert to MySQL a URL-Variable

[zack]

Hi, I'm sorry, I've a little question.. I want read 2 URL-Variable and
then to insert them in my DB (MySQL).

This is my code:

<?php
$insertSQL = sprintf("INSERT INTO nometabella (CAMPO1, CAMPO2) VALUES
('VAL1', 'VAL2')");
mysql_select_db($database_nomeconnessione, $nomeconnessione);
$Result1 = mysql_query($insertSQL, $nomeconnessione) or
die(mysql_error());
?>

How can I modifify?

Thanks.

P.S.
I'm sorry formy english.

[Fabian Wleklinski]

Hi "zack" (?),

given two variables named "var1" and "var2", try

$insertSQL = "INSERT INTO nometabella (CAMPO1, CAMPO2) " .
"VALUES ('" . addslashes($_REQUEST["var1"]) . "','" .
addslashes($_REQUEST["var2"]) . "')";

Greetings from Frankfurt / Germany,

Fabian Wleklinski