[RESOLVED] displaying db info after select box array

notaloser

hey guys, i have this code here, all the rows of my table, news, are queried and displayed in a select box, ditopic, using arrays.. what i want is after a user selects something from the select box, some other information from the same row is displayed in a textarea right below the select box without having to hit any submit buttons etc.. is this possible?

maybe seeing the code may help

if ($status == 'delete') {


$query = mysql_query("SELECT * FROM news ORDER BY id");
$numrows = mysql_num_rows($query);

if(empty($numrows)) {

echo "no rows";

}else{

echo "<form name='deletenews' method='post'>";
echo "<table width='350' cellpadding='0' cellspacing='0' bgcolor='#AAAAAA' align='left'>";
echo "<tr valign='top'>";
echo "<td width='100'>";
echo "<table width='350' cellpadding='3' cellspacing='1' align='left'>";
echo "<tr>";
echo "<td width='100' bgcolor='#EEEEEE'>";
echo "Topic";
echo "</td><td width='250' bgcolor='#EEEEEE'>";
echo "<select name='ditopic'>";
	while($deletearray = mysql_fetch_array($query)) {
	echo "<option value='".$deletearray[id]."'>".$deletearray[topic];
	}
echo "</td></tr>";

echo "<tr>";
echo "<td width='100' bgcolor='#EEEEEE'>";
echo "Message";
echo "</td><td width='250' bgcolor='#EEEEEE'>";
echo "<textarea rows='7' cols='40' name='dimessage'></textarea></td></tr>";


echo "</table></form>";

}

}

kakki

well, you can do that with php( little javascript ):
make all this a link and render a new page for each new textarea-content

OR
use javascript to update the textarea dynamically

notaloser

which way would be more logical? and im not quite sure what you mean by render a new page

TobyRT

You can either use a javascript onClick or onChange;; type command, or have the select box reload the page with new settings as soon as the user selects a new option - it still loads a new page, but they don't click any buttons

notaloser

ive decided i would like to use php to do this, but am not quite sure how to go about starting it.. i believe using php will overall provide more control over things and allow me to change and add features to my system im creating easier later on, yes?

could anyone start me out in any way? thanks

notaloser

decided to change how im going to do this.. instead of having a drop down box and have it load the textarea after a selection is made, im going to just list all the possible selections with checkboxes, and the selected checkboxes are the entries that will be deleted..

heres what i have, i have just set it up and thats it..
i dont know how to go about doing it this way either. i have a feeling this may be set up wrong since check boxes and radio boxes return true or false values right? im a little lost? could anyone help?

if ($status == 'delete') {


$query = mysql_query("SELECT * FROM news ORDER BY id");
$numrows = mysql_num_rows($query);

if(empty($numrows)) {

echo "no rows";

}else{

echo "<table width='350' cellpadding='0' cellspacing='0' bgcolor='#AAAAAA'>";
echo "<tr valign='top'>";
echo "<td width='100%'>";

echo "<table width='100%' cellpadding='3' cellspacing='1' align='left'>";
echo "<tr>";
echo "<td width='100%' bgcolor='#EEEEEE'>";
echo "<div align='center'><input type='submit' name='dsubmit' value='Delete Selected'></div>";
echo "</td></tr></table></td></tr></table><br>";

echo "<form name='deletenews' method='post'>";
	while($deletearray = mysql_fetch_array($query)) {


echo "<table width='350' cellpadding='0' cellspacing='0' bgcolor='#AAAAAA'>";
echo "<tr valign='top'>";
echo "<td width='100%'>";

echo "<table width='100%' cellpadding='3' cellspacing='1' align='left'>";
echo "<tr>";
echo "<td width='100' bgcolor='#EEEEEE'>";
echo "Delete";
echo "</td><td width='250' bgcolor='#EEEEEE'>";
echo "<div align='right'><input class='checkbox' type='checkbox' name='dicheckbox' value='".$deletearray[id]."'>";

echo "</td></tr>";
echo "<tr>";
echo "<td width='100' bgcolor='#EEEEEE'>";
echo "Topic";
echo "</td><td width='250' bgcolor='#EEEEEE'>";
echo "<input type='text' name='ditopic' size='40' value='".$deletearray[topic]."' disabled>";
echo "</td></tr>";
echo "<tr>";
echo "<td width='100' bgcolor='#EEEEEE'>";
echo "Message";
echo "</td><td width='250' bgcolor='#EEEEEE'>";
echo "<textarea rows='7' cols='40' name='dimessage' disabled>".$deletearray[message]."</textarea>";
echo "</td></tr>";
echo "<tr>";
echo "<td width='100' bgcolor='#EEEEEE'>";
echo "Author";
echo "</td><td width='250' bgcolor='#EEEEEE'>";
echo "<input type='text' value='".$deletearray[author]."' disabled>";
echo "</td></tr></table>";
echo "</td></tr></table><br><br><br>";
	}

echo "</form>";

	if($_POST['dsubmit']) {

	}


}

}