Database Forum
Web Database Register Members List Calendar FAQ

Go Back   Database Forum > Other Database Software > MySQL Database Reports Generator
User Name

Thread Tools Search this Thread Display Modes
Default SQL Statement
09-30-2011, 01:26 PM #1  

Junior Member

Status: Offline
Posts: 1
Join Date: Sep 2011

I am using PHPMagic Plus> PHPReportsGenerator

I am trying to use the following statement
SELECT Notes FROM PastorsDesk order by auto desc limit 1

but i get an error

* 'Sort By','group by','limit'or functions is not allowed in the sql statement, it could be done visually in a next step!

There is no place is saw where i can specify limit 1 record .. please help!!!!
Reply With Quote

10-01-2011, 05:12 PM #2  


Status: Offline
Posts: 98
Join Date: Mar 2005

Are you using single or doube quotes.
SELECT `Notes` FROM PastorsDesk order by auto desc limit 1
Reply With Quote


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT -5. The time now is 01:16 PM.

Powered by: vBulletin Version 3.7.4
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd.
Database Forums

Help support our forum assistants and product development ->

go to top go to top