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 Jason

Now there is nothing showing up at all.

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.