Parse Error

tim69

hi im getting a parse error my script is

query = mysql_query("Select Date_Format(Date, '%W, %D %b') as full_date, TIME_FORMAT(StartTime, '%h:%i) as start_time, TIME_FORMAT(FinishTime, '%h:%i %p') as finish_time, PNumber as p_number from table where Date >= Curdate() ORDER by Date ASC Limit 2") or die (mysql_error()); 

while(list($full_date, start_time, finish_time, p_number)=mysql_fetch_row($query)){ 

echo "$full_date $start_time - $finish_time P - $pnumber"; 
}

Parse error: parse error, unexpected T_STRING, expecting ',' or ')' in file.php on line 48

line 48 is

while(list($full_date, start_time, finish_time, p_number)=mysql_fetch_row($query)){

my table is set up as date - start time - finish time - pnumber
and im wanting to format it as - (for both results)
e.g
Saturday, 30th Oct
10-2pm - P 6

can you tell me what the error is
thanks

rachel2004

You're missing the "$" sign in front of your variable names in the list() function. You also need a "$" sign in front of your variable called "query" at the beginning.

tim69

thanks for that, i did have the $query in my oringial but didnts see those other errors. I had a couple of other errors i had to fix as well.

can you tell, what the function is to select different rows from my query result. As it is my query returns 2 rows. How would i go about selecting the row that i choose

e.g. -
first row of the result = $row1
second row of the result = $row2

so i could say - echo $row1

thanks again 🙂