Help with MYSQL_fetch_assoc

MrBiz

Hi...!

I have a database with tapes. The primary key is ID. I can access the databse without problems and echo the results in a table. But now I want to be able to access to access to more detailed info about each tape.

So... I tought of using the ID field and pass it as a URL variable to the script.

for that I'm using this script:

while ($line = mysql_fetch_assoc($result)) {
    echo "<tr>";
   	echo "<td><a href=\"altera.php?id=".$line['ID'] . "\ >" .$line['ID']. "</a></td>";
    echo "<td>" . $line['PGM']. "</td>";
    echo "<td>" . $line['DESCRIPTION']. "</td>";
    echo "<td>" . $line['TYPE]. "</td>";
	echo "<td>" . $line['SUPORT']. "</td>";
    echo "<td>" . $line['DATE']. "</td>";
    echo "<td>" . $line['STATUS']. "</td>";
	echo "<td>" . "</tr>";
}
echo "</table>";

The problem is that when, for instance, my query return the tape ID number "10" as result, the ID that is passed in the URL is 9. :queasy:
If there was another result with ID 55, it would pass 54 as the ID value to the URL variable.

So... After all that explanation, the question is: what do I need to do to make the echoed ID value match the value that is passed as URL variable?

Thanks in advance!

JVassie

Hmm, i can see you have a small error in your code at one point, might be (but i doubt it) the cause of your problems.

The line

    echo "<td>" . $line['TYPE]. "</td>";

Should be

    echo "<td>" . $line['TYPE']. "</td>";

(Missing a single quote)

illzz

So if you were to run the query manually, you get the expected results?

MrBiz wrote:
what do I need to do to make the echoed ID value match the value that is passed as URL variable?

I'm not quite sure what you mean here...
Are you trying to say that you are getting something like this:

<a href=\"altera.php?id=9">10</a>

After making the edits in the <a> tag, I think I may have found another typo, a missing " to close the href. You are escaping a space rather than the ". Try this...

echo "<td><a href=\"altera.php?id=".$line['ID'] . "\" >" .$line['ID']. "</a></td>";