Member Avatar

ok, so i am writing a program for my client.
i have a thing where they can view all of their clients.
I have it listed where their clients names are listed.
How do i make it so when they click on thir clients names, it calls their id from the members table?

Member Avatar

if you are listing all clients names from members table then pass member table id as parameter in java script on click function, which is not difficult.
like

<a href="javascript:showuser('<?php=$clicnt_id;?>');"><?php=$client_name;?></a>

The $client_id and $client_name are the variables contains proper values fetched from database table.

If this is not your requirement then post your code or come up with clear information.

Member Avatar

Where the clients (name,id, etc.) information stored? I mean are you used mysql database?

Member Avatar

ok, what i want to do is be able to click on their name and have it show all of their user information. the table rows are id, name, lname, pass, zip, customer type,

Member Avatar

Try this query.

<?php
 
   $query = mysql_query("SELECT * from table_name");
   while($result = mysql_fetch_array($query))
   {
     echo "<a href='some_page.php?id=$result[id]'>".$result['name']."</a>"."<br/>";
   }


?>

and here's the code for some_page.php

<?php
    $id = $_GET['id'];
    $query = mysql_query("select * from tbl_name where id='".$id."'");
    while($result = mysql_fetch_array($query))
    {
      echo $result['id']."<br>";
      echo $result['name']."<br>";
      echo $result['lname']."<br>";
      echo $result['pass']."<br>";
      echo $result['zip']."<br>";
      echo $result['customer_type']."<br>"; // although "customer type" should have "_" and the database right?
    }
?>