PHP - Creating Master-detail Page Using Php

Hi,

I am stuck. I have used dreamweaver to create a master details page with links to the details page successfully, but I would like to display the master details page results in 3 columns rather than the 1 column that dreamweaver defaults. As the site becomes richer the content will increase yielding many results, therfore the content displayed in a single column will require the users to scroll way down the page.

So, as it is now the results display as follows:

Plant1
Plant2
Plant3
Plant4
Plant5
Plant6
Plant7
Plant8
Plant9
etc...

I would like them to display as follows:
Plant1        Plant4        Plant7
Plant2        Plant5        Plant8
Plant3        Plant6        Plant9

Here is my code thus far:
<?php require_once('Connections/connGND.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_connGND, $connGND);
$query_rsBotanicalA = "SELECT * FROM plants WHERE CatIDB = 'A'";
$rsBotanicalA = mysql_query($query_rsBotanicalA, $connGND) or die(mysql_error());
$row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA);
$totalRows_rsBotanicalA = mysql_num_rows($rsBotanicalA);
?>
<table border="0" align="left">
  <?php do { ?>
    <tr>
      <td align="left"><a href="plantdetails.php?recordID=<?php echo $row_rsBotanicalA['PlantID']; ?>"> <?php echo $row_rsBotanicalA['BotanicalName']; ?>&nbsp; </a></td>
    </tr>
    <?php } while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA)); ?>
</table>

Could someone help me to write this code, as I have been unsuccessful maintaining the links. I have been able get the results to display in the columsn as I would like, but I haven't been able to figure it out while maintaining the links!

Thanks.

Hi,

I have successfully implemented a master details page with the results aligned in columns linking to a details page.
I wish to maintain the recordID passed from the master details page and make the dynamic text, which reads
Shade
A tree that is capable of.....
in the attached screen shot a link to another details page referencing the same recordID.

The detailspage2.php would look the same as the screenshot except the Shade text and description below will be highlighted, which I can do, there will be a new image and a new image description.  All other dynmaic elements on the page will remain the same.

I tried to simply save as my detailspage.php to detailspage2.php and create a link to detailspage2.php. It linked to detailspage2.php but none of the record info showed up in their respective table cells.

I have all the names desc's, images, etc setup in a table in my database.

Please let me know what code and other info you need to help me out with this procedure.

Thanks.

 

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

php can detect "mac address", "ip address", "browser agent", "cookie" and "hostname". What else php can detect?

I am an extremly novice at this php stuff. I have a file that displays a vehicle listing based on a xml feed. I am trying to add a link to another detail page by clicking on the words Full Detail (bolded below in the code) and send me to another page (index.php?option=com_content&view=article&id=6 (joomla)), the item detail page is based on the vehicle id and has the vehicle details show up. the detail page is also a xml file with the item info. I assume I have to use the <a href.... but how do I add the Id of the vehicle. Do I use a .($_Get['vehicleid']).

Follow me?

Partial Listing of Vehciles

