printing only data in a spcific row of a mysql table using php

[tolkienarda]

hi all i have gotten a table from a mysql database and stored into $request
in this table there is an 'id' field which is unique and auto incrimenting and a name field. i am doing a loop to display all of the names of the people in a <select> drop down box. i have written some code with english to fill in the blanks if someone could replace my english with php code i would appreciate it.
hereis the first set
[PHP]
$result=mysql_query("SELECT id, name, First, Second, Third, Fourth, Fifth, Sixth, Seventh, Eight FROM Students")
$row=mysql_num_rows($result);
[/PHP]
and the actual code
[PHP]
<form>
<select>
<?
$i=1;
while($i > $row)
{

$temp=(the name of the person stored in the row with the corasponding id);

if($temp = (if a record gets deleted then there will be a gap in 'id' and this value will be 0 or null not sure which)
{
$i++;
}
else
{
echo "<option>"$temp"</option>";
$i++;
}
}
?>
</select>
</form>
[/PHP]

[b1randon]

hi all i have gotten a table from a mysql database and stored into $request
in this table there is an 'id' field which is unique and auto incrimenting and a name field. i am doing a loop to display all of the names of the people in a <select> drop down box. i have written some code with english to fill in the blanks if someone could replace my english with php code i would appreciate it.
hereis the first set
[PHP]
$result=mysql_query("SELECT id, name, First, Second, Third, Fourth, Fifth, Sixth, Seventh, Eight FROM Students")
$row=mysql_num_rows($result);
[/PHP]
and the actual code
[PHP]
<form>
<select>
<?
$i=1;
while($i > $row)
{

$temp=(the name of the person stored in the row with the corasponding id);

if($temp = (if a record gets deleted then there will be a gap in 'id' and this value will be 0 or null not sure which)
{
$i++;
}
else
{
echo "<option>"$temp"</option>";
$i++;
}
}
?>
</select>
</form>
[/PHP]

[PHP]
<form>
<select>
<?
while ($row = mysql_fetch_row($result)) {
echo "<option>"$row[name]"</option>";
}
?>
</select>
</form>
[/PHP]

[ronverdonk]

As long as you understand that this select is doing nothing when an option is clicked, just displaying some names, I'll show you. But don't come back after this to expand this sample into a full-fledged application!
[php]<?
$result=mysql_query("SELECT id, name, First, Second, Third, Fourth, Fifth, Sixth, Seventh, Eight FROM Students")
or die("Select error: ".mysql_error());
echo '<form>';
echo '<select>';
while ($row=mysql_fetch_assoc($result)) {
$temp=$row['name'];
echo "<option value='$temp'>$temp</option>";
}
?>
</select>
</form>[/php]
Ronald :cool:

[ronverdonk]

Sorry Brandon, I didn't know you were also replying to this post.

Ronald :cool:

[tolkienarda]

thank you much next question:


after someone has selected the desired name out of the select box i need to get the rest of the information stored in that row. here is what i used for the <option>

[PHP]
echo "<option value=' "$row[id]" '>"$row[name]"</option>";
[/PHP]
now a function is called that recives the value from here there are several other pices of data i need from that row

[ronverdonk]

You did not make that <option> yourself, it was posted in this forum by b1randon. Now what have you developed yourself, or have been trying to develop yourself, to obtain and display that information?

As I said in a previous post, you cannot use 'salami-tactics' to let our members develop a full-fledged application for you from the ground up. You'll have to do something yourself.

So please show us your code!

Ronald :cool:

[tolkienarda]

Here is my code. I am not trying to take credit for code i didn't write myself. took the code b1randon wrote and changed one small detail. sorry if i offended anyone. anywhy i downloaded some of this code from another site this stuff is commented. i only changed variable names on these lines. on the non commented lines i either wrote them myself or was directed by one of the posts in this thread

the places where there are text in () instead of code are places i can't figure out if you think that i am asking for too much then mabey you could point me toward a tutorial that i could read. i am more than willing to do that and i have in the past but some of them leave out the simple stuff because they figure that most people already know how to do them

[PHP]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<?
session_start(); // Use session variable on this page. This function must put on the top of page.
if(!session_is_registered("username")){ // if session variable "username" does not exist.
header("location:index.php"); // Re-direct to index.php
}
?>
<?


// Connect database.
$host="localhost"; // Host name.
$db_user="rcadmin"; // MySQL username.
$db_password="nsds2004"; // MySQL password.
$database="RCA"; // Database name.
$RCA = mysql_pconnect($host, $db_user, $db_password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $RCA);

$result=mysql_query("SELECT id, Login name, class1, class2, class3, class4, class5, class6, class7, class8 FROM Students")
$row=mysql_num_rows($result);

function selectclass($tempstudent)
{
$therow = row that corosponds with that name
$displayclsses=1;
$login=the Login of the peron whos name is stored in $tempstudent
}
function disp($tempclass)
{
$assignments=mysql_query("SELECT ID, student, class1, class2, class3, class4, class5, class6, class7, class8 FROM assignments WHERE student='$login'")
$grades=mysql_query("SELECT ID, student, class1, class2, class3, class4, class5, class6, class7, class8 FROM grades WHERE student='$login'")
$comments=mysql_query("SELECT ID, student, class1, class2, class3, class4, class5, class6, class7, class8 FROM comments WHERE student='$login'")
}
?>
</head>

<body>
<p>Hello teacher <? echo $_SESSION['user'];?>! You are now Logged in.</p>
<p><a href="login.php">Logout</a></p>
<form method="post" action="$func">
<select>
<option>asdf</option>
<?
while ($row = mysql_fetch_row($result))
{
echo "<option value='"$row[name]"'>"$row[name]"</option>";
}
$func="selectclass";
?>
</select>
<?

if($displayclasses=1)
{
<select>
$i=1;

while($i<9)
{
$temp=the class name
if ($temp!=null or whatever)
{
echo '<option value="'$temp'">'$temp'</option>';
}
}
</select>
}
func="disp";
?>
<?
echo '<input type="text" maxlength="5" name="grade" id="grade" value="grade">';
echo '<textarea name="assignments" rows="16" cols="65" id="assignments" value='(assignment value for that student and class)' />';
echo '<textarea name="comments" rows="16" cols="65" id="comments" />'
$func="update";
?>

</form>
</body>
</html>
[/PHP]