Help Mysql query link

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
dynastym3
Forum Newbie
Posts: 13
Joined: Sun Apr 05, 2009 2:12 am

Help Mysql query link

Post by dynastym3 »

Im trying to show a list of names or data the matches my mysql query as links and when I click on the name it will show the name of the rows info.

Example
On facebook, when you search for somebodies name it queries the databases for all names that matches the name and list them as links, then when you click on one of the names (which are links) their profile info will show up.
heres my code so far but it will only show the last person info...

$query = "SELECT * FROM $usertable WHERE status = '1'";
$result = mysql_query($query) or die (mysql_error()) ;
$num = mysql_num_rows($result);

<?php echo"You have $num new entrees! <br/>";//shows # of new entrees

while($row = mysql_fetch_array($result))
{
$fname = $row['fname']; $username = $row['username']; $lname = $row['lname']; $email = $row['email']; $number = $row['number']; $street = $row['street']; $city= $row['city'];$zip = $row['zip'];$school = $row['school'];$major = $row['major'] ;

echo "<a href = 'entreeprofile.php'> $fname <br/></a>";

}

$_SESSION['fname'] = $fname;
$_SESSION['lname']= $lname;
$_SESSION['email'] = $email;
$_SESSION['number'] = $number;
$_SESSION['street']= $street;
$_SESSION['city']= $city;
$_SESSION['zip']= $zip;
$_SESSION['school']= $school;
$_SESSION['major']= $major;

///////////////////////////////////////////
mike
randy
charles

when I click on mike and randy info charles info will only show up.
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Re: Help Mysql query link

Post by Bill H »

Better chance for reply when you post database questions in the database forum.
Post Reply