switch($_GET["function"]){
case "view_shares":
$StockQ = mysql_query("SELECT id, price, open_price, name FROM stock_market ORDER by name") or print(mysql_error() . " " . __FILE__ . " #" . __LINE__);
?>
break;
case "view_records";
$Query = mysql_query("SELECT (SELECT name FROM stock_market WHERE id = stock_id) as stock_name, price, DATE_FORMAT(thetime, '%d/%c/%Y %r') as f_thetime FROM `stock_market_records`") or print(mysql_error() . " " . __FILE__ . " #" . __LINE__);
?>
Stock
Price
Time
while($Row = mysql_fetch_array($Query)){
?>
=$Row['stock_name'];?>
=format($Row['price']);?> KD
=$Row['f_thetime'];?>
}
?>
break;
case "buy";
$VI = mysql_query("SELECT id, name, price FROM stock_market WHERE name = '{$get_safe['item']}'") or print(mysql_error() . " " . __FILE__ . " #" . __LINE__);
if(mysql_num_rows($VI) > 0){
?>
Stock:
=mysql_result($VI, 0, "name");?>
Number:
}
break;
case "view_stock";
$MyStQ = mysql_query("SELECT * from stock_info where owner = '{$CharacterInfo['id']}'") or print(mysql_error() . " " . __FILE__ . " #" . __LINE__);
$total_price = 0;
$total_market_value = 0;
$total_owned = 0;
?>