help with banner rotation

[pdent1]

I have been working hard on my website and the only thing left is banner rotation..I have went completely brain dead at this tho..

$sql = "SELECT * FROM tb_ads WHERE banner!=="" ORDER BY id ASC;
$result = mysql_query($sql);

$row = mysql_fetch_array($result);

$id = $row['id']

$random = rand(0, count($id)-1);

$sql = "SELECT * FROM tb_ads WHERE id=$random;
$result = mysql_query($sql);

$row = mysql_fetch_array($result);

$url=$row['url']
$banner=$row['banner']

echo "<p><a href=\"" . $url . "\"><img src=\"" . banner. "\" alt=\"Advertisement\" /></a></p>";

is what I got but i can't figure out how to select from a database where banner is not empty...I get an error about " I want it to random the ID and select one id and display the banner... if you can just give me a hint I can do it from there...for some reason I'm just having trouble with this.

[pdent1]

welp i noticed a small error with the $row's 😉 and to use WHERE NOT banner="" but i still got an error with the "" so i did banner=\"\" and then I get an $end problem...

[devinemke]

it looks like you are way over complicating this

$result = mysql_query('SELECT banner, url FROM tb_ads ORDER BY RAND() LIMIT 1') or exit(mysql_error());
$row = mysql_fetch_assoc($result);
echo '<a href="' . $row['url'] . '"><img src="' . $row['banner'] . '" alt="Advertisement"></a>';

[pdent1]

thank you if some banners are blank how would I put in WHERE NOT banner='' i keep getting errors...cause its blank should i make it default none?

[pdent1]

everything has been solved. thanks