Hi
I have used the mysql_result function to return some specific information
from database. The information is returned as it should but I keep getting
this error message:
Warning: Unable to jump to row 0 on MySQL result index 4 in
/u1.bath/s31/eh842/public_html/SCR/register/process.php on line 140
I'm relatively new to PHP and am unable to solve the problem so I wondered
if someone would mind spending a couple of minutes to help me.
My script, in part, reads as below:
// check to see if company exists in db
$CompanyQuery = mysql_query("SELECT coid FROM co_details WHERE co_name =
'$company' AND co_city = '$city' AND co_country = '$co_country'");
$CompanyExist = mysql_num_rows($CompanyQuery);
$company_id= mysql_result($CompanyQuery,0,0);
if ($CompanyExist > 0) {
//if company exists add workplace details
$confirmkey = md5(uniqid(rand()));
$signup_id = signup_details($username, $title, $fname, $lname, $email,
$country, $job_title, $user_notes, $agree_terms, $confirmkey,$password);
addworkplace($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year );
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
} //END if statement
else { //add company and workplace details
// Add new member to table signup
$confirmkey = md5(uniqid(rand()));
$signup_id = signup_details($username, $title, $fname, $lname,
$email, $country, $job_title, $user_notes, $agree_terms, $confirmkey,
$password);
$company_id = company_details($company, $city, $co_country);
addworkplace($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year );
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
} // END else statement
}
// if successful in adding to vAuthenticate, send confirmation email
if (mysql_errno() == 0){
$emailerMessage .= "\n\n"; // 2 Line Breaks
$emailerMessage .= $confirm; // URL to confirm.php -> see email.inc
$emailerMessage .= "?confirmkey=" . $confirmkey; // add confirm key to
message
$emailerMessage .= "\n\n"; // 2 Line Breaks
$sent = @mail($email, $emailerSubject, $emailerMessage,
"From:$emailerName<$emailerEmail>\nReply-to:$emailerEmail");
} // END if statement
}
function signup_details($username, $title, $fname, $lname, $email, $country,
$job_title, $user_notes, $agree_terms, $confirmkey, $password) {
if ($user_notes == '') {
$user_notes = "Member chose not to include a profile";
$sql = "INSERT INTO signup VALUES
('','$username','$title','$fname','$lname','$email','$country','$job_title',
'$user_notes','$agree_terms',NOW(),'$confirmkey')";
$addmember = mysql_query($sql);
$memberid=mysql_insert_id();
// If SUCCESSFUL, add to vAuthenticate tables too
if (mysql_errno() == 0){
$AddToAuth = new auth();
$add =
$AddToAuth->add_user($username,$password,"Ungrouped","999","inactive", '',
0);
}
else{
print "this is the signup details sql statement\n ";
print $sql."\n";
print mysql_errno() . ": " . mysql_error() . "\n";
exit;
}
return $memberid;
}// END if
else {
$user_notes = addslashes($user_notes);
$sql = "INSERT INTO signup VALUES
('','$username','$title','$fname','$lname','$email','$country','$job_title',
'$user_notes','$agree_terms',NOW(),'$confirmkey')";
$addmember = mysql_query($sql);
$memberid=mysql_insert_id();
// If SUCCESSFUL, add to vAuthenticate tables too
if (mysql_errno() == 0){
$AddToAuth = new auth();
$add =
$AddToAuth->add_user($username,$password,"Ungrouped","999","inactive", '',
0);
}
else{
print "this is the signup details sql statement\n ";
print $sql."\n";
print mysql_errno() . ": " . mysql_error() . "\n";
exit;
}
return $memberid;
}// END else
} // END function
function company_details($company, $city, $co_country)
{
$newcompanysql = "INSERT INTO co_details VALUES
('','$company','$city','$co_country')";
$add_company= mysql_query($newcompanysql);
if (mysql_errno() > 0){
print "add compnay details \n";
print $newcompanysql. "\n";
print mysql_errno() . ": ".mysql_error() . "\n";
exit;
}
else
return mysql_insert_id();
}
function addworkplace ($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year)
{
//start date in correct format
$start_date= $start_year."-".$start_month."-01";
//end date in correct format
$end_date = $end_year."-".$end_month."-01";
/* if ($end_month || $end_year == "Present")
$end_date="NULL";
else
$end_date=$end_year."-".$end_month."-01";
*/
$worksql = "INSERT INTO workplace VALUES
('','$signup_id','$company_id','$end_date','$start_date','$department')";
mysql_query($worksql);
// need to meddle with date to get correct format
if (mysql_errno() > 0){
print "<p>add workplace details</p>";
print "<p>" . $worksql. "</p>";
print mysql_errno() . ": ".mysql_error() ;
exit;
}
Please contact me if you require further information.
Many thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
