Database Forum
Web Database Register Members List Calendar FAQ

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

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

GBS
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

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

Sandman
Moderator

 
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

Reply


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 12:54 AM.

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

Help support our forum assistants and product development ->

go to top go to top