|
|
Posted by cashmere on 06/21/06 14:41
cashmere@t-online.de wrote:
> 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
Hey figured it out. exit; !!
Navigation:
[Reply to this message]
|