Write a php function that logs user activities

[nma]

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("INSER T INTO LogsTableMainsc reen (page, action, userID, type, date) VALUES ('mainscreen', '$action', " . $_SESSION['user']->userID . ", 'drop list', getDate())");
}
?>
[/PHP] [PHP].....
....
log("genre");
.....
[/PHP]Thanks

[ronverdonk]

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

[nma]

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

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.locati on='/moviebrowser/MB2mainscreen.p hp?director='+d ocument.categor ies.director.va lue+'&genre='+d ocument.categor ies.genre.value ;
if (genre = ????)
{
logMainscreen(' genre droplist');
}
else
{
logMainscreen(' director droplist');
}

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

[/HTML]

[PHP]
<td width="100" align="left"><s elect onchange="selec tMovies()" name="genre" >
<option value="all">ALL </option>
<?php
foreach($genres as $genre){
$selected = ($_GET['genre'] == $genre->genreID)?'sele cted="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="selec tMovies()" name="director" ;>

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

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

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

?>
</select>
</td>

[/PHP]