IF condition

[vinny199]

Hi,

I have a simple request I think.
I know how to formulate it in asp, but need help in php.

I need to have an example of code for the following:

(I write it as I mean it)

IF {rsMP3.Price}="FREE" THEN SHOW <a href="<?php echo $row_rsMP3['downloadurl']; ?>">Download free track</a>

Basically, if my recordet value for the field MP3.Price is the word FREE then a download link should show as shown above.

could you help me with that?

Thanks,

Vinny

[Shrike]

$result = mysql_query("SELECT Price, downloadurl FROM recordset");
while($row_rsMP3 = mysql_fetch_array($result)){
  if($row_rsMP3['Price'] == "FREE"){
    print "<a href=\"$row_rsMP3['downloadurl']\">Download free track</a>";
  }
}

Of course assumes that $result is a valid recordset, and that your using MySQL 🙂

[tomwerner]

$result could be :

SELECT `Price`, `downloadurl` FROM recordset WHERE `Price`="FREE";

Which could then get rid of the

if($row_rsMP3['Price'] == "FREE"){

always more than one way to skin a cat...

[vinny199]

Thank you all!
Works great

[Shrike]

The next logical step would be to display the ones which aren't downloadable for free, surely. How else u gonna make some money? 😉

[vinny199]

Thats already done.

They all display on the page, and can be listen to, but I needed the download url to be shown only for the free tracks.

Cheers,

Vinny