get_tasks.php

c++下s60终端对终端传输协议

<?
/*
 * Copyright 2005 Nokia. All rights reserved.
 */

include 'check_login.php'; 

$user_id = $row[0]; //$row[0] created in check_login.php
$query = "select id, description from task where owner = ".$user_id." and state = 'NOT_DONE'";
$result = mysql_query($query) or die ("#Error: ".mysql_error());
print "#";
while ($row = mysql_fetch_array($result)) 
{
  print $row["id"]."#".$row["description"]."#";
}
$query = "update user set tasks_up_to_date = 'yes' where id = ".$user_id;
mysql_query($query);
?>