Create a list of titles that are links...

kmax

Hello, I'm trying to make a list of titles that link to the details.....
And it partialy works....

<?php
$db="jokes";
$link = mysql_connect("localhost");
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());
$result = mysql_query( "SELECT * FROM jokes" )
or die("SELECT Error: ".mysql_error());

while ($a_row=mysql_fetch_array($result))
{
echo "<a href=details.php?id=" . $a_row["id"] . ">" . $a_row["product"] . "</a> \n";
}
?>

That takes me to a page that is blank... and when I view the source here is what I get...

<html>
<head><title>LIST TEST</title></head>
<body>
<a href=details.php?id=></a> 
<a href=details.php?id=></a> 
<a href=details.php?id=></a> 
<a href=details.php?id=></a> 
<a href=details.php?id=></a> 
<a href=details.php?id=></a> 
I am just missing the "title" and the id number....
Any tips?

Thanks,
Kenny

nemonoman

according to the manual " The optional second argument result_type in mysql_fetch_array() is a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. This feature was added in PHP 3.0.7. MYSQL_BOTH is the default for this argument.

By using MYSQL_BOTH, you'll get an array with both associative and number indices. "

Check phpinfo() to see what version of PHP you are using.

THEN check that your array[keys] are EXACTLY like your db column names. ESPECIALLY caps/lowercase, etc.

As alternative try an explicit select

SELECT product, id FROM....

_SuperString

Also make sure you have the correct case, as queries are case sensitive on certain systems.
Or just reffer to the fields by element number : $a_row[0]

kmax

Thanks Guys! It was a dumb newbie mistake...
I did not realize that they had to were case sensitive...
I capitilized ID and JokeText and the links are showing up now...

Now I just have to work on the details page when you click on the links 🙂 thanks again for your time...

Kenny