invalid aruments supplied for foreach()....

dottedquad

I'm getting: Warning: Invalid argument supplied for foreach()

foreach ($dbh->query('SELECT id, state_county_key, org_type, org_name, contact_name, address, city, state, zip_code, phone, website FROM listing WHERE state_county_key = 39 AND enabled = 1 LIMIT $offset,$rowsperpage') as $row)

Could it possibly be since there are no values getting set to $row I'm receiving that error? Or is there something wrong with my query structure such as the proper use of single and double quotes? Those quotes always confuse me. Any help/suggestions are greatly appreciated.

-Thanks,
Rich

HalfaBee

$dbh->query() probably doesn't return an array, but a resource.

dottedquad

HalfaBee;10890469 wrote:
$dbh->query() probably doesn't return an array, but a resource.

If I'm not mistaken, it should return an array since in the passed, I used this way to return results from a database successfully.

-Rich

dottedquad

HalfaBee;10890469 wrote:
$dbh->query() probably doesn't return an array, but a resource.

Ok, the issue is within my query structure. where it says

LIMIT $offset,$rowsperpage

is the issue.

If I hard code the values into the query it works as expected. If I use variables I receive that warning. So, my query structure is wrong. Any suggestions on how the structure of my query should be?

-Rich

HalfaBee

You are using single quotes instead of double quotes.

dottedquad

I resolved the issue by using Ctrl+F5 to refresh the page a few times.

Weedpacket

dottedquad wrote:
I resolved the issue by using Ctrl+F5 to refresh the page a few times.

Okaaay.... I'm going to have to remember that technique. "If it doesn't work, keep thumping it until it does."

HalfaBee

I should have suggested the ctrl+F5 trick first 🙂

dottedquad

Weedpacket;10890511 wrote:
Okaaay.... I'm going to have to remember that technique. "If it doesn't work, keep thumping it until it does."

After I changed the single quotes to doubles it should have worked. I apparently was using the old page in the cache.