XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Some forum sql problems.
Register
1
hk888
Some forum sql problems.

  • 2004/1/26 4:41

  • hk888

  • Just popping in

  • Posts: 1

  • Since: 2004/1/24


SELECT p.*, t.post_text FROM xoops_newbb_postsp, xoops_newbb_posts_text t WHERE p.topic_id=2 ANDp.post_id = t.post_id ORDER BY p.post_id ASC LIMIT 0, 10
Error number: 1064
Error message: 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 'ANDp.post_id = t.post_id ORDER BY p.post_id ASC LIMIT 0, 10' at

how can i solve them?
Thanks
2
JayEsPi
Re: Some forum sql problems.

  • 2004/3/1 23:58

  • JayEsPi

  • Just popping in

  • Posts: 2

  • Since: 2004/2/24


Quote:

for the right syntax to use near 'ANDp.post_id = t.post_id ORDER BY p.post_id ASC LIMIT 0, 10' at


AND p.post_id
that blank space ?

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

246 user(s) are online (161 user(s) are browsing Support Forums)

Members: 0

Guests: 246

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits