Unknown column 'item' in 'field list'

Hi
I have created all the pages using dataassist wizard, im using xampp as my localhost.
When i upload the pages the only page that shows is `search page` all the others display
`Unknown column 'item' in 'field list' anyone know what this problem is?

can you send a copy of your pages so I can examine the code.

Hi
Thanks for your help.

the zip you sent only contains one file:
Shortcut to htdocs.lnk

can you resend the php files please.

Sorry Jason my mistake, i have now sent the PHP Pages. I have 2 sites im starting too put together, however im getting this error with both. Thanks for your help.

the problem is caused by using spaces in your column name like:
item name

you should not use spaces in your column names. I suggest using the "Camel Case" naming convention:
itemName

or:
itemDescription

Working great, thanks so much Jason

you're welcome.