Write a php function that logs user activities

Hi
Can someone help me in writing this function? I want to log user action and store it in the database
[PHP]
<?php
function log(_action) {
include_once('../ez_sql.php');
$db->query("INSERT INTO LogsTableMainscreen (page, action, userID, type, date) VALUES ('mainscreen', '$action', " . $_SESSION['user']->userID . ", 'drop list', getDate())");
}
?>
[/PHP] [PHP].....
....
log("genre");
.....
[/PHP]Thanks

re: Write a php function that logs user activities

Please remember to provide a meaningful Title for any threads started (see the FAQ entry Use a Good Thread Title).

This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR

re: Write a php function that logs user activities

thanks

Could someone help me how should I write this line?
if (genre = ????) in line 4

Please ignore my initial post above.


[HTML]

function selectMovies()
{
document.location='/moviebrowser/MB2mainscreen.php?director='+document.categories.d irector.value+'&genre='+document.categories.genre. value;
if (genre = ????)
{
logMainscreen('genre droplist');
}
else
{
logMainscreen('director droplist');
}

}
.....
....
function logMainscreen(_action) {
$.get("/moviebrowser/logMainscreen.php", {
page: "MB2mainscreen",
action: _action,
userID: "<?php echo $_SESSION['user']->userID?>",
type: "drop list"
});
}

[/HTML]

[PHP]
<td width="100" align="left"><select onchange="selectMovies()" name="genre" >
<option value="all">ALL</option>
<?php
foreach($genres as $genre){
$selected = ($_GET['genre'] == $genre->genreID)?'selected="true"':'';
echo '<option value="' . $genre->genreID . '" ' . $selected . '>' . $genre->genreName . '</option>';
}

?>
</select>
</td>

<td align="right"><img src="director-label.jpg" width="61" height="13" hspace="10" /></td>
<td>
<td width="100" align="left">
<select onChange="selectMovies()" name="director" ;>

<option value="all">ALL</option>
<?php

foreach($directors as $director){
$selected = ($_GET['director'] == $director->directorID)?'selected="true"':'';

echo '<option value="' . $director->directorID . '" ' . $selected . '>' . $director->directorName . '</option>';
}

?>
</select>
</td>

[/PHP]