PHP - Help. Unidentified Index..

I have two files

an sample.html which has just a search box some javascript on it to display images when users start typing on this search box.

the sample.html  works when i entre localhost\index.html

now, i have an index.php.

when i

include("index1.html");

the search box appears but the javascript does not work?

why? 

do i need to relink the following in my sample.html???
<script type="text/javascript"  src="autocomplete/lib/jquery.js"></script>
<script type='text/javascript' src='jquery.autocomplete.js'></script>
<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />

fyi i am using wordpress.

An open question this, and one that may or may not bear fruit. But here we go anyway.

index.php is a special case I feel because it is often the default script that is called for a web site. Moreover, I keep mine in the freely available root directory, but the rest of my php is out of the root for security purposes - in a directory called "lib".

The app I am working on at the present time requires that a user logs on first. So, the code I have in my index.php is very simple:

Code: [Select]
<?php

/* Require Log In */

require("lib/ezLogin.php");

?>

This at least is what I have presently. So I have a few questions:

1. Is treating index.php as a special case, a reasonable approach would you say?
2. Is the separation of the rest of the non-client php files a real security improvement?
3. When you declare the css path, do you use absolute path names? If so, how might it be done so it will work on local (testing) AND the main server (production) with no code change?
4. includes_path - I assume this is the path to the includes directory. However, I am not sure/happy/comfortable with this just yet. Can more than one path be included in this? (I have Googled around but still unhappy) If so, how so? Does this approach works across platforms? If not, is there a way to make it?

Many thanks for any help.

S

hi very good
I'm trying to get the indices of the gallery that I have a xml file to display it in a <select>
xml file is as follows ..
I'm trying to use "foreach" but what brings me, is twice galleria, but that's fine, what happens is that it brings are the names, but I want indices, 0 and 1
xml file
<?xml version="1.0"?>
<content>
 <gallery Name="Hostal" Folder="Gallery/hostal">
 <image Thumb="thumb0.jpg" Large="0.jpg" Caption="Hostal Regina" Colour="181f0a">
<comentarios><![CDATA[<p>Hostal Regina comentarios</p>]]></comentarios>
    </image>
    <image Thumb="thumb1.jpg" Large="1.jpg" Caption="Hostal Regina" Colour="181f0a">
<comentarios><![CDATA[<p>Hostal Regina</p>]]></comentarios>
    </image>
  </gallery>
<gallery Name="Vistas" Folder="Gallery/nerja">
    <image Thumb="thumb0.jpg" Large="0.jpg" Caption="Vista Nocturna" Colour="eeeeeee">
<comentarios><![CDATA[<p>Vista Nocturna realizada por Diego Palomo</p>]]></comentarios>
    </image>
<image Caption="eeeeeee"><comentarios>http://php-design-patterns.com</comentarios></image>
</gallery>
</content>

file select form
<select name="action">
<option value="">Escoger de la Lista</option>
<?php
$source = 'content.xml';
// load as string
$xmlstr = file_get_contents($source);
$sitemap = new SimpleXMLElement($xmlstr);
// load as file
$sitemap = new SimpleXMLElement($source,null,true);
foreach($sitemap->gallery as $index=>$content) {
$atributo = $content->attributes();
echo "<option value='".$index."'>".$index. "</option>";///in value no show index


}
?>
</select>

Hi I am new in PHP scripting.
I wrote a small script but stuck in the below error message.. Can someone please correct the code?

Thanks in advance.
Kapil


Notice: Undefined index: submitbutton in C:\xampp\htdocs\index.php on line 30
Error in code


<?php

echo "<title>PHP File Upload </title>";


$form = "<form action='index.php' method='POST' enctype='multipart/form-data'>
<table>

   <tr>
         <td>Title : </td>
         <td><input type = 'text' name = 'title'> </td>
   </tr>
   <tr>
         <td>Description : </td>
         <td><textarea name ='description' cols ='35' rows = '5'> </textarea></td>
   </tr>   
   <tr>
         <td> </td>
         <td><input type = 'file' name = 'myfile'> </td>
   </tr>
   
   <tr>
         <td> </td>   
         <td><input type = 'submit' name ='submitbutton' value ='Submit'></td>
   </tr>

