Php Help Please

I need help with this, i've tried and tried but i just keep getting error upon error, can anybody help?

Code:

---

<?php
// Connects to your Database
mysql_connect("localhost", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());
$data = mysql_query("SELECT * FROM ads")
or die(mysql_error());
if ($data[Paid]) == "Yes" {
echo " ?>
<a href=\"<?php $result=mysql_query('select * from ads');while($row=mysql_fetch_array($result)){echo $row[Site]. \"\";} ?>\">
<img src=\"<?php $result=mysql_query('select * from ads');while($row=mysql_fetch_array($result)){echo $row[bannerurl]. \"\";} ?>\" border=\"0\"><?php "; } else { echo ""; }?>

---

Its probobly all messed up but thats why i posted here, can anybody help

Quote:

---

Originally Posted by Johnnikins

I need help with this, i've tried and tried but i just keep getting error upon error, can anybody help?

Code:

---

<?php
// Connects to your Database
mysql_connect("localhost", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());
$data = mysql_query("SELECT * FROM ads WHERE Paid = 'Yes'")
or die(mysql_error());
if ($data[Paid]) == "Yes" {
echo " ?>
<a href=\"<?php $result=mysql_query('select * from ads');while($row=mysql_fetch_array($result)){echo $row[Site]. \"\";} ?>\">
<img src=\"<?php $result=mysql_query('select * from ads');while($row=mysql_fetch_array($result)){echo $row[bannerurl]. \"\";} ?>\" border=\"0\"><?php "; } else { echo ""; }?>

---

Its probobly all messed up but thats why i posted here, can anybody help

---

PHP Code:

---

<?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'");

while($data = mysql_fetch_array($query)) { 
echo "<img src=\"". $data["bannerurl"] ."\" /><br /><!-- I imagine that you wanted a breakspace -->";
echo $data["Site"];
}
?>

---

Thank you so much, and i have put in my username and password & db, but removed them for obvious reasons

Quote:

---

Originally Posted by Johnnikins

Thank you so much, and i have put in my username and password & db, but removed them for obvious reasons

---

Fair do'

Please reply if it works, I didn't try it but I re-wrote it completely.

Yes it works perfectly thanks.

I know my attempt was very very poor :(

Quote:

---

Originally Posted by Johnnikins

Yes it works perfectly thanks.

I know my attempt was very very poor :(

---

Ah, w3 schools is good for tutorials, and so is Tizag.com

Thanks for the advice also, i'll be sure to look on there before i give in :]

There wasn't any need to close php to give the link nor string an if statement with yes, as Calon showed you can just do that with a simple query and loop the links :P

It's not a big error but you may want to read up on PHP a bit more :)

Quote:

---

Originally Posted by Excellent1

There wasn't any need to close php to give the link nor string an if statement with yes, as Calon showed you can just do that with a simple query and loop the links :P

It's not a big error but you may want to read up on PHP a bit more :)

---

Agree'd. :P

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