SQL Inserting into a table

[GreenFanta]

Hi there reader(s)

 

I've been searching everywhere, and I'm not one to post my issue unless I've searched as hard as I could, I'm not new to PHP, but I am new to MySQL (so go easy on me) and I've got variables all set up, and I've successfully established connection to my Database and my Database's table, but now I cannot find a way to insert the data (variable) into a column of the table.

 

Willing to provide more information!

[mikosiko]

post your code

[herghost]

<?php

 

$sql="INSERT INTO tablename (columnname1, columnname2, columnname3)

VALUES

('$variable1',''$variable2'',''$variable3'')";

 

if (mysql_query($sql))

  {

echo "data added";

}

else

{

add failed

}

?>

[jcbones]

<?php

$sql="INSERT INTO tablename (columnname1, columnname2, columnname3)
VALUES
('$variable1','$variable2','$variable3')";

if (mysql_query($sql))
  {
echo "data added";
}
else
{
echo 'add failed!';
}
?>

[GreenFanta]

Thank you so much!