help with an error -- should be simple?

[cschuldt]

I am receiving this error and can't figure it out:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /nfs/home/user/public_html/frtest/process.php on line 9

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /nfs/home/user/public_html/frtest/process.php on line 10

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /nfs/home/user/public_html/frtest/process.php on line 11

here is my code:

$OrganizerName= $_POST['OrganizerName'];

mysql_connect("localhost","dbusername","password");
mysql_select_db("dbname");
$result1=mysql_query("SELECT Region, Organizer_Email, Desk_Email FROM organizer_biog WHERE Organizer_Name = $OrganizerName");
$Region=mysql_result($result1, 0, "Region");
$OrgEmail=mysql_result($result1, 0, "Organizer_Email");
$DeskEmail=mysql_result($result1, 0, "Desk_Email");

[LordShryku]

Use [man]mysql_error[/man]

[cschuldt]

I checked the mysql errors and was able to get the script to run without any errors.

Now one of three things is happening:
1. The db query isn't selecting the data that I think it should.
2. The db query is selecting the data, but it my variable assignment isn't "taking".
3. Or, my query to resend the data back to the database isn't working correctly for the specified fields.

How do I know this:
1. mail isn't being sent with the mail() function in my code
2. Region isn't being posted into my database.

The script runs without error, it just doesn't do what I want it to do. Can someone look at my entire script and let me know where I'm going wrong?

<?php
include("global.inc.php");


mysql_connect("localhost","dbusername","password");
mysql_select_db("dbname");
$result1=mysql_query("SELECT Region, Organizer_Email, Desk_Email FROM organizer_biog WHERE Organizer_Name = '".$POST['OrganizerName']."'") or die("MySQL Error: ".mysql_error()."\n<br/>SQL: ".$query); 
$Region=@mysql_result($result1, "Region");
$OrgEmail=@mysql_result($result1, "Organizer_Email");
$DeskEmail=@mysql_result($result1, "Desk_Email");

