PHP - Form Results To Web Page

Hello all. I'm using this code to go through the database and output certain user-defined numbers

Code: [Select]
<?php
mysql_connect ("pdb1.awardspace.com", "anastasov_db","moscow1945")  or die (mysql_error());
mysql_select_db ("anastasov_db");
 
$term = $_POST['term'];
 
$sql = mysql_query("select * FROM countries WHERE cocode = '$term'");
 
while ($row = mysql_fetch_array($sql)){
    echo '<br/> Code: '.$row['cocode'];
    echo '<br/> Country: '.$row['coname'];
    echo '<br/><br/>';
    }
 
?>
Now how would I go about making a page that appears if the script can't find any results in the database?

Thank you in advance

Hi, I have search form which works apart from 1 part, I have set the results limit to 10 per page with a next link if there are more than 10 results, however when the next link is clicked, i get the error 'you do not have a search parameter' which comes from this code:

Code: [Select]
if (!isset($var))
          {
          echo "<p>We dont seem to have a search parameter!</p>";
          exit;
          }
The next link is defined by the code below:

Code: [Select]
// check to see if last page
          if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {
       
          // not last page so give NEXT link
          $news=$s+$limit;
       
          echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
          }
Can anyone see where I have gone wrong with this code without me sending the whole search form? Any help would be very much appreciated. Thanks

i have built pages that paginate with 10 rows per page (some pages show more but for the moment i want to focus on this particular page)

//Define Some Options for Pagination
$num_rec_per_page=10;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $num_rec_per_page;

$results = mysql_query("SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name) LIMIT $start_from, $num_rec_per_page") or die(mysql_error());

	$results_array = array();
	while ($row = mysql_fetch_array($results)) {
    	$results_array[$row['characterID']] = $row;
}

The above sets the variables for the pagination and below the results are echo with 10 rows per page   then i show the pagination links:

<?php 
$sql = "SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name)";

$rs_result = mysql_query($sql); //run the query
$total_records = mysql_num_rows($rs_result);  //count number of records
$total_pages = ceil($total_records / $num_rec_per_page); 
?>


      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td align="center"><div style="width:100%; text-align:center;">
          <ul class="pagination">
    <li class="selected">
	<?php
echo "<a href='capitalmember.php?page=1'>".'«'."</a> ";?> 
</li>
<?
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<li><a href='capitalmember.php?page=".$i."'>".$i."</a></li> "; 
};
?>
<li class="selected">
<? 
echo "<a href='capitalmember.php?page=$total_pages'>".'»'."</a> "; // Goto last page
?></li>
  </ul></div>
    <?php
  $pageNr = $page;   // Get Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  // 3 * 10 = 30
$to = $from + $rowsPerPage;      // 30 + 10 = 40
echo $pageNr;
/* Result: From page 30 to 40 */
  ?></td>
        </tr>
      </table>

this works great and shows me 10 results per page,   what i need to work out and work on next is:   echo the number of results above the records (for example: "showing records 1 to 10" and then on page 2 "showing records 11 to 21" and page 3 "showing records 22 to 32"   how can i work out the maths for this echo?   i was thinking along the lines of;

    <?php
$pageNr = $page;   // Gets Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  
$to = $from + $rowsPerPage;      // 30 + 10 = 40
// Now Show Results
echo $from; // Echo from
echo $to // Echo to
  ?>

but i'm still working on this..   then i need to look at shortening the amount of page links on the page if for example i have 500 records it shows me links 1 to 50 and eats up the page....   Appreciate any help and light onto my problems.   Many thanks
Edited by jacko_162, 11 January 2015 - 05:43 PM.

Hi again PhpFreaks, yet again I got a problem regarding coding.

Hi all,

I need your help as I have got a problem with display the 50 rows in the search results. I want to limit 50 rows in per page and if I have less than 50 rows like 21 rows in the page 2 then display the 21 rows.

I have got a problem with the limit, because when I tried to use `LIMIT 0, 50`, it will display total 71 rows which I only want to display no more than 50 in per page.

Here is what I have tried:

    $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 0, 50");
    $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);

