Posted by cashmere on 06/19/06 10:36

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

[Back to original message]