Select * does not perform valid datas - Utilisation - Forum

Forum Homepage

Vous n'êtes pas connecté

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.)

Accueil du Forum » XForum Module » Utilisation

» Sujet: Select * does not perform valid datas

Auteur:

Message:

sail

Débutant

Messages: 20
Inscrit(e) le: 2002/12/12
Statut: Déconnecté(e)

Posté le 2004/5/13 à 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

Chercher tous les messages de cet utilisateur