It seems to be a slow night here so I will try my luck once again.
I wrote a cron tab that update an external text file (don't ask me why) and I would like the same cron to update a MySql database. How can I pass the array?
This works believe it or not, but it does not do what I need it to do. This script only places all of the same contents that would go into the text file into a single field of the MySql database. I need to be able to let a user know if they have been selected by posting a graphic in the main page. I tried winit like '%$uid%' and everybody was a winner. I need to pass the array to make this work.
<?
$today = date("F j, Y, g:i a");
include ("config.inc.php");
ob_start($blue);
$sql = "select distinct * from vipcustomer order by Rand() limit 12";
$namo = mysql_query($sql);
$r = mysql_fetch_array($namo);
do{
printf("<center><font face=\"Arial\" size=\"2\"><b>%s %s - %s</b></font></center>\n", $r["first_name"], $r["last_name"], $r["custid"]);
} while ($r = mysql_fetch_array($namo));
echo $today;
$string = ob_get_contents($blue);
$filename ="win.txt";
$handle= fopen($filename,'w');
fputs($handle, $string);
fclose($handle);
$killit = "DELETE FROM vipwin";
$result = mysql_query($killit);
$winsome = "INSERT INTO vipwin (custid,winit,win_time) VALUES ('$a','$string','$today')";
$result = mysql_query($winsome);
?>
Thank You!
