MySQL help

Anon

I have a lacrosse website, and it runs PHP around a MySQL database. I have had each of the players submit a bio of themselves and it was inserted into a database. The rows are: first, last, grade, quote, stick and bio_text. On the main players page: http://www.kaskelnetworks.com/palmetto?section=players&type=1, the rows "first" and "last" are placed on the players page as a link, how can the link actually link to the specific player it points to? thanks...

gardner1

tag

thought I figured it out, both for me, and you, but I was not gettin' it right.

Anon

Try this:
(on the page where you are linking to specific profiles)
$sql_query = "SELECT first, last FROM table";
$result = mysql_query( $sql_query );

while ( $row = mysql_fetch_array($result) ){
$first_name = urlencode($row["first"]);
$last_name = urlencode($row["last"]);
echo "<A HREF=\"view_profile.php?first_name=$first_name&last_name=$last_name\">" . $row["first"] . " " . $row["last"] . "</A><BR>";
}

then, view_profile.php would look like:

$first_name = urldecode($first_name);
$last_name = urldecode($last_name);

$sql_query = "SELECT * FROM tablename WHERE first = '$first_name' AND last='$last_name'";

then you'd execute the query and print the HTML...

*(personally i hate having long query strings, so i wouldn't do it that way. I'd add a column to the database like:
id int auto_increment not null
and use the id as the identifier for each player, instead of their name. So the link would look like view_profile.php?id=24
instead. However, the way above should work.)

I hope this is what you were looking for, i wasn't 100% clear on the question.

-Jim Keller
http://www.centerfuse.net

Anon

yes it worked, thanks

gardner1

Jim, thanks for your help; It was Ryan's question, but I tagged it, as I'm working on the same type of problem in the generic sense....

was wondering if you could clarify:

your statement copied from above, returns when decoded on the next page, the word $first_name, rather than the value from the DB... is this because we need to concatenate non-string variable types, as such?

echo '<A HREF=\"view_profile.php?first_name='.$first_name.'&last_name='.$last_name.'\">' . $row["first"] . ' ' . $row["last"] . '</A><BR>';

when concatenating non-string variables, it worked correctly, in otherwords the encoded URL variables had to NOT be in the echo's quotations. when i did it this way, it worked as intended.

Did I uncover an oversight? [big_grin] or does the way you have it there, works also, and Im just really daft at getting it to work that way <--- VERY possible. [sheepish_grin]

nevertheless, i got MINE to work; hoping Ryan is ok, and THANK you again, very much.