And I have also tried this:

    $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT $offset, $limit");
    $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);

It will not limit the rows I want. It will still show the 71 rows.

Here is the full code:

   

<?php
    
    // Initialize the session
    session_start();
    
    //Connect to the database
    require_once('config.php');
    
    $searchemail = '%' . 'gmail.com' . '%';
    $searchsubject = '%' . 'gmail.com' . '%';
    $searchmessage = '%' . 'gmail.com' . '%';
    
    $mailbox = $link->prepare("SHOW TABLES");
    $mailbox->execute();
    $folders = array();
    $total = 0;
    $total_rows = 0;
    $i = 0;
            
    while ($folder = $mailbox->fetch(PDO::FETCH_NUM)) {
        $folder = $folder[0];
    
        if (strpos($folder, 'users') !== false) {
            $folder = str_replace('users', '', $folder);
        }
        else
        {
            $folders[$i] = $folder;
        }
        $i++;
    }
    
    foreach($folders as $folder) {
        $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 0, 50");
        $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);
        
        if ($search_mailbox->rowCount() > 0) {
            $total += $search_mailbox->rowCount();
        }
    }
    
    $page = 1;
    $limit = 50;
    //$per_page = 50;
    //$pages = ceil($total / $per_page);
    
    $offset = ($page - 1) * $limit;
    
    
    foreach($folders as $folder) {
        
        $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT $offset, $limit);
        $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);
    
    
        if ($search_mailbox->rowCount() > 0) {
            foreach($search_mailbox->fetchAll() as $k => $row) {
                $email_number = $row['id'];
                $search_from = $row['from_email'];
                $search_subject = $row['subject'];
                $total_rows++;
                echo $search_subject . '.........................' . $total_rows;
                echo "<br>";
            }
        }
                        
    }
    
    ?>

I am unable to fetch the first 50 rows in the page 1 and I am also unable to fetch the 21 rows in the page 2. 

What I am trying to achieve is when I am in page 1, I want to display the first 50 rows, then in the page 2 if I have another 50 rows then display the 50 rows, but if I have less than 50 rows like 21 rows then display the 21 rows.

Can you please show me an example how I can start with first 50 rows when I am in the page 1 then in page 2 display 21 rows to make in total 71 rows?

Any advice would be much appreicated.

Thanks in advance.

Code: [Select]
The form below is meant to retrieve the named attribute of a form input called "limitedtextfield" , along side the current date and store those values in a database.  The form contains some javascript which can be disregarded for this particular problem.
[code]
<form name="mymind" style= "position:relative;left:40px;" action="insert_status.php" method="post">

<input  name="limitedtextfield" type="text" onKeyDown="limitText(this.form.limitedtextfield,this.form.countdown,55);"

onKeyUp="limitText(this.form.limitedtextfield,this.form.countdown,55);" maxlength="55"><br>

<font size="1">(Maximum characters: 55)<br>

You have <input readonly type="text" name="countdown" size="3" value="55"> characters left.</font>

<input type="hidden" name="submitted" value="TRUE"/>

<input style="position:relative;left:0px;bottom:0px;" type="submit" name="submit" value="Submit!" />

</form>




Here is the php script that processes the form. What it is meant to do is search the database and if no record is found for the authenticated member,  input the relevant values into the database.  If a record is found, it should update the record.  Well every time I hit the submit button, all I get is a blank page.  Any clue as to what is going wrong?

PS:  I checked the database and no values got inserted. Code: [Select]
<?php

//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);


//authenticate user
require('auth.php');

//Connect to database
require ('config.php');




if (isset($_POST['submitted'])) {

$query = "SELECT* FROM publications WHERE member_id ='".$_SESSION['id']."' AND cartegory='status'";
        $result = @mysql_query($query);
        $num = @mysql_num_rows($result);
       
        if ($num> 0) {

$update = mysql_query("UPDATE publications SET publication = '{$_POST['limitedtextfield']}' WHERE member_id = '".$_SESSION['id']."' AND cartegory = 'status'"); 

header("Location: member.php");
            
        } else {



         $query = "INSERT INTO publications ( member_id, publication, cartegory, pub_date)

  VALUES ( '{$_SESSION['id']}','{$_POST['limitedtextfield']}', 'status', NOW() )";


header("Location: member.php");
            

}

}



