Re: PHP/MYSQL query error
| From: | Chris Crane | Date: | Mon, 26 Aug 2002 15:44:41 +0000 |
| Subject: | Re: PHP/MYSQL query error | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114148@lists.php.net to get a copy of this message | ||
I got it working. It did not like the single quotes around the column names.
"Chris Crane" <ccrane@inxdesign.com> wrote in message
news:20020826140920.9594.qmail@pb1.pair.com...
> Thank you. I will try that.
> "Justin French" <justin@indent.com.au> wrote in message
> news:B99071C8.EADA%justin@indent.com.au...
> > Why don't you do
> >
> > $result = mysql_query($query) or die(mysql_error());
> >
> > or
> >
> > $result = mysql_query($query);
> > echo mysql_error();
> >
> > That way, instead of "Query Failed" you'll get something meaningful...
> > probably something that will solve the problem.
> >
> >
> > Justin French
> >
> >
> > on 26/08/02 11:55 PM, Chris Crane (ccrane@inxdesign.com) wrote:
> >
> > > Initially there was an error with too many values verses columns. But
I
> > > think it was fixed. I am double checking now.
> > >
> > >
> > > "Jay Blanchard" <jay.blanchard@niicommunications.com> wrote in
> > > message
> > > news:003201c24d07$b8560470$8102a8c0@000347D72515...
> > >> [snip]
> > >> /* Performing SQL query */
> > >> $query = "INSERT INTO SignupRequests ('FirstName',
> > >> 'LastName',
> > >> 'Address1', 'Address2',
> > >> 'City', 'State', 'Zip', 'Email',
> > >> 'Phone', 'ContactMethod', 'Date',
> > >> 'IP', 'Status', 'Comments')
> > >> VALUES ('', 'Chris', 'Crane', '655
> > >> Talcottville Road', 'Apt. 185',
> > >> 'Vernon', 'CT', '06066',
> > >> 'ccrane@inxdesign.com',
> > >> '860-659-6464', 'Email', 'August 25, 2002',
> > >> '64.252.232.82', 'Newly
> > >> Requested', 'Testing')";
> > >> $result = mysql_query($query) or die("Query failed");
> > >> [/snip]
> > >>
> > >> Have you printed the query to make sure that the syntax is right? The
> > > first
> > >> thing that I see is that there are 13 items in your INSERT statement
> and
> > > 15
> > >> items in your VALUES statement ... these must match in order for the
> query
> > >> to work.
> > >>
> > >>
> > >> HTH!
> > >>
> > >> Jay
> > >>
> > >> Ask smart questions:
> > >>
> > >> http://www.tuxedo.org/~esr/faqs/smart-questions.html
> > >> Top Questions on php-general;
> > >> (Answers can be found by RTFM, STFW, or STFA,
> > >> save for #3 and #6 which can probably be found
> > >> the same way, since they are usually one of the
> > >> other questions on this list.)
> > >> 1. How can I make file uploads work?
> > >> 2. How come my form will not pass variables?
> > >> 3. HELP! HELP! Please HELP!
> > >> 4. Register_Globals ?!?
> > >> 5. Is there a function to ... [insert thought here]?
> > >> 6. Anyone see the error in this code?
> > >>
> > >>
> > >
> > >
> >
>
>