Invalid function?

[Anon]

I don't understand why this isn't working. It has before 😐

When I try to view the website I get this error:

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/httpd/www/infodata/config.php on line 35

this is what line 35 is:

while($data=mysql_fetch_row($result)){

The chucnk of data I'm trying to do is in the following code:

function printrecords() {
$result = mysql_query("SELECT id,subjectname,dob,ssn,company,state,location,searchresults,searchperiod,courttype,searchtype,casenumber,casetype,offense,disposition,dispositiondate,notes FROM completedchecks WHERE company='$company'");
while($data=mysql_fetch_row($result)){
//print stuff
}
}

I have no idea why its not working 🙁

• Zimm

[Anon]

there might be a problem in your query ..check all your field name and run this query individualy to see the error..

[Anon]

I get these alot, its because there is no result. So yes, check the query and make sure you can connect to the DB properly.