simple drop down link

[pwesthead]

Hi
iam trying to get all users with a photo album to appear in a drop down list.

here is the code

$rime4 = mysql_query("SELECT * from users   ") 
or die(mysql_error());

while($row = mysql_fetch_array($rime4)) {
extract($row);
$username = $row["username"];
$userid = $row["userid"];


echo "<option  value='$userid'>  $username </option>"; 

Iget the list of users but need to add the link below
how do i add this link to the username this is the link http://www.$sitePath/index.php?username=$username

[php_daemon]

<select name="username" onchange="location.href='http://www.$sitePath/index.php?username='+escape(this.options[this.selectedIndex].text)">

[pwesthead]

Hi
no that didnt seem to work either
thanks paul

[a2K]

Why not make another variable or do = '<a>' + $username + '</a>'; ?
Sorry, I am bad at PHP and this is how I would have attempted it

[php_daemon]

Frankly, I don't know what is it that you want to do exactly. I assumed you want to go to a certain link when user selects an oprion from the dropdown. Is that not the case?

[pwesthead]

Hi
when a user clicks on a username it takes them to there photo album a link,

[a2K]

If I am correct then you wanted my option?

[php_daemon]

You can also try:

echo "<option  value='$userid' onclick=\"location.href='http://www.$sitePath/index.php?username=$username'\">$username</option>"; 

[a2K]

But wouldn't that be dependent on JavaScript?

[php_daemon]

No way to do that with a dropdown box otherwise. Without JS a list of simple hyperlinks is the only way.

[pwesthead]

Hi
just tried this
echo "<option value='$userid' onclick=\"location.href='http://www.$sitePath/index.php?username=$username'\">$username</option>";
but the link still didnt work

[php_daemon]

No way, what's going on? Do you have it online?

[a2K]

Did you click it? I tested it on my server with false values of course, and I got it working. There is no logical reason why that would not work

[pwesthead]

Hi
Iv tried everything but no joy, the link doesnt work no link at all

[php_daemon]

What do you mean by that? Do you expect to see a blue underlined text? That's not how it works.

It's not a link per se, it's impossible to add links to dropdown box. Instead it mimics the behaviour in JS, by redirecting browser to the page when the user clicks on an option from the list.

If you want it to appear like 'standard' hyperlinks, style them in CSS.

[pwesthead]

No i dont expect to see blue line with text, when a user clicks on the drop down list he sees a list of users they should be able to clck on the user which then takes them to there photo album page.

[php_daemon]

Which is how it should work, and I've tested it...

If you don't have it online (PM me the link if you don't want it be known in public), can you post the select box as it is output by the script in html?

[pwesthead]

Here is the full code

$rime4 = mysql_query("SELECT * from users   ") 
or die(mysql_error());

while($row = mysql_fetch_array($rime4)) {
extract($row);
$username = $row["username"];
$userid = $row["userid"];
$description = $row["description"];
echo "<select name='username' id='username'>
                    <option value= selected>Member Albums</option>
<option  value='$userid' onclick=\"location.href='http://www.$sitePath/index.php?username=$username'\">$username</option>";} ?> 

[php_daemon]

Other that it shold be:

$rime4 = mysql_query("SELECT * from users   ") 
or die(mysql_error()); 

echo "<select name='username' id='username'> 
                    <option value= selected>Member Albums</option> ";

while($row = mysql_fetch_array($rime4)) { 
extract($row); 
$username = $row["username"]; 
$userid = $row["userid"]; 
$description = $row["description"]; 
echo "<option  value='$userid' onclick=\"location.href='http://www.$sitePath/index.php?username=$username'\">$username</option>";
} ?> 

If $sitePath is correct, I don't see anything that wouldn't work.

Any JS errors?

And I would really rather see the html output to see what exactly is going on.

[pwesthead]

here is the link to the site
http://www.easynet4u.com/photoalbum/...username=westy

the drop down list is on the side named Member albums

[AnthonySterling]

Bingo!

I won't steal the glory from PHP_Deamon though.

[a2K]

I will

You have this link when you click the drop down

http://www.http//www.easynet4u.com/i...username=westy

Notice you have two http://www.'s in there?

[php_daemon]

<option  value='1' onclick="location.href='http://www.http://www.easynet4u.com/imagehost/index.php?username=westy'">westy</option>

Evidently your $sitePath has the full url and http://www. is redundant...

echo "<option  value='$userid' onclick=\"location.href='$sitePath/index.php?username=$username'\">$username</option>"; 

Edit:

I will

[pwesthead]

Hi
thats wierd i dont get any link just the username nothing else.

[php_daemon]

Are we on the same page then? Perhaps you have it cached in the browser?