Data Assist Recordset MySQL Error when try to expand
I have been working thru the DataAssist Getting Started Guide. Everything was going smoothly until I reached Customizing your Pages, Details.php.
When I try to Expand the Recordset in the Bindings Panel I receive the following error
MySQL Error#: 1064
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 'group, `item-id`, item, `item-photo`, item-desc, `item-size`, item-price FROM `b' at line 1
I have gone thru the DataAssist Wizard twice trying different settings. The MySQL table items are all set to VARCHAR or TEXT or MEDIUMBLOB (for photos) . Database was created on my local computer using MAMP
If I try to open a file on my local computer in the browser the following error loads
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 '-products-table ORDER BY item LIMIT 0, 1000' at line 1
Follows content of exported .sql table. What am I missing...?
-- phpMyAdmin SQL Dump
-- version 2.11.7.1
-- www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 15, 2012 at 09:12 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `boomerang-products`
--
-- --------------------------------------------------------
--
-- Table structure for table `boomerang-products-table`
--
CREATE TABLE `boomerang-products-table` (
`maincategory` varchar(55) NOT NULL,
`subcategory` varchar(55) NOT NULL,
`group` varchar(55) NOT NULL,
`item-id` varchar(15) NOT NULL,
`item` varchar(55) NOT NULL,
`item-photo` mediumblob NOT NULL,
`item-desc` text NOT NULL,
`item-size` varchar(55) default NULL,
`item-price` varchar(11) NOT NULL,
PRIMARY KEY (`item-id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `boomerang-products-table`
--
