On Sunday 24 February 2002 06:57, [EMAIL PROTECTED] wrote:
> I've just created a "add record to table" type of page - basically copied
> a working php file I have on hand, and changed the values etc.
>
> Now, I am having problems trying to troubleshoot something. Basically
> my mySQL query is:
>
> INSERT INTO events (TITLE, SUMMARY, ORG, CITY, PROVINCE, DATE, REG_DATE,
> FEE) VALUES ('Another Event', 'Summary of this event goes here', 'Another
> Organization', 'Coquitlam', 'BC', 'Another Date', 'Another Date', '$250')
>
> and I have a coding in my php file that pretty much tells mySQL if it
> can't insert this, spit out the problem:
>
> Can't execute INSERT INTO events (TITLE, SUMMARY, ORG, CITY, PROVINCE,
> DATE, REG_DATE, FEE) VALUES ('Another Event', 'Summary of this event
> goes here', 'Another Organization', 'Coquitlam', 'BC', 'Another Date',
> 'Another Date', '$250') Unknown column 'ORG' in 'where clause'
Where is your 'where clause' coming from?
>
> Okay, there's an ORG column in the database table, and if I check my
> mySQL phpAdmin interface (even ran the same query in the myPHPAdmin
> interface), the very record has been inserted into the
> database without problems. So the inserting record into database part
> isn't the problem - it seems to me that the problem is that somewhere
> along the line, PHP is confused and is telling me something else.
>
> Ideas?
Yes, post your code.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
I have an existential map. It has "You are here" written all over it.
-- Steven Wright
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
