Using event.php?events_id=4 instead of event4.php

[Sun Zaza]

Hello Guru's

I added a new table (4images_events) to my galery and also the events.php file.
At moment I am using it on some custom page, but I do not like it any more because everytime I have to make a new php file for every new event.

I want to use something like www.mysite.com/event.php?events_id=4 instead of www.mysite.com/event4.php

Can you give me please an idea how to do that. I will try it myself.

NOTE: I spent more than 5 hours to see how it works details.php and categery.php, but no luck yet

Many thanks in advance,
Cruxy

[thunderstrike]

NOTE: I spent more than 5 hours to see how it works details.php and categery.php, but no luck yet

See member.php file for $HTTP_GET_VARS and $HTTP_POST_VARS . Is big result.

[Sun Zaza]

Hey Thunderstrike. I can not believe it! I get it to work! Thank you very much for your support

[Sun Zaza]

Hi, the first step is done.
Now I need to use the events_hits.

I added the column events_hits (int (10)) to the database and this code to the events.php (before Clickstream ):

Code: [Select]

// Update Events Hits
  $sql = "UPDATE ".EVENTS_TABLE."
          SET events_hits = events_hits + 1
          WHERE events_id = '$events_id'";
  $site_db->query($sql);
 
and this line to functions.php:

Code: [Select]

"events_hits" => $events_row['events_hits'],

and the line to events.html:

Code: [Select]

HITS: {events_hits}
It does not want to work yet!!
Can you see what I need more or what I did wrong?

[Sun Zaza]

I just checked the database and I find that the table is updated. I will try now to show it on the events.html.
I will let you know if does not work!

[thunderstrike]

I will let you know if does not work!

If so, please remember step 6 of my signature.

[Sun Zaza]

Oke I give up! I can not show the {events_hits} value on the events.html.
All what I did you find it in the first post.
Can anyone help?

[thunderstrike]

All what I did you find it in the first post.

Ok so is no problem. 

[Sun Zaza]

I can not show YET the value of {events_hits} on events.html/php.

Can you help

[thunderstrike]

Can you help Sad

No.

[Sun Zaza]

Thank you anyway