content
16 posts by 3 authors in: Forums > CMS Builder
Last Post: April 26, 2010 (RSS)
By Jason - April 23, 2010
You just need to change the name "manufacturer" to whatever you call that field in your table.
Give that a try and let me know.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] content
By KCMedia - April 23, 2010
got a little bit futher this time now i get this error message on the page.
The History of Notice: Undefined variable: motorcycle_historyRecord in /var/www/vhosts/actionmc.com.au/httpdocs/newsite/used-motorcycles.php on line 316
Notice: Undefined variable: motorcycle_historyRecord in /var/www/vhosts/actionmc.com.au/httpdocs/newsite/used-motorcycles.php on line 318
Notice: Undefined variable: motorcycle_historyRecord in /var/www/vhosts/actionmc.com.au/httpdocs/newsite/used-motorcycles.php on line 322
Notice: Undefined variable: motorcycle_historyRecord in /var/www/vhosts/actionmc.com.au/httpdocs/newsite/used-motorcycles.php on line 323 No record found!
Craig
KC Media Solutions
www.kcmedia.biz
By Jason - April 23, 2010
You just have to re-add this line right under where you select the records:
$motorcycle_historyRecord =$motorcycle_historyRecords[0];Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] content
By KCMedia - April 23, 2010
Now there is nothing showing up at all.
Craig
KC Media Solutions
www.kcmedia.biz
By Jason - April 26, 2010
The problem is in your query. The URL for your page looks like this:
http://www.actionmc.com.au/newsite/used-motorcycles.php?manufacturer=Honda.
So, to get the value "Honda" we use this code:
$_REQUEST['manufacturer']. There is no variable $_REQUEST['title'].
Try changing your query to this:
list($motorcycle_historyRecords, $motorcycle_historyMetaData) = getRecords(array(
'tableName' => 'motorcycle_history',
'where' => "title='".mysql_escape(@$_REQUEST['manufacturer'])."'",
'allowSearch' => '0',
'loadUploads' => '0',
'limit' => '1',
));
$motorcycle_historyRecord = @$motorcycle_historyRecords[0]; // get first recordGive that a try and let me know if it works.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] content
By KCMedia - April 26, 2010
That is right now i got it working.
Craig
KC Media Solutions
www.kcmedia.biz