?>
 

Hi I'm new to the site...  and new to PHP, so excuse me if my verbiage isn't quite right.  I've been struggling to find a solution to paging through my search results.  MY code works for the first five entries that are found via the mysql query but when I click next five results, the code breaks down and sends me back to my index.  I believe the problem is he

print "&nbsp;<a href=\"$PHP_SELF?s=$news&poster=$var\">Next 5 &gt;&gt;</a>&nbsp&nbsp;";

I don't know how to rewrite, to display results based on the number of pages found.  Ideally the user should be able to query the db and then page through the results.  my entire code:


Code: [Select]
<?php

// Get the search variable from URL

$var = @$_GET['poster'];
$trimmed = trim($var);//trim whitespace from stored variable

// rows to return
$limit=5;

// check for empty string and display a message.
if ($trimmed == "")
{
echo "<p>Please enter a search...</p>";
}
else
{
// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }


//connect to your database
$con = mysql_connect("localhost", "test", "test") or die('Sorry, could not connect to server'); 
mysql_select_db("recipe", $con) or die('Sorry, could not connect to database');

//Build SQL Query
$query = "Select date, poster, title, article FROM bulletin WHERE poster LIKE \"%$trimmed%\"
  order by articleid desc";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

  }
  else
  

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

// begin to show results set
echo "Results";
         echo "<hr>";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {

           $date = $row['date']; 
         $poster = $row['poster'];
         $title = $row['title'];
         $article = $row['article'];

         echo "$date";
         echo "<br>\n"; 
         echo "<img src='images/marker.png'><font color=\"white\">$poster</font><br><br>\n";
         echo "$title";
         echo "<br />";
         echo "<br />";
         echo "<font color=\"white\">$article</font>\n";
         echo "<br>\n";
         echo "<hr>";
         echo "<br>\n";
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 5</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  print "&nbsp;<a href=\"$PHP_SELF?s=$news&poster=$var\">Next 5 &gt;&gt;</a>&nbsp&nbsp;";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<br />";
  echo "<br />";
  echo "<p>Showing results $b to $a of $numrows</p>";
  }
  
?>

If someone could help I would be so great full!  Thanks in advance...

Mod edit: [code] . . . [/code] BBCode tags added.

I would like to modify my php script where my PDF search results would not only display the company name, the country, but also display a limit number link by pages so that not all of the results are shown. 
 
I also want the first word searched to go to the first occurrence of the word on the PDF document.
 
What would be the best way to do this? 
 
Here is my code: 

<html>
  <head></head>
  <body>
  <?php if (!isset($_POST['q'])) { ?>
 
 
<img src="/wvb-logo-slogen.png" border="0" />
    <h2>Search</h2>
    <form method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>">
      <input type="text" name="q" size="30" />
    </form>
 
  <?php } else { ?>
 
<img src="/wvb-logo-slogen.png" border="0" />
    <h2>Search Results</h2>
 
  <?php
    try {
      // create object
     // $swish = new Swish('/usr/local/apache/htdocs/swish/index.swish-e');
        $swish = new Swish('/var/www/html/pdf2/index.swish-e');
 
 
      // get and run query from command-line
      $queryStr = htmlentities($_POST['q']);
      $result = $swish->query($queryStr);
  ?>
 
   Found <?php echo $result->hits; ?> match(es) for '<?php echo $queryStr; ?>'.
 
  <?php
      // iterate over result set
      // print details for each match
      while($r = $result->nextResult()) {
  ?>
 
  <p>
    <?php echo $r->swishreccount; ?>
    <strong>
      <a href="<?php echo '/pdf2', ltrim($r->swishdocpath, '.') ;  ?>">
         <?php echo $r->swishdocpath; ?>
      </a>
    </strong> (sco  <?php echo $r->swishrank; ?>) <br/>
<?php echo $r->swishdocpath; ?>

 </p>
 
  <?php
      }
    } catch (Exception $e) {
      die('ERROR: ' . $e->getMessage());
    }
  }
  ?>
 
  </body>
