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?

Quote:

---

Originally Posted by Johnnikins

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

---

PHP Code:

---

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


---

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

Quote:

---

Originally Posted by Excellent1

PHP Code:

---

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


---

---

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

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

---

Quote:

---

Originally Posted by Johnnikins

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

---

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

Quote:

---

Originally Posted by Calon

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

$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.

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

:]

Quote:

---

Originally Posted by Calon

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

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

Quote:

---

Originally Posted by 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

---

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

Quote:

---

Originally Posted by Calon

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

---

Stop sucking up to protege.

Quote:

---

Originally Posted by Excellent

Stop sucking up to protege.

---

How the **** am I sucking up to protege?

I posted before him, I posted on Jonnikins reply.


And that was about me, nothing to do with protege, or you infact.

Quote:

---

Originally Posted by Calon

How the **** am I sucking up to protege?

I posted before him, I posted on Jonnikins reply.


And that was about me, nothing to do with protege, or you infact.

---

Quote:

---

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

What did this guy actually want in full context :|

---

John then stuck up for you and you called it a life story, need I say more?

They all love me uhmm I feel privileged.

I duno how that works but be nice if he posted it clean :P But good if it worked, good.

Quote:

---

Originally Posted by Protege

They all love me uhmm I feel privileged.

I duno how that works but be nice if he posted it clean :P But good if it worked, good.

---

You're loved for being an ego maniac *by some*

Quote:

---

Originally Posted by Excellent

John then stuck up for you and you called it a life story, need I say more?

---

I didn't even see protege's post.

I meant life story because I was pretending to be a back-street-drunk-tramp, which I'm not, I was a bit drunk 1 night, yet still able to code.

Quote:

---

Originally Posted by Excellent

You're loved for being an ego maniac *by some*

---

Excellent you have yet to understand the awesomeness of myself.

I am... an awesome great wizard from Hogwartz and I have sexual relations with Hermione, untill she reported me for sexual harrassment but I tell you she enjoyed it - I even put on my wizard hat and invisible cloak.

or I'm a 'fat emo' like you say LOL.

Quote:

---

Originally Posted by Protege

Excellent you have yet to understand the awesomeness of myself.

I am... an awesome great wizard from Hogwartz and I have sexual relations with Hermione, untill she reported me for sexual harrassment but I tell you she enjoyed it - I even put on my wizard hat and invisible cloak.

or I'm a 'fat emo' like you say LOL.

---

The only awesome thing I see from you is coding. Second option sir :P

add me on msn, I show you how emo I rly am

[email protected]

Quote:

---

Originally Posted by Protege

add me on msn, I show you how emo I rly am

[email protected]

---

Mummy told me not to talk to strangers.

Okay, Mummy's boy. It's okay.

@Excellent;

You fail.