PHP and MySQL Err: Number of Columns Mismatch
PHP and MySQL Err: Number of Columns Mismatch
I know the reason for this error, but I need to add a column that is calculated from some of the data being pulled from the MySQL database. So by doing this, I create the number of columns mismatch. My table is as such:
[code]
QSR
Rating
Title
Description
Comments
Views
Pub. Date
Loading data from server
[/code]
Where QSR is the column that is not from the SQL table. I'm not sure how to fake the PHP file in order to accomplish this.
I added the column data to the JSON array, (i'm using the PHP serverside php example), even tried to add duplicate columns to the MySQL statement in order to get 7. But I'm still getting number of columns mismatch.
Please any help will be so great
[code]
QSR
Rating
Title
Description
Comments
Views
Pub. Date
Loading data from server
[/code]
Where QSR is the column that is not from the SQL table. I'm not sure how to fake the PHP file in order to accomplish this.
I added the column data to the JSON array, (i'm using the PHP serverside php example), even tried to add duplicate columns to the MySQL statement in order to get 7. But I'm still getting number of columns mismatch.
Please any help will be so great
This discussion has been closed.
Replies