Populating from Radio Button

Dev Articles Community Forums Sponsor:

August 13th, 2004, 06:07 PM

ramyaivan

Registered User

Join Date: Aug 2004

Posts: 16

Time spent in forums: < 1 sec
Reputation Power: 0

Populating from Radio Button

hi all,
Thank you for you are always there to help me in tough situations.
Now again i have a problem. I am populating a radio button from database.
On clicking that radio button, i need the related row of that field in radio button to be retrieved from the data base
I have written a code, but its retrieving only blank values or empty values.

Heres my code
Project1.php(this script i am using to populate the radiobutton)

<html>
<body>
<?php
include ("DbConnection.php")?>
<?
$sql = "select distinct NetProcess from tblEventLog order by tblEventLog.NetProcess";

<form method="post" action="Project2.php">
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
$NP=$row["NetProcess"];
echo "<input type=\"radio\" name=\"N\" value=\"N\"> $NP";

echo " ";
}
mysql_query($result);
?>
<input name="step" type="hidden" value="1" />
<input name="submit" type="submit" value="add" />
</form>
</body>
</html>

Project2.php(This script i am using for when clicking the radio button for corresponding NetProcess(a particular field)
its respective all other row values or column values shld be retrieved)

<? include("DbConnection.php"); ?>
<h2>View '$date' Alarms!!</h2>

<?php
$N = $_POST['N'];
$query = "SELECT * FROM tblEventLog WHERE NetProcess = '".$N."' ";
$result = mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>

<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th>NetProcess</th>
<th>Node</th>
<th>Unit</th>
<th>Class</th>
<th>Date</th>
<th>Start</th>
<th>End</th>
<th>Frequency</th>
<th>Service</th>
<th>Severity</th>
<th>Direction</th>
<th>Location</th>
<th>Atype</th>
<th>CompanyID</th>
<th>CustomerID</th>
<th>Description</th>
</tr>

<?$i=0;
while ($i < $num) {
$NetProcess=mysql_result($result,$i,"NetProcess");
$Node=mysql_result($result,$i,"Node");
$Unit=mysql_result($result,$i,"Unit");
$Class=mysql_result($result,$i,"Class");
$Date=mysql_result($result,$i,"Date");
$Start=mysql_result($result,$i,"Start");
$End=mysql_result($result,$i,"End");
$Frequency=mysql_result($result,$i,"Frequency");
$Service=mysql_result($result,$i,"Service");
$Severity=mysql_result($result,$i,"Severity");
$Direction=mysql_result($result,$i,"Direction");
$Location=mysql_result($result,$i,"Location");
$Atype=mysql_result($result,$i,"Atype");
$CompanyID=mysql_result($result,$i,"CompanyID");
$CustomerID=mysql_result($result,$i,"CustomerID");
$Description=mysql_result($result,$i,"Description");
?>

<tr>
<td><? echo $NetProcess; ?></td>
<td><? echo $Node; ?></td>
<td><? echo $Unit; ?></td>
<td><? echo $Class; ?></td>
<td><? echo $Date; ?></td>
<td><? echo $Start; ?></td>
<td><? echo $End; ?></td>
<td><? echo $Frequency; ?></td>
<td><? echo $Service; ?></td>
<td><? echo $Severity; ?></td>
<td><? echo $Direction; ?></td>
<td><? echo $Location; ?></td>
<td><? echo $Atype; ?></td>
<td><? echo $CompanyID; ?></td>
<td><? echo $CustomerID; ?></td>
<td><? echo $Description; ?></td>
</tr>

<?
$i++;
}

echo "</table>"
?>

Hope my confusion will be solved. Its retriving only empty values. So somebody help me in this.

Thanking you
ri

August 14th, 2004, 01:58 AM

Itsacon

Command Line Warrior

Join Date: Aug 2004

Location: Sector ZZ9 Plural Z Alpha

Posts: 995

Folding Points: 797501 Folding Title: Super Ultimate Folder - Level 2

Time spent in forums: 6 Days 13 h 57 m 35 sec
Reputation Power: 5

try this:

PHP Code:


		
			
 $NP=$row["NetProcess"];

echo "<label><input type=\"radio\" name=\"N\" value=\"".$NP."\"> $NP</label>";

The trick is in that I changed the value so you don't get an endless amount of radio buttons with value 'N', so the next script can actually distinguish what button was selected.
The <label> is there so you can click the text instead of the readio button, just a little HTML trick.

August 14th, 2004, 12:06 PM

ramyaivan

Registered User

Join Date: Aug 2004

Posts: 16

Time spent in forums: < 1 sec
Reputation Power: 0

Thank you so much

Thank you so much, it worked.
Can you suggest some good books or websites, that teaches
all these type of scripts with practical examples. It would be great, if there is one.

Thank you
once again.
ri

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: