PHP - Maintaining A Detail Result In A Details Page To Other Details Pages

Hi Everyone.

i have a page which list all records. i then have several detail pages which i need to link via the id number. for ex.

records:
id number name
1 john smith
2 peter parker

the detail page is layout out like so:
View details page 1 | view details page 2 | view details page 3

Any help would be appreciated. Thanks.

Hello.  I just created a product gallery containing thumbnails of items that I will be selling.

When a user click on on of the thumbnails, I want a product details page to appear with more details about the chosen product

Could use some feedback if I am going about things the right way...

Step 1: User goes to my gallery located he   www.mysite.com/store/product-gallery.php

Step 2: System displays a page of thumbnails representing items that I am selling.

Step 3: User click on a given thumbnail which is a hyperlink to:  www.mysite.com/store/products/4571

Step 4: System rewrites the URL as such:  www.mysite.com/store/products.php?sku=4571

Step 5: System queries MySQL and retrieves record for sku 4571

Step 6: System displays product details for the chosen item in Step 3 which is sku 4571

 

How does that sound?

 

Hi,

I am stuck. I have used dreamweaver to create a master details page with links to the details page successfully, but I would like to display the master details page results in 3 columns rather than the 1 column that dreamweaver defaults. As the site becomes richer the content will increase yielding many results, therfore the content displayed in a single column will require the users to scroll way down the page.

So, as it is now the results display as follows:

Plant1
Plant2
Plant3
Plant4
Plant5
Plant6
Plant7
Plant8
Plant9
etc...

I would like them to display as follows:
Plant1        Plant4        Plant7
Plant2        Plant5        Plant8
Plant3        Plant6        Plant9

Here is my code thus far:
<?php require_once('Connections/connGND.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_connGND, $connGND);
$query_rsBotanicalA = "SELECT * FROM plants WHERE CatIDB = 'A'";
$rsBotanicalA = mysql_query($query_rsBotanicalA, $connGND) or die(mysql_error());
$row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA);
$totalRows_rsBotanicalA = mysql_num_rows($rsBotanicalA);
?>
<table border="0" align="left">
  <?php do { ?>
    <tr>
      <td align="left"><a href="plantdetails.php?recordID=<?php echo $row_rsBotanicalA['PlantID']; ?>"> <?php echo $row_rsBotanicalA['BotanicalName']; ?>&nbsp; </a></td>
    </tr>
    <?php } while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA)); ?>
</table>

Could someone help me to write this code, as I have been unsuccessful maintaining the links. I have been able get the results to display in the columsn as I would like, but I haven't been able to figure it out while maintaining the links!

Thanks.

Hello there,

I'm trying to make when you click on a record, it opens another page with full details about this record

the code for it is

Code: [Select]
  <td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>

and it's working right, but when it opens the other page, no records is shown about the user with that ID

So I figure the problem that I need to pass $row['id'] to my second page and make it search for it in the database

how can I do that?

here is the code from the second page (details of the record)

Code: [Select]

$dbObj = new DB();
$result = mysql_query("select * from users where id = '$userID'");
return $result;



$row = @mysql_fetch_array($result);
echo "<table width=98%>";       
        echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
echo "<td valign=\"top\">";
echo "<table>
<tr>
<td valign=\"top\" class=\"searchtitle\">
".$row['fname']. '  ' .$row['mname']. '  ' .$row['lname']."
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['mobile']."
</td>
</tr>
<tr>
<td>
<a href=\"user.php?id=".$row['recruiterid']."\" class=\"link\">".$row['recruiterid']."</a>
</td>
</tr>
</table>";
echo "</td>";
echo "</tr>";
echo "</table>";

Hi,

I would like to display my master details page links to the details pages in three columns rather than a single column.

Below is the do-while code I have thus far, and I am stuck.  Could someone please mock up this code quick, because I know it is a simple syntax error somewhere.

<?php do {
   echo "<table border='0'>";
   for ($y=1; ; $y++) {
      echo "<tr>";
      for ($x=1; $x<=3; $x++) {
         echo "<td align='left'><a href="plantdetails.php?recordID=echo $row_rsBotanicalA['PlantID'];">; echo $row_rsBotanicalA['BotanicalName']; </a></td>"
      }
      echo "</tr>";
   }
}
while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA));
echo "</table>";
?>