This is more like what we want to see and pointing us to which line causes
the error would help even more. But from this, you're mixing up your INSERT
and UPDATE statements for starters. What you have would be correct if you
replaced INSERT INTO with UPDATE. For INSERT, it is a comma delimited list
of values enclosed by brackets. Please RTFM.
----- Original Message -----
From: "Stink" <[EMAIL PROTECTED]>
To: "Werner Stuerenburg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 19:31
Subject: Re: Re[4]: saving in mysql
> > What do you send to MySQL? $query is just a string.
>
> well i send to you only a part of code, here is complete example of it:
>
> [the login stuff]
>
> $zapytanie = "INSERT INTO aktualnosci SET tytul='$tytul',
przemd='$przemd',
> przeml='$przeml', przemm='$przemm', polska='$polska', swiat='$swiat',
> data='$data', lead='$lead', tresc1='$tresc1', tresc2='$tresc2',
> tresc3='$tresc3', tresc4='$tresc4', tresc5='$tresc5', autor='$autor',
> dzial='$dzial', standart='$jest'";
>
> $wynik = mysql_query($zapytanie);
> if($wynik) echo "<center><b>Artyku| dodany prawid|owo!</b><br>
> </center>";
> else {
> echo "<center>B|_d przy dodawaniu artyku|u - sprˇbuj jeszcze
> raz.<br></center>";
> }
>
> the data is coming from a form...
>
> > > MySQL pops out a error message - "unable to save result set in
> example.php
> > > on line xxx"
> > > but the data gets put inside the database anyway...
> >
> > Why should php try to save something into a file? You must tell
> > it to do so. And if you do, you have bad luck. php runs as
> > nobody, and nobody should not be able to write to files.
>
> but i do NOT write anything into a file...
> the comes from the form and is saved in the database as in the code above.
> i do not use any files here...
>
> i must mention that it must be something with system i think. the server
was
> run on linux red hat 7, but a week ago it was moved because the firm moved
.
> and then it was reinstalled also, admin installed debian instead of red
hat
> [i don't know what for anyway, but admin is always admin ;)]. and before
> [when red hat was on] there was no such problem, and all scripts ran well
> without this error messages. now - i dont know , maybe php is configured
> badly ? have no idea...
>
> > The problem is not with MySQL, as is obvious.
>
> i think so
>
> > You should look for line xxx. Here you will try to write to the
> > file, which cannot work unless you define the rights accordingly.
> > You may chmod the rights on the file you want to write to or put
> > that file into a directory open for nobody.
>
> as i said, i do not use any file...
>
> > --
> > Herzlich
> > Werner Stuerenburg
>
> stink
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
