I am a little confused as to how to do this.
I use this on the htm template file (one example colum heading):
Code
<a href="<!--[pnmodurl modname="roqCamps" func="view" sort="number"]-->"><!--[pnml name="_ROQCAMPSNUMBER"]--></a>
shere "sort" is the colum i want to sort by. i use this in the pnuser file in the view function:
Code
then in the pnuserapi file in the getall function i use this:
Code
extract($args);
if (!isset($sort)) {
$orderby = $roqCampscolumn[yr].' DESC, '.$roqCampscolumn[stDate].' ASC';
}
else {
$orderby = $roqCampscolumn[yr].' DESC, '.$roqCampscolumn[$sort].' ASC';
}
$sql = "SELECT $roqCampscolumn[cid],
$roqCampscolumn[yr],
$roqCampscolumn[campname],
$roqCampscolumn[number],
$roqCampscolumn[stDate],
$roqCampscolumn[endDate],
$roqCampscolumn[grades],
$roqCampscolumn[price],
$roqCampscolumn[ebPrice],
$roqCampscolumn[desc],
$roqCampscolumn[albumNum],
DATE_FORMAT($roqCampscolumn[stDate], '%c/%D') AS formStDate
FROM $roqCampstable
ORDER BY ".$orderby;
if (!isset($sort)) {
$orderby = $roqCampscolumn[yr].' DESC, '.$roqCampscolumn[stDate].' ASC';
}
else {
$orderby = $roqCampscolumn[yr].' DESC, '.$roqCampscolumn[$sort].' ASC';
}
$sql = "SELECT $roqCampscolumn[cid],
$roqCampscolumn[yr],
$roqCampscolumn[campname],
$roqCampscolumn[number],
$roqCampscolumn[stDate],
$roqCampscolumn[endDate],
$roqCampscolumn[grades],
$roqCampscolumn[price],
$roqCampscolumn[ebPrice],
$roqCampscolumn[desc],
$roqCampscolumn[albumNum],
DATE_FORMAT($roqCampscolumn[stDate], '%c/%D') AS formStDate
FROM $roqCampstable
ORDER BY ".$orderby;
and everytime (i use die($SQL) to check the query) no matter what i do, it uses this version of the $orderby:
Code
$roqCampscolumn[yr].' DESC, '.$roqCampscolumn[stDate].' ASC';
that tells me that i am not passing the argument $sort correctly. can anyone help me with this? am i even on the right track?
