login  Naam:   Wachtwoord: 
Registreer je!
 Forum

mysql insert fout (Opgelost)

Offline Warbringer - 28/09/2007 23:01
Avatar van WarbringerOnbekend
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php $query = "INSERT INTO events_accounts (name, linkshell, nation, rank, zm, cop, job1, job2, job3, job4, job5, level1, level2, level3, level4, level5, email, msn, yahoo) VALUES (
  2. '".$_POST['name']."',
  3. '".$_POST['linkshell']."',
  4. '".$_POST['nation']."',
  5. '".$_POST['rank']."',
  6. '".$_POST['zm']."',
  7. '".$_POST['cop']."',
  8. '".$_POST['char1']."',
  9. '".$_POST['char2']."',
  10. '".$_POST['char3']."',
  11. '".$_POST['char4']."',
  12. '".$_POST['char5']."',
  13. '".$_POST['level1']."',
  14. '".$_POST['level2']."',
  15. '".$_POST['level3']."',
  16. '".$_POST['level4']."',
  17. '".$_POST['level5']."',
  18. '".$_POST['email']."',
  19. '".$_POST['msn']."',
  20. '".$_POST['yahoo']."'"; ?>


Ik krijg de foutmelding:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 20

Iemand enig idee? ik zie er niks verkeerd aan namen kloppen ook allemaal gewoon.

Groetjes

1 antwoord

Gesponsorde links
Offline lemoinet - 28/09/2007 23:03 (laatste wijziging 28/09/2007 23:04)
Avatar van lemoinet PHP gevorderde
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php $query = "INSERT INTO events_accounts (name, linkshell, nation, rank, zm, cop, job1, job2, job3, job4, job5, level1, level2, level3, level4, level5, email, msn, yahoo) VALUES (
  2. '".$_POST['name']."',
  3. '".$_POST['linkshell']."',
  4. '".$_POST['nation']."',
  5. '".$_POST['rank']."',
  6. '".$_POST['zm']."',
  7. '".$_POST['cop']."',
  8. '".$_POST['char1']."',
  9. '".$_POST['char2']."',
  10. '".$_POST['char3']."',
  11. '".$_POST['char4']."',
  12. '".$_POST['char5']."',
  13. '".$_POST['level1']."',
  14. '".$_POST['level2']."',
  15. '".$_POST['level3']."',
  16. '".$_POST['level4']."',
  17. '".$_POST['level5']."',
  18. '".$_POST['email']."',
  19. '".$_POST['msn']."',
  20. '".$_POST['yahoo']."')"; ?>


haakje vergeten
Gesponsorde links
Dit onderwerp is gesloten.
Actieve forumberichten
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.175s