A strange problem.

[sujith787]

hai
i have a mysql table named customer:

s.no name phone
----------------------------------
100 sam 2453
210 george 5637
98 mark 7382


i have a page name index.php
it displays s.no of the customer table like this


The source code is:
--------------------
<a href="phone.php">100</a>
<a href="phone.php">210</a>
<a href="phone.php">98</a>

ie output is
--------
100
210
98


phone.php page is simple. its displaying the phone number of clicked customer.
if a user click 100 phone.php should display 2453. (ie phone of s.no 100)
if a user click 98 phone.php should display 7382 (ie phone of s.no 98)


how can i do this.

[tech_support]

You can use SELECT... to do this.

Here's a good place to start.
http://www.php-mysql-tutorial.com/

[sujith787]

thank you tech_support.
select option is a good choice.

but with out using any form i want to solve this problem. using forms, using select option all r working fine

withour using this forms i want the solution.

[thetestingsite]

Make your links like so:

<a href="phone.php?id={id_of_customer}">{id_of_customer}</a>

Then in phone.php make it look something like so:

<?php
 require('connection.php'); //database connection

$id = $_GET['id'];

 $info = mysql_query("SELECT * FROM `customers` WHERE `s.no`='$id'");
 if (mysql_num_rows($info)) { //if found in table
   while ($qry = mysql_fetch_array($info)) {
?>
  Customer Name: <?php echo $qry['name'];?> <BR>
  Phone Number:  <?php echo $qry['phone'];?>
<?php
   }
 }
?>

Hope this helps.

[sujith787]

thank you mr.thetestingsite.

i got the solution from your code.

thank you verymuch.

[tech_support]

thank you tech_support.
select option is a good choice.

but with out using any form i want to solve this problem. using forms, using select option all r working fine

withour using this forms i want the solution.

I was talking about MySQL Select....