[SOLVED] retreiving mysql data via form problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Cromeium
Forum Newbie
Posts: 2
Joined: Fri Jul 09, 2004 3:15 pm
Contact:

[SOLVED] retreiving mysql data via form problem

Post by Cromeium »

I am trying to use a form to be able to search threw a database and pull out info but I cant seem to get it to work.

When I enter data into the form all it does is show the forms page again.

Any help would be nice.

Here is the code from the php form.

Code: Select all

<form method="POST" name="Search by Camnumber" action="prestigedb-searchby.php">
    <p class="style2" align="center">
    <input name="searchlast" type="text" value="Cam #" size="25" maxlength="12"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
  </form>
Here is the code from the php script

Code: Select all

<?php
$username="username"; 
$password="password"; 
$database="database";

$searchlast=$_Post['searchlast'];

mysql_connect('servername',$username,$password) or die("Could not connect to localhost");
@mysql_select_db($database) or die("Unable to select database");

$query="SELECT * FROM userprestige WHERE camnumber='$searchlast'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$firstname=mysql_result($result,$i,"firstname");                                                                              
$lastname=mysql_result($result,$i,"lastname");                                                      
$camnumber=mysql_result($result,$i,"camnumber");                                                     
$chapternumber=mysql_result($result,$i,"chapternumber");                                                     
$domainnumber=mysql_result($result,$i,"domainnumber");                                                      
$date=mysql_result($result,$i,"date");                                                      
$description=mysql_result($result,$i,"description");                                                      
$category=mysql_result($result,$i,"category");                                                      
$generalprestige=mysql_result($result,$i,"generalprestige");                                                      
$regionalprestige=mysql_result($result,$i,"regionalprestige");                                                      
$nationalprestige=mysql_result($result,$i,"nationalprestige");

echo "<b>Name:$firstname $lastname, Cam#: $camnumber, Chapter#: $chapter, Domain#: $domainnumber, Date: $date, Description: $description, Category: $category, General: $generalprestige, Regonal: $regionalprestige, National: $nationalprestige<br><hr><br>";

$i++;
}

?>

feyd | switched

Code: Select all

to

Code: Select all

tag.[/color]
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

$_POST not $_Post
Cromeium
Forum Newbie
Posts: 2
Joined: Fri Jul 09, 2004 3:15 pm
Contact:

Post by Cromeium »

Wow... Thanks
Post Reply