Link

[sanchez77]

Hi Everyone,

 

So I am building a page that list records from a table, in this case customers, and I want to the printed last name (lname) of the record to be the link to the a detail php page that displays the detailed record. Any suggestions on how to do that?

 

Here is what I'm using now. I don't like the button look, that's why i'm trying to make a link. Any Suggestions?

 

Thanks

 

<? 
session_start(); 
include 'menu.php';
  include ("include/connect.php");
  
// how many rows to show per page
$rowsPerPage = 10;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$sql = @mysql_query("SELECT * FROM customer ORDER BY id LIMIT $offset, $rowsPerPage");
$id = '';

echo "<table border='0' align='center'><tr><td align='left' colspan='2'>Last Name</td><td align='center'>Location</td><td align='right'>Date Posted</td></tr>";
while ($row = mysql_fetch_array($sql))
{

if ($id != $row['id'])
{
echo "<tr><td><form action='customerdetail.php' method='post'><input type='hidden' name='locationp' value='{$row['location']}' /><input type='hidden' name='titlep' value='{$row['title']}' /><input type='hidden' name='idp' value='{$row['id']}' /><b><font size='4'><input type='submit'  value='{$row['lname']}'></font></b></form></td><td> </td><td align='center'><b><font size='4'>{$row['location']}</font></b></td><td align='right'><b><font size='4'> {$row['datep']}</font></b>   </td></tr><tr><td colspan='4'> </td></tr>";
$id = $row['id'];
}
}
echo "</table>";


// how many rows we have in database
$query   = "SELECT COUNT(id) AS numrows FROM customer";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Prev]</a> ";

   $first = "<br><center> <a href=\"$self?page=1\">[First Page]</a> ";
} 
else
{
   $prev  = ' '; // we're on page one, don't print previous link
   $first = '<br><center> '; // nor the first page link
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\">[Next]</a> ";


   $last = "<a href=\"$self?page=$maxPage\">[Last Page]</a></center> ";
} 
else
{
   $next = ' '; // we're on the last page, don't print next link
   $last = ' </center>'; // nor the last page link
}

// print the navigation link
echo $first . $prev . 
" Showing page $pageNum of $maxPage pages " . $next . $last;


// and close the database connection
mysql_close($con)

// ... and we're done!	  	  
  ?>

[volatileboy]

'<a href="page.php">' . $row["lname"] . '</a>';

 

Is that what your asking about?

[sanchez77]

No, I want the link to pass the value lname to the page.php so the page.php can return the record of the lname.