PHP - Taking Php To The Next Step

Hi all,

I've been trying to create a page whereby a user enters a few details which is then emailed, but I'm seriously stuck on one issue.

First page - console type
Second page - serial number

Only two steps at the moment as I need to figure it out.  I'm passing everything into a variable from a post(ed) form.  It appears on the next page fine, as I've been testing, but the details entered on the first page don't show on the third, however, the details from the second page do!  Here is the code I have:

Code: [Select]
   <?php switch ($step) { 
   case "1": ?>
   <table width="75%" align="center">
   <tr>
   <td colspan="2" valign="top">
   <form action="?step=2" method="post" id="consoletype">Please select your console type<br /></td></tr>
   <tr><td align="center" valign="top" width="50%">
<label>Xbox 360 Original (Beige or Black)<br /><img src="images/xbox360orig.gif" width="250" height="250"><br /><input class="button" type="radio" name="console" value="xboxorig" /></label></td>
<td align="center" valign="top" width="50%"><label>Xbox 360 Slim<br /><img src="images/xbox360slim.gif" width="250" height="250"><br /><input type="radio" name="console" value="xboxslim" /></label></td>
    </tr>
    <tr>
    <td colspan="2">
   <input type="submit" value="Next">
   </form>
   </td>
   </tr>
   </table>
   <?php echo $code; 
   include("footer.php");
   echo $code2;
   include("compat.php");
   echo $code3;   
   case "2":
   $console = $_POST['console'];
   echo $console; ?>
   Please enter your Xbox 360 Serial Number:<br />
   <form action="?step=3" method="post">
   <input name="serialno" type="text" size="20" maxlength="20">
   <input type="submit" value="Next">
   </form>
   <?php echo $code; 
   include("footer.php");
   echo $code2;
   include("compat.php");
   echo $code3;
   case "3":
   echo "<br />";
   $serialno = $_POST['serialno'];
   echo $serialno;
   echo $console;
   echo $code; 
include("footer.php");
echo $code2;
include("compat.php");
echo $code3; } ?>
I do understand it's messy at the moment but I don't see much point beautifying everything until I can solve this problem!

Cheers!

Hey guys,

I have checked in google and on this forum for answers to my question but haven't found anything regarding validating each step of a multipage form, hence my post!

I wonder if anyone can help me, or rather provide me with advice....

I am trying to create a multipage form, which so far i have done a basic one which i have done using my php cookbook by O'Reilly which is a very basic version, without any validations or anything....

My multipage has 3 steps:
Step1: user details - takes users name, email etc Step 2: House details - Takes users address, house type, no of rooms, descriptions of rooms etc Step 3: Image upload - Allows user to upload 3 images max to display (using my original file upload script)
As i said, my basic multipage form works, storing all posted values into sessions which can then be outputted at the end in a review page, which will be at the end of the form.

In previous forms i have created, i always have an html form, which when posted or submitted, has an action of a separate php script which processes the form and validates it, sends email, updates database etc, and all errors are then stored in sessions and appear back on the form page until there are no errors displayed and then a success page is shown....

so the code i have taken from my cookbook doesn't seem to be able to allow me to validate EACH STEP of the form? it can validate at the end, when the user reviews and then the form is processed all in one go. But i want to be able to validate form entries at each step, rather than in one go.
For example if a user leaves their 'town' field empty, an error message will be displayed before going to the next step...

