Problemwith application form

homer09001

here the error message:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/vsrafd2/public_html/Roster/apply.php3 on line 30

and my code

<?php
print "<BODY BGCOLOR=\"#CCCCCC\">";
$DBhost = "localhost"; /* DON'T CHANGE should be fine as it is ok*/
$DBuser = "**********";
$DBpass = "****";
$DBName = "********";
$table = "pilotinfo";  /* DON'T CHANGE*/
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db($DBName) or die("Unable to select
database $DBName");


$name = $_POST['name'];
$email = $_POST['email'];
$age = $_POST['age'];
$history = $_POST['history'];
$webaddyhist = $_POST['webaddyhist'];
$role = $_POST['role'];
$comments = $_POST['comments'];
$registered_on = gmdate("l d M Y");
$registered_at = gmdate("H:i:s");
$regcode = md5(uniqid(rand(),1));

$sqlquery = "INSERT INTO $table values ('$id','$visible','$name','$email','$age','$history','$webaddyhist','$role','$comments',0,'$registered_on','$registered_at','$regcode')";
$results = mysql_query($sqlquery);

$idquery = "SELECT id FROM $table WHERE regcode='$regcode'";  

$results2 = mysql_query($idquery); 
$pid = mysql_result($results2,0,"id");

####################################
#confirmation e-mail settings Below#
####################################
$subject = "New V-RAF.co.uk Registration";
$message = "A New User Has Registered

here's the information they submitted:

Name:  $name
E-Mail:  $email
Age:  $age
History: $history
Web address or e-mail of previous Site or CEO:  $webaddyhist
Role:  $role
Comments:  $comments
They registered on:  $registered_on
They registered at:  $registered_at


Before you appear on the roster and before you can file pireps you are required to activate your account to do so please click on this link to activate your account http://www.v-raf.co.uk/activate.php?code=$regcode&id=$pid

May i thank you again for joining us here at easyJet Virtual

Daniel Hill
CEO

If you recieved this e-mail in error please delete it.

PLEASE DO NOT respond to this e-mail as it is an automaticaly generated e-mail.";
$headers = "From: SOME EMAIL ADDRES HERE";
$mailsend = mail($email,$subject,$message,$headers);
#####################################
#End of confirmation e-mail settings#
#####################################


mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Name : $name
<p>
E-Mail : $email
<p
age : $age
<p>
History : $history
<p>
Url of previous VA or E-Mail address : $webaddyhist
<p>
Your Role within V-RAF : $role
<p>
Comments : $comments
</blockquote></td></tr></table>
</center></BODY></HTML>";
?>

what i dont understand is this works on y other server but not this 1 any ideas?

maxpup979

have you moved the data from one mysql instance to the other? the error you are getting is being caused by no results coming back.

homer09001

u mena im getting that error because theres no data in teh database?

if so i never had that problem before and if so how am i ment to enter data?

maxpup979

you probably had data in your other database. what you could do (and probably should do) is before you try to assign the value in the record, check to make sure that the recordset isnt empty.

And you can enter data a number of ways. if you have phpmyadmin or such on your server, you can throw in some test data. you can export the existing data from your old database, you can write a simple script that just inserts a bunch of proper values.

homer09001

ok ive inserted a record using phpmyadmin and im still getting the error

btw im a newb to php and mysql

its anoying me because all its ment to do is insert the data they entered into teh database and send an e-mail to someone containing a link on which they click to activate their account

thats where the error on line 30 comes in thats the bit that gets the id No of teh member who just registered out teh database and puts it in teh url

ui got me?

maxpup979

hmmm...this code should work...in theory anyway....try running the script again, and checking what is in the table pilotinfo after it errors out. you arent running in a transaction, so the insert should happen. And until you get this fixed, get rid of the @ in front of the mysql functions. that supresses the errors.

homer09001

found out y i had 14 fields in my db and only 13 bits of data where being entered so it was entering it working now thanx anyway