scriptygoddessI use this almost on a daily basis, and yet I can't commit it to memory. So I don't have to go searching for it each time I need to write it…
$databaseName = "YOURDATABASENAME";
$dbconnection = mysql_connect("localhost", "DATABASE-USERNAME", "DATABASE-PASSWORD") or
die ('I can?t connect to the database.');
mysql_select_db($databaseName,$dbconnection);
$value = "SOMEVALUE";
$query = sprintf("SELECT FIELDNAME from TABLENAME where FIELDNAME='%s';", $value);
$result = mysql_query($query);
$totalNum = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
echo $row['FIELDNAME'];
}
////////OR//////
for ($i =0; $i < $totalNum; $i++) {
$row = mysql_fetch_array($result);
echo $row['FIELDNAME'];
}
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
