header
**
 Accueil du Forum

Par respect de la netiquette, tous les contributeurs s'engagent à ne tenir ni propos insultants ni propos infamants envers un tiers. Merci d'avance à tous et ... bonne pêche aux infos - (Les numéros d'IP sont conservés.)
XML/RSS 2.0  page_down
newtopiclink  replylink  Version imprimable 
Ordre ascendantOrdre descendant » Sujet: Select * does not perform valid datas
Auteur: Message:


threadicon Posté le 13/05/2004 à 01:28
hello Trollix hello all here,

i have got some troubles in a DB-request: Want to get some useful datas out of the db.
Therefore i perform some request for a XForum: This one runs all right and gives some valid and useful output

Code:
SELECT * 
FROM `nuke_XForum_threads` 
WHERE (
`fid` = 5
) AND (
`replies` = 4) LIMIT 0 , 4000 


the followning statement runs all right and gives some valid and useful output
too

Code:
SELECT * 
FROM `nuke_XForum_threads` 
WHERE (
`fid` = 5
) AND (
`author` = 51) LIMIT 0 , 4000 



the last one - below here - does not run with a valid result - WHY

Code:
SELECT * 
FROM `nuke_XForum_threads` 
WHERE (
`fid` = 5
) AND (
`author` = Anonym) LIMIT 0 , 4000 


well the result is bullshit. What is wrong here?
why does the statement not work the statement- does not run with a valid result - WHY?

any advice `? many many thanks in advance!!

sailor
Profil Message Privé Editer le message Voir le site de l'utilisateur Chercher tous les messages de cet utilisateur Signaler ce message aux Administrateurs top
newtopiclink  replylink  Version imprimable 

page_up

 

Powered by XForum 3.5.2-ix by Trollix Software
0.0101390 - 28 queries
iXprim Website © powered by Ixprim 1.3 rc2
| E-mail: trollix at trollix.com | Contact | Rapports de bug | Feed XML des News | Feed XML du Forum