If statement help for newbie!

ctoshack

Sorry guys I'm real green with php here is what I have!

The code below pulls numbers from a data base which are refered to as the bidstart and bnvalue.

I would like to have an if else statement that compares the bidstart to the bnvalue and if it is less then the bnvalue to display exactly as above showing the bidstart and the bnvalue, and if it is found that there is no bnvalue then to display as below showing only the bidstart like below!

And finally if the bidstart and the bnvalue are = to each other then I would like it to display like this showing the bnvalue only and not the bidstart

ctoshack

I think my real problem lies in understanding how to make the code recognize that the variables are bidstart and bnvalue and where to get them from.

awesome_aims

I'm not positive what you are asking but I think this is what you might want:

<?php
// this isn't how I get values from DB's, but it may be easier for you
// obviously you would first make an MySQL connection if you havent already on that page
$bidstart = getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bidstart");
$bnvalue = getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bnvalue");

if($bidstart < $bnvalue) {
?>

<td class="feat1" nowrap align="right"><?=strtoupper($lang[startbid]);?>:</td> 
<td class="feat1" nowrap> <? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bidstart"),$currency[$numb]);?> </td> 
</tr> 
<tr> 
<td class="feat3" align="right"><?=$lang[currbid];?>:</b></td> 
<td class="feat3"><? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","maxbid"),$currency[$numb]);?></td> 
</tr> 
<tr> 
<td class="feat1" nowrap align="right"><?=strtoupper($lang[binfeat]);?>:</td> 
<td class="feat1" nowrap> <? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bnvalue"),$currency[$numb]);?> </td>

<?php
}
if($bnvalue == "") {
?>

<td class="feat1" nowrap align="right"><?=strtoupper($lang[startbid]);?>:</td> 
<td class="feat1" nowrap> <? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bidstart"),$currency[$numb]);?> </td> 
</tr> 
<tr> 
<td class="feat3" align="right"><?=$lang[currbid];?>:</b></td> 
<td class="feat3"><? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","maxbid"),$currency[$numb]);?></td> 

<?php
}
if($bnvalue == $bidstart) {
?>

<td class="feat1" nowrap align="right"><?=strtoupper($lang[bnvalue]);?>:</td> 
<td class="feat1" nowrap> <? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bnvalue"),$currency[$numb]);?> </td> 
</tr> 
<tr> 
<td class="feat3" align="right"><?=$lang[currbid];?>:</b></td> 
<td class="feat3"><? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","maxbid"),$currency[$numb]);?></td>

<?php
}
?>

Because you can do PHP if statements like that, you just gotta make sure to close them after you are through with your HTML.

ctoshack

You pretty much got it bang on the nose! I just had to make a couple of typo changes but it seems to work exactly as I wanted it to! Thanks

ctoshack

The only thing I can't seem to figure out is that this if statement in the middle does not want to come up.

}
if($bnvalue == "") {
?>

<td class="feat1" nowrap align="right"><?=strtoupper($lang[startbid]);?>:</td>
<td class="feat1" nowrap> <? echo displayAmount(getSqlField("SELECT FROM probid_auctions WHERE id='".$id[$numb]."'","bidstart"),$currency[$numb]);?> </td>
</tr>
<tr>
<td class="feat3" align="right"><?=$lang[currbid];?>:</b></td>
<td class="feat3"><? echo displayAmount(getSqlField("SELECT FROM probid_auctions WHERE id='".$id[$numb]."'","maxbid"),$currency[$numb]);?></td>

<?php

I've tried changing it to

if($bnvalue < $startbid ) {

and still no go!

awesome_aims

I'm still not 100% positive what you mean, if you want to know if the bnvalue exists then try this, but if you want to know if bnvalue is blank ("") then that shouldv'e worked.

// this is the middle section
<?php
}
// if it is valid, this would output the HTML if bnvalue doesn't exist
if(!getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bnvalue")) {
?>

<td class="feat1" nowrap align="right"><?=strtoupper($lang[startbid]);?>:</td> 
<td class="feat1" nowrap> <? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","bidstart"),$currency[$numb]);?> </td> 
</tr> 
<tr> 
<td class="feat3" align="right"><?=$lang[currbid];?>:</b></td> 
<td class="feat3"><? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$id[$numb]."'","maxbid"),$currency[$numb]);?></td>

<?php
}
// then finish it
?>