I want to get this if to work here!

MitchEvans

Any idea how to get this working? Would love it if you could help me on this one! 🙂

while ($row= mysql_fetch_array($result3)) {
  $title = $row['product'];
  $link = $row['Link'];
  if ( $title == '' ) {
    echo "Apologies but we don't stock anything for that!";
}


  echo " <strong>$title<a target='_blank' href='$link'>Click Here To View</a></strong>" ;

  }

scialom

Try this:
if ( $title == "") {

Piranha

What is happening?
What should happen?

I can't see anything obvius in the code, so those two questions have to be answered to let us understand what is wrong.

bradgrafelman

If you're trying to check whether no results were returned from the database, you would do something like so:

if(mysql_num_rows($exec) == 0) {
echo "Apologies but we don't stock anything for that!";
}

Otherwise, you will have to help us out by outlining what it is you're trying to do versus what is actually happening.

MitchEvans

Thanks for replying guys!
The code that i provided in my first post echoes:

"The best prodcut for you to use is: $title"

This is even when there is no product for that specific one, so when there is no product I want it to say "sorry" but when there is i want it to say "the best product for you to use is: $title"

while ($row= mysql_fetch_array($result3)) {
  $title = $row['product'];
  $link = $row['Link'];
 if($title == "") { 
echo "Apologies but we don't stock anything for that!"; 
}


  echo " The best product for you to use is:<strong>$title<a target='_blank' href='$link'>Click Here To View</a></strong>" ;

  }

With the above code is used no statement is echoed when $title is nothing. But it works fine when $title has a value.

MitchEvans

Problem is solved, i've had a fresh look at it this morning and as always a new day brings new light hehe!

I placed the if statement under the echo statement that read "the best product to use is:"

like so:

while ($row= mysql_fetch_array($result3)) {
  $title = $row['product'];
  $link = $row['Link'];

  echo " The best product for you to use is:<strong>$title<a target='_blank' href='$link'>Click Here To View</a></strong>" ;

  }
if($title == "") { 
echo "Apologies but we don't stock anything for that!"; 
}

Thanks again guys!!!!!!!

bradgrafelman

Don't forget to mark this thread resolved.