$errors=0;
$error="The following errors occured while processing your form input.<ul>";
pt_register('POST','OrganizerName');
pt_register('POST','Date');
pt_register('POST','lapgd');
pt_register('POST','lapgc');
pt_register('POST','lapgna');
pt_register('POST','lapglm');
pt_register('POST','lapgbn');
pt_register('POST','lapgwn');
pt_register('POST','lapvd');
pt_register('POST','lapvc');
pt_register('POST','lapvna');
pt_register('POST','lapvlm');
pt_register('POST','lapvbn');
pt_register('POST','lapvwn');
pt_register('POST','medgd');
pt_register('POST','medgc');
pt_register('POST','medgna');
pt_register('POST','medglm');
pt_register('POST','medgbn');
pt_register('POST','medgwn');
pt_register('POST','medgmail');
pt_register('POST','medvd');
pt_register('POST','medvc');
pt_register('POST','medvna');
pt_register('POST','medvlm');
pt_register('POST','medvbn');
pt_register('POST','medvwn');
pt_register('POST','medvmail');
pt_register('POST','vetgd');
pt_register('POST','vetgc');
pt_register('POST','vetgna');
pt_register('POST','vetglm');
pt_register('POST','vetgbn');
pt_register('POST','vetgwn');
pt_register('POST','vetgvfd');
pt_register('POST','vetvd');
pt_register('POST','vetvc');
pt_register('POST','vetvna');
pt_register('POST','vetvlm');
pt_register('POST','vetvbn');
pt_register('POST','vetvwn');
pt_register('POST','vetvvfd');
pt_register('POST','lacgk');
pt_register('POST','lacgc');
pt_register('POST','lacgwa');
pt_register('POST','lacgba');
pt_register('POST','lacvk');
pt_register('POST','lacvc');
pt_register('POST','lacvwa');
pt_register('POST','lacvba');
pt_register('POST','voltvols');
pt_register('POST','volpvols');
pt_register('POST','volcvols');
pt_register('POST','voltomo');
pt_register('POST','volrcd');
pt_register('POST','volrcc');
pt_register('POST','volnew');
pt_register('POST','vollttes');
pt_register('POST','vollttesub');
pt_register('POST','vollttep');
pt_register('POST','Ones');
pt_register('POST','TwoVs');
pt_register('POST','TwoWs');
pt_register('POST','Threes');
pt_register('POST','Fours');
if($OrganizerName=="" || $Date=="" || $lapgd=="" || $lapgc=="" || $lapgna=="" || $lapglm=="" || $lapgbn=="" || $lapgwn=="" || $lapvd=="" || $lapvc=="" || $lapvna=="" || $lapvlm=="" || $lapvbn=="" || $lapvwn=="" || $medgd=="" || $medgc=="" || $medgna=="" || $medglm=="" || $medgbn=="" || $medgwn=="" || $medgmail=="" || $medvd=="" || $medvc=="" || $medvna=="" || $medvlm=="" || $medvbn=="" || $medvwn=="" || $medvmail=="" || $vetgd=="" || $vetgc=="" || $vetgna=="" || $vetglm=="" || $vetgbn=="" || $vetgwn=="" || $vetgvfd=="" || $vetvd=="" || $vetvc=="" || $vetvna=="" || $vetvlm=="" || $vetvbn=="" || $vetvwn=="" || $vetvvfd=="" || $lacgk=="" || $lacgc=="" || $lacgwa=="" || $lacgba=="" || $lacvk=="" || $lacvc=="" || $lacvwa=="" || $lacvba=="" || $voltvols=="" || $volpvols=="" || $volcvols=="" || $voltomo=="" || $volrcd=="" || $volrcc=="" || $volnew=="" || $vollttes=="" || $vollttesub=="" || $vollttep=="" || $Ones=="" || $TwoVs=="" || $TwoWs=="" || $Threes=="" || $Fours=="" ){
$errors=1;
$error.="<li>You did not enter one or more of the required fields. Please go back and try again.";
}
if($errors==1) echo $error;
else{
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));
$message="Organizer Name: ".$OrganizerName."
Region: ".$Region."
Date: ".$Date."
lapgd: ".$lapgd."
lapgc: ".$lapgc."
lapgna: ".$lapgna."
lapglm: ".$lapglm."
lapgbn: ".$lapgbn."
lapgwn: ".$lapgwn."
lapvd: ".$lapvd."
lapvc: ".$lapvc."
lapvna: ".$lapvna."
lapvlm: ".$lapvlm."
lapvbn: ".$lapvbn."
lapvwn: ".$lapvwn."
medgd: ".$medgd."
medgc: ".$medgc."
medgna: ".$medgna."
medglm: ".$medglm."
medgbn: ".$medgbn."
medgwn: ".$medgwn."
medgmail: ".$medgmail."
medvd: ".$medvd."
medvc: ".$medvc."
medvna: ".$medvna."
medvlm: ".$medvlm."
medvbn: ".$medvbn."
medvwn: ".$medvwn."
medvmail: ".$medvmail."
vetgd: ".$vetgd."
vetgc: ".$vetgc."
vetgna: ".$vetgna."
vetglm: ".$vetglm."
vetgbn: ".$vetgbn."
vetgwn: ".$vetgwn."
vetgvfd: ".$vetgvfd."
vetvd: ".$vetvd."
vetvc: ".$vetvc."
vetvna: ".$vetvna."
vetvlm: ".$vetvlm."
vetvbn: ".$vetvbn."
vetvwn: ".$vetvwn."
vetvvfd: ".$vetvvfd."
lacgk: ".$lacgk."
lacgc: ".$lacgc."
lacgwa: ".$lacgwa."
lacgba: ".$lacgba."
lacvk: ".$lacvk."
lacvc: ".$lacvc."
lacvwa: ".$lacvwa."
lacvba: ".$lacvba."
voltvols: ".$voltvols."
volpvols: ".$volpvols."
volcvols: ".$volcvols."
voltomo: ".$voltomo."
volrcd: ".$volrcd."
volrcc: ".$volrcc."
volnew: ".$volnew."
vollttes: ".$vollttes."
vollttesub: ".$vollttesub."
vollttep: ".$vollttep."
Ones: ".$Ones."
TwoVs: ".$TwoVs."
TwoWs: ".$TwoWs."
Threes: ".$Threes."
Fours: ".$Fours."
";

mail($OrgEmail, "Sugject", "Message");
mail($DeskEmail,"Desk Subject", "Desk Message");


