I need just an idea how to do this?

[wafasn]

Hi all,

I am new to PHP programing but I am doing well.
my question is:
I have created an events calendar system using PHP and MySQL db.
I have successfuly created the admin interface, and I am working on the pages that will be displayed to the end users on the we site. On one of the pages I list all the events(title, start date, location), its works fine. What I am trying to do now is to have the possiblity to order the list by title when the user clicks on title and by start date when he clicks on start date etc...
I know I need to write some JavaScript function to do that but I dont know how to pass variables between PHP ans JS.

Any idea? or if you have an example.

Thanks in advance.

[Erkilite]

you are better off setting a variable in the url

ex: www.mydomain.com/events.php?sort=date

then in your script do something like

$sql = 'select * from event';

if($_GET['sort']=='date')
  $sql .= ' order by date';
else
  $sql .= ' order by title';

mysql_query($sql,$dblink);