Code: [Select]
$doc = new DOMDocument();
$doc->loadXML($output);
$vehicles = $doc->getElementsByTagName("vehicle");
//print_r($xmlarray);
$results = print_r($xmlarray, true);
echo $results;
foreach ($vehicles as $vehicle) {

    $vehicleIDs = $vehicle->getElementsByTagName("vehicleID");
    $vehicleID = $vehicleIDs->item(0)->nodeValue;
    $years = $vehicle->getElementsByTagName("year");
    $year = $years->item(0)->nodeValue;
    $makes = $vehicle->getElementsByTagName("make");
    $make = $makes->item(0)->nodeValue;
    $models = $vehicle->getElementsByTagName("model");
    $model = $models->item(0)->nodeValue;
    $prices = $vehicle->getElementsByTagName("price");
    $price = $prices->item(0)->nodeValue;
    $modelExts = $vehicle->getElementsByTagName("modelExt");
    $modelExt = $modelExts->item(0)->nodeValue;
    $conditions = $vehicle->getElementsByTagName("condition");
    $condition = $conditions->item(0)->nodeValue;
    $auxPhotoss = $vehicle->getElementsByTagName("auxPhotos");
    $auxPhotos = $auxPhotoss->item(0)->nodeValue;
    $transmissions = $vehicle->getElementsByTagName("transmission");
    $transmission = $transmissions->item(0)->nodeValue;
    $cylinderss = $vehicle->getElementsByTagName("cylinders");
    $cylinders = $cylinderss->item(0)->nodeValue;
    $fueltypes = $vehicle->getElementsByTagName("fueltype");
    $fueltype = $fueltypes->item(0)->nodeValue;
    $doorss = $vehicle->getElementsByTagName("doors");
    $doors = $doorss->item(0)->nodeValue;
    $financings = $vehicle->getElementsByTagName("financing");
    $financing = $financings->item(0)->nodeValue;
    $paymentFrequencys = $vehicle->getElementsByTagName("paymentFrequency");
    $paymentFrequency = $paymentFrequencys->item(0)->nodeValue;
    $kilometerss = $vehicle->getElementsByTagName("kilometers");
    $kilometers = $kilometerss->item(0)->nodeValue;
    $imgSrcs = $vehicle->getElementsByTagName("imgSrc");
    $imgSrc = $imgSrcs->item(0)->nodeValue;
    $formattedprice = sprintf("%01.2f", $price);
    $price_currency = number_format($price, 2, ".", ",");
    if ($price_currency == 0) {
        $price_currency = "CONTACT DEALER";
    }

    $featuress = $vehicle->getElementsByTagName("features");
    $features = $featuress->item(0)->childNodes;
    $featureCount = $features->length;
    $i = 0;
    $featurestring = "";
    while ($i < $featureCount) {
        $i++;
        $featureA[$i] = $features->item($i - 1)->nodeValue;
        $featurestring .= ($i % 2 == 0 ? $featureA[$i] . ", " : "");
    }
   
echo "<table style=background-color: rgb(246, 246, 246)text-align: left width: 900px height: 100px\n";
echo "    border=0 cellpadding=2 cellspacing=2>\n";
echo "    <tbody>\n";
echo "    <tr>\n";
echo "    <td\n";
echo "    style=background-color: black font-family: Helvetica,Arial,sans-serif><small><span\n";
echo "    style=color: yellow><span style=font-weight: bold>Vehicle ID:</span>\n";
echo "    $vehicleID</span></small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 147px><small>Year:\n";
echo "    $year</small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 109px><small>Make:\n";
echo "    $make</small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 141px><small>Model:\n";
echo "    $model</small></td>\n";
echo "    <td\n";
echo "    style=background-color: black font-family: Helvetica,Arial,sans-serif width: 147px><small><span\n";
echo "    style=color: rgb(255, 204, 0) font-weight: bold>Price: $\n";
echo "    $price_currency</span></small></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "    <td colspan=1 rowspan=3><small><span\n";
echo "    style=font-family: Helvetica,Arial,sans-serif><img src=$imgSrc></span></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Condition:\n";
echo "    $condition</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small></small></td>\n";
echo "    </tr>\n";
echo "    <tr width=147\n";
echo "    style=font-family: Helvetica,Arial,sans-serif>\n";
echo "    <small></small><td\n";
echo "    style=background-color: black width: 147px colspan=4 \n";
echo "    rowspan=1><span style=color: rgb(255, 204, 0)><a href=\"http://heavyequipmentwantedads.com/icardemo/inventory/getitems.php?&$vehicleID\" title=\"Full Details (View)\" target=\"_new\">Full Details (View)</a></span></td>\n";
echo "  <small></small></tr>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Transmission\n";
echo "    : $transmission</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small>Doors:\n";
echo "    $doors</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small>FuelType: $fueltype</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>KM:\n";
echo "    $kilometers</small></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "    <td style=background-color: rgb(204, 204, 204)><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Cylinders:\n";
echo "    $cylinders</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small>Features: $featurestring</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small></small></td>\n";
echo "    </tr>\n";
echo "    </tbody>\n";
echo "    </table>\n";

Partial listing of items:

Code: [Select]
<?php
$xmldata ='<dealerAccount>
<accountNum>xxxxxx</accountNum>
<dealerPwd>xxxxxxxxx</dealerPwd>
<data>item</data>
<vehicleID>'.$vehicleID.'</vehicleID>
</dealerAccount>';
$URL = "http://www.wheelsonline.ca/api/";
 
$ch = curl_init($URL);
//curl_setopt($ch, CURLOPT_MUTE, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
curl_setopt($ch, CURLOPT_POSTFIELDS, "$xmldata");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
curl_close($ch);

$doc=new DOMDocument();
$doc->loadXML($output);
$items=$doc->getElementsByTagName("item");
$results = print_r($xmlarray, true);
echo $results;

?>

Hi all expert. I am a newbie in this PHP programming. I need your help or advise on the PHP. And question is, I have a list of data and the details are as below: ID  BILLNO   DATE        AMOUNT   ITEM   DESCRIPTION   QTY   UPRICE
1   IV001   01/01/2015   100.00   A1     Balloon        1    30.00
2   IV001   01/01/2015   100.00   A2         Bag        2    20.00
3   IV001   01/01/2015   100.00   A3         Pen        3    10.00
4   IV002   02/01/2015    20.00   A3         Pen        2    10.00
5   IV003   02/01/2015    50.00   A1     Balloon        1    30.00
6   IV003   02/01/2015    50.00   A2         Bag        1    20.00     How can I make the output in xml by using PHP to output as below: <RECORD>
  <HEADER BILLNO="IV001" DATE="01/01/2015" AMOUNT="100.00>
    <DETAIL ITEM="A1" DESCRIPTION="Balloon" QTY="1" UPRICE="30.00">
    </DETAIL>
    <DETAIL ITEM="A2" DESCRIPTION="Bag" QTY="2" UPRICE="20.00">
    </DETAIL>
    <DETAIL ITEM="A3" DESCRIPTION="Pen" QTY="3" UPRICE="10.00">
    </DETAIL>
  </HEADER>
  <HEADER BILLNO="IV002" DATE="02/01/2015" AMOUNT="20.00>
    <DETAIL ITEM="A3" DESCRIPTION="Balloon" QTY="2" UPRICE="10.00">
    </DETAIL>
  </HEADER>
</RECORD>     Your feedback is highly appreciated. Thank you.

This is my code is display my database (member_details) after user sign up but when a user register first name = <script>window.location="google.com"</script>  This error occur=(The requested URL /yy2/html/google.com was not found on this server)

Code: [Select]
<?php
  session_start();
  include ('includes/database_connection.inc.php');
$conn = connectDatabase();

  if($_SESSION['uid'] == ''){
    // redirect unauthenticate user to login page.
  header('Location: login.php');
  }

  if($_GET['task'] == 'delete' && $_GET['id'] != ''){
      // delete function here
     $sql="DELETE FROM Newest Where ID='".mysql_real_escape_string($_GET['id'])."'";
     
     mysql_query($sql,$conn);
     header('Location: member_list.php');
  }

  if($_POST['Logout']){
     session_destroy();
   header('Location: login.php');
}

?>

<html><head><title>Member Details</title>
</head>
<body>
<div style=" margin: 350px ">
<?php 


      $sql="SELECT * FROM Newest";
      $rs = mysql_query($sql,$conn)
        or die( mysql_error() );

   
   $list = "<table border=\"1\" cellpadding= \"2\">";
   $list .= "<tr><th>First Name</th>";
   $list .="<th>Last Name</th>";
   $list .= "<th>User Name</th>";
   $list .= "<th>Email</th>";
   $list .= "<th>Edit User</th>";
   $list .= "<th>Delete User</th>";
    $list .= "<th>Change Password</th>";
   

While( $row = mysql_fetch_array($rs) ) {
   
    $list .= "<tr>";
    $list .= "<td>".$row["name"]."</td>";
     $list .= "<td>".$row["last"]."</td>";
    $list .= "<td>".$row["user"]."</td>";
    $list .= "<td>".$row["email"]."</td>";
    $list .= "<td><a href='member_details.php?id=".$row['ID']."'>Edit</a></td>";
    $list .= "<td><a onclick='return confirm(\"Are you sure to delete ".$row["name"]." \")' href='member_list.php?id=".$row["ID"]."&task=delete'>Delete</a></td>";
     $list .= "<td><a  href='Password.php?id=".$row['ID']."'>Click Here</a></td>
     </tr>";
   
} 
   $list .= "</table>";
   echo ( $list );
   
?>
   <form method="post" action="member_list.php"><br>
   <div style="margin : 0px 600px">
   <style type="text/css">
body {background:#F5F5F5 url('http://images.apple.com/downloads/dashboard/travel/images/traveltodolist_20070724165034.jpg') no-repeat top;;
     
       }</style>
   
         
         <input type="submit" name="Logout" value="logout" />
         
      </form>
</body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.

I have set up a database using myPHPadmin,

I have created the following code:
Code: [Select]
<?php

session_start();

$username = $_POST['username'];
$password = $_POST['password'];

if ($username&&$password)
{
   $connect = mysql_connect("127.0.0.1","root","password") or die("Couldnt connect to database");
   mysql_select_db("login") or die ("Couldnt find database");
   
   $query = mysql_query("SELECT * FROM users WHERE username ='$username'");
   
   $numrows = mysql_num_rows ($query);
   
   if($rumrows != 0)
   
   {
      
   while ($row = mysql_fetch_assoc($query))
   {
      $dbusername = $row['username'];
      $dbpassword = $row['password'];
      
   }
   
   if ($username==$dbusername&&$password==$dbpassword)
     {
           echo "Login successful. <a href='members.php'> Click here to enter memebers area </a>";
        $_SESSION['username']=$dbusername;
     }
     else
           echo "Incorrect password";
   }
   else 
         die ("Username does not exist");
   }
   else
   die ("Please enter a username and password"); 
   

?>   
Even though the database is set up when i try and enter the username for the log in page and password, it says the username does not exist? I dont understand why when it is in the database?
Please help!

MOD EDIT: [code] . . . [/code] BBCode tags added.

I am using the code below for my webpage. When no or non existant querystring is passed the user is directed to the homepage. 

I want to change this so that if a user goes uses an invalid query string (?page=oldcontent) they are directed to a 'not found page'. Can this be done with the way I hae set this up?


switch ($page) {

case 'about':
include 'about.php';
break;

case 'contact':
include 'contact.php';
break;


default:
include 'homepage.php';
}

i have a mysql db, i have a form that i use to post data to db.
i would like to have visitors to my site be able to post to db as well, but they would have to be registered and have their own profile. when logged in they could see and edit their own space and content that they posted to mysql.

how would i go about creating something like this? can someone point me in the right direction ? thank you.

Hi

Does anyone know any good tutorials for creating a registration page for a website?

Thanks in advance.

So, I'm designing a website (who isn't?) and I created the basic framework for a users page from a tutorial I found. Using some previous knowledge I managed to make it display a few custom fields that are defined by the user. Everything works fine as is, but now I want to do a few things to it that I have not the slightest clue how to even begin...