$query2="insert into organizer_tallies (Organizer_Name,Region,Date,lapgd,lapgc,lapgna,lapglm,lapgbn,lapgwn,lapvd,lapvc,lapvna,lapvlm,lapvbn,lapvwn,medgd,medgc,medgna,medglm,medgbn,medgwn,medgmail,medvd,medvc,medvna,medvlm,medvbn,medvwn,medvmail,vetgd,vetgc,vetgna,vetglm,vetgbn,vetgwn,vetgvfd,vetvd,vetvc,vetvna,vetvlm,vetvbn,vetvwn,vetvvfd,lacgk,lacgc,lacgwa,lacgba,lacvk,lacvc,lacvwa,lacvba,voltvols,volpvols,volcvols,voltomo,volrcd,volrcc,volnew,vollttes,vollttesub,vollttep,Ones,TwoVs,TwoWs,Threes,Fours) values ('".$OrganizerName."','".$Region."','".$Date."','".$lapgd."','".$lapgc."','".$lapgna."','".$lapglm."','".$lapgbn."','".$lapgwn."','".$lapvd."','".$lapvc."','".$lapvna."','".$lapvlm."','".$lapvbn."','".$lapvwn."','".$medgd."','".$medgc."','".$medgna."','".$medglm."','".$medgbn."','".$medgwn."','".$medgmail."','".$medvd."','".$medvc."','".$medvna."','".$medvlm."','".$medvbn."','".$medvwn."','".$medvmail."','".$vetgd."','".$vetgc."','".$vetgna."','".$vetglm."','".$vetgbn."','".$vetgwn."','".$vetgvfd."','".$vetvd."','".$vetvc."','".$vetvna."','".$vetvlm."','".$vetvbn."','".$vetvwn."','".$vetvvfd."','".$lacgk."','".$lacgc."','".$lacgwa."','".$lacgba."','".$lacvk."','".$lacvc."','".$lacvwa."','".$lacvba."','".$voltvols."','".$volpvols."','".$volcvols."','".$voltomo."','".$volrcd."','".$volrcc."','".$volnew."','".$vollttes."','".$vollttesub."','".$vollttep."','".$Ones."','".$TwoVs."','".$TwoWs."','".$Threes."','".$Fours."')";
mysql_query($query2);


?><?php 
}
?>

[dalecosp]

I ask your forgiveness if I'm wrong and wasting
your time, (I hardly ever use mysql_result, 'cause
I prefer grabbing arrays...) but

//shouldn't this...

$Region=@mysql_result($result1, "Region"); 

// be this instead?

$Region=@mysql_result($result1, 0, "Region"); 

or at least have some indicator of the row?

[marky2coats]

Yes, if its the first row you want then 0 it is.

Mark.

[cschuldt]

I tried that, and there still is not syntax errors or mysql errors, but still no insertion of the correct value for "Region" and still no email being sent to either address.

I am stumped.

Help?!

[laserlight]

Post your updated code.

Also, it might be good to work on a separate test script that is similiar to the one you're debugging, but has less distractions.

[cschuldt]

My revised code is exactly as seen above, making the changes noted above where I changed the mysql_result command to include the '0'

😕

[laserlight]

Are there any correct values being inserted for other fields?

Do you have error reporting set to E_ALL?

Really, the problem with debugging your script is:
1. It isnt well commented.
2. It isnt well formatted, e.g. indentation.
3. It contains the full code, which includes useless junk when it comes to debugging.
This 'junk' is only useful in the actual code.

#3 isnt so much of a problem if we were actually involved with your project.
But we're here providing free consultation, so it would be best if you provided a form that is easy to spot mistakes.

Who knows, while trying to get into this form, you may (or probably will) find out the error yourself, and fix it.

[cschuldt]

The correct values for all of the other fields are being inserted just fine.

I have error checking set to E_ALL

I know the formatting on this is poor. No excuses for that, I realize it doesn't make it easy to read.

I posted the entire script because to be honest, I'm not sure where the script is failing to execute. I'm almost positive that it isn't fetching 'Region' correctly in the first query (at the top of the code).

I appreciate everyone looking at it, and if anyone else has any clues, I'll surely appreciate those as well.

In the meantime, I'm going to try a shorter 'test' script as suggested.