Can't figure out how to write this query properly... involves two tables.

[eluser]Christopher Blankenship[/eluser]
if you are only attempting to return 1 record from the ads table but many records from the comments table as it appears in your code you can :
output your $ads_row

Array (
[0] => array(
'information' => 'here'
)
)

if you see something like this use the following $ads_row = array_shift($ads_query->result_array());

Then your code should work.