Here is my user page code so far... and oh yes I'm using WordPress which is why I made it check manually for page status in my Page.php file.

<?php
if ( is_page('Users'))
{

echo "<ul id=\"UsersList\">";

/*
First we set how we'll want to sort the user list. You could sort them by:
------------------------
* ID - User ID number.
* user_login - User Login name.
* user_nicename - User Nice name ( nice version of login name ).
* user_email - User Email Address.
* user_url - User Website URL.
* user_registered - User Registration date.
*/
$szSort = "user_nicename";
/*
Now we build the custom query to get the ID of the users.
*/
$aUsersID = $wpdb->get_col( $wpdb->prepare("SELECT $wpdb->users.ID FROM $wpdb->users ORDER BY %s ASC", $szSort ));
/*
Once we have the IDs we loop through them with a Foreach statement.
*/

foreach ( $aUsersID as $iUserID ) :

/*
We use get_userdata() function with each ID.
*/

$user = get_userdata( $iUserID );


/*
Here we finally print the details wanted.
Check the description of the database tables linked above to see
all the fields you can retrieve.

To echo a property simply call it with $user->name_of_the_column.
*/

if($user->user_login != "Unknown") // don't show the placeholder for [unknown] author

{
echo '<a href="">' . get_avatar( $iUserID, $size = '45', $border='0') . '</a>';
echo '<li>' . ucwords( strtolower(  $user->user_login ) ) . '</li>';

if($user->favorite_player != "")
{
echo '<li>' . $user->favorite_player . '</li>';
}
if($user->player_name != "")
{
echo '<li>' . $user->player_name . '</li>';
}
}
/*
     The strtolower and ucwords part is to be sure
     the full names will all be capitalized.
*/

endforeach; // end the users loop.

echo "</ul>";
};
?>


