rob200375
-
Posts
1 -
Joined
-
Last visited
Never
rob200375's Achievements
Newbie (1/5)
0
Reputation
-
hi, I am trying to alter some code to try and understand it, I have a page called amend.php, it shows me all records in my table (agent_details), i can type a record number in and then hit submit and it should go to amend1.php, this iswhere it goes wrong, I have tried to edit the coding and I am getting lost, i get an error saying "Parse error: syntax error, unexpected $end in C:\wamp\www\amend1.php on line 62" here is the amend1.php in full. <html> <?PHP session_start(); ?> <HTML> <?php $record = $_POST['record']; echo "Reference Number: $record<br><BR>"; $host = "localhost"; $login_name = "root"; $password = ""; //Connecting to MYSQL MySQL_connect("$host","$login_name","$password"); //Select the database we want to use mysql_select_db("performance_tracker") or die("Could not find database"); $result=mysql_query(" SELECT * FROM agent_details WHERE IDNumber='$record'"); $num=mysql_num_rows($result); $i=0; while ($i < $num) { // collect all details for our one reference $description=mysql_result($result,$i,"AgentName"); $text2=mysql_result($result,$i,"TeamName"); $reference=mysql_result($result,$i,"LucentLogin"); $thumb=mysql_result($result,$i,"Date Of Birth"); $img1=mysql_result($result,$i,"Sex"); $img2=mysql_result($result,$i,"Employment"); $f='<font face=Verdana,Arial,Helvetica size=2 Color=Blue'; //next we display only the details we want to allow to be changed in a form object // the other details that we won't allow to be changed can be echoed to the screen //note the hidden input line 3 below. We don't need to echo it to the screen ?> <TABLE WIDTH="100%" CELLPADDING="10" CELLSPACING="0" BORDER="2"> <TR ALIGN="center" VALIGN="top"> <TD ALIGN="center" COLSPAN="1" ROWSPAN="1" BGCOLOR="#F2F2F2"> <FORM ACTION="amend2.php" METHOD="post"> <P ALIGN="LEFT"> <INPUT TYPE="hidden" NAME="IdNumber" VALUE="<? echo "$record" ?>"> <BR>Agent Name:<BR><TEXTAREA NAME="AgentName" COLS="50" ROWS="4"> <? echo "$description"?></TEXTAREA></P><P ALIGN="LEFT">Description:<BR> <TEXTAREA NAME="ud_text2" COLS="50" ROWS="4"><? echo "$text2"?></TEXTAREA></P><HR><B> </B><P ALIGN="LEFT">Thumbnail:<BR> <INPUT TYPE="text" NAME="ud_thumb" VALUE="<? echo "$thumb"?>" SIZE="30" MAXLENGTH="50"></P><P ALIGN="LEFT">Image 1 :<BR> <INPUT TYPE="text" NAME="ud_img1" VALUE="<? echo "$img1"?>" SIZE="30" MAXLENGTH="50"></P><P ALIGN="LEFT">Image 2 :<BR> <INPUT TYPE="text" NAME="ud_img2" VALUE="<? echo "$img2"?>" SIZE="30" MAXLENGTH="50"></P><P ALIGN="LEFT">Image 3 :<BR> <INPUT TYPE="text" NAME="ud_img3" VALUE="<? echo "$img3"?>" SIZE="30" MAXLENGTH="50"><BR><BR> </P><P><INPUT TYPE="Submit" VALUE="Update the Record" NAME="Submit"> </P></FORM></TD></TR></TABLE> <? ++$i; } ?> can someone please tell me what I have or havnt done and how to get it show the record in a table, that I have selected on amend.php, as I believe this is what it is trying to get me todo, but i can get it to work. thanks