</table>
</form>";

if($_POST['submitbutton'])
{
   $name = $_FILES['myfile']['name'];
   echo "$name";
}

else
{
   echo "Error in code";
}

?>

Hi, I would like to pass the value of a form name through "rsTown" but I am getting undefined index

my form:
Code: [Select]
<form method="post" class="textbox" action="<?php print $_SERVER["PHP_SELF"]; ?>">
                    City/Town:&nbsp;<input type="text" size="26" class="searchbox" value="" name="rsTown" id="inputString" onKeyUp="lookup(this.value);" onBlur="fill();" />
               
                <div class="suggestionsBox" id="suggestions" style="display: none;">
                    <img src="images/upArrow.png" style="position: relative; top: -36px; left: 105px; z-index:1;" alt="upArrow" />
                    <div class="suggestionList" id="autoSuggestionsList">
&nbsp;                    </div>
                </div>
                <input type="image" src="images/go.png" height="30" with="30" value="GO" />
            </form>
my code on same page:
Code: [Select]
<?
$Townsearch = $_REQUEST['rsTown'];
// how many rows to show per page
$rowsPerPage = 20;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;
$query  = "SELECT * FROM pubs WHERE rsTown LIKE '$Townsearch%' LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die(mysql_error().'<br>SQL: ' . $query); 

//looping counties
$query1  = "SELECT rsCounty, COUNT(PubID) AS County_Count FROM pubs GROUP BY rsCounty";
$result1 = mysql_query($query1) or die(mysql_error().'<br>SQL: ' . $query1); 

$county_select_options = '<option value="">Search county</option>';
while ($row = mysql_fetch_assoc($result1))
{
    $counties[$row['rsCounty']] = $row['County_Count'];
    // $county_select_options .= '<option value="display.php?PubID='.$row['id'].'">'.$row['rsCounty'].' (x'.$row['County_Count'].')</option>'."\n";
}
        // make this arrays not strings:
    $values = array();
    $labels = array();
        // compute the sum:
        $total = array_sum($counties);
    foreach($counties as $rsCounty=>$count){
                // compute percent and add to values list:
        $values[] = ($count*100/$total);
        $labels[] = $rsCounty;
    }
        // convert array $values to a string comma separated
    $values = implode(',',$values);
        // same conversion for $labels but '|' separated
    $labels = implode('|', $labels);
    $url = 'http://chart.apis.google.com/chart?cht=p3&chd=t:'.$values.'&chs=480x200&chl='.$labels.'&chco=b0d584';
    ?>
    <img src="<?php echo $url ?>" />
 <?


// start main page
while($row = mysql_fetch_array($result)){
echo '<div id="pubholder" class="wrap">';
$PUBID = $row['PubID'];
$RSPUBNAME = $row['rsPubName'];
$RSADDRESS = $row['rsAddress'];
$RSPOSTCODE = $row['rsPostCode'];
$RSTEL = $row['rsTel'];
$RSTOWN = $row['rsTown'];
$RSCOUNTY = $row['rsCounty'];

//div container of header and information

echo <<<EOF
  <a title="$PUBID" id="$PUBID" name="$PUBID"></a>
  <div class="entry_header">
    <div class="pubname">$RSPUBNAME</div>
EOF;
if ($_SESSION["RSUSER"] == "admin")
{
echo "<a href=\"edit.php?PUBID=$PUBID\" class=\"small\">edit this pub</a>";
}
echo  "</br>";
echo  "</br>";
echo "<div class=\"county\">".$RSCOUNTY."</div><div class=\"town\">".$RSTOWN."</div>";

echo "</div>";
echo "</div>";
}

// how many rows we have in database
$query   = "SELECT COUNT(*) AS numrows FROM pubs";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);



// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   }
}

// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";

$first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
$prev  = '&nbsp;'; // we're on page one, don't print previous link
$first = '&nbsp;'; // nor the first page link
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">[Next]</a> ";

$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
$next = '&nbsp;'; // we're on the last page, don't print next link
$last = '&nbsp;'; // nor the last page link
}


