[search and view in php and mysql]

how do i do that

do you have any ideal how i can do this i tried this code

<?php

$username  = "webuser";

$password = "";

$database = "collinsdemo";

$server = "intranet";

 

 

$db_handle = mysql_connect($server, $username, $password);

$db_found = mysql_select_db($database, $db_handle);

 

 

 

$result = mysql_query("SELECT * FROM contacts");

 

echo "<table border='1'>

<tr>

<th>Firstname</th>

<th>Lastname</th>

</tr>";while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['firstName'] . "</td>";

  echo "<td>" . $row['lastName'] . "</td>";

  echo "</tr>";

  }

 

?>

 

but it doesnt show me no data

[search and view in php and mysql]

i have created a php form and 5 database table

i can use the form which has various sections to input data from the form into the 3 table

 

 

what i want now is have a search page that i can type a search word into and it shows me the records of what i have got from the database

 

eg

 

name,last name is in table1

address, postcode in tabel2

businesstype, equipment in table3

 

 

i want to type in say john as a firstname it give me all the john details from table1-3 but in a short form then when i click view tab i can see more detail about john in a page

[]I need help creating a multistep DATA input page in php & mysql environment.]

its a  form of customer relation managemnet systems,

 

for a my work

sales man take a form to the client to fill out once that has been filled out i need to enter those detail unto the system using a form to store thos detail unto my database

 

and eas part of the form has the own databse table like page 1- page 5

 

so i have 4 tables in my database,

 

i created one but the form is too long

[]I need help creating a multistep DATA input page in php & mysql environment.]

]I need help creating a multistep DATA input page in php & mysql environment.

i can only create a single form that input data into one database table

 

what am trying to achieve is

create a php page that can input data into more than one database table

 

this is in form of a registration page where the user can click on the first page they fill that out then click on the next link that say page 2 then fill that out then do so for up to 5 pages the last page wil have the summit button

 

each php page has their own database table, page1 data get store on page1 database table and so on with the rest page

 

 

can any body help me