Question about the Enhanced 1.5 Script

[Imdbombboarder]

Ok, the php script the original 1.5 pageofstats.php worked fine. Although I dloaded the enhanced because it seemed alot easier to edit
things. It gave me this error when going to the page: SQL Error - 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 '100' at line 1
SELECT * FROM flights ORDER BY id desc LIMIT ,100

I put the old php script back on and worked fine again. What do I do?

[nem]

The "," shouldn't be in that line you quoted.

[eazy]

nem wrote:
The "," shouldn't be in that line you quoted.

This would work for the first page only. Normally you should have 2 numbers for LIMIT. First one tells with which database record to start,
the second sets the number of records to read. So it should read something like "... order by id desc LIMIT 0,100". The first number is
missing. Probably a bug (shame!). I'll have a look at this.
The original script doesn't use paging, that's why there's no LIMIT in the sql query.

Just to make sure: Do you have any records in your database or is it empty?


[EDIT]
In case your database is not empty, we have a problem... Otherwise it should be fixed in the version which you can download here:
http://www.vademo.com:8080/myVa/download...script.zip
I will also upload it to 'More Downloads' this evening.
Additionally this version features an improved paging with only one row of page numbers, no matter how many records/pages.
See the preview at http://www.vademo.com

Hope it works for you.

Peter



Post Edited ( 09-02-05 14:44 )

[Imdbombboarder]

What do you mean "empty"? No theirs a user_profile or whatever table and a flights... The flights table is empty because I accidently
deleted it so, now that its back on their it has a clean slate.

[eazy]

That's what I meant: the flights table
There was a bug in the script if no flights were recorded. The fixed version is also available in downloads section now.