How do I return TRUE or FALSE from MySQL within PHP function?

Question

I am experimenting with PHP. This is my func.php

function returnBlankStylist(){

$sql=mysql_query("SELECT * FROM `".$dbn."`.`stylist` WHERE `stylist`.`customer_id`='1'");
if (mysql_affected_rows()==0) {
 return false;
} else {
 return true;
}
}

This is my page.tpl

<?php if (returnBlankStylist==false){?>
<div class="center graybox"> Please enjoy this discount since this you have never filled out a query before</div>
<? }?>

If the customer Id 1 exists it shows the message, and if the customer Id 1 does not exist it shows the message?

Jeroen · Accepted Answer · 2012-05-15 12:41:44Z

4

Page.tpl

<?php if (returnBlankStylist() == false) : ?>
    <div class="center graybox">
        Please enjoy this discount since this you have never filled out a query before
    </div>
<? endif; ?>

or

<?php if (!returnBlankStylist()) : ?>
    <div class="center graybox">
        Please enjoy this discount since this you have never filled out a query before
    </div>
<? endif; ?>

or

<?php if (returnBlankStylist() == false) { ?>
    <div class="center graybox">
        Please enjoy this discount since this you have never filled out a query before
    </div>
<? } ?>

edited May 15, 2012 at 12:41

answered May 15, 2012 at 12:32

Jeroen

13.3k4 gold badges45 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

TheBlackBenzKid Over a year ago

Why the dots and calling the function again within the IF?

Jeroen Over a year ago

returnBlankStylist alone doesn't do anything, you need to call it by adding the (). The dots don't really matter, it just looks better ;)

will Over a year ago

@TheBlackBenzKid it's just an alternative syntax

Rukmi Patel · Accepted Answer · 2012-05-15 12:33:08Z

1

you have missed parenthises ..

if(returnBlankStylist()==false){
    //your code...
}

hope it will work for you

answered May 15, 2012 at 12:33

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

Comments

Rohit Choudhary · Accepted Answer · 2012-05-15 12:34:35Z

1

Please replace your code if (mysql_affected_rows()==0) to if (mysql_num_rows()==0);

and try this:

<?php if (!returnBlankStylist()){?>
<div class="center graybox"> Please enjoy this discount since this you have never filled out a query before</div>
<? }?>

answered May 15, 2012 at 12:34

Rohit Choudhary

2,2571 gold badge24 silver badges35 bronze badges

1 Comment

TheBlackBenzKid Over a year ago

repped for efforts – I prefer the ! when it can be used for performance and less characters

Collectives™ on Stack Overflow

How do I return TRUE or FALSE from MySQL within PHP function?

3 Answers 3

Page.tpl

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Page.tpl

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related