I'm new to MySQL and I get a 1054 error on this SQL query sent by a PHP 4
script:
1054: Unknown column 'pricerange' in 'field list'
$sql is INSERT INTO CCC_reviews (restname, type, specialties, address,
phone, hours, pricerange, creditcards, reservations, rating, miscinfo,
area, wheelchair, maplink, byline, date, reviewsum, review) VALUES
('Junkyard dog', 'Bakery', 'dogburgers', 'who cares', 'none', 'none',
'Moderate', 'Y', 'N', '1 1/2', 'Place stinks', 'North', 'N', 'somewhere',
'By Junkyard Bob', 'August 6, 2001', 'blah blah blah sum', 'blah blah blah
real thing')
The column pricerange does exist, and I've verified there's no trailing
space or the like.
Anyone know what's wrong?
Thanks.
Mike Kent The Indianapolis Star - Information
Technology
Internet mail: AOL messenger: mkent INI
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
