Hello Myro
I have copied this from some of my code i think this is an example that you want. From 
one WHILE loop i list all that my SQL statement has found then within the HREF 
statements i include the variables that i want to be used by the page that i link to.

I hope this is not confusing, im still learning myself so my explanations are not the 
greatest. Let me know if this helps.
Mike
*******
while($user = mysql_fetch_array($result) ) {
$dcolor = ($a == 0 ? $dcolor_A : $dcolor_B);

echo "<td bgcolor=\"$dcolor\"><font color=\"#000000\">";

if ($pictext != "P") {
   echo "<a 
href=\"modules.php?op=modload&amp;name=$module_name&file=$programname&pic=$user[fname]&amp;letter=$letter&amp;pictext=$pictext&amp;sortby=$sortby&amp;media=$media&amp;catalogue=$catalogue&amp;page=$page\">";
   echo "<img src=\"modules/$module_name/thumb/$user[fname].jpg\" style=\"border: 2 
solid #FFFFFF\"></font></td>\n";
   echo "<td bgColor=\"$dcolor\" valign=\"top\"><font 
color=\"#000000\">$user[name]</font></td>";
   echo "<td bgColor=\"$dcolor\"><A 
HREF=\"modules.php?op=modload&amp;name=$module_name&file=ecard&pic=$user[fname]&amp;letter=$letter&amp;pictext=$pictext&amp;sortby=$sortby&amp;media=$media&amp;catalogue=$catalogue&amp;page=$page\">
 Ecard </a></td>";
}

echo "<td bgcolor=\"$dcolor\"><font 
color=\"#000000\">$user[place]</font>&nbsp;</td>\n";

echo "<td bgcolor=\"$dcolor\"><A 
HREF=\"user.php?op=userinfo&amp;uname=$user[uname]\"><font 
color=\"#000000\">$user[uname]</font></a>&nbsp;</td>\n";

echo "</tr>";
$a = ($dcolor == $dcolor_A ? 1 : 0);

}
******

  ----- Original Message ----- 
  From: news.uni-mannheim.de 
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, September 11, 2001 9:44 AM
  Subject: [PHP-DB] getting a details-page


  Hello

  I have a problem:
  with a mysql_query I get the results of a table field into a list page.
  Is it possible to use this result (as link) to open a new page where the
  detailed results of each row are shown?

  thx

  Myro



  -- 
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]
  To contact the list administrators, e-mail: [EMAIL PROTECTED]



Reply via email to