Inserting into mysql

[Anon]

Hi There, i often get confused with the many ways of inserting variables into a mysql database as there as so many ways. Can anyone tell me what is the 'correct' way of doing this is?

[mrblom]

mysql_query("INSERT INTO table ('variable1','varialble2') VALUES($variable1, $variable2)");

I use this in my scripts.

Kristian

[Anon]

Kristian

Not sure, but I dont think you need quites around the 'variable1' and 'variable2', but you might need them around '$variable' and '$variable2' if they are strings. But I guess this is what you meant anyway.

John

[Anon]

I am sure the followng is correct, however it wont work! Any1 know why?

<?php

$DBhost = "localhost";
$DBuser = "**";
$DBpass = "";
$DBname = "***";

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
mysql_select_db ($DBname);

$query = mysql_query("INSERT INTO ****_users (username, password)" . "VALUES ('$username', '$password')");

?>

[mrblom]

I know...

I was just typing in a hurry...

Sorry

[mrblom]

$query = mysql_query("INSERT INTO ****_users (username, password) VALUES ('$username', '$password')");

This works fin with me...
I changed it a little...