Hi,

I connect a List/menu component on DW2004 with MYSQL and Im getting my data
with out any problems but I would love for example that if I chose something
I will get that information from my DB on the page.

I have on MYSQL the column ID (get by List/menu) and I need to get the
content from the NEWS column on the page after I made my choice.

How I can achive this?


_Lobo_
my code:
PHP Code:
<?php require_once('../../Connections/conn_newland.php'); ?>
<?php
mysql_select_db($database_conn_newland, $conn_newland);
$query_Oldnews = "SELECT * FROM tbl_news";
$Oldnews = mysql_query($query_Oldnews, $conn_newland) or die(mysql_error());
$row_Oldnews = mysql_fetch_assoc($Oldnews);
$totalRows_Oldnews = mysql_num_rows($Oldnews);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body><table width="400" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><select name="region" id="region">
<?php
do {
?>
<option value="<?php echo $row_Oldnews['Title']?>"><?php echo
$row_Oldnews['Title']?></option>
<?php
} while ($row_Oldnews = mysql_fetch_assoc($Oldnews));
$rows = mysql_num_rows($Oldnews);
if($rows > 0) {
mysql_data_seek($Oldnews, 0);
$row_Oldnews = mysql_fetch_assoc($Oldnews);
}
?>
</select></td>
<td>&nbsp;</td>
</tr>

</table>


</body>
</html>
<?php
mysql_free_result($Oldnews);
?>