Re: [PHP-DB] session_registered variable problem

2002-01-29 Thread Markus Lervik
On Monday 28 January 2002 18:42, Jason Wong wrote: $page behaves just fine : page: 2 - yup, it's incrementing, all right... nr_pages: 230 Whack! Doesn't work any more... It's starting to drive me mad. Me too. Post the full code so we can all revel in this madness! All rightey. Here

Re: [PHP-DB] Date operations.

2002-01-29 Thread DL Neil
Wow Garry, I know that I like to kick-start my brain by getting 'into' a list problem/challenge in the (London) mornings, but today I'm completely beaten. Thanks for the broad explanation, which is probably quite meaningful, but I'm not into breeding (could that statement be misunderstood?)

Re: [PHP-DB] RE: ensuring unique field value in MySQL using PHP

2002-01-29 Thread DL Neil
Janet, MySQL (and indeed all multi-user databases) has a feature called Locking. What this means is that whilst many users/clients may access a database, apparently simultaneously, when one (or more) is updating the data in some way, everyone else is kept locked-out for the duration. Hopefully

[PHP-DB] php db2

2002-01-29 Thread Fabio Spinelli
hi, I have a RedHat distribution installed with mysql. Now I would like also to connect to my AS400 with database DB2, via ODBC unificated functions... but these functions are not defined, probably because the PHP installed was not compiled for DB2 support. Does anyone know how to recompile PHP

[PHP-DB] Session across Multiple Hosts

2002-01-29 Thread Hayan Al Mamoun
Dear all, I was wondering, can session variables be transfered across multiple hosts, i.e. if I send a request from http://host1/page1.phtml, to http://host2/page1.phtml where I started the session by SessionRegister() or some other way and I gave the variable VAR1 some value, then I went back

Re: [PHP-DB] session_registered variable problem

2002-01-29 Thread Markus Lervik
On Monday 28 January 2002 18:42, Jason Wong wrote: $page behaves just fine : [snip] page: 2 - yup, it's incrementing, all right... nr_pages: 230 Whack! Doesn't work any more... It's starting to drive me mad. Me too. Post the full code so we can all revel in this madness! Well,

Re: [PHP-DB] session_registered variable problem

2002-01-29 Thread Jason Wong
On Tuesday 29 January 2002 21:15, Markus Lervik wrote: On Monday 28 January 2002 18:42, Jason Wong wrote: $page behaves just fine : [snip] page: 2 - yup, it's incrementing, all right... nr_pages: 230 Whack! Doesn't work any more... It's starting to drive me mad. Me too.

[PHP-DB] Re: Date operations.

2002-01-29 Thread Frank Flynn
The traditional Data Warehouse way to solve this is to have a second table of dates. The table might look like: DateTable --- dayID int, myDate datetime And you add all the particular columns that you might ever want to search on, like: month int, year int,

[PHP-DB] session vars between two host servers

2002-01-29 Thread razorfish
Problem: hosts http://www.; and https://secure.; of the same domain need to work with the same browser session_id. This is a login/authenticate/redirect scenario. In this case the session data store is a common MySQL database, so the issues of /tmp sharing, NFS, etc. are set aside. My

[PHP-DB] arrays and email

2002-01-29 Thread Kevin Ruiz
I'm working on an application that will allow someone to view all attendees for a specific webinar that my company is hosting. I want to allow the user to send one group email to all participants scheduled for that particular webinar. After I connect to my database my code looks like this: ?

[PHP-DB] Re: Session across Multiple Hosts

2002-01-29 Thread Ivo Stoykov
Hi Hayan Thechnically yes - for instance you could send it as a form hidden input. But I wonder whether there is sense in it. regards Ivo Hayan Al Mamoun [EMAIL PROTECTED] wrote in message 000401c1a8a9$838d4ee0$5e00a8c0@cybernation">news:000401c1a8a9$838d4ee0$5e00a8c0@cybernation... Dear

RE: [PHP-DB] arrays and email

