|
The Omega
New Member
55 Posts |
 Posted - 22 August 2003 : 02:20:04
|
I have a random number script that has been given to me that uses php/mysql however I would like a asp/accessdb version instead....
could somebody covert this
update.php
<?php
mysql_pconnect("host","user","pass");
mysql_select_db("db");
$values = mysql_query("SELECT * FROM trade WHERE id>0");
while($row = mysql_fetch_array($values))
{
$id = $row[id];
$min = $row[value_min];
$max = $row[value_max];
$inner = mt_rand($min,$max);
$mid = mt_rand($min,$max);
$outer = mt_rand($min,$max);
$sql = "UPDATE trade SET value_inner = '$inner', value_mid = '$mid', value_outer = '$outer' WHERE id = '$id'";
$result = mysql_query($sql) or die(mysql_error());
echo"$row[name]-$inner-$mid-$outer<br>";
}
?>
getmsg.php script
<head><title>TCW - Market Trading Values</title></head>
<?php
mysql_pconnect("host","user","pass");
mysql_select_db("db");
$timeoffset = "5";
$maindate = date("l, F d Y H:i",time() + $timeoffset*3600);
$next = date("l, F d Y",time() + $timeoffset*3600 + 1*24*60*60);
if(!isset($action) || $action == "view")
{
$content .= "<body bgcolor=black><center><img src=img/jedihanger.jpg><br><br></center><table align=center><tr><td align=center width=200 bgcolor=#2d3369>Goods Name</td><td align=center width=200 bgcolor=#2d3369>Inner Core</td><td bgcolor=#2d3369 align=center width=200>Mid Rim</td><td bgcolor=#2d3369 align=center width=150>Outer Rim</td></tr>";
$result = mysql_query("SELECT * FROM trade WHERE id>0");
while($row = mysql_fetch_array($result))
{
$name = $row[name];
$inner = $row[value_inner];
$mid = $row[value_mid];
$outer = $row[value_outer];
$content .= "<tr><td align=center><font color=#FFFFFF>$name</font></td><td align=center><font color=#FFFFFF>$inner</font></td><td align=center><font color=#FFFFFF>$mid</font></td><td align=center><font color=#FFFFFF>$outer</font></td></tr>";
}
$content .= "</table><br><br><center><font color=#FFFFFF>The current server time and date is: <b>$maindate</b><br>The next update is on: <b>$next 00:00</b></center>";
echo($content);
}
?>
db consists of:
id, name, min, max, innervalue, midvalue, outervalue
thanks |
|
Topic Locked
