Query returning hyperlink

[GameOn]

Hi everyone

Im trying to get a query to return a hyperlink, used a couple of different ways with no success. I would like it to return all the makes in the cardetails table with hyperlinks to a page that has some feilds of the cardetail table of the selected make.

The following code only outputs "Car Details:"

products.php

PHP Code:

<?PHP
include 'connectdb.php';
session_start();

$sql="SELECT make FROM cardetail";

$result = mysql_query($sql,$db);
echo "Car Details:<br>";
$i=1;
while ($myrow = mysql_fetch_array($result))
{
echo "<a href=\"productdetails.php?id=".$myrow["Make"]."\">".$myrow["Model"]."</a><br>";
$i=$i+1;
if($i>5)
break;
} 
?>

Heres the connect to database file

PHP Code:

<?PHP

$db=mysql_connect("localhost", "XXX", "XXX") 
or die("Could not connect to localhost."); 

if (!@mysql_select_db("cardb",$db)) 
    {
    exit('Error. Unable to select database.');
        } else {
        //Connection successful
    }

?>

[GameOn]

Also tried this:

Code in index.php

PHP Code:

//Request the car details
$result = @mysql_query('SELECT make FROM cardetail');
$hlink = mysql_query($result);

while ($make = mysql_fetch_array($hlink))
               {
                       echo "<a href=".$row['make'] .">";
                }

echo ' <table>
      <tr>
        <td>' . $row['make'] . '</td>
        <td><a href="products.php" target="_blank">' . $row['make'] . '</a></td>
        <td>' . $row['model'] . '</td>
        <td>' . $row['year'] . '</td>
      </tr>
      </table>';

if (!$result) {
    exit('<p>Error performing query: ' . mysql_error() . '</p>');
} 


I'm hoping to turn the query results into a page with an order option below.

[draven77]

Try this ----

// Connect up code here

$result = mysql_query("SELECT make, model FROM cardetail") or die ("no DB connection<br><br>".mysql_error() );
		while($r=mysql_fetch_array($result))
		{    
			// ESTABLISH FIELD NAMES
			$make=$r["make"];
			$model=$r["model"];
			
			echo "<a href=\"productdetails.php?id=$make\">".$model."</a><br />";
		}

Just some advice, it looks like your table may not be structure optimally.. I'd use a car_id. Consider fields like this--

car_id
car_make
car_model

Then you'd pass the id instead of the $make

echo "<a href=\"productdetails.php?car_id=$car_id\">".$model."</a><br />";

And your query would make more sence on your details page

SELECT * FROM cardetail WHERE car_id = $car_id

[GameOn]

Thanks a lot for the detailed reply.

I managed to get it going the other day, looking back i can see how clueless i was, and the first example i stumbled across pointed down the wrong path.
I ended up doing something very similar to what you have stated, by displaying the details from the table then having the hyperlink pass the id, with a REQUEST on the page its passing it to so you can display the previous record selected in more depth.

Thanks again.