Jump Menu from text file?

[sonofyoda]

I have 50 names and links I need to show up alphabetically in a jump-menu.

I'm pretty green with php and databases. Is there a quick and easy way to accomplish this?

I know how to create a jump-menu using Dreamweaver, but how would I set it to read the text file?

Better solutions are welcome and appreciated.

Thanks.

[devinemke]

sonofyoda wrote:

I'm pretty green with php and databases

huh? your subject line mentions text files and then you mention databases. which is it? how/where are you storing the data? if it's in a text file then use [man]file[/man] to read the contents in an [man]array[/man]. if it's in a database then you will have use an SQL query.

[sonofyoda]

devinemke wrote:

huh? your subject line mentions text files and then you mention databases. which is it? how/where are you storing the data? if it's in a text file then use [man]file[/man] to read the contents in an [man]array[/man]. if it's in a database then you will have use an SQL query.

Sorry, I'll try to be more clear.

I'd like to use a text file instead of a database, since I have no clue how to create a database from scratch.

I'm just now collecting the data, so it's not stored anywhere except in my email.

How would what you're suggesting fit into this code?

[INDENT]
<select name="name" onChange="MM_jumpMenu('parent',this,1)">
<option selected>Names</option>
<option value="URL">Name 1</option>
<option value="URL">Name 2</option>
</select>[/INDENT]

[devinemke]

i would format your txt file this this:

http://www.php.net|PHP
http://www.phpbuilder.com|PHPbuilder
http://www.google.com|Google
http://www.yahoo.com|Yahoo!
http://www.cnn.com|CNN
etc...

then your code would look like:

<?php
$file = file('/path/to/file.txt');
echo '<select name="name">';
foreach ($file as $value)
{
	$explode = explode('|', trim($value));
	echo '<option value="' . $explode[0] . '">' . $explode[1] . '</option>';
}
echo '</select>';
?>

[sonofyoda]

Ahh, I see now. Thanks so much for your help.

devinemke wrote:

i would format your txt file this this:

http://www.php.net|PHP
http://www.phpbuilder.com|PHPbuilder
http://www.google.com|Google
http://www.yahoo.com|Yahoo!
http://www.cnn.com|CNN
etc...

then your code would look like:

<?php
$file = file('/path/to/file.txt');
echo '<select name="name">';
foreach ($file as $value)
{
	$explode = explode('|', trim($value));
	echo '<option value="' . $explode[0] . '">' . $explode[1] . '</option>';
}
echo '</select>';
?>