Loftus Versfeld Stadium on map of Pretoria
Er zit een fout in de query:
SELECT SQL_CALC_FOUND_ROWS
a.sn_id
FROM accommodation_x_destination axd
INNER JOIN accommodation a ON (a.sn_id=axd.accommodation_id)
WHERE 1
AND c.id='154' ORDER BY rating ASC LIMIT 10
De fout is:
Unknown table 'c' in where clause
Array
(
[0] => Array
(
[file] => /home/httpd/vhosts/yourcapetown.com/httpdocs/inc/sql.inc.php
[line] => 5
[function] => sql_error
[args] => Array
(
[0] =>
SELECT SQL_CALC_FOUND_ROWS
a.sn_id
FROM accommodation_x_destination axd
INNER JOIN accommodation a ON (a.sn_id=axd.accommodation_id)
WHERE 1
AND c.id='154' ORDER BY rating ASC LIMIT 10
)
)
[1] => Array
(
[file] => /home/httpd/vhosts/yourcapetown.com/httpdocs/inc/custom.func.php
[line] => 1081
[function] => query
[args] => Array
(
[0] =>
SELECT SQL_CALC_FOUND_ROWS
a.sn_id
FROM accommodation_x_destination axd
INNER JOIN accommodation a ON (a.sn_id=axd.accommodation_id)
WHERE 1
AND c.id='154' ORDER BY rating ASC LIMIT 10
)
)
[2] => Array
(
[file] => /home/httpd/vhosts/yourcapetown.com/httpdocs/inc/site/wc2010_stadiums.inc.php
[line] => 67
[function] => getAccommodations
[args] => Array
(
[0] => Array
(
[city] => 154
)
[1] => 10
)
)
[3] => Array
(
[file] => /home/httpd/vhosts/yourcapetown.com/httpdocs/inc/fun.inc.php
[line] => 420
[args] => Array
(
[0] => /home/httpd/vhosts/yourcapetown.com/httpdocs/inc/site/wc2010_stadiums.inc.php
)
[function] => require_once
)
[4] => Array
(
[file] => /home/httpd/vhosts/yourcapetown.com/httpdocs/index.php
[line] => 56
[function] => returnIncludeFile
[args] => Array
(
[0] => inc/site/wc2010_stadiums.inc.php
)
)
)