[RESOLVED] php loop, how to take each result to their own 'single' page

rpsep2

I have a php query which loops all the results ( which are image, title, username, rating)

question is, how would i go about making it so that when you click one of the results, it would take you to a 'single' page ( like a single post page in wordpress) solely for that exact result.

I have a working demo atm, which does all of the above except when you click one of the results it takes you to the image filepath, not its own individual page at: http://www.creative-spotlight.com/dynamic-site/start-page/display-most-recent2.php

code snippet how it looks at the moment to display these results:



 <a href="<? echo $query['filepath']?>"><div id="mainWindow">
 <div id="image"><img src="<? echo $query['filepath']?>" class="image"/></div> 

 <div id="smallInfo">
 <div id="smallTitle"><? echo $query['title']?></div>
<div id="smallUsername">by <? echo $query['username']?></div>
 <div id="smallRating">rated <? echo $query['rating']?></div>
 </div>
 </div></a>

I tried googling and stuff but the questions pretty long winded! does anyone have any resources they can point me to which would help with this?

bradgrafelman

Just create a link to a script and include in the query string some unique ID value that would identify the data in the DB. That script would then retrieve the data based on that ID value.

m_tt

The same question was asked here, this may be helpful.

http://www.phpbuilder.com/board/showthread.php?t=10384058

rpsep2

so close..!

okay so now i have:


?>
    $FILEPATH = $query['filepath']; 
	?>

 <a href="viewArticle.php?FILEPATH=<? echo $FILEPATH?>"><div id="mainWindow"> 
 <div id="image"><img src="<? echo $query['filepath']?>" class="image"/></div> 

 <div id="smallInfo">
 <div id="smallTitle"><? echo $query['title']?></div>
<div id="smallUsername">by <? echo $query['username']?></div>
 <div id="smallRating">rated <? echo $query['rating']?></div>
 </div>
 </div></a>

on my multiple display page, and then


 <?php

$FILEPATH = (int) $_GET['FILEPATH'];

$result = mysql_query("SELECT * FROM uploads WHERE filepath=$FILEPATH");//
$row= mysql_fetch_array($result);

  ?>
     <div id="mainWindow">

 <div id="image"><img src="<? echo $row['filepath']?>" class="image"/></div>
  <div id="smallInfo">
 <div id="smallTitle"><? echo $row['title']?></div>
<div id="smallUsername">by <? echo $row['username']?></div>
 <div id="smallRating">rated <? echo $row['rating']?></div>
 </div>
 </div>

on my viewArticle page. it works.. kind of. the browser displays the correct url in the url bar for the image you click.. yet displays the wrong info, infact it always displays the same picture and info no matter what one you click on to view in its single post page.

im guessing theres something wrong with my query but I cant work it out!

EDIT: the query appears to be just selecting the first row of data in the database, and not selecting the row where the filepath matches, but i cant figure out the query

rpsep2

figured it out... some reason it didn't like that i was using the filepath so i added an 'id' field to my table and used that instead, works perfectly now 🙂

Derokorian

3 reasons why filepath wasn't working:

You are type casting it as int, so it will most likely become 0 unless it starts with a number (then everything from the first non-numeric character on will be lost).
You aren't enclosing what is expected to be a string (if it wasn't type cast, see previous) in single quotes inside your query. All strings need to be contained in single quotes.
You should use [man]urlencode[/man] when outputting the filepath to be part of the query string, otherwise parts of it may be lost.