Jump Menu

[Blue Moose Aaron]

Here is my code

PHP Code:

// ######################### EPISODE JUMP ############################ 
$ep = $DB_site->query_first("SELECT * FROM smallville_episode_guide ORDER BY id ASC"); 
$php_self = $_SERVER['PHP_SELF']; 
$jump[id] = $ep[id];
$jump[episode_name] = $ep[episode_name];
eval("\$episodejumpbits = \"".fetch_template('smallville_episodejumpbits')."\";"); 


[AN-net]

PHP Code:

// ######################### EPISODE JUMP ############################ 
$ep = $DB_site->query("SELECT * FROM smallville_episode_guide ORDER BY id ASC"); 
$php_self = $_SERVER['PHP_SELF']; 
while($jump= $DB_site->fetch_array($ep))
{
eval("\$episodejumpbits = \"".fetch_template('smallville_episodejumpbits')."\";"); 
} 


[Blue Moose Aaron]

Its still only showing one record

[AN-net]

how many episodes do you have in the database?

[Blue Moose Aaron]

its going to change as entries are added. somewhere around 65 though at the moment

[AN-net]

if you have only one entry in that table than it will only display that entry

[Blue Moose Aaron]

Yea i know, but I just said I have 65 in the table

[AN-net]

oh, hmmm. that code should work. well i give up, ill think on it but most likely im stuck lol!

[CarCdr]

You are overwriting the result every time with this straight assignment:

$episodejumpbits = stuff

you want to append each new bit, so use ".=" (dot equals):

$episodejumpbits .= stuff

which is the shortcut for "concatenation assignment".

[Blue Moose Aaron]

Thank you very much. I appreciate it!