On Tue, 2006-03-21 at 00:52 +0000, Mark Mckee wrote:
> hi all
>
> i want to create an inut page for the content on my website. is it
> possible to have 1 data entry box and choose the specific what table
> of
> a database to put it usign a drop down box?
>
> if so, can someone please point me in the right direction. i have
> been
> troubling over this for the last few days
>
> thanks in adavce
>
> mark m...
I don't see why this wouldn't be possible. You would just use the table
name selected from the list box in constructing the query string you use
in your mysql_query.
Ex.
I select 'SomeTable' from a list box called 'list' and hit the Submit
button. Another page is called, in which is a line like this:
$list = $_POST['list'];
You code says:
$query = "SELECT * FROM ".$list;
Then you issue
$result = mysql_query($query, $link2DB) or die ("Could not access table
$list:".mysql_error());
or whatever you want...
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/