few questions all related

bike5

#1. I want to get all of a colum for all rows in my table in mysql and display the results.

$Query = "SELECT user_name from $TableName";
$Result = mysql_db_query($DBName, $Query, $Link);
while ($colum = mysql_fetch_field ($Result)) {
echo ("http://www.ridingamerica.com/dbl/members.php?user_name=$colum[user_name]");
}

Im not sure how to get that to work properly. Theres probably an even better way to display this info?

#2. After the names are displayed. I want to have a link on each name which links to a page that displays all the information assosiated with that one name they clicked. Is the way I set it up, would that work by getting the infor from the url?

#3. How would I get the info for the single name based on the url from the table and display it all?

Sorry if this is a lot. Thank you very much in advance for you help.

bike5

edit this line to-
echo ("<A HREF=\"http://www.ridingamerica.com/dbl/members.php?user_name=$colum[user_name]\">$colum[user_name]</A>");

Anon

1) You don't want mysql_fetch_field, you want mysql_fetch_array - fetch_field just gives you a lot of info about the column, not its contents.

2) For safety, change user_name=$colum[user_name]
to
username=".urlencode($colum["user_name"])."
so that URL-unfriendly characters in the user names don't have a chance to slip into the URL.
Otherwise, you pretty much have it.

3) The query would be
SELECT * FROM $TableName WHERE user_name='$user_name'

bike5

This was what I put in and when I opened the page it shows:

Array (the array is link http://......php?user_name=Array)

Did I do something wrong or what happened?

$Query = "SELECT user_name from $TableName";
$Result = mysql_db_query($DBName, $Query, $Link);
while ($colum[user_name] = mysql_fetch_array ($Result)) {
echo ("<A HREF=\"http://www.ridingamerica.com/dbl/members.php?user_name=".urlencode($colum["user_name"])."\">$colum[user_name]</A>");
}

bike5

This was what I put in and when I opened the page it shows:

Array (then the array is linked to http://......php?user_name=Array) Each name I add to the table prints out an aditional "Array".

Did I do something wrong or what happened? Why does it print out Array and not the user_name?

Anon

Well yeah, you're putting the entire result array into $colum['user_name'] instead of just $colum

while($colum=mysql_fetch_array($Result)){

bike5

Thanks a lot, it worked, I never even looked at that doing that.lol

Thanks again.