bid = 0.00 don't show.

Anon

Hi, I'm trying to setup a bidding system, and it will print the bidders price when the value is above 0.00.

I was thinking that if I had this sort of coding, that would do it, but I'm not doing it right. Any help?

Thanks Stuart

/////////////

if ($myrow["bid"] = "0.00"); {

printf ("");

} else {

Anon

Well, do you want to not print anything if there bid is 0.00 if so, Is your field type afloat or a string
If float
if ($myrow["bid"] > 0) {
//do something
}
If string
if ($myrow["bid"] != "0.00") {
//do something
}

Anon

Thank Louie,

I still can't get it to work. Rather that put in the code with all the errors, I'll show you the code that works. The thing I want to change is that when the bid is 0.00 , the remarked section below is the bit I don't want to show.

Any help would be great!

Stuart

/////////////

<?
$db = mysql_connect("localhost", "gopile", "password");
mysql_select_db("database",$db);

$result = mysql_query("SELECT * FROM search WHERE ((title LIKE '%$keywords%') OR (term LIKE '%$keywords%') OR (description LIKE '%$keywords%') OR (url LIKE '%$keywords%')) ORDER BY bid DESC, time ASC",$db);

printf(" <ol>");

if ($myrow = mysql_fetch_array($result))

do {printf("<li><a href=%s>%s</a></li> %s %s

//this is the bit I need to be shown ONLY if the bid is higher than 0.00

(cost to advertiser = \$%s)", $myrow["url"], $myrow["title"], $myrow["description"], $myrow["url"], $myrow["bid"]);}

//this is the end of the bit to be be shown ONLY if the bid is higher than 0.00

while ($myrow = mysql_fetch_array($result));

else {printf ("Error");}

printf ("</ol>");
?>

Anon

I think I follow you, what I would do is to test to see if $myrow["bid"] = 0.00 and if it doesn't assign it to a new varibale

within your while statement do:
if ($myrow["bid"] != "0.00") {
$bid = $myrow["bid"];
}
else {
$bid = "";
}

Now you can use $bid in your printf statement so if the value is not 0.00 it will display the value or else it will display nothing. Hope that is on the right track

Anon

Thank Louie,

I appreciate your help. I tried putting it in the WHILE statement but it didn't work, so I tried the next logical thing.

Not only don't I want 0.00 shown, but the whole line (cost to advertiser - 0.00).

Thanks again.

Stuart

Here's the code which comes out with errors.

//////////////

<?
$db = mysql_connect("localhost", "gopile", "password");
mysql_select_db("database",$db);

printf(" <ol>");

if ($myrow["bid"] != "0.00") {
$bid = "(cost to advertiser - ($myrow["bid"])😉"
}
else {
$bid = "";
}

if ($myrow = mysql_fetch_array($result))

do {printf("<li><a href=\"http://www.gopile.com/click.php3?url=%s&keywords=$keywords&ip=$ip&bid=$bid\">%s</a></li> %s %s
$bid", $myrow["url"], $myrow["title"], $myrow["description"], $myrow["url"]);}

while ($myrow = mysql_fetch_array($result));

else {printf ("Sorry, no matches found.");}

printf ("</ol>");
?>

Anon

I am not sure how the whole do clause works I would normally do this

By the wya what erros are you getting?

if ($result > 0)
while ($myrow = mysql_fetch_array($result)) {

printf("<li><a href=\"http://www.gopile.com/click.php3?url=%s&keywords=$keywords&ip=$ip&bid=$bid\">%s</a></li> %s %s
$bid", $myrow["url"], $myrow["title"], $myrow["description"], $myrow["url"]);
}
}

else {printf ("Sorry, no matches found.");}

printf ("</ol>");