// print the page navigation link
echo "<div class=\"centertext\">";
echo $first . $prev .  $nav ." Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last;
echo "</div>";

?>

Also, I need my pagination sorting out if anyone can help?!

take a look at my site: http://www.retroandvintage.co.uk/default.php

i am trying to sort out some errors i have on my website but am not really all that clued up with PHP or MySql......

currently on this page http://fifaworld360.co.uk/headtohead/team.php i am thrown 3 errors......

now it says the errors are on line 11, 12 & 13 which would be this part of the code ....... 

Code: [Select]
$league = $_REQUEST["league"];
$league_id = get_league_id($league);
$team = rawurldecode($_REQUEST["team"]);
below is the full code for this page..... what i need is for someone to tell me if their is something wrong...i got a funny feeling it is something silly but as i said i am not clued up on this at all....the site was built for me and has since been throwing errors when the coder left..... now i just need to sort it so i can re run it again..



Code: [Select]
if (!isset($_REQUEST["team"])){
$league = $random_league;
$league_id = get_league_id($league);
$team = random_team($league_id);
}else{
$league = $_REQUEST["league"];
$league_id = get_league_id($league);
$team = rawurldecode($_REQUEST["team"]);
}

//echo "<br>team: $team";

$team_information = get_team_information_by_name($team);
$team_id = get_team_id($team_information[1]);
$user_id = get_current_user_id($team_id, $league_id);
$user_name = get_user_name($user_id);

?>
<div class="DivMiddleLeagueTable">
<table class="layoutTable" width="100%" cellspacing="0" border="0">
<tbody>
<tr>
<td>
<table class="layoutTable" width="100%" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td class="layout" valign="top">
<div class="layout">
<div id="leagueTable" class="TeamTable">
<table class="TeamTable" width="100%" cellspacing="0" border="0">
<tbody>

<tr class="header">

<td colspan="4">Team: <?php echo $team_information[1];?></td>
<td rowspan="2" align="right" bgcolor='white'><?php echo "<IMG SRC=plaatje.php?plaatje_id=$team_information[0]>";?></td>
</tr>
<tr class="header">
<td colspan="4">League: <?php echo $league;?></td>
</tr>

<tr class="rowHeader">
<td>Ground:</td><td colspan="2"><?php echo $team_information[3];?></td>
<td>Capacity:</td><td><?php echo $team_information[4];?></td>
</tr>
<tr class="rowHeader">
<td>Manager: </td>
<td colspan="2"><?php echo $user_name;?></td>
<td>Partner: </td>
<td colspan="1"><?php echo get_partner($team_id, $league_id);?></td>
</tr>

</tbody>
</table>
<br />

<!-- dit stuk wordt dynamisch gevuld -->
<?php
$sql_fixtures = "SELECT f.hometeam_id, f.awayteam_id, f.home_result, f.away_result ".
"FROM fixtures_result AS f, league AS l ".
"WHERE f.league_id = '" . mysql_real_escape_string($league_id) . "' AND (f.hometeam_id='" . mysql_real_escape_string($team_id) . "' or f.awayteam_id='" . mysql_real_escape_string($team_id) . "') ".
"AND f.league_id=l.league_id AND f.week_nr <= l.league_weeknr ".
"ORDER BY f.week_nr ASC";
$sql_result = mysql_query($sql_fixtures);
?>
<table class="TeamTable" width="100%" cellspacing="0" border="0">
<tr><td valign="top" width="60%">
<table width="100%" cellspacing="0" border="0" class="TeamInfo">
<tr class="header">
<td colspan="5">Results / Fixtures</td>
</tr>
<tbody>
<?php
$colourclass = "fixturesLightRow";
while ($row = mysql_fetch_array($sql_result)){
?>
<tr class=<?php echo $colourclass;?>>
<td class="TeamTD">
<?php echo get_team_name($row[0]);?>
</td>
<td class="TeamTD">
<?php echo get_team_name($row[1]);?>
</td>


<td class="ScoreTD"><?php echo $row[2];?></td>
<td class="ScoreTD">-</td>
<td class="ScoreTD"><?php echo $row[3];?></td>
</tr>
<?php
if ($colourclass == "fixturesLightRow"){
$colourclass = "fixturesDarkRow";
}elseif ($colourclass == "fixturesDarkRow"){
$colourclass = "fixturesLightRow";
}
}
?>
</tbody>
</table>
</td><td valign="top" width="35%">
<?php
$sql = "SELECT trophy_year, trophy_name FROM `team_history` where team_id=$team_id ORDER BY trophy_year DESC";
//echo $sql;
$result = mysql_query($sql);
?>
<table width="100%" cellspacing="0" border="0" class="TeamInfo">
<tr class="header">
<td colspan="5">Team History</td>
</tr>


