Hi
First, correct the quotes around "user" from 'user" to "user"...
second, try this for your insert.
sql = "INSERT INTO test (firstname, username, registerdate,
password, lastname ) VALUES
('$firstname','$username','$registerdate','$password', '$lastname');
Technically, I understand that as long as the 'insert' and
the 'variable's are in the 'same sequence', then it does not matter
if they appear in that sequence in the database.
Kizzie
--------------------------------------------------
--- In [email protected], Wade <[EMAIL PROTECTED]> wrote:
> 03142005 0951 GMT-6
>
> Ok.
>
> if( isset ( $_POST['Register'] ) ) {
> $firstname = trim($_POST['firstname']);
> $lastname = trim($_POST['lastname']);
> $username = trim($_POST['username']);
> $password = trim($_POST['password']);
> $registerdate = $_POST['registerdate'];
>
> $db_name = "test";
> $connection = mysql_connect
("localhost", 'user", "pass") or
> die("Connection error: <br />" . mysql_error() );
> $db = mysql_select_db($db_name, $connection) or die("db
> select error: <br />" . mysql_error() );
>
> $sql = "INSERT INTO test (firstname, username,
registerdate,
> password, lastname ) VALUES (";
> $sql = " ' " . $firstname . " ' , " ;
> $sql.= " ' " . $lastname . " ' , " ;
> $sql.= " ' " . $username . " ' , " ;
> $sql.= " ' " . $password . " ' , " ;
> $sql.= " ' " . $registerdate . " ' ) " ;
>
> <<------ Big Snippers here --------------------->>
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
