Search found 6 matches

by aalbright
Tue Dec 29, 2009 10:30 am
Forum: Databases
Topic: automatically truncate table daily
Replies: 1
Views: 560

automatically truncate table daily

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.
by aalbright
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...
by aalbright
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...
by aalbright
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 ...
by aalbright
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 &...
by aalbright
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...