i managed to complete it and it all works brilliantly.
thank you for putting me in the right direction
Mark Mckee wrote:
> 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
>
>
>
>
>
>
>
>
>
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/