|
$bit = query("SELECT *, rand() as rand FROM tigsm_yes.tigbits WHERE TypeID = 1 AND flActive = 1 ORDER BY rand LIMIT 1");
?>
=$bit[Bit]?>
$link = mysql_connect('localhost','web','ratpow');
$myquery1 = "select webcounter from tigsm_yes.seqcounter WHERE pagename = 'home'";
$result1 = mysql_query($myquery1);
while($row1 = mysql_fetch_array($result1))
{
$numcount = $row1{'webcounter'};
}
$myq = "UPDATE tigsm_yes.seqcounter SET webcounter=LAST_INSERT_ID(webcounter+1) WHERE pagename = 'home';";
$result2 = mysql_query($myq);
$now1 = date("Y-m-d H:i:s");
$myq1 = "INSERT INTO tigsm_yes.userinfo(pagename,remoteaddr,remotehost, remoteport, remoteuser, browser, visittime) VALUES ('home','".$REMOTE_ADDR."','".$REMOTE_HOST."','".$REMOTE_PORT."','".$REMOTE_USER."','".$HTTP_USER_AGENT."','".$now1."');";
$result3 = mysql_query($myq1);
mysql_close($link);
?>
How does Technology impact you Please fill out the Survey To understand you better
|