Link on each record

[nyah_RMC]

nyone can tell me how can i put a link on my AuthorName results so when i try to click it and call another .php file it will display the whole contents of that particular record?

$result = mysql_query ("SELECT * FROM tblAuthor WHERE AuthorName LIKE '%$bsearch%'"); 
  $total_records = mysql_num_rows($result);
  echo "<table>";
  echo "<tr><td><B>Author Name</B><td><B>Author ID</B></tr>";
  while ($row = mysql_fetch_array($result))
  {
  echo "<tr><td>";
  echo $row["AuthorName"];
  echo "<td>";
  echo $row["AuthorID"];
     }
  echo "</table>";
  }
  echo "<p>";
  echo "Total records found!:  ".$total_records."</p>"; 

[The Hobo]

  $result = mysql_query ("SELECT * FROM tblAuthor WHERE AuthorName LIKE '%$bsearch%'"); 

  $total_records = mysql_num_rows($result);

  echo "<table>";
  echo '<tr>
      <td>
          <B>Author Name</B>
      </td>
      <td>
          <B>Author ID</B></td>
  </tr>';

  while ($row = mysql_fetch_array($result))  {
      echo '<tr>
          <td><a href="page.php?id=' . $row["authorID"] . '">' . $row["AuthorName"] . '</a></td>';
      echo '<td>' . $row["AuthorID"]. '</td>';
  }
  echo "</table>";
  }//Where does this come from?

  echo "<p>";
  echo "Total records found!:  ".$total_records."</p>";

Then in your page.php, have it run a sql query like this:

$result = mysql_query ("SELECT * FROM tblAuthor WHERE AuthorID='$id'");

And run through the info like you are above.

[nyah_RMC]

hey thanks hobo it works!...but ive come to change the whole code...i just download this code...i hope you can help me out too..

{who ever owns the code please inform me so I can give u the credit you deserve}

