Posted by cashmere on 06/18/06 09:38

cashmere@t-online.de wrote:
> cashmere@t-online.de wrote:
> > cashmere@t-online.de wrote:
> > > Geoff Berrow wrote:
> > > > Message-ID: <1150560684.019895.139910@i40g2000cwc.googlegroups.com> from
> > > > cashmere@t-online.de contained the following:
> > > >
> > > > >Thanks Geoff - I'm gettting a parse error but looking to see if it's
> > > > >maybe a typo.
> > > >
> > > > This may fix it
> > > >
> > > > if(mysql_query("INSERT INTO `multiple` VALUES
> > > > ('$_POST[id]','$_POST[joketext]')")){
> > > > --
> > > > Geoff Berrow 0110001001101100010000000110
> > > > 001101101011011001000110111101100111001011
> > > > 100110001101101111001011100111010101101011
Hey Geoff,
It now works - somehow a part of the form had got mysteriously
swallowed up!! (input type=)
Yippee! Now to get to work adding drop downs and checkboxes etc.
Thanks A LOT. Now I know you can put 2 POST[variable]s on one line.
Cheers Dave
> > >
> > > Thanks Geoff - that got rid of the parse error - I was trying out
> > > different brackets there too.
> > > Now it looks ok, but this time the text doesn't make it into the
> > > content field, even though the "Joke added" text is displayed.
> > > I'm now going to go back through some of my previous attempts using
> > > your above syntax.
> > > Well, I say now, but the footie starts in 2 mins! (Italy v USA).
> > > Cheers Dave
> >
> > Sorry mens libertina, I didn't see your post till now.
> > I'm going to try re-phrasing my problem and will be back shortly.
> > Thanks you guys it's really appreciated.
> > Cheers Dave
>
> OK here we go:
> I get one or more results from a database, that contains people's IDs
> and names. I have made the returned entries clickable so the user can
> pick the one they're interested in, if more than one entries were
> returned.
> I found through trial and error that these 2 variations both pass the
> clicked member's id to the url of the msg_form page
>
> <a href=msg_form.php?id=$memb_id'>$memb_id</a></td> // or
>
> <a href='msg_form.php?id={$r[0]}'>$r[0]</a></td>
> and it was easy to get that value into the INSERT statement.
>
> What my original intention was (and of course still is) is for the user
> to enter text via a text field, that will be entered using an UPDATE
> query into the new table (called multiple) which (so far) consists of 2
> columns, 'id' INT(5) not NULL not auto-increment, and 'content'
> TEXT(100).
> Of course this
>
> $id=$_GET['id'];
> mysql_query("INSERT into `multiple` VALUES ('$id','')");
>
> from my above-posted script runs as soon as the url is clicked. It
> creates a row with the id from the url, and the content field empty.
> When I try to fill the content field with the text from the form,I find
> that the UPDATE instead creates a new row with an id of zero, and the
> text correctly in the content field, while the previously inserted row
> with the 5 digit id remains unaltered.
> So obviously the value of $id is gone at that point!
> I then tried to create a session id with that value and pass that to
> the UPDATE query, as well as some other stuff, none of which I could
> get to work.
> So that's where I'm at at this point. Learned a couple of things in the
> process though.
> When you think about it, it should be easy!
> Cheers Dave

[Back to original message]