[PHP-DB] Re: Querying two tables

2002-12-16 Thread Stas Trefilov
Cesar Aracena wrote: Table 1 - Categories catid (autonum) catname Table 2 - Sub categories subcatid (autonum) subcatname Table 3 - Products prodid (autonum) prodname Table 4 - Relationships Catid Subcatid Prodid Now, the question is how to fetch all the sub-categories let's say that are

[PHP-DB] Re: approaching a relational database

2002-12-16 Thread Stas Trefilov
Doug Parker wrote: I'm about to embark on a project where I have to enter many, many fields into a MySQL database, and I don't know how to approach the database structure. The data is statistics for a golf course. There are 18 holes, and each hole has a Red Tee Par, White Tee Par, and Blue

Re: [PHP-DB] Problems with images in the db

2001-02-15 Thread Stas Trefilov
Hello, Sunil Jagarlamudi! You wrote: How do I overcome that ? When I try to just echo the image it works fine, but when I try to add a few more lines like echoing other rows which have firstname and lastname of the people nothing comes out Imagine you open an image file from the disk.

Re: [PHP-DB] Positioning into a query

2001-02-12 Thread Stas Trefilov
Hello, "Francesco Rossi"! You wrote: Hi, After i have traverse a queryhow i can repositioning my cursor to the first record of the query ? While traversinq, put records in array, then work with it. -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Damn Cookie

2001-02-01 Thread Stas Trefilov
Hello, John Starkey! You wrote: I've got a login page posting only the user_name and password vars. No matter what it's using the same name over again. What's between the FORM tags? -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] storing query result in arrays: waste of memory?

2001-01-31 Thread Stas Trefilov
Hello, "Tyson Lloyd Thwaites"! You wrote: Is it better to retrieve the whole table up-front and store it in a session array, or to run the queries seperately each time the data is needed and specify the column targets? First read all the short columns from the row in your base class

Re: [PHP-DB] Linked Tables Problem

2001-01-15 Thread Stas Trefilov
Hello, Justin Smith! You wrote: It's definitely a security issue, not allowing access to the linked tables in a database with its own security even though the database I'm connected to via ODBC has full access. Any tips on how to get around this? Any help would be greatly

Re: [PHP-DB] Transactions. How?

2001-01-15 Thread Stas Trefilov
Hello, "Marko Perich"! You wrote: I need to make a transaction over several pages and commit it after validating the last one. Insert line on the first page, update on next, mark as commited on the last. Each hour drop uncommited lines. You may also provide current time of transaction

Re: [PHP-DB] exporting databse from oracle to msql

2001-01-15 Thread Stas Trefilov
Hello, sajid jamal! You wrote: can anyone help me out ,in how to export my oracle databse i.e sql to mysql database. Use Oracle Export tool to produce a text datafile, then load it to MySQL with its import command. Look docs for syntax of both commands. -- Piloteers do it on the road --