</html>

 
Any assistance would be greatly appreciated.
Edited by mac_gyver, 15 May 2014 - 08:17 AM.
code tags please

Hello,
When I submit my home-built php contact form (below) the information doesn't make it to my inbox - it just disappears. There's no error log and once I click the Submit button, it says the info was submitted successfully.
<form method="POST" action="mailer.php">
Name&#58; &nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" name="name" size="19"><br>
<br>
Company&#58;
<input type="text" name="company" size="19"><br>
<br>
e-Mail&#58; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" name="email" size="19"><br>
<br>
<input type="checkbox" name="check[]" value="digital_sample"> <b>Please send unrestricted digital access<br>
<input type="checkbox" name="check[]" value="physical_sample"> Reserve my physical, retail shipper pack</b><br><br>
<p style="text-align:center; font-family:Arial">
Shipping Instructions&#58;<br>
<textarea rows="9" name="message" cols="30"></textarea><br>
<br>
<input type="submit" value="Submit" name="submit"></p>
</form>

<?php
$check_msg = "";
if(isset($_POST['submit'])) {
$to = "contact@stopsmokingforgood.com";
$subject = "Sample Request";
$name_field = $_POST['name'];
$email_field = $_POST['email'];
$company_field = $_POST['company'];
$message = $_POST['message'];
foreach($_POST['check'] as $value) {
$check_msg .= "Checked: ".$value;
}
$body = "From: ".$name_field.": E-Mail: ".$email_field." : Company: ".$company_field." : Message: ".$message." : ".$check_msg;
echo "Data has been submitted to ".$to;
mail($to, $subject, $body);
} else {
echo "blarg!";
}
?>

EDIT: sorry - new to posting guidelines - using XAMPP with mysql 5.1.44 (I think this is correct!!)

Newbie question he I have successfully created a form that that displays students (based on a selected lesson/group/date) with the ability to enter scores.

I'm now trying to set the form up so that if data already exists then it is displayed in the form.

Eg: if a member of staff choses group 7AS, lesson 1, 24/09/2010 and another member of staff has entered a score already for one student it shows up in the <select> drop down by using
Code: [Select]
<option>" . $scorevalue . "</option>

I had this working at one point but have made a change somewhere and cannot get it working again! can anyone spot an obvious mistake I am making?

The code I am using is as follows:
Code: [Select]
<input type="hidden" name="tutor" value="<?php echo $_GET["tutor"]; ?>" />
<input type="hidden" name="date" value="<?php echo $_GET["date"]; ?>" />
<input type="hidden" name="lesson" value="<?php echo $_GET["lesson"]; ?>" />


<?php

error_reporting(-1);

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("lakeside", $con);

