hi all
I am definately stuck now. i have managed to insert data into my table
using php and sql staements.
I have also managed to display that data on a single page.
the points where i am stuck
1) how do i display all the data contained in the table and not just the
one row?
2) i have my input form up and ready. a place for the header, test and a
drop down box containing the 40 pages i want to choose from to update.
how do i send the correct header text and the chioce in the drop down to
the correct table?
i think thats it for now lol. any help would be grately appreciated
kind regards
Mark...
Mark Mckee wrote:
> thank you for the help.
>
> i wil keep trying to get it working.
>
> Michael Sullivan wrote:
>
>>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
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
> 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
>
>
>
>
>
>
>
>
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/