what is wrong - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

what is wrong

Author

Topic

frits
Starting Member

1 Post

Posted - 2002-06-23 : 14:43:41

I got this message.
You have an error in your SQL syntax near 'rand() LIMIT 0,1' at line 1
We are using MySQL 3.22.32

We also have the same php on an other server and it is working great.
we are using on that server MySQL 3.23.33

this is the php scripting
$emailadressen=q("SELECT * FROM xusers WHERE leeftijd='s' ORDER BY rand() LIMIT 0,$aantal1");
while($row=mysql_fetch_object($emailadressen))
Is it wrong on our sql server

EDIT: moved to Other Topics

Edited by - robvolk on 06/23/2002 15:05:19

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-06-23 : 15:06:47

We don't really cover MySQL here (we're a SQL Server site).

You can try [url]http://dbforums.com[/url], they have a MySQL forum and may be able to help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources