Hi, I've got a question:
How would I be able to automatically truncate a mysql table at midnight every night? Is this not even possible, or really simple?
Thanks.
Search found 6 matches
- Tue Dec 29, 2009 10:30 am
- Forum: Databases
- Topic: automatically truncate table daily
- Replies: 1
- Views: 560
- Fri Nov 27, 2009 8:24 pm
- Forum: PHP - Code
- Topic: MySql php pageview counter
- Replies: 1
- Views: 92
MySql php pageview counter
<?php $con = mysql_connect("xxxx","xxxx","xxxx"); if (!$con) { die('Could not connect: ' . mysql_error()); } $dbname = 'xxxx'; mysql_select_db($dbname); $result = mysql_query("SELECT * FROM prizes") or die(mysql_error()); echo "<table b...
- Sun Mar 15, 2009 11:48 am
- Forum: PHP - Code
- Topic: Php/MySql error
- Replies: 4
- Views: 202
Re: Php/MySql error
Parse error: syntax error, unexpected T_VARIABLE in /homepages/28/d212747455/htdocs/Sender/contact.php on line 25 <?php //include config file include ('config.php'); //sets date and time variables $last = gmdate("Y-m-d"); $time = gmdate("H:i", time() + $zone); //make the connect...
- Sun Mar 15, 2009 11:36 am
- Forum: PHP - Code
- Topic: Php/MySql error
- Replies: 4
- Views: 202
Php/MySql error
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on line 25 <?php include ('config.php'); //sets date and time variables $last = gmdate("Y-m-d"); $time = gmdate("H:i", time() + $zone); //make the connection to the ...
- Tue Mar 10, 2009 8:35 pm
- Forum: PHP - Code
- Topic: PHP Mail CC
- Replies: 1
- Views: 106
PHP Mail CC
1. <?php 2. $to = "you@yoursite.com"; 3. $subject = "Contact Us"; 4. $email = $_REQUEST['email'] ; 5. $message = $_REQUEST['message'] ; 6. $headers = "From: $email"; 7. $sent = mail($to, $subject, $message, $headers) ; 8. if($sent) 9. {print &...
- Sun Feb 15, 2009 8:42 pm
- Forum: PHP - Code
- Topic: PHP Mail From Name
- Replies: 1
- Views: 110
PHP Mail From Name
I'm using this code in a feedback form on a website: <?php $to = "you@yoursite.com"; $subject = "Contact Us"; $email = $_REQUEST['email'] ; $message = $_REQUEST['message'] ; $headers = "From: $email"; $sent = mail($to, $subject, $message, $headers) ; if($sent) {print &q...