"supplied argument is not a valid"

tranquillo · Jan 9, 2003

Hi... I'd be really glad if someone would like to take a look at my code here and tell me what's wrong with the "arbetsplats" function.
everything else works fine, and that function is the same as the others... I just can't see what's wrong...

---------------------------
this is the form:
---------------------------

Personnummer :
<input type="text" name="pnr">

Förnamn :
<input type="text" name="fnamn">

Efternamn :
<input type="text" name="enamn">

<input type="checkbox" name="info" value="skyddsombud.fnamn, skyddsombud.gatuadress,
skyddsombud.postnummer, skyddsombud.ort">Info

<input type="checkbox" name="utbildning" value="utford_utbildning.kursID, utford_utbildning.datum,
utbildning.beskrivning">Utbildning

<input type="checkbox" name="arbetsplats" value="arbetsplats.organisationsnummer,
arbetsplats.org_namn, arbetsplats.gatuadress, arbetsplats.ort, arbetsplats.verksamhet">Arbetsplats

<input type="checkbox" name="skyddsomrade" value="skyddsomrade.omrade, skyddsomrade.organisationsnummer">Skyddsområde

<input type="checkbox" name="mandat" value="mandat.startdatum, mandat.sltopdatum">Mandat

<td><input type="submit" name="Submit" value="Submit">

---------------------------
this is the php code:
---------------------------

$persnr = $_POST["pnr"];
$fnamn = $_POST["fnamn"];
$enamn = $_POST["enamn"];
$info = $_POST["info"];
$arbetsplats = $_POST["arbetsplats"];
$skyddsomrade = $_POST["skyddsomrade"];
$utbildning = $_POST["utbildning"];
$mandat = $_POST["mandat"];

$fraga="select distinct skyddsombud.personnummer, skyddsombud.enamn";

if ($info)
$fraga.= ", $info";

if($utbildning)
$fraga.= ", $utbildning";

if ($arbetsplats)
$fraga.= ", $arbetsplats";

if ($skyddsomrade)
$fraga.= ", $skyddsomrade";

if ($mandat)
$fraga.= ", $mandat";

$fraga.= " FROM skyddsombud";

if ($utbildning)
$fraga.= ", utford_utbildning, utbildning";

if ($arbetsplats)
$fraga.= ", mandat, skyddsomrade, arbetsplats";

if ($skyddsomrade)
$fraga.= ", mandat, skyddsomrade";

if ($mandat)
$fraga.= ", mandat";

$fraga.= " WHERE skyddsombud.personnummer='$persnr' OR skyddsombud.fnamn='$fnamn'
OR skyddsombud.enamn='$enamn'";

if ($utbildning)
$fraga.= " and skyddsombud.personnummer=utford_utbildning.personnummer and
utford_utbildning.kursID=utbildning.kursID";

if ($arbetsplats)
$fraga.= " and skyddsombud.personnummer=mandat.personnummer and
mandat.skyddsomradesID=skyddsomrade.skyddsomradesID and
skyddsomrade.organisationsnummer=arbetsplats.organisatinsnummer";

if ($skyddsomrade)
$fraga.= " and skyddsombud.personnummer=mandat.personnummer and
mandat.skyddsomradesID=skyddsomrade.skyddsomradesID";

if ($mandat)
$fraga.= " and skyddsombud.personnummer=mandat.personnummer";

$result = mysql_query($fraga,$db);

if ($info)
{
printf("Förnamn: %s \n", mysql_result($result,0,"fnamn&quot

);
printf("Efternamn: %s \n", mysql_result($result,0,"enamn&quot

);
printf("Personnummer: %s \n", mysql_result($result,0,"personnummer&quot

);
printf("Gatuadress: %s \n", mysql_result($result,0,"gatuadress&quot

);
printf("Postnummer: %s \n", mysql_result($result,0,"postnummer&quot

);
printf("Ort: %s \n", mysql_result($result,0,"ort&quot

);
}

if ($utbildning)
{
printf("Kurs ID: %s \n", mysql_result($result,0,"kursID&quot

);
printf("datum: %s \n", mysql_result($result,0,"datum&quot

);
printf("Beskrivning: %s \n", mysql_result($result,0,"beskrivning&quot

);
}

if ($arbetsplats)
{
printf("Organisationsnummer: %s \n", mysql_result($result,0,"organisationsnummer&quot

);
printf("Företagets namn: %s \n", mysql_result($result,0,"org_namn&quot

);
printf("adress: %s \n", mysql_result($result,0,"gatuadress&quot

);
printf("ort: %s \n", mysql_result($result,0,"ort&quot

);
printf("verksamhets beskrivning: %s \n", mysql_result($result,0,"verksamhet&quot

);
}

if ($skyddsomrade)
{
printf("skyddsområde: %s \n", mysql_result($result,0,"omrade&quot

);
printf("organisationsnummer: %s \n", mysql_result($result,0,"organisationsnummer&quot

);
}

if ($mandat)
{
printf("startdatum: %s \n", mysql_result($result,0,"startdatum&quot

);
printf("stopdatum: %s \n", mysql_result($result,0,"sltopdatum&quot

);
}

?>

---------------------------

I know this is a lot... but I realy hope someone could just look it over... because I just can't see what differs the "arbetsplats" from any of the other functions.

thanks alot

------
stefan
------

sleipnir214 · Jan 9, 2003

The title of your post is "Supplied argument is not a valid". Not a valid what? What error messages are you getting for what line of this code? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

tranquillo · Jan 9, 2003

hehe... sorry bout that...

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\phpdev\

http://www\public\databas\resultat_test.php

on line 80

the same on line 81,82,83,84

thanks for looking at it!

-stefan.

swampBoogie · Jan 9, 2003

Add some debug

$result = mysql_query($fraga,$db) or die(mysql_error() . " when processing " . $fraga );

There probably is some syntacical error in the SQL statement.

tranquillo · Jan 9, 2003

thank you sooo much... I'll try that...

what exactly does that thing do btw?

thanks again..

-stefan

tranquillo · Jan 9, 2003

didn't work... :/

swampBoogie · Jan 9, 2003

>> didn't work.

Could you be a speck more informative?

What have you done and what is the result?

What does the query look like if you echo it?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

"supplied argument is not a valid"

tranquillo

Technical User

sleipnir214

Programmer

tranquillo

Technical User

swampBoogie

Programmer

tranquillo

Technical User

tranquillo

Technical User

swampBoogie

Programmer

Similar threads

Part and Inventory Search

Sponsor

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

&quot;supplied argument is not a valid&quot;

tranquillo

Technical User

sleipnir214

Programmer

tranquillo

Technical User

swampBoogie

Programmer

tranquillo

Technical User

tranquillo

Technical User

swampBoogie

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor

"supplied argument is not a valid"