[Resolved] Table query to make a specific URL.

yinka

I know this is a common question, but I just can't seem to find exactly what I am looking for. I might have even seen the answer, but since I am new to this I might have missed it!

Basically I have MySQL table with ten products in it. Each product has it's own row with several columns for the product's features.
Now, I have one HTML file with placeholders for each of the product's features. I have been able to call on the database, but all of the products are coming up at once. I'd like to be able to call up just one product at a time with it's own page and own link. I'm guessing that I do this with IDs, but I'm a little confused about them. Can I use IDs to have different URLS for each of the products all using the one HTML file?
Here is the code that I have working now, but obviously it is not correct. It was the closest that I could get. Any help would really be appreciated!

<?php
$query = "SELECT * FROM products";
$result = mysql_query($query) or die("Error in query." .mysql_error());

?>

<?php
while($row = mysql_fetch_object($result))
{

?>

<?php echo($row->description); ?>

Thanks

bad76

Hi,
you can do this in two way:
1) split your table in two:
- one for product
- one for feature
Then you can write them in two nested loop.

2) sort your product by product name.
Then memorize name of current product.
If different from preview you echo it.

<?php 
$query = "SELECT * FROM products ORDER BY name_prod"; 
$result = mysql_query($query) or die("Error in query." .mysql_error()); 

$currname="";
while($row = mysql_fetch_object($result)) 
{ 
     if(currname!=$row["name_prod"])
     {
                currname!=$row["name_prod"];
                echo $row["name_prod"];
     }
     echo($row->description);      

}
?>

stolzyboy

if you go something like this in your href:

then on your php page, you do

$query = "select * from tablename where id = " . $_GET['id'] . ";";

this will give you the record with the id of two

now of course you can make the href's thru a loop to get all of them, then click each one to see the full thing also

yinka

Thanks guys,

Stolzyboy, your method seems to be what I am looking for, but now I am getting an error on this line.

          <?php

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

Would I still fetch the data like this? And would I still echo the row like this?

<?php echo($row->description); ?>

stolzyboy

show me your full code for that section and what the exact error is and point out what line it is

yinka

This is the Error I get.

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource

The Error line is highlighted in Red.

<?php
$query = "select * from products where id = " . $_GET['id'] . ";";
?>

<?php
while($row = mysql_fetch_object($result))
{
?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="340" height="30"><?php echo($row->title); ?></td>
</tr>
<tr>
<td width="340"><?php echo($row->description); ?></td>
</tr>
</table>

stolzyboy

are you getting the id from the url like i showed, or somewhere else

oh and you still need this line after your $query

$result = mysql_query($query) or die(mysql_error());

yinka

Thanks stolzyboy!

It's working. I put back in that line of code and it worked perfectly.
This is exactly what I wanted to do, so I really appreciate it. Can't believe it took this long.