$result = mysql_query("SELECT students.admin, students.fname, students.surname, students.tutor
FROM students
WHERE tutor='$_GET[tutor]' 
ORDER BY students.tutor, students.surname");


echo "<table class='scores'>
<tr>
<th>Admin</th>
<th>Firstname</th>
<th>Surname</th>
<th>Tutor</th>
<th>Score</th>
<th>Code</th>
<th>Comment</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  
$sqlstatement = "SELECT * FROM scores where admin = '" . $row['admin'] . "' and lesson = '" . $_GET[lesson] . "' and date = '" . $_GET[date] . "' ";
$scorevalue = mysql_query($sqlstatement);  



echo " . $score . ";

while($rowvalue = mysql_fetch_array($scorevalue))
{
$score = $rowvalue['score'];
$comment = $rowvalue['comment'];
$code = $rowvalue['code'];
}
  
  
  echo "<tr>";
  echo "<td>" . $row['admin'] . "</td>";
  echo "<td>" . $row['fname'] . "</td>";
  echo "<td>" . $row['surname'] . "</td>";
  echo "<td>" . $row['tutor'] . "</td>";

  echo "<td><select name='score"  . $row['admin'] . "' value='{$row['score']}' />
   <option>" . $scorevalue . "</option>
   <option>0</option>
   <option>1</option>
   <option>2</option>
   <option>2.5</option>
   <option >3</option>
   <option>3.5</option>
   <option>4</option>
   </select>
   </td>";

Hi Guys.

I have some code which displays the rows of a database table in a html table on my webpage:

Code: [Select]
<?php//to display image from source$dir = "360_covers";echo '<table>';echo '<tr><th>Title</th><th>Cover</th><th>comment</th></tr>';$result = mysql_query("SELECT * FROM xbox_games order by gametitle");while ($row = mysql_fetch_assoc($result)) {    echo "<tr><td>{$row['gametitle']}</td><td><img src=\"$dir/{$row['cover']}\" width='38' height='38'></td><td>{$row['cover']}</td></tr>";}//close out tableecho '</table>';?>

What i want to do now is add a form, possibly at the end of each row of the html table, which will allow a session user to update that record.

Can anybody advise on the best way to do this?

Sounds a bit long winded in the name so i'll explain...

I'm coding a site where the user inputs their vehicle reg, and submits the form. The site will then show their car's details. This is being done using an external service that provides an up to date database of vehicle details.

So far, i've got the form and when you submit it, it returns the vehicle data in an XML, but the XML it displays is remote. I need to retrieve the details back to the website to display on the page. Here is what I have already:

Code: [Select]
<html>
<head>
<title>Reg Test Page</title>
</head>
<body>
<form method="post" action="https://www.****.com/UAT/">
<input type="hidden" name="ESERIES_FORM_ID" value="B2INT">
<input type="hidden" name="MXIN_USERNAME" value="****"><br />
<input type="hidden" name="MXIN_PASSWORD" value="****"><br/>
REG<input type="text" name="MXIN_VRM" value="REG NUM"><br />
<input type="hidden" name="MXIN_TRANSACTIONTYPE" value="03"><br />
<input type="hidden" name="MXIN_PAYMENTCOLLECTIONTYPE" value="02"><br />
<input type="hidden" name="MXIN_CAPCODE" value="1"><br />
<input type="submit" />
</form>
</body>
</html>

I've ***'d out some details for obvious reason. The form currently works fine and returns a valid XML response, but it's remote. My original plan was to get the form to load up in another php file that processes the detail and sends a file_get_contents() request, but looking at the results page on the xml, there is no extension to the posted url and if you go directly to it, you get the error "METHOD NOT ALLOWED. ONLY 'POST' IS ALLOWED."

The other issue I have is that i'm not sure how it's handling the request, and the url is not modified, so i'm not sure how i'd set an url with values to retrieve it?

Any help is gratefully received.

Cheers Guys.

Hi,

I'm currently learning PHP through tutorials and I am working on a webpage that filters statistics (crime records) from an SQL table and filters them by an option of years that the user has picked from a dropdown box.

$desiredyear = $_POST['year'] is the year picked from the drop down box on a different page.

I did not encounter any problems simply displaying the entire table until I tried to filter the crimes by year. I keep getting this error message.

Warning: sqlsrv_fetch_array() expects parameter 1 to be resource, boolean given in C:\RDEUsers\NET\400792\1.php on line 40

Here is the error line.

Code: [Select]
while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
And here is my code so far

Code: [Select]
<?php 

$server = 'SQL2008';
$connectionInfo = array( "Database"=>"rde_400792");
$conn = sqlsrv_connect($server,$connectionInfo);

$desiredyear = $_POST['year'];


$describeQuery='select year, force, homicide from crime where year = $desiredyear ';
$results = sqlsrv_query($conn, $describeQuery);

echo '<table border="1" BORDERCOLOR=Black>';
echo '<tr><th bgcolor = "LightBlue">Year</th><th bgcolor = "LightBlue" >Force</th><th  bgcolor = "LightBlue">Homicide</th></tr>';


while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC)) 

{           echo '<tr>';
   echo '<td >' .$row['year'].'</td>'; 
   echo '<td>' .$row['force'].'</td>'; 
   echo '<td>' .$row['homicide'].'</td>'; 
   echo '</tr>';
} 

