MySQL –– Returning a value from the database
written by: admin
Date Written: 1/19/08
Last Updated: 3/29/10
The following will assign a value to a variable from the database.
$query = "SELECT field FROM tablename WHERE ID=1";
$result = mysql_query($query) or die ("Couldn't execute query.");
$value = mysql_fetch_array($result,MYSQL_ASSOC);
$value= $value['field'];echo "pop $value pop";
Return the latest value from the database
$query = "SELECT date FROM attendance ORDER BY date DESC LIMIT 1";
$result = mysql_query($query) or die ("Couldn't execute query.");
$value = mysql_fetch_array($result,MYSQL_ASSOC);
$value= $value['field'];echo "pop $value pop";
Get the latest 3 results from a table
<?php
$conn=mysql_connect("host", "username", "password");
mysql_select_db("database_name",$conn) or die("Unable to select database");
$query = "SELECT ID FROM maincontent ORDER BY ID desc limit 0,3";
$result = mysql_query($query,$conn) or die ("Couldn't execute query.");
while ($list_info = mysql_fetch_array($result,MYSQL_ASSOC)) {
$tadaa= $list_info['ID'];$me.="pop $tadaa pop<br>";}
echo "$me";
?>
TAGS: mysql