If you see the code i have done so fare below:
Code: [Select]
<?php
                //Figure out what stage to use
                if (($_SERVER['REQUEST_METHOD'] == 'GET') || (! isset($_POST['stage'])))
                {
                    $stage = 1;
                }
                else
                {
                    $stage = (int) $_POST['stage'];
                }
                
                //Save any submitted data
                if ($stage > 1)
                {
                    foreach ($_POST as $key => $value)
                    {
                        $_SESSION[$key] = $value;
                    }
                }
                
                if ($stage ==1)
                {?>
                <div id="submitCustomerForm">
<FORM ACTION='<?php echo $_SERVER['SCRIPT_NAME'] ?>' method='post'>
                    <h7>Your details</h7>
                        <br />
                    <div id="inputfield">
                    <label class="textleft" for="forename">forename:</label>
                            <input class="fade" name="forename" type=text size="30" align="right" maxlength="15" id="forename" value="<?php echo $_SESSION['forename']?>">
                    </div>
                        <div id="inputfield">
                    <label class="textleft" for="surname">surname:</label>
                    <input class="fade" name="surname" type=text size="30" maxlength="15" id="surname" align="right" value="<?php echo $_SESSION['surname']?>">
                    </div>
                    <div id="inputfield">
                    <label class="textleft" for="email">email:</label>
                    <input class="fade" name="email" type=text size="30" maxlength="30" align="right" id="email" value="<?php echo $_SESSION['email']?>">
                    </div>
                        <br />
                        <h7>Your property Address</h7>
                        <br />
                    <div id="inputfield">
                        <label class="textleft" for="address1">Address Line 1:</label>
                        <input class="fade" name="address1" type=text size="30" maxlength="30" id="address1" value="<?php echo $_SESSION['address1'];?>" />
                        </div>
                        <div id="inputfield">
                        <label class="textleft" for="address2">Address Line 2:</label>
                        <input class="fade" name="address2" type=text size="30" maxlength="30" id="address2" value="<?php echo $_SESSION['address2'];?>" />
</div>
                        <div id="inputfield">
                            <label class="textleft" for="town">Town/City:</label>
                            <input class="fade" name="town" type=text size="30" maxlength="30" id="town" value="<?php echo $_SESSION['town'];?>" />
                        </div>
                        <div id="inputfield">
                            <label class="textleft" for="county">County:</label>
                            <input class="fade" name="county" type=text size="30" maxlength="30" id="county" value="<?php echo $_SESSION['county'];?>" />
                        </div>
                        <div id="inputfield">
                            <label class="textleft" for="postcode">Post Code:<span class="asterix">*</span></label>
                            <input class="fade" name="postcode" type=text size="30" maxlength="30" id="postcode" value="<?php echo $_SESSION['postcode'];?>" />
                    </div>
                        <input type='hidden' name='stage' value='<?php echo $stage + 1 ?>'/>
                        <input name="Next" class="submit" type="image" align ="right" src="Images/updateButton.png" />
                    </FORM>
                </div>
               
                <?php } else if ($stage == 2) { ?>
                <div id="submitCustomerForm">
                <FORM ENCTYPE="multipart/form-data" action="<?php echo $_SERVER['SCRIPT_NAME']?>" method="post">
                <input type="hidden" name="MAX_FILE_SIZE" value="1000000" />
                        <div id="divinputfile">
                            <input name="userfile" type="file" size="30" id="userfile" onchange="document.getElementById('fakeuserfile').value = this.value;"/>
                            <div id="fakeinputfile"><input name="fakeuserfile" type="text" id="fakeuserfile" /></div>
                       </div>
                    <br />
                        <input type='hidden' name='stage' value='<?php echo $stage + 1 ?>'/>
<input type="image" src="Images/upload.png" align="right" name="Send File" />
                    <br />
                    <br />
                 </FORM>
                </div>
               
                <?php } else if ($stage == 3) {?>
                <p class="largeblue">
                hello there <?php echo $_SESSION['forename']; echo $_SESSION['surname'];?>
                    <br />
                    the first line of your address is: <?php echo $_SESSION['address1'];?>
                    <br />
                    the second line of your address is: <?php echo $_SESSION['address2'];?>
                </p>
                <?php } ?>
For the 'form action' it uses Quote

<?php echo $_SERVER['SCRIPT_NAME'] ?>

meaning that the form reloads the page, upon which the stage number has changed and therefore loads next step.
Where as normally, i have the path for my process script which would handle validation etc and then send them to a success screen or back to the form displaying errors.

I propose a few ideas that i could do to get around this, which i just wanted to get a bit of insight on, as to which way of going about this is the right one!!

