PHP Mysql Example

I need a script made so i can use it as an example that I can use to code other pages with similar needs. I need this today. So bid now if you can do it this NOW!

I have a drop down menu that gets its values from a Mysql database and table called via. What I want to do is once someone chooses the company they want it will give me the phone number and email that is in the database for that company on the same page. here si what I got so far. The menu is getting the Company name form the table but I can not get it to show the specific Company Phone Number and Email for that company. All I can get is the first entry in the table called via. But I need it to change to show the company that is chosen by the dro down menu.

This what I have - I am trying to learn basic things so I need soem help with this..


$dbhost = "localhost";

$dbname = "name";

$dbuser = "user";

$dbpass = "pass";



$sql="select * from via";


$zeile = mysql_fetch_array($result);


<form action="<?=$_SERVER['PHP_SELF']?>" method="post">


$query5 = "select * from via ORDER BY Customer_Company";

echo "<select name=\"Customer_Company\">";

$result5 = mysql_query($query5);

echo "<OPTION selected>$Customer_Company";

while ($row=mysql_fetch_array($result5))



echo "<option>$Customer_Company";


echo "</select>";


<br />

<input type="submit" name="button" id="button" value="Search by Customer Name" /></form>

//Then I want to have it add to my html page the Phone number and email on the same page below it.//

Customer Phone Number: <?php echo "$zeile[Customer_Phone_Number]" ?>

Customer Email: <?php echo "$zeile[Customer_Email_Number]" ?>

// this entry works but only shows the first record in the table I need it to show the Phone and Email for the company that was selected from the drop down.//

Stephen Bryant

Kemahiran: PHP

Lihat lagi: php mysql example, mysql example, php mysql examples, samples php mysql forms, example mysql project, php mysql example project, select mysql example, php mysql sql example, mysql php example, what php can do, php form search mysql database, php code search mysql database, mysql customer database, learn works, learn what works, learn sql, i want to learn php, customer database php mysql, mysql php order form sample, php select show page, select example php exemple, php example, mysql php example select table, complete php mysql samples, mysql php example project

Tentang Majikan:
( 22 ulasan ) LaFargeville, United States

ID Projek: #373812

Dianugerahkan kepada:


It's done, please check your PMB for see it working. Thanks. Leo.-

$30 USD dalam 0 hari
(105 Ulasan)

9 pekerja bebas membida secara purata $32 untuk pekerjaan ini


quick pro help

$50 USD dalam sehari
(757 Ulasan)

I can help you. I can write code to show "phone" and other details.

$30 USD dalam sehari
(1531 Ulasan)

Please check PMB. jexplorer

$30 USD dalam 0 hari
(170 Ulasan)

Hello. Let me help you. Pls, check PMB. Thnx.

$30 USD dalam 0 hari
(215 Ulasan)

Ready to start! Please check PMB

$30 USD dalam sehari
(35 Ulasan)

Will complete quikcly.

$30 USD dalam 0 hari
(29 Ulasan)

I can do this

$30 USD dalam sehari
(26 Ulasan)

Hello. I will do my best to help you. Thanks.

$30 USD dalam sehari
(23 Ulasan)