Php Help Please

[Excellent1]

With the one you gave me, is there a way to show a certain banner if there is none with Paid = yes?

if($data[paid] = "No") {
echo "<img src='urltothenobanner'>";
} 

[Johnnikins]

Okay, that apparantly wants to show up two banners :s

[Calon]

if($data[paid] = "No") {
echo "<img src='urltothenobanner'>";
} 

<?php
mysql_connect("localhost", "", "") or die(mysql_error()); // Try putting in your username and password
mysql_select_db("") or die(mysql_error());  // Try putting in your database

$query = mysql_query("SELECT * from `ads` WHERE Paid = 'Yes'");

$something = mysql_query("SELECT * from `ads`");
$loldongs = mysql_fetch_array($something);

if($loldongs["Paid"] == "Yes") {
while($data = mysql_fetch_array($query)) { 
echo "<img src=\"". $data["bannerurl"] ."\" /><br /><!-- I imagine that you wanted a breakspace -->";
echo $data["Site"];
}
else {
echo "<!-- how private.. --><img src=\"URLTOTHABANNER\"><br />Some descriptive text?";
}
?>

[Excellent1]

Okay, that apparantly wants to show up two banners :s

Oops I forgot about the query that was in use before.

[Calon]

<?php
mysql_connect("localhost", "", "") or die(mysql_error()); // Try putting in your username and password
mysql_select_db("") or die(mysql_error());  // Try putting in your database

$query = mysql_query("SELECT * from `ads` WHERE Paid = 'Yes'");

$something = mysql_query("SELECT * from `ads`");
$loldongs = mysql_fetch_array($something);

if($loldongs["Paid"] == "Yes") {
while($data = mysql_fetch_array($query)) { 
echo "<img src=\"". $data["bannerurl"] ."\" /><br /><!-- I imagine that you wanted a breakspace -->";
echo $data["Site"];
}
else {
echo "<img src=\"URLTOTHABANNER\"><br />Some descriptive text?";
}
?>

I think mine might work, I'm really tired and a tiny bit drunk so, sorry if it doesn't work.

[Johnnikins]

thank you both, i just had to change a few of the names and it worked

:]

[Protege]

I think mine might work, I'm really tired and a tiny bit drunk so, sorry if it doesn't work.

Wat the hell is that man, that confuses the hell into me...

What did this guy actually want in full context :|

[Johnnikins]

I wanted a script which would display a certain banner if Paid = Yes, if not it would display an alternative banner, and even though he may have been drunk it worked perfectly

[Calon]

I wanted a script which would display a certain banner if Paid = Yes, if not it would display an alternative banner, and even though he may have been drunk it worked perfectly

Dude, we don't want people's life stories!

[Excellent]

Dude, we don't want people's life stories!

Stop sucking up to protege.