Glendenning Grain - Stock Quotes

connect_error) { die("Connection failed: " . $conn->connect_error); } $query = "SELECT symbol, current_price FROM stocks WHERE active=1"; $result = $conn->query($query); while ($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } $conn->close(); ?>

Symbol	Current Price ($)	Open	High	Low	Close	Volume
" . $row["symbol"] . "	" . number_format($row["current_price"], 2) . "	" . number_format($row["open"], 2) . "	" . number_format($row["high"], 2) . "	" . number_format($row["low"], 2) . "	" . number_format($row["close"], 2) . "	" . $row["volume"] . "