Problem one: This does NOT sort my name, despite the tutorial's insistence that it will. I have not even a guess as to why this is.

Problem two: I would like to either sort this list into two columns or paginate it or both but I am not sure how to do either.

Problem three: I want to insert some static text between the echo '<li>'  and the  . $user->player_name . '</li>'; so that it reads:

o Player Name: USER'S VARIABLE ' PLAYER NAME' HERE

Yes that 'o' is supposed to be the list item dot. I know how strings work, I just can't get my attempts to work out syntax-wise.

Any help would be greatly appreciated! Tutorials, answers, suggestions, examples, anything. The extent of my previous coding knowledge is several years of UnrealScript, so you can see why this simple thing is baffling me. Frankly I'm surprised this much of it works.

I've been following http://nvie.com/post...branching-model, which recommends master, release, and develop branches, in addition to hotfix and feature branches. Since I work with another developer only, we did not use release branches as staging area but used everything else.   Well, to ease on merges, the new idea is as such:  use only master branch, and get rid of all others.  Feature and hotfix branches can branch off of master and be merged back into master.  So in short, only have one main branch called master, and remove the develop branch.   Since we have {local, develop, production} servers, this will not impact actual development and testing. Removing 'develop' branch will however remove that "extra" intermediate step between the master branch and feature branches   Do you see any problems with this?  Or it's "to each his own, however you want to use git, use it" type thing?

