tcollins412 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?
Shanti C 106 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.
lyrico 23 Where the clients (name,id, etc.) information stored? I mean are you used mysql database?
tcollins412 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,
lyrico 23 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?
}
?>