Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming

Unregistered, Check out the Coder Battles in the Announcement and Game forums.

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-04-2007, 08:51 AM
reachpradeep's Avatar   
reachpradeep reachpradeep is offline
Learning Programmer
 
Join Date: Mar 2007
Location: India
Posts: 41
Credits: 0
Rep Power: 6
reachpradeep is on a distinguished road
Send a message via MSN to reachpradeep
Default SQL syntax error

hello,

i'm getting the following error and i just can't see the mistake in my code...

the error:
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 ') VALUES('caleyc@email.com', 'Caley', 'Crossman', 'English', 'on', 'on', 'cons' at line 2

my php code:

Code:
// Insert a row of information into the table "mailing_list"
mysql_query("INSERT INTO mailing_list 
(ml_email, ml_first_name, ml_last_name, ml_language, ml_mailing_list_status, ml_rsvp, ml_link_id,) VALUES('$email_refresh', '$first_name_refresh', '$last_name_refresh',
 '$language_refresh', '$mailing_list_status', '$rsvp_refresh', '$link_id_refresh') ") 
or die(mysql_error());
Where's my mistake?

thanks a lot,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 10-10-2007, 01:33 PM
Patrick Patrick is offline
Programmer
 
Join Date: Sep 2007
Posts: 100
Credits: 1
Rep Power: 5
Patrick is on a distinguished road
Default

I have sent this thread to one of my friend who is doing MSc in Computer Science in US. He will definitely send some help and I will post it here in 24 hours.

Don't worry you'll be fine soon.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 10-11-2007, 11:29 AM
WingedPanther's Avatar   
WingedPanther WingedPanther is offline
Super Moderator
 
Join Date: Jul 2006
Age: 35
Posts: 2,453
Last Blog:
wxWidgets is NOT code ...
Credits: 761
Rep Power: 28
WingedPanther is a jewel in the roughWingedPanther is a jewel in the roughWingedPanther is a jewel in the roughWingedPanther is a jewel in the rough
Default

You have a comma after ml_link_id.
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
VB6.0:Tutorial, Error handling TcM VB Tutorials 9 06-06-2008 01:31 PM
Download problem, internal Server Error j3cubcapt ionFiles 1 07-02-2007 09:45 AM
Php - CGI Error thesquirrel16 General Programming 1 05-19-2007 05:09 PM
Error message "error in your SQL syntax." thesquirrel16 Database & Database Programming 3 05-18-2007 07:48 AM
can someone help me with my c librarys? bobwrit C and C++ 4 04-27-2007 06:19 PM


All times are GMT -5. The time now is 11:08 PM.

Contest Stats

Xav ........ 1276.19
MeTh0Dz|Reb0rn ........ 1048.58
marwex89 ........ 869.98
morefood2001 ........ 868.04
John ........ 865.15
WingedPanther ........ 761.06
Brandon W ........ 684.87
chili5 ........ 294.12
Steve.L ........ 216.18
dargueta ........ 192.86

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 81%

Ads