content

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!

Hi,

You just have to re-add this line right under where you select the records:
$motorcycle_historyRecord =$motorcycle_historyRecords[0];

Hope this helps.

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.

Hi Jason

That is right now i got it working.