CODEWITHSUNDEEP
phpsql
Head
Head

Reputation: 568

php if and else if statement from a sql value

I have a query like so:

if ($auto_hold = sql::value("select a.code, a.primcode, b.secondary_auto_hold from ev.do.nt_dg_li() a
                         left outer join eve.do.nce_data b on a.seccode = b.CODE_
                         where primcode like 'INSM%%' and secondary_auto_hold = 1 and code='$patient_id'"))

if my variable matches that query than i want to echo an alert if it doesn't than it should do nothing.

easy question but i'm drawing blanks atm. any help would be greatly appreciated. Thank you.

I've tried various assignment operators ie. ==, === but nothing.

I'm sure i could probably drop the variable as well and just say if(sql::value etc)

I figured it out:

if ($patient_id == $auto_hold) echo "<div class='patient_alert_red'>Auto hold on deductible for this patient.</div>";

Upvotes: 0

Views: 108

Answers (1)

Head
Head

Reputation: 568

My answer is as follows:

if ($patient_id == $auto_hold) echo "<div class='patient_alert_red'>Auto hold on deductible for this patient.</div>";

I used the == / Equal operator to verify they're the same.

More here:

http://www.w3schools.com/php/php_operators.asp

Upvotes: 1

Related Questions