07-27-2023, 12:00 AM
What I wanna do is replace ALL columns in the "subject" field & that has a "0" in "replyto" with the subject ( as long as it is 0) because when replying it leaves a "RE" thing which i dont like... so i just wanna replace it with the subject matching 0
How can I accomplish this??
$result = mysql_query("
SELECT * FROM mybb_posts
LEFT JOIN mybb_userfields ON (mybb_posts.uid = mybb_userfields.ufid)
WHERE (fid=42) OR (replyto=0)
ORDER BY pid DESC
LIMIT 0,3
");
You can see in the yellow-ish picture that i pull the information successfully and the crossed out subject is what i am talking about
The table in the picture is the "mybb_posts" table
How can I accomplish this??
$result = mysql_query("
SELECT * FROM mybb_posts
LEFT JOIN mybb_userfields ON (mybb_posts.uid = mybb_userfields.ufid)
WHERE (fid=42) OR (replyto=0)
ORDER BY pid DESC
LIMIT 0,3
");
[To see links please register here]
You can see in the yellow-ish picture that i pull the information successfully and the crossed out subject is what i am talking about
The table in the picture is the "mybb_posts" table