Php Help Please

[Johnnikins]

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

<?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

[Calon]

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

<?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
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"];
}
?>

[Johnnikins]

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

[Calon]

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.

[Johnnikins]

Yes it works perfectly thanks.

I know my attempt was very very poor

[Calon]

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

[Johnnikins]

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

[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

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

[Calon]

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

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

Agree'd.

[Johnnikins]

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