Posted by cashmere on 06/21/06 13:33

cashmere@t-online.de wrote:
> cashmere@t-online.de wrote:
> > mens libertina wrote:
> > > cashmere@t-online.de wrote:
> > > > When you think about it, it should be easy!
> > >
> > >
> > > To paraphrase Bruce Lee: when you gain true understanding of the
> > > problem, the solution presents itself.
> > >
> > > Glad you got through it and good luck :)
> >
> > Hey I don't kid myself that I know what I'm doing. I meant easy for
> > youse guys.
> > I take my hat off to those who really do.
> > Anyway guys, I changed things a little and have a new prob.!
> > I realised that every id needs its own database!! (cos there are a lot
> > of 'em.)
> > It was easy to get the value from the url as before
> > $db = $_GET['id'];
> > etc
> > if (mysql_creat_db("$db")) {
> > etc
> >
> > then
> >
> > mysql_select_db("$db");
> > $sql='CREATE TABLE `multiple`( ìd` int(5) NOT NULL `content` text NOT
> > NULL
> > etc PRIMARY KEY (ìd`)) ; // could be typos in there I'm not pasting
> > (on wrong computer)
> > mysql_query($sql);
> >
> > OK, the above creates a database called whatever 5 digit id was
> > clicked, and creates a table in it called multiple which has 2 columns,
> > id and content.
> > Now, looking at the page with the form for posting the user content, I
> > first figured I'd copy/paste all of it at the end of the above but that
> > just hung for a while. Obviously not a good idea as the FORM
> > ACTION='<?php echo($_SERVER[PHP_SELF']) part was not working.
> > So I removed that again and instead put this line at the bottom
> > print ("Click <a href='msg_form.php?id=$db'>here!</a>;
> > This takes me to the form page that we got working before, and here I
> > replaced
> > mysql_select_db("memb_id") or die etc. with mysql_select_db("$id") or
> > die etc.
> > And promptly got No Database Selected.
> > Attempts to get the $_GET variable in there resulted in parse errors.
> > Just to be sure the script is otherwise working, if I hardcode the
> > particular id as the database name, everything works. The comment gets
> > posted into the comment field.
> > So how to get the just-created database selected? Any ideas?
> > Cheers Dave
>
> Sorry guys, plr disregard the above. When I put $_POST['id'] as the db
> name, it worked!!
> Of course, you might say.
> Cheers Dave

Hi-ya everyone,
How would I stop the form reappearing?
Cheers Dave

[Back to original message]