Using javascript values in mysql query

[gin0115]

I am having trouble getting the values generated by a javascript date display into a mysql query.

so far i have got this

javascript :
<script language="JavaScript">
var weekday=new Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
months = new Array("January","February","March","April","May","June","July","August","September","October","November","December");
suffixArray = new Array("th","st","nd","rd","th","th","th","th","th","th");
var time=new Date();
var lmonth=months[time.getMonth()];
var date=time.getDate();
var year=time.getYear();

n_string = date+"";
if (date >= 11 && date <= 13)
{
suffix = "th";
} else {
suffix = suffixArray[n_string.substring(n_string.length,n_string.length-1)];
}
</script>

Query :
$query = "SELECT id, venue, band1, band2, band3, band4, band5, cost, time FROM guests WHERE day=getDay() AND month=getMonth() AND year=getYear()";
$result = mysql_query($query);

I had this working at one point but cant figure out why it stoped the javascript works as far as i can tell it will display with

<script type="text/javascript">
document.write(weekday[time.getDay()]);
document.write("&nbsp;" +date + suffix + "&nbsp;" + lmonth + "&nbsp;" + year);
</script>

can any one help Please!

Glynn

[ReveL]

it is really hard to mix javascript and php values.

PHP is done on the server, javascript is done in the webbrowser.

The only thing you could do is having javascript make a request to a webserver and then putting the values in php/mysql.

But probably you don't need that, do you?