Problem with including in Joomla

[morteza_it]

Hi,
I am using Joomla CMS and want to use php-residence but when i include verfuegbarkeitscheck.php template i get this error :

ERROR IN: select * from ntariffe2009 where idntariffe > 4 and nomecostoagg != '' and mostra_ca 's%' order by tipo_ca, idntariffe
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''s%' order by tipo_ca, idntariffe' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/web5/10/06/52122306/htdocs/de_eu/cms/verfuegbarkeitscheck.php on line 932
I use mysql 5.
When i view these template directly everything is ok.
can anybody help me.

Best regards

[kyomar]

Hello,

I am not a mysql expert but I implemented php-residence in Joomla 1.5.14 without any problems (see http://www.koyuki-hakuba.com). I am using mysql 5 as well. How did you include php-residence in Joomla? Did you use the wrapper module in Joomla?

[morteza_it]

Hi,
I do not use wrapper.it is not proffessional and on my project i can not use wrapper. because i have to redirect customers from homepage to another page to see the result of availability.(so availability form is in frontpage after sending a request, customers will be redirected to another page with result.)I used php include() and got the error.
i tried $onbook = file_get_contents("verfuegbarkeitscheck.php"); and it works on my frontpage and on my result page without error.
But after redirecting to resulting page it display the normal form without result.only with include i get a result page but with error mentioned above.

result page is: after submitting the request for availability of a room, the customer sees a page with information about availability and he can fill the form.
best regards

this script is really great. but support is very poor.

[kyomar]

Hi,

did you read this thread http://www.digitaldruid.net/php-residen ... d495b5fc6d.

I tried to do the same as you but gave up:-(. So if you find a solution I would be really happy if you could post it here.

Thanks!

[marco]

Hello,
you don't seem to be a digitaldruid.net hosting subscriber, so please don't talk abuot things you haven't even tried claiming that our support is poor.

The templates are supposed to work as a stand alone file, not as an included file. You can use an iframe or try the solution in the thread suggested by kyomar, only html knowledge is needed to understand it. You can see an exaple here:

http://www.residencepb.com

Regards,
Marco