RE: [PHP] IF in mysql query results problem

2002-01-06 Thread Jason Dulberg
] Subject: Re: [PHP] IF in mysql query results problem Hi Jason, I am not too familiar with IF statements in SQL, but one thing may be the reason you see the incorrect results: You have three tables, player, coach and co_bookmarks, but you only join player and coach. Shouldn't you

Re: [PHP] IF in mysql query results problem

2002-01-06 Thread Mehmet Kamil ERISEN
Hi Jason, I am not too familiar with IF statements in SQL, but one thing may be the reason you see the incorrect results: You have three tables, player, coach and co_bookmarks, but you only join player and coach. Shouldn't you join coach with co_bookmarks. I hope this helps. erisen SELECT

[PHP] IF in mysql query results problem

2002-01-06 Thread Jason Dulberg
I am working on a program that allows users to "bookmark" a particular item that they view. The bookmarks are stored in the database. I would like to use an IF statement in the mysql query so when the user logs in and views the items, the option to bookmark the record has been removed if they hav