<?php
/// connect to database
    $global_db = mysql_connect('localhost', 'scidev', 'scidev');
    mysql_select_db('scidev', $global_db);
    // query to get the number of records
    if ($select == "Author") {
    $query = "SELECT AuthorName FROM tblAuthor WHERE AuthorName LIKE '%$bsearch%'";
    $result = mysql_query($query) or die("MYSQL Connection Failed!");
    $num_record = mysql_num_rows($result);
    if($num_record > $display) { // Only show 1,2,3,etc. when there are more records found that fit on 1 page
    // when the page is loaded first...
    if(empty($page)) { 
    $page = 1;
    }
    // some variables
    $display = 10; // number of records to display per page
    $max_pages_to_print = 7; // number of pages to show, if you change this you also have to change the variable 'middlenumber', for example:increase this one with two, increase middlenumber with one
    $startrecord = $page * $display; // first record to show from the queryresult
    $num_pages = intval($num_record / $display) + 1; // total number of pages
    $loopcounter = 0; // counter for whileloop
    $currentpage = $page; // Page where we are at the moment
    $middlenumber = 3; // Number will be decreased from variable currentpage in order to get the currentpage always in the middle
    $colourcounter = 0; // Variable to change the background-color of the <td>
    $i = 1; // variable that will print 1,2,3,etc..
    $x = 0; // variable i use to put always the current, marked page in the middle
    // actual stuff starts here
    print("<table border=0 align=center><tr>");
    if($currentpage >= $max_pages_to_print) {
    print("<td><a href=\"$PHP_SELF?page=1\">First</a>...</td>");
    }
    //BEGIN LOOP
    while($loopcounter < $max_pages_to_print) { 
    if($currentpage >= $max_pages_to_print) { // If user clicks om page higher than $max_pages_to_print
    // Mark current page
    if($currentpage == $i) {
    print("<td>$i  </td>"); // print pagenumbers
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    }
    // End marking
    if($i > $num_pages) { // if last page has been printed, exit loop
    break;
    }
    if($x == 0) {
    $i = $currentpage - $middlenumber; // current page will always be printed in the middle
    }
    print("<td><a href=\"$PHP_SELF?page=$i\">$i</a>  </td>"); // print pagenumbers
    $x = $x + 1;
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    }
    else { // Else user clicks on a pagenumber lower $max_pages_to_print
    // Mark current page
    if($currentpage == $i) {
    print("<td>$i  </td>"); // print pagenumbers
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    }
    // End marking
    if($i > $num_pages) { // if less than $max_mages_to_print, exit loop
    break;
    }
    print("<td><a href=\"$PHP_SELF?page=$i\">$i</a></td>"); // print pagenumbers
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    } // End if
    } 
    // END LOOP
    if(($num_pages > $max_pages_to_print AND // notice the user that there are more pages
        $i <= $num_pages)) {
    print("<td>...<a href=\"$PHP_SELF?page=$num_pages\">Last</a></td>");
    }
    print("</tr></table>");
    $startrecord = $startrecord - $display; // Set startrecord to the right position
    // Some calculation for the lastrecord
    if($currentpage == $num_pages) { // Last page...
    $lastrecord = $num_record; // so $lastrecord = $num_record
    }
    else {
    $lastrecord = ($currentpage * $display);
    }
    } // End of the first if-statement
    // Some info
    print("<table align=center>
    <tr><td>You are now on page $currentpage</td></tr>
    <tr><td>There are $num_pages pages in total</td></tr>
    <tr><td>$num_record records are spread over $num_pages pages</td></tr>
    <tr><td>Current display : $startrecord - $lastrecord</td></tr>
    </table>");
    // End info
    // actual query, watch the end($startrec
    //     ord, $display)
    $query2 = "SELECT AuthorName FROM tblAuthor WHERE AuthorName LIKE '%$bsearch%' LIMIT $startrecord, $display";
    $result2 = mysql_query($query2) or die("ERROR");
    // print results on screen
    print("<table border=0 align=center width=300 bgcolor=#0E711D cellpadding=\"2\" cellspacing=\"1\"><tr><td><font color=#FFFFFF><b>Author Name</b></font></td></tr>

    while(list($AuthorName) = mysql_fetch_row($result2)) {
    if ($colorcounter == 0) {
    $colorbg = "#ECE28B";
    }
    else {
    $colorbg = "#F4EFC1";
    $colorcounter = $colorcounter - 2;
    }
    print("<tr><td bgcolor=$colorbg>$AuthorName</td></tr>           $colorcounter = $colorcounter + 1;
    }
    print("</table>");
 }
    ?>

could you help me how can I put links on the AuthorName query results? i tried ur code here too, but i really dont know how to revised it..im just new to php...hope u can help me out

[The Hobo]

Just to let you know, code is A LOT easier to read when it's properly spaced out. And it would make me more anxious to help...but since I'm a nice guy, I'll give it a try anyways:

while(list($AuthorName) = mysql_fetch_row($result2)) {
    if ($colorcounter == 0) {
        $colorbg = "#ECE28B";
    } else {
        $colorbg = "#F4EFC1";
        $colorcounter = $colorcounter - 2;
    }
    print('<tr><td bgcolor=$colorbg><a href="YOUR_PAGE.PHP?id=' . $AuthorID . '>' . $AuthorName . '</a></td></tr>');
    $colorcounter = $colorcounter + 1;
}

[nyah_RMC]

oopppss..sorry about that! hey it works, but i got some problem...the row colors turned to blue! and as i query the 4th record shows this:

<a href="basic_view.php?Authorid=>wilkins

and also it didnt return the correct record searched!

let me show it:

this is my previous code. this is wat it shows after i execute my query (without the links)..

1
You are now on page 1
There are 1 pages in total
7 records are spread over 1 pages
Current display : 0 - 7
Author Name
jollibee
Koala
Leah
Leny
Leon
lola
wilkins

and this is wat it returned after i adopted ur print code:

1
You are now on page 1
There are 1 pages in total
7 records are spread over 1 pages
Current display : 0 - 7
Author Name
Koala
Leny
lola
<a href="basic_view.php?id=>wilkins

wats wrong with this?

[nyah_RMC]

mmmm...nobody seems to know what's wrong!