[thelist] running a mysql query after receiving the php $_GET var.

Joshua Hmielowski jhmielowski at comcast.net
Sun Oct 5 13:22:29 CDT 2003


	what I  have is a database path as an image on one page (catalog.php).
there is  link surrounding each image that directs and sends the global  
var, 'id' to another page (details.php).
		
what I am trying to figure out is how to query all of the other  
information in that table of the "id" selected and
display it. I am not really sure how to use this variable sent within  
the query.

thanx
Josh


QUERY ON PAGE ONE.

  <?  do {  ?>

  <a href= "details.php?id=<?php echo $row_Recordset1['id']?> "><img  
src="<?php echo    			$row_Recordset1['thumbpath']; ?>"></a>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));

------------------------------------------------------------------------ 
-------------------------------------------------------

TRYING TO USE THE VARIABLE 'ID' TO QUERY OTHER INFO ABOUT ID SELECTED..

<?php
if(isset($_GET['id'])) {
	
	echo $row_Recordset1[$_GET['id']];  }
  	  


More information about the thelist mailing list