What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Help with MySQL queries

Help with MySQL queries
Author: Message:
RaceProUK
Elite Member
*****

Avatar

Posts: 6073
Reputation: 57
39 / Male / Flag
Joined: Oct 2003
RE: Help with MySQL queries
Actually, quick question: why is fid a text field when you're storing numbers in it?

I also recommend using capitals for all keyworks, like:
SELECT * FROM posts WHERE fid IN ('2','8','4','5','6','9','22','24','14','23','11','12','13') ORDER BY dateline DESC LIMIT 5
The SQL stands out from the data then.
[Image: spartaafk.png]
08-24-2006 02:27 PM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
Help with MySQL queries - by absorbation on 08-23-2006 at 05:52 PM
RE: Help with MySQL queries - by Ezra on 08-23-2006 at 06:07 PM
RE: Help with MySQL queries - by RaceProUK on 08-24-2006 at 12:12 PM
RE: Help with MySQL queries - by absorbation on 08-24-2006 at 12:14 PM
RE: Help with MySQL queries - by RaceProUK on 08-24-2006 at 02:27 PM
RE: Help with MySQL queries - by absorbation on 08-24-2006 at 03:21 PM
RE: Help with MySQL queries - by RaceProUK on 08-25-2006 at 10:11 AM
RE: Help with MySQL queries - by surfichris on 08-25-2006 at 10:22 AM
RE: Help with MySQL queries - by RaceProUK on 08-25-2006 at 10:46 AM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On