each row has its own page

[Wrenn]

How would I make 1 row from a table have its own page? At: http://venus.lunarpages.com/~planet6/area_pso/query.php you will see two weapons from a query. I'd like to see only one. The file is right below:

<?php
mysql_select_db("planet6_pso")
or exit("Could not select database");

$query = "SELECT * FROM pso_weapons";
$result = mysql_query($query)
    or die("Query failed");

for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
    if (!mysql_data_seek($result, $i)) {
        echo "Cannot seek to row $i\n";
        continue;
    }

    if(!($row = mysql_fetch_object($result)))
        continue;

    echo "<div align=\"center\">\n

<center>\n
<table class=\"forumline\" border=\"0\" cellspacing=\"0\" width=\"800\" height=\"263\"

cellpadding=\"0\">\n
<tr>\n
<td class=\"catHead\" colspan=\"4\" width=\"796\" height=\"21\"> <span

class=\"nav\">$row->weapon_name</span> </td>\n
</tr>\n
<tr>\n
<td valign=\"top\" width=\"792\" colspan=\"4\" height=\"59\"><br>\n
Weapon Type: $row->weapon_type<br>\n\n

    Required $row->weapon_req_type: $row->weapon_req<br>\n\n

    Max Grind: $row->weapon_grind\n\n

  </td>\n
</tr>\n
<tr>\n
  <td valign=\"top\" width=\"32\" height=\"135\">\n
    ATP<br>\n
    DFP<br>\n
    MST<br>\n
    ATA<br>\n
    EVP<br>\n
    LCK\n
  </td>\n
  <td width=\"10\" valign=\"top\" height=\"135\">\n
    +<br>\n
    +<br>\n
    +<br>\n
    +<br>\n
    +<br>\n
    +\n
  </td>\n
  <td width=\"274\" valign=\"top\" height=\"135\">\n
    $row->weapon_atp<br>\n
    $row->weapon_dfp<br>\n
    $row->weapon_mst<br>\n
    $row->weapon_ata<br>\n
    $row->weapon_evp<br>\n
    $row->weapon_lck\n
  </td>\n
  <td width=\"476\" valign=\"top\" height=\"135\">\n
  <table class=\"forumline\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n
    <tr>\n
      <td><img border=\"0\" src=\"equipment_gallery/$row->weapon_img\" width=\"150\" 

height=\"121\"></td>\n
</tr>\n
</table>\n
<p> \n
</td>\n
</tr>\n
<tr>\n
<td valign=\"top\" width=\"792\" colspan=\"4\" height=\"25\">\n
Description: $row->weapon_desc<br>\n
Stars: $row->weapon_star/12<br>\n
\n
</td>\n
</tr>\n
<tr>\n
<td class=\"catHead\" width=\"792\" colspan=\"4\" height=\"15\">\n
<span class=\"nav\">Sightings:</span>\n
</td>\n
</tr>\n
<tr>\n
<td valign=\"top\" width=\"792\" colspan=\"4\" height=\"146\"><br>\n
Section ID: $row->weapon_section_id<br>\n
Area: $row->weapon_found<br>\n\n

  Enemy: $row->weapon_from\n
  <hr>\n
  <p>The following classes can equip this weapon: $row->weapon_use</p>\n\n

  </td>\n
</tr>\n
<tr>\n
  <td class=\"catHead\" valign=\"top\" width=\"792\" colspan=\"4\" height=\"11\">\n\n

  </td>\n
</tr>\n

</table>\n
</center>\n
</div>\n\n

<P>\n
";
}

mysql_free_result($result);

?>

How would I do this?
~don't laugh, eheh. I honestly don't know.

[leatherback]

Hi,

In short: you'd have to add some criterium to your query:

$query = "SELECT * FROM pso_weapons where $WEAPON = $SOME_SPECIFIC_WEAPON";

Then you'd only get the weapons from pso_weapons which are as you identified them in $SOME_SPECIFIC_WEAPON.

So you'd have to tell the page which weapon to display.

I am assuming it is part of some sort of overview of several weapons etc.

You could create an indexlisting on the left:

$query = "SELECT * FROM pso_weapons";
$result = mysql_query($query) or die("Query failed");

// get the results:

while $row = mysql_fetch_array($result)
{
$indexList .= "<a href=\"weaponpage.php?SOME_SPECIFIC_WEAPON=$row[weapon]\">$row[weapon]</a><br>";
}

Then this list would tell the page which weapon you are interested in. Remeber to set a value for $SOME_SPECIFIC_WEAPON for the first time the page is loaded, otherwise the variable will be empty, and the query will result in an empty var.

Hope this helps.

[Wrenn]

Yeah, you have the idea. I almost understand how it works. When I added"where $WEAPON = $SOME_SPECIFIC_WEAPON" it gave me query failed. I put query.php?SOME_SPECIFIC_WEAPON=1 , and it said query failed. I think I did something wrong.

I was also going to add an index for the weapons on a separate page.

I appreciate the help very much.