echo '</table>';
sqlsrv_close($conn); 
Please can somebody help me fix this? It's driving me mad and I've exhausted my limited knowledge on the subject. I just don't understand what I'm doing wrong.

I have a search page and everything works fine but I would like to add the latest 10 rows to the page so there is something to look at or click on before the user searches.

The page is at: www.giantstridedives.com/locations. You can see that it's pretty boring. Hit submit and you'll see the entries so far (only 3 right now). I'd like to have the latest 10 display there by default but then when a user searches they are replaced by the search results. Make sense?

Here's the code I'm using for the search:

Code: [Select]
<?php
if (isset($_POST['submit'])) {

require_once('dbconnection.php'); 
mysqli_select_db($conn, $dbname); 
$searchterm = $_POST['search']; 
$searchterm = strip_tags($searchterm);
$searchterm = trim ($searchterm);
$q ="SELECT * FROM locations WHERE loc_name LIKE '%" . $searchterm . "%' AND loc_approved != '0'"; 
$r = mysqli_query($conn, $q) or die(mysql_error($q)); 
$row = mysqli_fetch_assoc($r); 
$rowcount = mysqli_num_rows($r);
}
?>

<h1>Search for Scuba Dive Locations</h1>
<form id="searchform" name="searchform" method="post" action="index.php"> 
    <input type="text" name="search" id="search_bar" />
    <input type="submit" name="submit" id="submit" value="Submit" /> </form>
<span style="color: #333;">Search for the name of the location, ie: Devils Den or USS Oriskany.</span><br />   


<?php 
if (isset($_POST['submit'])) {

if ($rowcount == 0)  
{
echo "Sorry, but we can not find an entry to match your query: <strong>$searchterm</strong>";
}
else { //this tells the table below to display since $totalRows_Products_res is not 0
?>
<table style="font-size: 14px;" border="0" width="650">
 <tr>
  <td colspan="6"><p>You searched for <strong><?php echo $searchterm; ?></strong>. Results are displayed below.</p></td>
 </tr>
<tr>
  <td><strong>Location Name</strong></td>
  <td><strong>City</strong></td>
  <td><strong>State</strong></td>
  <td><strong>Depth (ft)</strong></td>
  <td><strong>Fees</strong></td>
  <td><strong>Gear Rentals</strong></td>
  <td><strong>Map</strong></td>
 </tr>
 <?php do { ?>
  <tr>
   <td><a href="loc_details.php?loc_id=<?php echo $row ['loc_id']; ?>">
<?php echo $row ['loc_name']; ?> </a></td>
<td><?php echo $row ['loc_city']; ?></td>
<td><?php echo $row ['loc_state']; ?></td>
<td><?php echo $row ['loc_depth']; ?></td>
<td>$<?php echo $row ['loc_fee']; ?></td>
<td><?php if($row['loc_gear'] == 1) {
echo 'Yes';
} else { echo 'No'; } ?></td>
<td><a href="http://maps.google.com/maps?q=<?php echo $row ['loc_lat'];?>,<?php echo $row ['loc_lon'];?>" target="_blank">View Map</a></td>
   </tr>
  <?php } while ($row = mysqli_fetch_assoc($r)); ?>
</table>
<?php 
mysqli_free_result($r); 
} // this closes out results else
}
?>

I figure I can use the below query to get the results.
Code: [Select]
select * from table WHERE id >  ((SELECT MAX(id) from table) - 10);I'm just not sure how I can display them by default and then have them be replaced by the search results.  Anyone have any ideas for me? As always I appreciate the help as I continue to learn this beast.

I'll walk you first through what is working:

<?php echo($user['biz_site'] != '' ? "<h4>Web Site</h4>" . $user['biz_site'] : ""); ?>


In a results page, the code renders something that looks like:
Quote

Web Site
http://www.somecoolsite.com


What I'd like instead is something like this:
Quote

Web Site
Visit Site


...where the "visit site" links to the site.  I'm trying to address a problem of some sites, especially government sites, having 75+ character-long addresses, which messes up the finite space I have allotted for site addresses.

Everything I've tried thus far has rendered blank white pages.

(the original code posted up top does not produce a hyperlink)