<tbody>
<?php
while ($row = mysql_fetch_array($result)){
?>
<tr>
<td valign="top">
<?php
echo $row[0];
?>
</td>

<td><?php echo $row[1];?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</td>
</tr>
<!-- einde vandit stuk wordt dynamisch gevuld -->

</table>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</td>

<td class="middleRight">
<img height="1" width="1" alt="" src="images/shim.gif"/>
</td>
</tr>
</tbody>
</table>
</div>

Hi all,

I am fairly new to php.  I am learning php by a book.'

I am getting an undefined index error. With the following code in dreamweaver.

<?php
              if
              ($row_rsCoffee['image'] == "")
              {
                 echo '<img src="images/missing_image.jpg" />';
              }
              else
              {
                 echo '<img src="images/' . $row_rsCoffee['image'] . '" />';
              }
              ?>

The line the error is at: ($row_rsCoffee['image'] == "") --> Notice: Undefined index: image in C:\wamp\www\coffee\coffeevarieties.php

Can anyone help with this>?

Thanks in advance.

Alexander Lejuez

Hi guys

I am getting an error of
Code: [Select]
Notice: Undefined index: photo_filename in /home/sites/haldonguesthouse.co.uk/public_html/new-site/admin/upload.php on line 28

I understand that the error would suggest that the field is not referenced on the form that is used to post the values through.

Below is the form code that is used to post the values
Code: [Select]
<form id="add_gallery" action="upload.php" method="post">
<table>
<tr>
<td>Gallery Name</td>
<td><select name="category" id="category">
<option>Please select...</option>
<option value="14">Superior Double Room</option><option value="15">Superior Single Room</option><option value="16">Double en-suite</option><option value="17">Twin or Triple Room, en suite</option><option value="18">Family Room for 4</option><option value="19">Single Room with Private Facilities</option><option value="20">Double Room with Private Facilities</option><option value="21">The Gallery</option></select></td>
</tr>
<tr>
<td>
     Photo 1:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 2:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 3:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 4:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 5:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 6:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 7:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 8:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 9:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td>
     Photo 10:
    <input name='photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
     Title:
    <input name='photo_caption[]' type="text" size="30">
</td>
</tr><tr>
<td></td><td><input type="submit" name="submit" value="Upload Photos"/></td>
</tr>
</table>
</form>

Hello i am new to php and i was wondering if someone knew how to do this. I just need a simple index.php file that lists the files and folders in a directory but i need it to look exactly like this (With Bullets):


Thank You In Advance

(I also need it to open the folder directory if a folder is clicked on and button for Parent Directory)

Hi guys,

I have a question, I realised that when I type in my url, for example, www.abc.com, it will automatically lead to www.abc.com/index.php URL, I would like to remain the URL as www.abc.com. How do I achieve that? Thanks

Wilson

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=357652.0

hi all,

i have made a counter as a module for my website.

when i directly go to de module and start de counter i see the picure en he does his work, butt wen i call it in de index.php by include('modules/counter/counter.php')

then i see een not loaded picturebox and i dont know why it doesnt works ?

you can see the counter and the problem on: http://nieuw.pc-hulp-online.nl/index.php

can someone help me to make it als work with include()??

thnx

want to carry over session to help page? but getting the error undefined index.

Any help would be greatly appreciated!

//getting my value from database table and put it into session
$_SESSION["user_firstname"] = $data["Firstname"];


//decides on where the user gets re-directed to.
 if ($_SESSION["user_priority"] == '1')
        {
            header("Location: AdminSection.php");           
        }
        else
        {
            header("Location:LoggedIn.php");
      }      

      if ($_SESSION["user_times_loggged_in"] == '0')
      {
         
         header("Location:UsingTheSystem.php");
      }




//Help page
<?php

session_start();
$name = $_SESSION["user_firstname"];

echo $name;
?>

any idea why its not picking up the session?

Thanks

im having problems with the initial loading of a page "Undefined index". i no the problem is due to 2 $vars having no value but i dont no how to get around the problem.

its a form that posts to itself then pulls from the database.
once you hit submit the problem goes away. i just need to sort the 1st page load out

thanks

the problem is the 1st 2 lines of the snippet.
snippet
$ser_type=$_POST['list'];
$search = $_POST['search'];
if ($search == '' || $search == ' '){

echo "Search Field is Empty - Please Input a Search Query!";
die;
}
else{
if ($ser_type=="sku"){
$sql = "SELECT * from $tbl_name WHERE sku like '%$search%' or rsku like '%$search%'";
$result = mysql_query($sql);

full code

<?php
include("http://localhost/dsgi/includes/header.html");
?>
<!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>Modify DataBase</title>
</head>

<body>
<form method="post" action="main.php"> 
<table class="tablesrch" width=583 height="101" border="0" align=center> 
<tr>
  <td height="32" colspan="2"> <div align="center">Enter Search:
  <input type=text name='search' size=20 maxlength=255>
  </div></td>
  </tr>
<tr>
  <td width="193" align="right">Search By:</td>
  <td width="380"><label>
    <input name="list" type="radio" id="SKU" value="sku" checked>
    SKU
        &nbsp;
          &nbsp;
          &nbsp;
          &nbsp;
          <input name="list" type="radio" id="make" value="make">
    Make
    &nbsp;
    &nbsp;
    &nbsp;
    <input type="radio" name="list" id="model" value="model">
    Model</label></td>
</tr>
   
<td height="28" colspan="2"><div align="center"><input type=submit></div></td></tr> 
</table>
</form>
<p align="center">&nbsp;</p>
<table class="table2"  align="center">
  <tr>
    <td align="center">
<?php

//include("http://localhost/dsgi/includes/config.php"); 

$INC_DIR = $_SERVER["DOCUMENT_ROOT"]. "/dsgi/includes/"; 
include($INC_DIR. "config.php"); 


// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
$tbl_name="dsgi_serval"; 


// Retrieve data from database 
$ser_type=$_POST['list'];
$search = $_POST['search'];
if ($search == '' || $search == ' '){

echo "Search Field is Empty - Please Input a Search Query!";
die;
}
else{
if ($ser_type=="sku"){
$sql = "SELECT * from $tbl_name WHERE sku like '%$search%' or rsku like '%$search%'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {

echo "Image is on the server. If not green please inform imaging team";

?>
</td>
  </tr>
</table>
<table class="table1" width="800" height="72"  align="center">
  

<tr class="tablehead">
<th width="113" align="center">Recon SKU</th>
<th width="66" align="center">Orig SKU</th>
<th width="90" align="center">Make</th>
<th width="169" align="center">Model</th>
<th width="58" align="center">Recovery</th>
</span></span></tr>
<?php

while ($rows=mysql_fetch_array($result)){

// table bg colour
$choice = strtoupper($rows['comments']);

$findme    = 'FAIL';
$findme1    = 'PASS';
$mystring2 = trim($rows['comments']);
$pos2 = stripos($mystring2, $findme);
$pos1 = stripos($mystring2, $findme1);

if ($pos1 !== false){ 
$bgc = "pass" ; }    
elseif ($pos2 !== false){
$bgc = "fail" ;   
}else{
$bgc = "wait" ; }
?>

<tr id="tabledata" class="<?php echo "$bgc"; ?>">
<td>&nbsp;<?php echo $rows['sku'] ; ?></td>
<td>&nbsp;<?php echo $rows['rsku']; ?></td>
<td>&nbsp;<?php echo $rows['make']; ?></td>
<td>&nbsp;<?php echo $rows['model']; ?></td>
<td>&nbsp;<?php echo $rows['recovery']; ?></td>

</tr>



<?php



}
}
else {
$sql = "SELECT * from dsgi_request WHERE sku = '$search'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {
while ($rows=mysql_fetch_array($result)){
?>
Image not found on server. <br>
please Inform Engineering Team.
<?php
}
?>
<?php
}else{
?>
Image not found on server.<br> 
please Inform Engineering Team.
</table>
<table width="350" border="1" align="center" cellpadding="0" cellspacing="1">
  <tr>
  <td><form name="form1" method="post" action="request_ac.php">
  <table width="100%" border="1" cellspacing="1" cellpadding="3">
<tr>
<th colspan="3" >
  Image Request
</th>
  </tr>
  <tr>
    <td>SKU</td>
    <td>:</td>
    <td><input name="sku" type="text" id="sku" size="30" maxlength="6" /></td>
  </tr>
  <tr>
  <td width="97">Make</td>
  <td width="3">:</td>
  <td width="222"><input name="make" type="text" id="make" size="30"></td>
  </tr>
  <tr>
  <td>Model</td>
  <td>:</td>
  <td><input name="model" type="text" id="model" size="30"></td>
  </tr>
  <tr>
    <td>OS</td>
    <td>:</td>
    <td><input name="os" type="text" id="os" value="Which Version? Home, Basic?" size="30" /></td>
  </tr>
  <tr>
    <td>Serial</td>
    <td>:</td>
    <td><input name="serial" type="text" id="serial" size="30" /></td>
  </tr>
  <tr>
    <td>Bcn</td>
    <td>:</td>
    <td><input name="bcn" type="text" id="bcn" size="30" /></td>
  </tr>
  <tr>
    <td>Cell</td>
    <td>:</td>
    <td><label>
      <select name="personel" id="personel">
        <option selected="selected">Laptop Cell</option>
        <option>Cell A</option>
        <option>Cell B</option>
        <option>Cell C</option>
        <option>Desk Top's</option>
        </select>
      </label></td>
  </tr>
  <tr>
  <td>Date</td>
  <td>:</td>
  <td><input name="date" type="text" id="date" value="<?php echo date("d, M, Y - h:i:s"); ?>" size="30" readonly="readonly" /></td>
  </tr>
  <tr>
  <td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
  </tr>
  </table>
  </form>
  </td>
  </tr>
</table>
<?Php
}
}
}
else{
$sql = "SELECT * from $tbl_name WHERE $ser_type like '%$search%'";
$result = mysql_query($sql);
$srch = strtoupper($search);
$sertype = strtoupper($ser_type);
// echo "$sertype Search Result's For $srch";
echo "Searched $sertype For $srch";
?>
</td>
  </tr>
</table>
<table class="table1" width="800" height="72" align="center">
  

<tr class="tablehead">
<td>Recon SKU</td>
<td>Orig SKU</td>
<td>Make</td>
<td>Model</td>
<td>Recovery</td>
</tr>
  
<?php

while ($rows=mysql_fetch_array($result)){

// table bg colour
$choice = strtoupper($rows['comments']);

$findme    = 'FAIL';
$findme1    = 'PASS';
$mystring2 = trim($rows['comments']);
$pos2 = stripos($mystring2, $findme);
$pos1 = stripos($mystring2, $findme1);

if ($pos1 !== false){ 
$bgc = "pass" ; }    
elseif ($pos2 !== false){
$bgc = "fail" ;   
}else{
$bgc = "wait" ; }

// $bgc = "#EE2C2C" ;red
// $bgc = "#FF6600" ; amber
?>
<?php $make = strtoupper($rows['make']); ?>
<tr id="tabledata" class="<?php echo "$bgc"; ?>">
<td>&nbsp;<?php echo $rows['sku'] ; ?></td>
<td>&nbsp;<?php echo $rows['rsku']; ?></td>
<td>&nbsp;<?php echo $make; ?></td>
<td>&nbsp;<?php echo $rows['model']; ?></td>
<td>&nbsp;<?php echo $rows['recovery']; ?></td>
</tr>
<?php
}
}
}
?>

<p>&nbsp;</p>
</body>
</html>