3 replies to this topic

[empty_kinse]

For an online reservation, any tips on making a query to delete the reservation if it isn't confirmed like 10 days before the event?
Anyone can tell me how to enhance this one?

<?php

$dbhost = 'sql204.p4o.net';

$dbuser = '';

$dbpass = '';

$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if(! $conn )

{

die('Could not connect: ' . mysql_error());

}

$sql = 'DELETE FROM orders WHERE 'date' <= CURDATE()-5";


mysql_select_db('somedatabasehere');

$retval = mysql_query( $sql, $conn );

if(! $retval )

{

die('Could not delete data: ' . mysql_error());

}

echo "Deleted data successfully\n";

mysql_close($conn);

?>

[Orjan]

(untested) this should work...

DELETE FROM orders WHERE datediff(now(), `date`) > 10

[empty_kinse]

Thanks a lot for the help Orjan.

Say, how can I make an output of a pie chart or any kind of chart showing the statistics of what item is the most ordered and/or the least ordered one..?Any idea?

[Orjan]

easiest way would be to use google chart api, Google Chart Tools / Image Charts (aka Chart API) - Google Code