2002-01-29 Thread Gurhan Ozen
Hi kevin, Seems like in your while loop, you are not populating your list array correctly with all the emails you have. Try to have a count value and populate the array list accordingly such as: $count = 0; while ($row = mysql_fetch_row($result)) { $real_name = $row[1];

RE: [PHP-DB] arrays and email

2002-01-29 Thread olinux
The other thing you could do is populate a string of emails and add the BCC header to your mail() function. This way everyone's email will not be seen by all other recipients. Check out the docs at www.php.net for this one a better way to build the string would probably be: while ($row =

Re: [PHP-DB] Re: Session across Multiple Hosts

2002-01-29 Thread Andrés Felipe Hernández
i did something like that once. I passed the session variables using an encrypted query string ( could be using a hidden input, anyway i think it is a good idea to encrypt the value). I didnt like it because of the unnecesary use of a second server, but i'm sure sometimes you just have to go

[PHP-DB] Do persistent dba_popen connections work ?

2002-01-29 Thread S A
I'm trying to use Berkeley DB db2 files with PHP persistent connection dba_popen. When I try persistent connections with dba_open then sometimes I don't get reads working I never get insert/replace working. Without persistent connections reading writing work fine. Has anyone else gotten

Re: [PHP-DB] Date operations.

2002-01-29 Thread Garry Optland
On Wed, 30 Jan 2002, DL Neil wrote: Can I request some db-speak please? You already have a tbl (or more). So let's start by asking for the table definitions The table definition is as follows: CREATE TABLE breeding ( rec SMALLINT(4) UNSIGNED AUTO_INCREMENT, sire SMALLINT(4) UNSIGNED,

[PHP-DB] multiple pages for large result sets

2002-01-29 Thread mike
Hello, I have this query: if ($cat){ $result = mysql_query(SELECT * FROM table WHERE $cat=1,$db); if ($myrow = mysql_fetch_array($result)); { do { I use a link on the menu to call this query(a href=browse.php?cat=food) This returns a large result set that I

Re: [PHP-DB] Date operations.

2002-01-29 Thread Miles Thompson
Garry, Could you please explain (define) in one sentence(paragraph) what end result you want. It might be possible to handle it in one SQL statement. Miles Thompson At 09:54 AM 1/30/2002 +1100, Garry Optland wrote: On Wed, 30 Jan 2002, DL Neil wrote: Can I request some db-speak please?

Re: [PHP-DB] Date operations.

2002-01-29 Thread Garry Optland
On Thu, 31 Jan 2002, DL Neil wrote: Garry, I regret to say that I can't see an immediate answer. CREATE TABLE breeding ( rec SMALLINT(4) UNSIGNED AUTO_INCREMENT, sire SMALLINT(4) UNSIGNED, dam SMALLINT(4) UNSIGNED, paired DATE, split DATE, num_offspring TINYINT(1)

[PHP-DB] same connection to access two different database?

2002-01-29 Thread Vincent Ma
Hi everyone: is it possible to use one connect to access two database in postgreq, because i would like to use subquery to do same search. on the fly in postgreq must faster a lot than evaluate in php code... A, B belong to different database... sql : select * from A in ( select * B)

[PHP-DB] odbc_columns()

2002-01-29 Thread Scott Teglasi
Hi. Have a question: I've tried using the odbc_columns() function to get a list of columns in an access database connected via an ODBC System DSN.. However, I haven't had much luck in trying to use it. The manual page doesn't really cover much about it, and I noticed a few comments posted

Re: [PHP-DB] multiple pages for large result sets

2002-01-29 Thread Jason Wong
On Wednesday 30 January 2002 09:48, [EMAIL PROTECTED] wrote: Hello, I have this query: if ($cat){ $result = mysql_query(SELECT * FROM table WHERE $cat=1,$db); if ($myrow = mysql_fetch_array($result)); { do { I use a link on the menu to call this

[PHP-DB] how to reverse a hudge multidimensional array?

2002-01-29 Thread Etienne Durand
Well i hope someone will be able to give me a solution... Here s my problem: I'm working with a hudge mysql table (about 15 columns and 100 rows...) in fact i ve got to count the number of couples `ncompte`/`naffaire` in the table and finaly calculate the number of couples that appear once,

[PHP-DB] drop down list

2002-01-29 Thread B.J.Rumsey
I have two fields artist_id, artist. How do I put the contents of artist into a dropdown list. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

[PHP-DB] RE: drop down list

2002-01-29 Thread Oliver Cronk
Something I have created for a project recently (note that I use my own db wrapper functions - just substitute the dbconn(), dbquery(), dbnumrows() and dbresult() for your database functions - e.g. mysql_connect() for mysql, ms_sql_connect() - look them up in the PHP manual however as I am not

RE: [PHP-DB] arrays and email

2002-01-29 Thread Oliver Cronk
It would appear that I should check if anyone else has answered a question first! And get some more sleep! Sorry! Ollie -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: 29 January 2002 20:05 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] arrays and email The other thing