Jump to content


Photo

A little error. need help!!! pls


  • Please log in to reply
1 reply to this topic

#1 DieSucker

DieSucker
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 04 July 2006 - 07:38 PM

I am coming up with an error though, and I am prety sure I know why, I just dunno how to fix it, the reason for the error would be the players name its trying to input "DoN*']['r0p$" and the error i get is


Quote
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 ']['r0p$ ', 'CTF-BT-PsychoJungle', '4:16', '1150447172')' at line 1

I have my table set up as

Code:
$sql = "CREATE TABLE information(
player_name CHAR(30) NOT NULL,
map_name CHAR(60) NOT NULL,
map_time CHAR(60) NOT NULL,
rec_date CHAR(30) NOT NULL
)"; any help would be greatful

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 05 July 2006 - 12:57 AM

I'm guessing it's a quoting issue... you either have to handle this yourself or by magic_quotes().
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users