My first idea would be to treat each step of the form as a separate form almost. Doing a form as i normally do, where the form is on one page, then the completed form is sent to a processing page, which processes the entries, sends user back to  the form page with errors if there are any, or if it is all ok, increase the 'stage number' in a session and then use a header to go to next page(the next step of the form. at the top of each page is a check to whether the stage number is the same as the step number of the form.

OR would i put all my validation in one page, with all the steps of the form as i have at the moment?

OR is there a way to send each step of the form to a process script, which then sends the user back to the original form displaying errors if there are any or then moves them to the next step??

Just a little confused with which method to do this, i dont want to start working on it and find out i have done it completely the wrong way!!

any help would be greatly received, thanks guys!!

Craig

I'm stuck at trying to figure out out to complete the 3 Step scripts to accomplish passing $variables between 2 different servers.  Since there will actually be 12 Non-POST $variables involved in the SERVER #1 to SERVER #2 transfer , it doesn't appear that trying to put these all in a URL string and going the 'GET' route is practical.    I'm just using 3 short test variables in the examples.  My eyeballs started rolling within I ran across something about 'CURL' that might be a necessary part of the solution?   The code I have been able to hammer out so far is below as STEP 1, STEP 2 and STEP 3.    STEP 1

<?php

// submit.php 

// STEP 1

// On (LOCAL) SERVER #1 TO relay $variables to 'process.php' on (REMOTE) SERVER #2

// To submit $variables to directly another destination server script
// NOTE: The $variable are NOT the result of Form Input !!!

// For login Authenticaion ALL 3 must match db entries on SERVER #2 
// NOTE: (Again) The $variables are NOT the result of Form Input !!! 

$userid = "adam";
$passwd = "eve";
$pscode = "peterpan";

// NOTE: (Again) The $variable are NOT the result of Form Input !!! 
// These $variables are needed for MySQL db INSERT on the destination URL server
// For testing simplicity (actual data will be 12 $variables)

$a = "apple";
$b = "banana";
$u = "1234567;

//
// Not sure if something called 'CURL' is needed here ???
//

$submit_to_url = http://www.blahblah.com/process.php";

?>

STEP 2

<?php

// processor.php

// STEP 2

// ON SERVER #2 TO RECEIVE DATA DIRECTLY FROM SERVER #1 'submit.php'

// To receive and process the $variables into a MySQL db on SERVER #2
// NOTE: The $variables are NOT the result of Form Input !!!

// First validate $userid, $passwd & $pscode against `verify` table MySQL records

require '/SERVER_2_securelocation_for_database_connection/secret_mysqli.php';

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

//
// Not sure if something called 'CURL' is needed here ???
//

// These login $variables are from submit.php on SERVER #1

$userid 
$passwd 
$pscode

$sql="SELECT `userid`, `passwd`, `pscode` FROM `verify` 
WHERE `userid` = '$userid'" AND `passwd` = '$passwd` AND `pscode` = '$pscode';

$result = mysqli_query($con,$sql);

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

//
// Then some Authentication code if ALL 3 components match
//

// If Authentication = true then $passed = "YES" must sent
// be sent back to the 'finalstep.php' script on SERVER #1
// If Authentication (or connection) = false ... $passed = "NO" 

$return_to_url = http://www.blahblah.com/finalstep.php";

// These $variables are from submit.php on SERVER #1

$a = "apple";
$b = "banana";
$u = "1234567";

$sql="INSERT INTO `data` (`a`, `b`, `u`) 
VALUES ('$a', '$b', '$u')"; 

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

// If $SQL INSERT into `data` on SERVER #2 works ...
// $status = "Pending" must be sent back to the 'finalstep.php' 
// script on SERVER #1 for MySQL db Table insertion
// If $SQL INSERT into `data` = false, then $status = "Error"
// NOTE: The '$u' $variable also needs send back to finalstep.php !!!

$return_to_url = http://www.blahblah.com/finalstep.php";

mysqli_close($con);

?>

STEP 3

<?php

// finalstep.php 

// STEP 3

// ON SERVER #1 TO RECEIVE DATA DIRECTLY BACK FROM SERVER #2 process.php

// To receive the $passed, $status and $u $variables for final step action
// NOTE: The $variable are NOT the result of Form Input !!!

require '/SERVER_1_securelocation_for_database_connection/secret_mysqli.php';

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// These $variables are from process.php on SERVER #2

$passed
$status
$u

$sql="UPDATE `tracking` 
SET `passed` = '$passed',
    `status` = '$status' 
WHERE `uniqueid` = '$u' ";

$result = mysqli_query($con,$sql);

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

mysqli_close($con);

?>

Thanks very much for any assistance and guidance.   -freakingOUT  

After many, many years of struggling, I would like to finally learn how to separate my website's PRESENTATION from its LOGIC.

I have been working on a startup business for over a decade now.

And one of the reasons it is taking me so long to build my website from scratch is because I am a horribly INEFFICIENT PROGRAMMER!!

On one hand, I think I write solid business logic.  But considering that each of my scripts averages between 1,000-2,000 lines of code, that is a monster to manage.

(My website is over 50,000 lines of code at this point.  All home-grown and hand-coded.)

While it is hard to manage things while I am actively coding, what kills me even more, is when I get pulled away for months (or recently for 2 years), and then later on when I come back, it is a nightmare to load all of that code into my brain?!

I mean if you read any of my scripts starting at line 1 and going through line 1,500 I think it reads pretty well.  But who in the hell can keep track of all of that in one reading?  It's certainly a struggle for me!!

I definitely wantto strive for more of a "component archtecture" approach.

(On a side note, I have heard "good" Object-Oriented programmers claim that if a class is more than 100 lines of code then it is too long?!)

So anyways....

My #1 priority for v2.0 is to learn and master separating my website's PRESENTATION from its LOGIC using something like MVC.

(And after that, my goal is to finally learn and master Object-Oriented Programming, but one thing at a time!!)

I want to finally learn how to program like a *professional* coder.  (A very successful and RICH professional programmer!!!)  ?  

So, can all of you gurus out there, please help me get started with a solid Model-View-Controller introduction and/or resources and/or advice??

I know the Internet is littered with this topic, but like anything done well, you need to find good learning materials and at least one or two good mentors.

After all, if MVC and OOP and whatever were so easy, then everyone would be doing it, and doing it well.  (And of course you realize that very few people actually do things like MVC and OOP well!!)

So my goal is to become a "jedi", but I will need some good teachers to get there...

 

 

Edited February 24, 2019 by SaranacLake
Type-o's and added some more stuff...

Hello,

Is there any way to capture a screenshot of a full length view of a website using php on a shared hosting linux server?

I'm trying to get details of family members to display in a grouped fashion under their family, but for some reason the cell phone (mobile phone) number comes through from the query but not into the variable assignment!?

I've used FirePHP to track the variable assignments and I can see that the value pulls into the query variable $per_Cellphone but not through into the array as it outputs a NULL value!? The Email works fine, just not CellPhone?

$aCellPhone[$iCount] = $per_Cellphone;
$aEmail[$iCount] = $per_Email;

I can add and delete data from my table. Now I need to be able to change one or more fields in an entry. So I want to retrieve a row from the db, display that data on a form where the user can change any field and then pass the changed data to an update.php program.

I know how to go from form to php. But how do I pass the data from retrieve.php to a form so it will display? Do I use a URL and Get? Can I put the retrieve and form in the same program?

Hi i have the following code

Code: [Select]
$orderFetch->order="3";
mysql_query("UPDATE `categories` SET order=order-1 WHERE `order` > $orderFetch->order");

i wish to minus -1 from all the "order" fields in categories that are over a certain value i.e 3. But however this code is not working can anyone tell me where i'm going wrong?

thank you

Hi all,

first of all sorry if this is in the wrong board, im currently building a site which will charge an annual fee of X amount.
I've never build something like this before so Ill be using paypal for ease of use and security, but how would you usually go about constructing the tables etc?

I am trying to adapt a database search form from a tutorial I saw, and it's not working. I just get a blank white slate despite having

error_reporting(E_ALL);


at the top of the page. I was hoping someone might be able to spot anything obvious I might be missing.

Here is my code

<?php
error_reporting(E_ALL);
// include MySQL-processing classes

require_once 'mysql.php';

try{

// connect to MySQL

$db=new MySQL(array
('host'=>'localhost','user'=>'username','password'=>'password',
'database'=>'DBName'));

$searchterm=$db->escapeString($_GET['searchterm']);

$result=$db->query("SELECT last_name, first_name,employee_id,title,territory,districts FROM
Scores WHERE MATCH(last_name,first_name,employee_id,title,territory,districts) AGAINST
('$searchterm')");

if(!$result->countRows()){

echo '<div class="maincontainer"><h2>No results were found. Go
back and try a new search.</h2></div>'."n";

}

else{

// display search results

echo '<div class="maincontainer"><h2>Your search criteria
returned '.$result->countRows().' results.</h2>'."n";

while($row=$result->fetchRow()){

echo '<div class="rowcontainer"><p><strong>First Name:
</strong>'.$row['first_name'].'<p><p><strong>Last Name:
</strong>'.$row['last_name'].'</p><p><strong>Employee ID:
</strong>'.$row['employee_id'].'</p>
<p><strong>Title:
</strong>'.$row['title'].'</p>
<p><strong>Territory:
</strong>'.$row['territory'].'</p>
<p><strong>Districts:
</strong>'.$row['districts'].'</p>
</div>'."n";

}

}

echo '</div>';

}

catch(Exception $e){

echo $e->getMessage();

exit();

}

?>




and here is the included file mysql.php code

<?php

// define 'MySQL' class

class MySQL{

private $conId;

private $host;

private $user;

private $password;

private $database;

private $result;

const OPTIONS=4;

public function __construct($options=array()){

if(count($options)!=self::OPTIONS){

throw new Exception('Invalid number of connection parameters');

}

foreach($options as $parameter=>$value){

if(!$value){

throw new Exception('Invalid parameter '.$parameter);

}

$this->{$parameter}=$value;

}

$this->connectDB();

}

// connect to MySQL

private function connectDB(){

if(!$this->conId=mysql_connect($this->host,$this->user,$this-
>password)){

throw new Exception('Error connecting to the server');

}

if(!mysql_select_db($this->database,$this->conId)){

throw new Exception('Error selecting database');

}

}

// run query

public function query($query){

if(!$this->result=mysql_query($query,$this->conId)){

throw new Exception('Error performing query '.$query);

}

return new Result($this,$this->result);

}

public function escapeString($value){

return mysql_escape_string($value);

}

}

// define 'Result' class

class Result {

private $mysql;

private $result;

public function __construct(&$mysql,$result){

$this->mysql=&$mysql;

$this->result=$result;

}

// fetch row

public function fetchRow(){

return mysql_fetch_assoc($this->result);

}

// count rows

public function countRows(){

if(!$rows=mysql_num_rows($this->result)){

return false;

}

return $rows;

}

// count affected rows

public function countAffectedRows(){

if(!$rows=mysql_affected_rows($this->mysql->conId)){

throw new Exception('Error counting affected rows');

}

return $rows;

}

// get ID form last-inserted row

public function getInsertID(){

if(!$id=mysql_insert_id($this->mysql->conId)){

throw new Exception('Error getting ID');

}

return $id;

}

// seek row

public function seekRow($row=0){

if(!is_int($row)||$row<0){

throw new Exception('Invalid result set offset');

}

if(!mysql_data_seek($this->result,$row)){

throw new Exception('Error seeking data');

}

}

}

?>

I am using this code in my "create_account.php" script...

Code: [Select]
mail($trimmed['email'], ' Please Activate Your Account', $body, 'From: admin@mywebsite.com <admin@mywebsite.com>');

It is taking anywhere from one to several hours to receive this e-mail in my inbox?!

It used to take seconds, and now takes forever.

I thought it was a Gmail or SPAM issue, but I just did a test on my AT&T paid account and the same issue so far...   

It's awfully hard to do development and testing if I have to wait a half-a-day to get these e-mails?!


Debbie

Hi all...

I am facing problems in taking screenshot for the currently open page. What I want is by clicking on a link like "Click for taking Screenshot" the screenshot of that page gets generated, which can be saved further. I have tried by using "imagegrabscreen" & "imagegrabwindow" but both of them results as a big black png image, also searched forums but not able to get the perfect match. If any expert there...then plzzzzz do help me out.... Thank You

Hi all   we have an ajax query which queries a MySQL database for cities around the world for our hotel search.  We are running on a Linux web hosted server.   The problem we are having is when you first visit out site and type in Brisbane or Sydney it takes around 15 seconds maybe to return.  After that what ever city you query is lightening fast.  I have had a few friends try this and when they first visit our site they experience the same then second time around it is fast.   Could this be some sort of caching issue or setting somewhere that I am missing?   I have attached a file so you can see what I mean   Thanks in advance Attached Files  ajaxqry.jpg   169.31KB   0 downloads

I have a small issue here which I can't quite figure out. I have three containers on one page all below each other. One for buttons, a JS image slideshow and a description box. The image slider seems to take up unnecessary space when the browser is resized activating media queries: http://gyazo.com/333...d5668e240fae788 CSS desktop view (without media queries):

body {
background: #141414 url('../images/background1.png');
background-repeat: repeat-y;
background-attachment:fixed;
background-position:center;
}
#container{
height:450px;
width:840px;
margin:120px auto 2% auto;
position:relative;
}
#container2{
height:60px;
width:840px;
margin:0 auto 50px auto;
position:relative;
-moz-box-shadow:0 0 5px 5px black;
-webkit-box-shadow:0 0 5px 5px black;
box-shadow:0 0 5px 5px black;
}
#container2 p{
color:white;
font-size:15px;
padding-left:5px;
}
#container2 h2{
color:white;
font-size: 18px;
text-decoration:none;
padding-left:5px;
padding-top:2px;
}
#img{
height:450px;
width:840px;
position:absolute; 
-moz-box-shadow: 0 0 5px 5px black;
-webkit-box-shadow: 0 0 5px 5px black;
box-shadow: 0 0 5px 5px black;
}
#l_holder{
height:450px;
width:100px;
position:absolute;
left:0px;
top:0px;
cursor:pointer;
}
#r_holder{
height:450px;
width:100px;
position:absolute;
right:0px;
top:0px;
cursor:pointer;
}
.left{
height:50px;
width:50px;
position:absolute;
top:45%;
left:0px;
}
.right{
height:50px;
width:50px;
position:absolute;
top:45%;
right:0px;
}
.clear{
clear:bottom;
}

