Linux, Apache, MySQL, PHP

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);

header("HTTP/1.1 200 OK");
header("HTTP/1.1 404 Not Found");

<?php
echo "<pre>";
print_r($_POST);
echo "</pre>";
?>

<?php
// this is very basic and I am not doing a lot of checks.
// I also split my real files up and rarely place this all in one file, but this is just for show anyways.

$dbh = mysql_connect("","",""); //<-- fill in your connection strings...
mysql_select_db(""); //<-- database_name_here

$sql = "select name, phone1 from contacts"; // <-- sample sql
$rst - mysql_query($sql) or die(mysql(error());
if(mysql_num_rows($rst)>0)
{
   $i=0;
   echo "<table class='contact_list'>\n";
   echo "<tr><th>NAME</th><th>PHONE #</th></tr>\n";
   while($row = mysql_fetch_assoc($rst))
   {
      $bgcolor = "#fff;";
      if($i%2) $bgcolor = "#ddf;";
      echo "<tr style='background-color:".$bgcolor."'><td>".$row['name']."</td><td>".$row['phone1']."</td></tr>";
   }
   echo "</table>\n";
}
else
{
   echo "<p class='notice'>No records founds.</p>\n";
}
?>

<?php
include('config.php');
include('format.php');
//bunch of other stuff
//then something like
basic("Portland","Collection");
//basic holds the "function" that displays the table in the proper format based on those two variables.
?>