Have you built this table in your database?
If you have, then if you open a commandline, start mysql client, the use
mysql>SHOW CREATE TABLE table_name \G
just like I did for you.
The output will be a script I can copy/paste into my commandline to create
exactly the same table. Save me hacking around to get a table that might/might not be the same as yours.
Then, how about some INSERTs for a sample a data to populate the table?
A select * from table_name will do in the abscence of anything better.
Other than that I'm only crystal ball gazing.
BTW. Don't use float for money amounts. Float will give you rounding errors.You probably want to use decimal(6,2) or something similar. That will give you a range of up to $9999.99. If you want more then increase the 6 to as many digits (total) that you want.
Good luck,
Barry.
Edited 1 time(s). Last edit at 04/11/2014 12:25AM by Barry Galbraith.