Linux, Apache, MySQL, PHP

$query="SHOW TABLES";
$Results=mysql_query($query);
if (!$Results) die("DB Error in GetTableNames ($query)".mysql_error());
$res=array();
while($row=mysql_fetch_array($Results)) $res[]=$row[0];

$query="SELECT field0,field1 FROM table";
$Results=mysql_query($query);
$res=array();
while($row=mysql_fetch_array($Results)) $res[$row[0]]=$row[1];

// note: $connection is an open mysql connection
$table = array();
$query = "SELECT * FROM my_table";
$result = mysql_query($query, $connection) or die(mysql_error($connection));
while ($record = mysql_fetch_assoc($result))
{
	$table[] = $record;
}
// the result
// $table[0] = array("name" => "John Smith", "bdayMonth" => 12, "bdayDay" => 8)
// $table[1] = array("name" => "Jane Doe",   "bdayMonth" => 12, "bdayDay" => 8)
// .
// .
// .

<?php
	$dbh = mysql_connect("host","user","password") or die("Can not connect to db.");
	mysql_select_db("your_db_name");
	
	$i = 1;
	$sql = "select name, dept_id, pay_grade from employees";
	$rst = mysql_query($sql) or die("PG: ".__FILE__." ON LINE: ".__LINE__." ERROR: ".mysql_error());
	if(mysql_num_rows($rst)>0)
	{
		echo "<table><tr><th>#</th><th>NAME</th><th><DEPT</th><th>GRADE</th></tr>";
		while($row = mysql_fetch_assoc($rst))
		{
			echo "<tr><td>".$i."</td><td>".$row['name']."</td><td>".$row['dept_id']."</td><td>".$row['pay_grade']."</td></tr>";
			$i++;
		}
		echo "</table>";
	}
	else
	{
	echo "No Results.";
	}
?>

<?php
	$dbh = mysql_connect("host","user","password") or die("Can not connect to db.");
	mysql_select_db("your_db_name");
	
	$results = array();	
	$sql = "select name, dept_id, pay_grade from employee";
	$rst = mysql_query($sql) or die("PG: ".__FILE__." ON LINE: ".__LINE__." ERROR: ".mysql_error());
	if(mysql_num_rows($rst)>0)
	{		
		while($row = mysql_fetch_assoc($rst))
		{
			$results[$row['name']] = array($row['dept_id'],$row['pay_grade']);
		}		
	}
	else
	{
		echo "No Results.";
	}
	
	echo "<pre>";
	print_r($results);
	echo "</pre>";
?>

echo "<pre>";
print_r($array_var);
echo "</pre>";

komanche wrote:

$make = "SELECT make FROM cars WHERE make='".$q."' ORDER BY make";
$make = "SELECT id,value FROM make ORDER BY id";

<br />
$dbResID = mysql_query ( $make, $access);<br />
if(mysql_errno($access)>0)die("the following sql: $make<br /> produced an error:<br />".mysql_error($access)."<br />");<br />

<br />
echo'<select name="cars">';<br />
while ( $row = mysql_fetch_row($dbResID) )<br />
print "<option value=\"$row[0]\">$row[1]</option>\n";<br />
echo'</select>';<br />

min=-99999; // the smallest number possible
max=+99999; // the largest number possible
minLine="";
maxLine="";
foreach(line in file) {
    split the line by its colon
    convert the second part to a number, and store in val
    if (val < min) { min=val; minLine=line;}
    if (val > max) { max=val; maxLine=line;}
}
// now the results are in min, max, minLine, maxLine

header("Location: error.php", 404);