I need a script where I can insert to a mysql database
but have the values come from a form as variables that are passed to mysql




-
John

That would be in every beginning php book and tutorial.

http://www.php-mysql-tutorial.com/ph...-php-forms.php

http://www.php.net/manual/en/function.mysql-query.php

Go with an SQL query simular to this.

PHP Code:

<?php
  $con = mysql_connect('db_server','db_name','db_password');
  if(!$con){
     die('Cannot Connect: ' . mysql_error());
  }
 
  mysql_select_db('db_name');
 
   $sql = "INSERT INTO some_table (somefield, someotherfield)
            VALUE('$_POST[user_input_text]','$_POST[more_input_text]')";
  mysql_query($sql, $con);
?>