SQL query works but I get an error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL query works but I get an error

Author

Topic

jarv
Posting Yak Master

131 Posts

Posted - 2015-01-27 : 06:23:32

I get the error: Fatal error: Call to a member function getrow() on a non-object in /var/www/synced/cactuslanguage/en/cactus/contact.php on line 315
</select>

but when I put my SQL code into phpMyAdmin it pulls back results?!



$SQL="SELECT DISTINCT schools.city FROM schools INNER JOIN courses ON courses.school_id = schools.id WHERE schools.active = 1 AND courses.active ='Y' AND courses.domains IN ('[CL]');";
																			$qPreferredcity = new query($DB,$SQL);
																			while ($preferredcity=$Preferredcity->getrow()):
																				unset($selected);
																				echo "<option value='$preferredcity[city]' $selected>$preferredcity[city]</option>\n";
																			endwhile;

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-27 : 06:52:39

That's not a SQL error