Jump to content

stephtort

Members
  • Posts

    9
  • Joined

  • Last visited

    Never

About stephtort

  • Birthday 10/22/1974

Contact Methods

  • Website URL
    http://www.schteff.com

Profile Information

  • Gender
    Female
  • Location
    north of 8 Mile

stephtort's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Just forget it...  I would think a global moderator would be a little more helpful.
  2. removed the actual code ... this forum is really not being helpful. [quote]Your kidding aren't ya? The relevent code will be sufficient, no one wants to wade through all that especially seeing as your using php's short tags which the boards syntax highlighting wont work with.[/quote]
  3. [quote]And please, do as every other programmer does... [/quote] Not the original author of the code, sorry..  :-[  I adjusted the capitalization. No matter which fields are the last two in the array, I still get the error. [code]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 'addlemail3='test', WHERE id=''' at line 1[/code] [code]sql: UPDATE contestinfo SET sponsor='test', coordinator='test', coordaddress='test', coordcity='test', coordstate='test', coordzip='test', coordphone1='test', coordphone2='test', coordemail='test', emergency='test', emergencyphone='test', addl1='test', addlemail1='test', addl2='test', addlemail2='test', addl3='test'addlemail3='test', WHERE id=''[/code]
  4. sorry - got sent out of town for a few days for work. ok - I added the print command, and also drastically reduced the update form into smaller sections so I could see if a specific field was giving me the error. Here is the print result: [code]sql: update contestinfo set sponsor='test', coordinator='test', coordaddress='test', coordcity='test', coordstate='test', coordzip='test', coordphone1='test', coordphone2='test', coordemail='test', emergency='test', emergencyphone='test', addl1='test', addlemail1='test', addl2='test', addlemail2='test', addl3='test'addlemail3='test', where id=''[/code] In the actual insert.php file, here is the array: [code] 'host' => Array( 'contestinfo' => Array( 'sponsor','coordinator','coordaddress','coordcity','coordstate','coordzip','coordphone1','coordphone2','coordemail','emergency','emergencyphone','addl1','addlemail1','addl2','addlemail2','addl3','addlemail3', ), ),[/code]
  5. Hi there.  I'm trying to adapt an existing php/mysql insert/update form with new fields and information, and I'm running into an error.  I am ok with PHP, but definitely not well-versed so I'm having trouble narrowing down the problem.  Can someone help by taking a look at the code and giving me advice on what to fix? The error I'm getting is this: [code]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 'where id=''' at line 1[/code] It looks like there is an extra ' somewhere in the code, but I cannot find it. I've made a .zip file with all necessary files that can be reviewed here (including the table structure): http://www.schteff.com/phphelp.zip Thanks in advance for any help!
  6. Can someone explain what JOIN actually does? Does it combine tables? Or just reference them?
  7. I have been searching the internet and books trying to find an actual explanation of how to query a DB using something along the lines of relationships. I\'m also an Access & Filemaker Pro user learning MySQL, and learning new terminology and structure is killing me! Thank you Effigy for spelling it out for us converts!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.