[RESOLVED] Can this be done? mysql query

kpowning

I have the following script and I'm wondering how to do the following. I want to check if (userinfo.paidstatus = 'Yes' or 'No' and that user.trial='In Process' or 'Paid') and if I can make this the result for $paypalstatus; that would be great or does anyone else have any ideas how I can change my query to make it check all of these settings?

THANKS IN ADVANCE..


$require="AND haircolor='Blonde'";

$paypalstatus = ''; // THIS IS THE PROBLEM...

$getescorts = mysql_query("SELECT * FROM userinfo, user WHERE (userinfo.category1='Female Escorts' OR userinfo.category2='Female Escorts') $require $paypalstatus AND userinfo.status='Approved' AND userinfo.id = user.id");
$getpageproperties = mysql_fetch_array($getescorts);

bradgrafelman

So you want to add this onto your WHERE clause:

(userinfo.paidstatus = 'Yes' OR userinfo.paidstatus = 'No') AND (user.trial = 'In Process' OR user.trial = 'Paid')

kpowning

Is this query getting to long? Also what is your personal opionion on my query layout? I appreciate your help by the way, it worked great...

bradgrafelman

I can't comment on any of that... I'm no DB guru. As to the query being too long... I would say if there's nothing you can remove from it, then no, it's not too long. shrug

alimadzi

kpowning wrote:
Is this query getting to long? Also what is your personal opionion on my query layout? I appreciate your help by the way, it worked great...

Believe me... your query is not long at all. BTW, I can only imagine what kind of website this query is for. All I know is that it sounds more interesting than the work I usually do... 😉

bradgrafelman

Heh... I was trying to ignore the category names! :p Any chance we can add on "OR username = 'bradgrafelman'" onto that paid status bit? 😉

alimadzi

Ah, the things you can buy with PayPal... 😉

kpowning

Thanks all 🙂, YA it is a FUN project... lol

bradgrafelman

Don't forget to mark this thread resolved (if it is).