Re: [PHP-DB] Handling missing rows on joins

2004-04-21 Thread -{ Rene Brehmer }-
nse system is among the things I'm looking at doing). Rene According to historical records, on Wed, 21 Apr 2004 16:18:45 +0400 Mikhail U. Petrov wrote about "Re: [PHP-DB] Handling missing rows on joins": >Hi! >I think it'd be good to add in hf_users column status - ENUM('

Re: [PHP-DB] Handling missing rows on joins

2004-04-21 Thread Doug Thompson
-{ Rene Brehmer }- wrote: Working with PHP 4.3.0 and MySQL 4.0.14 (but code MUST be compatible with 3.23.56). For my forums, I've got this 4-way join to load (and output) the posts with info on the poster: $fullthread = "SELECT postID,hf_posts.userID,name,time,post,edit,nickname,joined,location,pos

Re: [PHP-DB] Handling missing rows on joins

2004-04-21 Thread Mikhail U. Petrov
Hi! I think it'd be good to add in hf_users column status - ENUM('Active', 'Blocked', 'Deleted'), and when user will be deleted you should set this status to Deleted. Value 'Blocked' may give you a simple way to ban user :) Yes, this method of deletion take more database space, but it'd be better,