Re: [PHP-DB] force no results

2002-06-25 Thread Martin Adler
Thans for awnsering! OK here is my Query SELECT entries.id, entries.head, entries.date, entries.author, (catgroup.gid IS NULL || catgroup.gid = *user-group-id*) AS indi FROM entries LEFT JOIN category ON entries.cat_no REGEXP CONCAT(\\.,category.id,(\\.|$)) LEFT JOIN entgroup ON entries.id =

Re: [PHP-DB] force no results

2002-06-24 Thread Martin Clifford
Could you give us some examples of entries in the table? You might need to set it up as a relational database, but we can't know that without information. Martin C Martin Adler [EMAIL PROTECTED] 06/24/02 10:47AM Hi, is it possible to force mysql in a SELECT clause depend on a condition to

Re: [PHP-DB] force no results

2002-06-24 Thread Jason Wong
On Monday 24 June 2002 22:47, Martin Adler wrote: Hi, is it possible to force mysql in a SELECT clause depend on a condition to give no results? for example: I do a SELECT and get 3 rows as result, but one row contains a value, which make the other rows worthless. and I won't get this