Clickable Text with Dynamically Created Functions?

[darthjones]

[FONT=Courier]I have a table called information that contains 2 fields – one called description and one called content. I would like to create a script that takes everything in the description field and puts them into either buttons or clickable text (preferably clickable text). When the user clicks on the description, whatever is in the corresponding content field is displayed in a text area box at the top of the screen.

Is creating clickable text that contains dynamically created functions doable in PHP? If so, I am sure that that is how this should be approached. That would mean that I should put something in the while loop (please see the code below). If you have any tips, suggestions, or code that you can throw at me, it would be very much appreciated.

Thanks!

The table will look something like this –

description ......... content

---

a red wagon ......... the red wagon is a radio flyer
silver cell phone ... i use this to call people
noisy truck ......... it is very annoying

A typical page would look like the following -

----------------------------
| it is very annoying .... |
| ........................ |
| ........................ |
| ........................ |
| ........................ |
| ........................ |

| ........................ |

a red wagon
silver cellular phone
noisy truck

In this example, because the user clicked on “noisy truck”, “it is very annoying” showed up in the text area at the top.

The following code is what I came up with so far (minus all the database connection stuff). It creates the text area and will list everything in the description field below the text area.

<form action="<?php echo($php_self); ?>" method=post>

<textarea name="contentArea" cols=60 rows=20></textarea>

</form>


<?php

$query = "SELECT * FROM information";
$result = mysql_query( $query ) or die( mysql_error() );

while( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) )
{
    echo "{$row['description']}<p>";
}

?>[/COLOR][/SIZE]
[/FONT]

[devinemke]

you should add another field to your table called "id" which should be an auto_incrementing integer field and should be the primary key field. then do something like:

<?php
// connect to the db

$content = '';
if (isset($_GET['id']))
{
   $result = mysql_query("SELECT content FROM information WHERE id = '" . $_GET['id'] . "'") or exit(mysql_error());
   if (mysql_num_rows($result)) {$content = mysql_result($result, 0);}
}

echo '
<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">
<textarea name="contentArea" cols="60" rows="20">' . $content . '</textarea>
</form>
';

$result = mysql_query('SELECT id, description FROM information') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
      echo '<a href="' . $_SERVER['PHP_SELF'] . '?id=' . $row['id'] . '">' . $row['description'] . '</a><br>';
}
?>

[darthjones]

Thanks! It worked perfectly.