Hi TG! First of all thank you very much for your corrections to my English. I accept them in good faith. Finding people like yourself is great because that way I can improve my English. If happen for you to like Spanish, I might be able to help you no matter what the cost. Just let me know, ok?. I guess that way I could learn better English.
Now, letīs get down to the point. As a matter of fact I havenīt tried your sugestions on the PHP script yet. First there are some details I need to understand much better (is "much" well used here this time?) > Ok, if I understand what you're asking, here's how your scripts are set up: > 1. One page/script lets users enter information that is then stored into > the database That is correct. > 2. Another page/script displays links (href links right?). One for each > item submitted to the database Correct. > 3. A third page (?) displays the data or maybe the links point directly to > a text file that's created on the server. Correct again. There are several pages that will do this because there are several tables in the Database. Each table is used for an specific user and itīs data. That is why the script for one page is a little diferent from the other due to the diferent tables. > If this is the case, then here is what I would do: > > 1. Have the user enter data into a form (or do a FILE upload of a text > file). How can I do that?. I mean to upload a text file. >The data is either stored in a database or the file path/location > of th text file is stored in the database. I would like to have the file sotred in the database, not the path. Can it be done?. How?. Although Iīm counting on moving the Database to another server after the PHP programming task is done. That is why Iīm wondering if it would be better to have the file into the database or on an specific folder, to show it to de user through a web page every time itīs needed. > 2. The "list" page will go to the database, get all the records that match > that user's ID (or all new items if you want to view all new items.. you > probably want to do this by date or just show the last 20 items or > something). You are right again. Thatīs what I want, at least thatīs what Iīm intempting to do. >Do this with a basic database query then loop through the > result set and display a line for each. I donīt quite fallow you on this. Can you explain it a little better, please? >You had asked about how to create > a dynamic link. You would probably do something like this: > > $filepath = "c:\\config.sys"; # You'd get this from your database query > echo "<a href=\"$filepath\">Click here for text file</a><br>\n"; Assigning a query to $filepath variable will assure me that when ever a new text is uploaded, the link will point to the newest file? > or if the text was stored in the database: > $infoid = 12345; # Unique ID of the text stored in the database > $textinfo = "User Entered Data 12/25/2004"; # Basic info you retrieved > from the database just to show there's a data to display > echo "<a href=\"view.php?infoid=$infoid\">$textinfo</a><br>\n"; > > All of that in a "for" or "foreach" loop depending on how you want to do > it and how you're retrieving data from the database. Do you have an example you can send me, please?. That way I might understand it a little better. > 3. View the info (view.php): > > $infoid = $_GET["infoid"]; > or... > $filepath = "c:\\config.sys"; > > This is where you'd either get the data out of the database to display, or > you'd load the text file in to display. I donīt know if it is better to have the file outside the database or not. What are your recomendations on this?. Iīm looking for the best performance of the queries. > That's the general idea at least. Did I answer your question? In deed you did!!!. Thankīs again. I hope that this time Iīve used a better English Grammar. Anyway, it would be better for me if you where able to speak Spanish because taking into account that I donīt now much about PHP and that my English in not that good, I guess that speaking Spanish is a faster way for me to learn about PHP and itīs fetures. Donīt you think so? > > Take care! You too!!. And thank you, again. Regards... Daniel... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
