[Resolved] Displaying more MySQL data onto webpage

redirish

Hello there,

I found this thread and it answered most of my query:-

[Resolved] Displaying MySQL data onto webpageclick

After getting my output onto the screen after choosing the letter "M" or another I would like the user to click beside the name he is interested in and then a script gets it from the database.

It is a database with 2 tables. One containing name, address, etc and the other contains ship and ship information.

If you know of an example or athread or the right PHP/Mysql function or class will you let me know. I know it has to do with assigning a URL with a variable, I think?

greetigs

from the Netherlands

Liam

bpat1434

I'm guessing you just want to show the info about the person. You would create a link for them that passes the user_id or ID of the person to a query. From there, you select all the fields/row(s) where the ID is the ID passed through the URL or form.

Then use the same idea to display it as you have already used.

~Brett

redirish

Hello Brett,

Thanks but do you mean using it this way in a script......I am one of those people that always need example to understand the simple and difficult things in programming.

$Recordset1 = mysql_query($query_Recordset1, $seaman) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<?php do { ?>

<?php echo $row_Recordset1['surname']; ?>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

<?php mysql_free_result($Recordset1); ?>

I know this can be written as one <?php-?> but it make life easier while testing.

All idea's are welcome

bpat1434

Well, it makes life easier if you use it logically as well. While I can follow your code, it makes more sense to just use the while() loop instead of the do{} while(). Nothign wrong with what you have, it's just personal coding preference.

You call the values into the associative array twice. It's really not needed. I would also suggest that perhaps use you mysql_fetch_array() and then define what type of array you want. Gives you more options. But that's just another personal preference.

As for an example, here's how my code version of your stuff work, with the minor fix:

<?php
$Recordset1 = mysql_query($query_Recordset1, $seaman) or die(mysql_error());
/*
I got rid of this, because you don't seem to use it here.  If you do use it, uncomment it.  If not, it's not necessary.
*/
//$totalRows_Recordset1 = mysql_num_rows($Recordset1);

while($row_Recordset1 = mysql_fetch_array($Recordset1, MYSQL_ASSOC))
{
?>
    <a href="details.php?surname=<?= $row_Recordset1['surname']; ?>">
    <?= $row_Recordset1['surname']; ?>
    </a><?
}
php mysql_free_result($Recordset1); 
?>

You don't need to redeclare the associative array and then perform a while loop. But what you had was a good start and effort.

~Brett

redirish

Thanks Brett.

It is interesting to see that there are many ways to solve the way to write a script.

Liam