In message <[EMAIL PROTECTED]>, Kaela Street <[EMAIL PROTECTED]>
writes
>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.
As far as I know, that is correct, but bad practice, because it makes it
more difficult to debug.
However, here, the variables and field names don't match.
firstname, username, register, password, lastname
and
firstname, lastname, username, password, registerdate
>> $sql = "INSERT INTO test (firstname, username,
>registerdate,
>> password, lastname ) VALUES (";
>> $sql = " ' " . $firstname . " ' , " ;
>> $sql.= " ' " . $lastname . " ' , " ;
>> $sql.= " ' " . $username . " ' , " ;
>> $sql.= " ' " . $password . " ' , " ;
>> $sql.= " ' " . $registerdate . " ' ) " ;
Doesn't matter what order they come in, as long as both sides match...
--
Pete Clark
http://www.hotcosta.com
http://www.spanishholidaybookings.com
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/
