content

16 posts by 3 authors in: Forums > CMS Builder
Last Post: April 26, 2010   (RSS)

By Jason - April 23, 2010

Hi,

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

Hi Jason

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!
Thanks



Craig

KC Media Solutions

www.kcmedia.biz
Attachments:

used-motorcycles_003.php 30K

By Jason - April 23, 2010

Hi,

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/

By Jason - April 26, 2010

Hi,

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 record


Give 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

Hi Jason

That is right now i got it working.
Thanks



Craig

KC Media Solutions

www.kcmedia.biz