CSS with media queries, this is where the container is causing a problem:

@media all and (min-width: 3.5in) and (max-width: 10in) {

body {
background: #141414;
}
#container{
height:30%;
width:100%;
margin:5% auto;
padding:0 0 0px 0;
}

#container2{
width:100%;
margin: 0; padding: 0;
}
#container2 p{
padding-left:3px;
}
#container2 h2{
padding:5px 0 0 3px;
}
#container2 .body_black_box{ 
}
#img{
height:80%;
width:100%;
}
#l_holder{
height:80%;
}
#r_holder{
height:80%;
}
.left{
}
.right{
}
.clear{
}
}

Any help is greatly appreciated.

Hi,

I have a searchbar which looks for a value in my tables, it works great but i want to know how i can make the results of the search clickable; go to a page relevent to that search, let me explain in more depth.

User searches for a postcode, script finds and displays the postcode on the next page, user clicks the result postcode to goto the next page.

What im stuck with is how to take that result and automatically display it on the clicked "final" page?

Search script:

Code: [Select]
<?php

// Get the search variable from URL
  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("xxxxx","xxxx","xxxx"); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db("removalspacelogin") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "(SELECT postcode FROM freelistings
             WHERE postcode like '%$trimmed%')         
UNION           
  (SELECT postcode FROM basicpackage              
    WHERE postcode like '%$trimmed%')          
UNION           
  (SELECT postcode FROM premiumuser              
    WHERE postcode like '%$trimmed%')         
  ORDER BY postcode"; // EDIT HERE and specify your table and field names for the SQL query
 
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);
 $result = mysql_query($query) or die("<b>Query:</b> $query<br><b>Error</b>: " . mysql_error());



// If we have no results, offer a google search as an alternative

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

// google
 echo "<p><a href=\"http://www.google.com/search?q=" 
  . $trimmed . "\" target=\"_blank\" title=\"Look up 
  " . $trimmed . " on Google\">Click here</a> to try the 
  search on google</p>";
  }

// 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 for $q";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row['postcode'];

  echo "&nbsp;$title" ;
  $count++ ;
  }

$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 10</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;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

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

<form method="post" action="localarea.php">
<a href="localarea.php"><?php echo "&quot;" .$var. "&quot;</p>";?></a>
</form>
[\code]


The form at the bottom im guessing is where i should take the $var from but how exactly? or if not where should it be pulled from to display on the next page?

I want this "next" page because ideally there would be lots of results in postcode, so the user can choose which one is more relevant to them and go to that specific page with all the companies within that postcode. Hope this helps for a better understanding of what im trying to achieve, its just implementing it in?