I got it working. It did not like the single quotes around the column names.
"Chris Crane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Thank you. I will try that.
> "Justin French" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTEC
Thank you. I will try that.
"Justin French" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
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 Cran
There are 15 columns and 15 pieces of data. In my second post I fixed this
error and pasted it into PHPMYADMIN and it worked fine, but not here...
"Chris Crane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Initially there was an error with too many values v
Initially there was an error with too many values verses columns. But I
think it was fixed. I am double checking now.
"Jay Blanchard" <[EMAIL PROTECTED]> wrote in message
003201c24d07$b8560470$8102a8c0@000347D72515">news:003201c24d07$b8560470$8102a8c0@000347D72515...
> [snip]
> /* Performing
[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'
I did some more testing and I found that I forgot the first field in the
columns section of the Statement. So now it looks like this:
I also copy and pasted the statement into PHPMYADMIN and it worked fine. It
just doesn't work here
function AddSignupRequest($Signup_FName, $Signup_LName, $Si
I am getting a failed query error message. Could someone take a look and let
me know.
//F U N C T I O N S
//=
function AddSignupRequest($Signup_FName, $Signup_LName, $Signup_Address1,
$Signup_Address2, $Signup_City,
$Signup_State, $Signup_Zip, $Signup_Email, $Signup_Phone,
$Si
Code:
That results
"You have an error in your SQL syntax near 'Constructor='2001-09-17',
Enertec='2001-09-17', Seatec='2001-09-17'' at line 1".
What's wrong? I don't see anything that can be wrong! Am I blind once again?
Niklas
No, that is exactly as the PHPLib Debug function is returning... :|
-Original Message-
From: Samantha Savvakis [mailto:[EMAIL PROTECTED]]
Sent: Monday, 22 January 2001 3:21 PM
To: Matt Stone
Subject: RE: [PHP] MySQL Query Error
I'm not sure why are getting that error.
Is the stat
Hi,
I have a MySQL statement, namely:
SELECT COUNT(*) AS Count FROM images i LEFT JOIN categories c ON
i.cat_id=c.id LEFT JOIN subcategories s ON i.subcat_id=s.id
I want to change the LEFT JOINs to INNER JOINs like so:
SELECT COUNT(*) AS Count FROM images i INNER JOIN categories c ON
i.cat_id=c.i
11 matches
Mail list logo
