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
Go to Top of Page

sz1
Aged Yak Warrior

555 Posts

Posted - 2015-01-27 : 07:29:52
This is MySQL with PHP frontend.

We are the creators of our own reality!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2015-02-02 : 01:30:52
You may need to post this in MySQL forum

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -