Jump to content

Archived

This topic is now archived and is closed to further replies.

rockonxox

Link to query based on %id, but show on new page w/ just that id's data...

Recommended Posts

Okay, another ? but since it pertains to a different database I'm using a new topic. Click on a link, and you will see that the results show between the previous code... which is expected because I don't know how to do this any other way. Also, when I click on the ID, no info is shown... at least not on the 0_horselist.php link. Don't mind the layout, I'm not worried about looks till I get the queries & all working.

 

Here is the site in it's current state: [a href=\"http://visionseq.com/hfhorses/0_horselist.php\" target=\"_blank\"]http://visionseq.com/hfhorses/0_horselist.php[/a]

What I want it to look like: [a href=\"http://visionseq.com/hfhorses/0_listhorseinfo.php\" target=\"_blank\"]http://visionseq.com/hfhorses/0_listhorseinfo.php[/a]

 

Is this possible?

 

I'm also looking for information on how to let users search my database, so any resources I can look at would rock. I've got the search form, now I just need to figure out how to make it do something!

 

---------

 

Here is my code for 0_horselist.php:

 

 

<?php
include 'horsesearch_connect.php';
include 'opendb.php';

if(isset($showdetails)){ 

  $id=(int)$_GET['showdetails']; 
  
  $result=mysql_query("SELECT * FROM hlist WHERE ID=$id");
  $row=mysql_fetch_array($result);
   
  echo "<center><h3>{$row['title']} {$row['name']}</h3>" .
         "<hr color=black width=25%>" .
         "<font color=grey>#{$row['id']}</font> {$row['year']} {$row['color']} {$row['breed']} {$row['sex']}<br>" .
         "{$row['sire']} x {$row['dam']}" .
         "<hr color=black width=25%><P>" .
         "A Picture would go here<P>" .
         "<table width=80% border=1 bordercolor=white cellpadding=5 cellspacing=0><tr><td bgcolor=black width=40%><center><font color=white><b>Sire Info</b></font></center></td><td bgcolor=black width=40%><center><font color=white><b>Dam Info</b></font></center></td></tr>" .
         "<tr><td>Sire info would go here</td><td>Dam info would go here</td></tr></table><p>" .
         "<table width=80% border=1 bordercolor=white cellpadding=5 cellspacing=0><tr><td bgcolor=black width=40%><font color=white><center><b>Offspring</b></center></font><td bgcolor=black width=40%><font color=white><center><b>Notes</b></center></font></td></tr> " .
         "<tr><td>{$row['progeny']}</td><td>{$row['notes']}</td></tr></table><p>" .
         "<table width=80% border=1 bordercolor=white cellpadding=5 cellspacing=0><tr><td bgcolor=black><center><center><font color=white><b>Show Record</b></font></center></td></tr>" .
         "<tr><td>" .
         "<b>Competes In:</b> {$row['discipline']}<P>" .
         "{$row['showrecordlink']}</td></tr></table>" .
         "<p>" .
         "<table width=80% border=1 bordercolor=white cellpadding=5 cellspacing=0><tr><td bgcolor=black><center><center><font color=white><b>View Photos</b></font></center></td></tr>" .
         "<tr><td>" .
         "Not working, this really sucks!<P>";
}
else{
$result=mysql_query("SELECT * FROM hlist"); 

while($row=mysql_fetch_array($result)){

echo("<tr><td><a href=?showdetails=$id>"."{$row['id']}</a></td>"."<td>{$row['title']} {$row['name']}</td>"."<td>{$row['year']}</td>"."<td>{$row['breed']}</td>"."<td>{$row['sex']}</td>"."<td>{$row['forsale']}</td>"."<td>{$row['canbreedto']}</td>"); 
} 
} 

?>

Share this post


Link to post
Share on other sites

[!--quoteo(post=327441:date=Dec 14 2005, 11:45 PM:name=rockonxox)--][div class=\'quotetop\']QUOTE(rockonxox @ Dec 14 2005, 11:45 PM) 327441[/snapback][/div][div class=\'quotemain\'][!--quotec--]

**Bump**

 

Can anyone help... or do I need to explain myself better? Hopefully it's understandable!!!

 

Your two links give me an HTTP 404...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.