03142005 1528 GMT-6 Sorry, typo. Im taking everything apart to see if I can find the error.
wade Mike Royalty wrote: >maybe this is just a typo - if not, shouldn't that be .= versus = > >$sql.= " ' " . $firstname . " ' , " ; > >instead of > >$sql = " ' " . $firstname . " ' , " ; > > > > ----- Original Message ----- > From: Wade > To: [email protected] > Sent: Monday, March 14, 2005 2:42 PM > Subject: Re: [php_mysql] Re: value position as they go in a db > > > 03142005 1437 GMT-6 > I was running some tests after my last posting and I have noticed that > Im not getting any connection to the db. Using this script - which I use > all the time for testing - Im not getting any result. I restarted the > db. Restarted mysql but still Im not making a connection other than > through control center. > > Wade > > $db_name = "test"; > $connection = mysql_connect("localhost", "master", "getalife") or > die("Connection error <br />" . mysql_error() ); > > $db = mysql_select_db($db_name, $connection) or die ("DB selection error > <br />" . mysql_error() ); > > $sql = "INSERT INTO users (firstname, lastname, username, password) > VALUES ("; > $sql = " ' " . $firstname . " ' , " ; > $sql.= " ' " . $lastname . " ' , " ; > $sql.= " ' " . $username . " ' , " ; > $sql.= " ' " . $password . " ' ) "; > > $result = mysql_query($sql, $connection); > > echo "Result of Insert: $result"; > > > > Pete wrote: > > >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... > > > > > > > > > [Non-text portions of this message have been removed] > > > > The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web > database possibilities through group learning. > > > Yahoo! Groups Sponsor > ADVERTISEMENT > > > > > >------------------------------------------------------------------------------ > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > http://groups.yahoo.com/group/php_mysql/ > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > >[Non-text portions of this message have been removed] > > > >The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web >database possibilities through group learning. >Yahoo! Groups Links > > > > > > > > > > > > [Non-text portions of this message have been removed] 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/
