December 6th, 2006, 11:48 AM
|
|
Registered User
|
|
Join Date: Jul 2006
Posts: 3
Time spent in forums: 37 m 6 sec
Reputation Power: 0
|
|
Ok...
As an update i have it working
My code is
PHP Code:
<?php
$conn = mysql_connect ("localhost", "******", "******") or die ('I cannot connect to the database because: ' . mysql_error());
$selected = mysql_select_db ("bdct")
or die ("Could not select database");
// PHP Search Script
$sql = "select * from phonebook, where pb_surname = '".$_POST['seek']."' or pb_forename = '". $_POST['seek'] ."' or pb_job_title = '". $_POST['seek'] ."'";
$result = mysql_query($sql,$conn)or die (mysql_error());
if (mysql_num_rows($result)==0){
echo "No Match Found";
}else{
while ($row = mysql_fetch_array($result)){
echo "Name: " .$row['pb_forename']." ".$row["pb_surname"]."<br>";
echo "Job Title: ".$row['pb_job_title']."<br>";
// echo "Department: ".$row['department_name']."<br>";
// echo "Directorate: ".$row['directorate_name']."<br>";
//echo "Site: ".$row['site_name']."<br>";
echo "Phone #: ".$row['pb_tel_ext']."<br>";
echo "Email Address: ".$row['pb_email_address']."<br>";
echo "<br>";
echo "---------------------------------------------------------------------"."<br>";
}
}
mysql_close();
?>
SO i am learning hehe but now i would like to do something more complicated
I have 1 other tables called Sites and in that table is a site_id
Now back in the table phonebook there is a pb_site_id which every record has and that corispondes to the site_id in sites.
How can i get it to go and get the right information from the sites table using the pb_site_id of each record and then echo that out with the the rest of the information.
Please help or advise, i am enjoying learning this 
|
Dev Articles Community Forums Sponsor:
Searching and displaying results from mysql database using PHP
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
