[SOLVED] Search Result with Link

[PHPro]

Could anyone please help about making a search result with links. To be specific, I have a list of names in my database. I want to create a search that will list names with links. Its been 5 hours and cant still figure out how it goes.

 

Thank you

[avvllvva]

Can you explain it more.

[trq]

Links to what? Profile pages?

 

As an example.

 

<?php

$sql = "SELECT id, uname FROM users";
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      echo "<a href='prefile.php?id={$row['id']}'>{$row['uname']}</a>";
    }
  }
}

 

profile.php

<?php

if (isset($_GET['id'])) {
  $id = mysql_real_escape_string($_GET['id']);
  $sql = "SELECT email FROM users WHERE id = $id LIMIT 1";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      $row = mysql_fetch_assoc($result);
      echo $row['email'];
    }
  }
}

[PHPro]

Link to profile

 

Thank you so much Thorpe.Thats exactly what I'm looking for. You refer to this as a pagination right?

thanks again sir!

[trq]

Link to profile

 

Thank you so much Thorpe.Thats exactly what I'm looking for. You refer to this as a pagination right?

thanks again sir!

 

Nope, nothing to do with pagination. Pagination is when you have so many results from one query that you split those results over several pages. Much how this board is split into pages, otherwise this page would need to display something like 150000 records at once.

[PHPro]

I see . thanks again sir!

[snallemap]

Thanks alot