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
Problem with including in Joomla
Moderator: marco
Re: Problem with including in Joomla
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?
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?
-
- Posts: 2
- Joined: Tue Jul 28, 2009 9:40 pm
Re: Problem with including in Joomla
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.
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.
Re: Problem with including in Joomla
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!
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!
Re: Problem with including in Joomla
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
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
Problems installing, configuring, upgrading?
Try the easiest way to use HotelDruid:
https://www.digitaldruid.net/hosted/index.php
Try the easiest way to use HotelDruid:
https://www.digitaldruid.net/hosted/index.php