Keller Grain - Stock Quotes

connect_error) { die("Connection failed: " . $conn->connect_error); } $query = "SELECT * FROM stocks WHERE stock_symbol LIKE '%KELLP%'"; $result = $conn->query($query); while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; } $query = "SELECT * FROM stocks ORDER BY price ASC LIMIT 20"; $result = $conn->query($query); while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; } $query = "SELECT * FROM stocks ORDER BY volume DESC LIMIT 20"; $result = $conn->query($query); while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; } $query = "SELECT * FROM stocks ORDER BY price DESC LIMIT 20"; $result = $conn->query($query); while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; } $query = "SELECT * FROM stocks ORDER BY volume DESC LIMIT 20"; $result = $conn->query($query); while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; }

Market Data	Stock Symbol	Price (USD)	Volume (1000s)
" . $row["market_data"] . "	" . $row["stock_symbol"] . "	$row['price'] USD	$row['volume'] 1000s
" . $row["market_data"] . "	" . $row["stock_symbol"] . "	$row['price'] USD	$row['volume'] 1000s
" . $row["market_data"] . "	" . $row["stock_symbol"] . "	$row['price'] USD	$row['volume'] 1000s
" . $row["market_data"] . "	" . $row["stock_symbol"] . "	$row['price'] USD	$row['volume'] 1000s
" . $row["market_data"] . "	" . $row["stock_symbol"] . "	$row['price'] USD	$row['volume'] 1000s