The thing is that I am trying to make Frog CMS read my pages by slug.
So instead of using http://www.site.com/diving/weekend-courses/course1.html, I want to use http://www.site.com/course1.html.
I want to do this without manually adding htaccess lines with 301 redirects.
Other way then 301 redirect?
It simply displays a blank page, no errors even with DEBUG set to TRUE.
I am not using a PDO connection to the database.
The thing that I am trying to do is read some values for some Course Pages (prices, lenght) from another table but in the same database. When I put the code from my first post in the “Layout” for Courses the page stops there and it doesen’t continue to show rest of the content. For example if I put my PHP code before the footer, the footer won’t show and of course no values are assigned to $courseduration, $courseprice, etc.
Can you please help me with this? It’s a quite urgent and important stuff.
I have this code in a Snippet but it doesen’t work.
// READING COURSE ID
$lookingFor = $this->id();
$SQLquery = “SELECT * FROM courses WHERE COURSECATEGORY=‘55’”;
$SQLresult = mysql_query($SQLquery) or die(mysql_error());
$SQLrow = mysql_fetch_array($SQLresult) or die(mysql_error());
$courseduration = $SQLrow[‘COURSEDURATION’];
$courseprice = $SQLrow[‘COURSEPRICE’];
$allowdeposit = $SQLrow[‘ALLOWDEPOSIT’];
$depositamount = $SQLrow[‘DEPOSITAMOUNT’];
$bookonline = $SQLrow[‘BOOKONLINE’];
If I replace the TABLE NAME to “page” for example (an original Frog CMS table) and try to read from it, it works. If I try any other tables made by me it doesen’t work. Someone can help me with this?
PS: All tables are in the same database…
I currently use Frog CMS on a website.
The current link looks like this:
Is there any way to modify the link to look like this?
This is very important for me because I have to keep the same link structure as the old website. Someone can help?