I need to configure my SMTP mail port so I can use mail() function to send out e-mails.  However, I am confused as to which php.ini to configure.  I see four files when I do a search under C:\WAMP\
php.ini (C:\wamp\bin\apache\Apache2.2.11\bin)
php.ini (C:\wamp\bin\php\php5.3.0)
php.ini-development (C:\wamp\bin\php\php5.3.0)
php.ini-production (C:\wamp\bin\php\php5.3.0)

Thanks

OK, here it is.  I have been trying to do this myself, but it has been driving me insane and I turn to professionals here for help.   I am a basic web developer for a company that I work for in other capacities. I have a reasonable understanding of HTML and that is about where my expertise ends. I am not typically a programmer, just a simple (extremely) part time designer that uses Muse and Dreamweaver when necessary.   However, recently my company has asked me to accomplish a task for their website. In plain English, they want a large database that exists currently as a CVS file made into a searchable web page.  It is 21 columns by approximately 6,700 rows.   To explain what I need a little more technically, here are my ideas and where I have gotten to so far:   1. The company uses godaddy, into which I *believe* I have successfully imported the spreadsheet. I believe it is successful because through godaddy's SQL Control Panel (phpMyAdmin console), I can do the EXACT searches that the company needs, and it spits out the EXACT results that I need.   2. The end result needs to be a .php that I can upload to the website's root folder that can be then inserted into premade pages using:

<iframe src="SMQ.php" scrolling="yes" width="950" height="800"></iframe>

3. On the .php page, I need to have a way to log in to the SQL server and a simple search box built in that will allow the user to input a very simple search string consisting of no more than 4 numbers and 3 letters at a time. No buttons, no check boxes, just a search box.   3. This query then needs to be output as a nice data table, similar to this: This in fact is a screenshot of a search I performed out of my SQL database, in phpMyAdmin using the column "Scott" for the search, and the number 226 as the search term. All column names are visible with the exception of the first column, entitled LINEID, made to be the key, and the output should not include the key but have everything else as above.   4. I can see what the simple line of php is that performed this task:

SELECT * FROM `SMQSQL` WHERE `Scott` = '226' ORDER BY `LINEID` ASC 

but I can't figure out how the hell to get this incorporated to a .php search.   To sum it up, I need a .php page written that can connect to a SQL database, perform a data based search, and spit out a clean table when it is done.   I had accomplished this in the past using an import into google docs and using it to perform a search and result display via the following code built into a php called SMQ.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Example of Google Spreadsheet Data Visualisation</title>
</head>

<body>

<form id="form1" method="post" action ="<?php echo $_SERVER['PHP_SELF']; ?>"> <label>
<input id="search" name="search" type="text" />
</label>
<label>
<input id="Scott #" name="Scott #" type="submit" value="Scott #" />
</label>

<img src="loading.gif" width="16" height="11" />
</form>
<p>
<?php
$search= $_REQUEST['search'];
if ($search > ''){ $search = $search;} else { $search = '';}
?>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['table']});
</script>
<script type="text/javascript">
var visualization;
function drawVisualization() {

var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=0AronCwm9QPefdGpIUllscGgtLUJod2pOazc0bjU0cUE&usp=sharing');

query.setQuery('SELECT A, B, C, D, E, F, G, H, I, J, K, L, M, N, O ,P ,Q ,R ,S ,T WHERE (A) LIKE ("<?php echo $search; ?>") order by A asc label A "Scott #", B "Den", C "Color", D "Cond", E "40", F "60", G "70", H "70J", I "75", J "75J", K "80", L "80J", M "85", N "85J", O "90", P "90J", Q "95", R "95J", S "98", T "98J"');
query.send(handleQueryResponse);
}

function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + '' + response.getDetailedMessage());
return;
}

var data = response.getDataTable();

    visualization = new google.visualization.Table(document.getElementById('table'));
    visualization.draw(data, { page: 'enable', page: 16, pageSize: 16, legend: 'bottom'});
}
google.setOnLoadCallback(drawVisualization);
</script>

 <div id="table"></div>

</div>

</body>
</html>

But as you can see, this may not be the most secure thing in the world, plus we want to be able to expand it in the future and not be so simplistic, hence the need to switch to SQL.   Please let me know right away by contacting me at disead@gmail.com if this is something YOU might be able to help with. I'm sure for an experienced programmer, once you have the details from me that you need, it would take maybe 10 minutes to write. I don't have much, but I can pay a little bit for this one time job. If it ends up working out, I may be able to pay more down the line for more advanced options such as being able to do drop-down searches based on the column titled "ISSUE", as well as more things down the line as it grows.   Thank you so much, I hope to hear from someone soon!!!