Re: [PHP-DB] Session End

2002-02-09 Thread Jeroen Timmers
hello, i think you could not realize that with php and sessions. Because you can not read the session from a visitor. or ? Jeroen - Original Message - From: Hayan Al Mamoun [EMAIL PROTECTED] To: PHPList (E-mail) [EMAIL PROTECTED] Sent: Saturday, February 09, 2002 7:52 AM Subject:

Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Jeroen Timmers
what would you like todo? explain further Jeroen - Original Message - From: Hayan Al Mamoun [EMAIL PROTECTED] To: PHPList (E-mail) [EMAIL PROTECTED] Sent: Saturday, February 09, 2002 7:51 AM Subject: [PHP-DB] Maintain MySQL Transactions Hi, How can I maintain MySQL transactions with

[PHP-DB] Re: Oracle 9i support

2002-02-09 Thread Jarosaw Jankowski
Theodore D Boardman wrote: Greetings! As far as I can tell from the documentation, the OCI8 driver supports Oracle 8. However, on the ADODB site, they mention that the OCI8 driver supports Oracle 8/9. Can someone clarify what the status of support for Oracle 9i is in PHP? I need to

[PHP-DB] Re: Creating temp table with data out of 2 tables possible?

2002-02-09 Thread Jarosaw Jankowski
Andy wrote: Hi there, how is it possible to copy rows from more then one table into a temporary table? I have 250 city tables named after the country e.g: ca_cities. Now the user has choosen stuff from lets say ca and gm. I want to collect the data into a temp table and then querry

Re: [PHP-DB] Re: Oracle 9i support

2002-02-09 Thread Thies C. Arntzen
On Sat, Feb 09, 2002 at 01:10:58PM +0100, Jaros?aw Jankowski wrote: Theodore D Boardman wrote: Greetings! As far as I can tell from the documentation, the OCI8 driver supports Oracle 8. However, on the ADODB site, they mention that the OCI8 driver supports Oracle 8/9. Can

Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Miles Thompson
Unless there has been a very recent development, MySQL doesn't support transactions. Use PostgreSQL, DB, etc. Miles Thompson At 09:51 AM 2/9/2002 +0300, Hayan Al Mamoun wrote: Hi, How can I maintain MySQL transactions with PHP Best Regards Hayan -- PHP Database Mailing List

Re: Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Jeroen Timmers
you must first connect to the mysql database, for example $dbhost = localhost; $dbuser = DATABASE USER; $dbpass = DATABASE PASSWORD; $database = DATABASE NAME; @mysql_connect($dbhost, $dbuser, $dbpass) or die (Deze pagina is tijdelijk offline.); @mysql_select_db($database) or die

[PHP-DB] Searching records...

2002-02-09 Thread Todd Williamsen
What I am doing is user inputs their contact information, then copies and pastes text and also uploads a formal document, which the location is stored in the database. Now, the text that gets pasted into the text field is then stored into the database for search purposes. This is the problem...

Re: [PHP-DB] Searching records...

2002-02-09 Thread Jason Wong
On Sunday 10 February 2002 00:58, Todd Williamsen wrote: What I am doing is user inputs their contact information, then copies and pastes text and also uploads a formal document, which the location is stored in the database. Now, the text that gets pasted into the text field is then stored

Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Jason Wong
On Sunday 10 February 2002 00:21, Miles Thompson wrote: Unless there has been a very recent development, MySQL doesn't support transactions. Use PostgreSQL, DB, etc. The v4 series of MySQL does support transactions. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Without love

Re: [PHP-DB] count from the results

2002-02-09 Thread Jason Wong
On Sunday 10 February 2002 00:55, Barry Rumsey wrote: I have the following code: $query = SELECT * FROM artist WHERE artist LIKE 'b%' ORDER BY artist ASC; [snip] What I would like to know is how do I do a count on each result returned.e.g. Benny(4) , Bill(10) Try: $query = SELECT artist,

Re: [PHP-DB] Resource link errors

2002-02-09 Thread Ken Thompson
Thanks Rick, Now it works. On Thursday 07 February 2002 03:04 pm, Rick Emery wrote: The following means you have not opened a link to your database. Concerntrate your efforts there. Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/list.php3 on line 26

[PHP-DB] Re: count from the results

2002-02-09 Thread Raymond Lilleodegard
Hi Barry! you can do it like this for example: $query = SELECT * FROM artist WHERE artist_name LIKE 'b%' ORDER BY artist ASC; $count = mysql_query(SELECT COUNT(artist) AS count FROM artist WHERE artist_name LIKE 'b%',$db); $x = mysql_fetch_array($count); $result = mysql_query($query) or

Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Paul DuBois
At 2:00 +0800 2/10/02, Jason Wong wrote: On Sunday 10 February 2002 00:21, Miles Thompson wrote: Unless there has been a very recent development, MySQL doesn't support transactions. Use PostgreSQL, DB, etc. The v4 series of MySQL does support transactions. MySQL has supported transactions

[PHP-DB] Re: option in forms

2002-02-09 Thread Adam Royle
I think this is what you're getting at: select name=artistID option value=?= $row[ID] ??= $row[ArtistName] ?/option /select or something like that so it would look like (in HTML) select name=artistID option value=23Artist's Name First in list/option option value=44Artist's Name second in

[PHP-DB] Outputing Distinct rows

2002-02-09 Thread KingZeus
I'll give you all the short version of what I need and if it is enough for you to help that would be great. I need to pull the last 10 updated topics from a table and output them. However, the posts table lists each post and then has a topic id. There is also a table of topics with topic id,

[PHP-DB] PHP MySQL and updating

2002-02-09 Thread Jennifer Downey
Hi again, I am having trouble with updating. How do I tell php to update the database at mid night instead of every time the browser is refreshed? I have looked for it but can't find the info. Also I thought session ID's were different between users. Is this true? Thanks Jennifer Downey --