Re: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-27 Thread Jason Wong
On Thursday 28 November 2002 14:21, Gavin Amm wrote: > ok, > > i've looked around the web a bit more & it would appear you can't just use > a foreach function, apparently you need to use a while{foreach{}} > structure. i was hoping you could just use the foreach function? > > so this is the code no

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-27 Thread Gavin Amm
ok, i've looked around the web a bit more & it would appear you can't just use a foreach function, apparently you need to use a while{foreach{}} structure. i was hoping you could just use the foreach function? so this is the code now: -select- $value\n"; } } ?> but now th

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-27 Thread Gavin Amm
good point! whoops. ok, i've moved the $result_dept & $result_deptsub queries, now i'm getting 2 of the same entries in my html code: -select- audit audit any thoughts? Gav -Original Message- From: John Coder [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 November 2002 3:44 PM To:

Re: [PHP-DB] foreach loop from MySQL select query to HTML selectlist

2002-11-27 Thread John Coder
On Wed, 2002-11-27 at 23:33, Gavin Amm wrote: > Hi, > > I'm trying to pick up data from my MySQL database, use a foreach loop to > extact the data from the result & put that data into a select list. > > I have tried the following code with & without the $row = ... line, both > unsucessfully: > >

[PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-27 Thread Gavin Amm
Hi, I'm trying to pick up data from my MySQL database, use a foreach loop to extact the data from the result & put that data into a select list. I have tried the following code with & without the $row = ... line, both unsucessfully: -select- $value\n";} ?> I get the following er

Re: [PHP-DB] Session questions

2002-11-27 Thread Marco Tabini
Here's a couple of suggestions: 1) You can use javascript to trap the window's closure and create a new window that simply calls one of your scripts that closes the session. This is not 100% foolproof, however, so you need to come up with a backup plan, like closing sessions automatically with a b

RE: [PHP-DB] Session questions

2002-11-27 Thread John W. Holmes
> I have a login system which uses sessions, and when people login it puts > the date they logged in in their profile and moves their last login date > over to another field, that works fine, but how can I check if someone has > logged out via code? In other words, if someone does what they want

[PHP-DB] Session questions

2002-11-27 Thread Chris Payne
Hi there everyone, I have a login system which uses sessions, and when people login it puts the date they logged in in their profile and moves their last login date over to another field, that works fine, but how can I check if someone has logged out via code? In other words, if someone does wha

[PHP-DB] 'Remote' data

2002-11-27 Thread Bartosz Matosiuk
Hi I need to create function which would read a data (mysql) from the table from the other page, put this data in my MySQL table and return them on my page. My problem is that I have no idea how to get that data. Please give me a hint or maybe you know some articles about that, Thanks B

Re: FW: [PHP-DB] PHP and PostrgeSQL tutorial

2002-11-27 Thread Daniel Wells
I have tried the designmagick tutorial and cant get ti to post data to the DB. It tells me I have posted data and a new row appears, but only th e"id" field has any data. Are there any other tutorials or am I doing something wrong? I am cutting and pasting from the tutorial. I do have to make a

Re: [PHP-DB] imap_search problems

2002-11-27 Thread Peter Beckman
Don't you hate it when, right after you post to the list, you figure out your problem? :-) I removed the quotes around $id after using: $err = imap_errors(); print_r($err); to determine what the problem was. Anyway, Happy Thanksgiving all, happy troubleshooting and never forget to use t

[PHP-DB] imap_search problems

2002-11-27 Thread Peter Beckman
I'm writing a command line script to go through a mailbox on the file system. PHP the binary is compiled with imap, I've confirmed by using imap_headers to get the array of the 10,051 messages and printed the array out. Here's my code: #!/usr/local/bin/php -q Here's what I get when sea

Re: [PHP-DB] Resource id #2

2002-11-27 Thread Adam Voigt
They don't do anything, but my point was, he said that what he pulled from the DB needed to be put into an array, and I was pointing out, it already was. On Wed, 2002-11-27 at 12:23, Mark wrote: > But what do all those $row['fieldname'} rows do? Call me ignorant > (you wouldn't be the first), but

[PHP-DB] is innodb faster than MyISAM???

2002-11-27 Thread Dave
i just read a benchmark on innodb.org http://www.innodb.com/bench.html that says under the "innodb vs MyISAM" section... MyISAM is the default table type used in MySQL and InnoDB is a table type supporting transactions in MySQL. I wrote a Perl program which inserts 100 000 rows to a table wit

Re: [PHP-DB] Resource id #2

2002-11-27 Thread Mark
But what do all those $row['fieldname'} rows do? Call me ignorant (you wouldn't be the first), but a statement that simply has a variable name doesn't DO anything. Should these have echos in front of them? --- Adam Voigt <[EMAIL PROTECTED]> wrote: > Umm, he is putting them into an array, I quote:

Re: [PHP-DB] PHP4, Apache 1.3.x, and mod ssl install document?

2002-11-27 Thread Peter Beckman
Actually, it's easier: cd /usr/ports/www/apache13-modssl make install cd /usr/ports/www/mod_php4 make install apachectl start (or restart) Peter On Wed, 27 Nov 2002, RClark wrote: > Hello all, > > I have a FreeBSD server which has been updated to 4.7 STABLE. I have updated > my ports collection

Re: [PHP-DB] PHP4, Apache 1.3.x, and mod ssl install document?

2002-11-27 Thread Adam Voigt
Off the top of my head (general guidelines, don't use word for word): mkdir /usr/local/apache cd /usr/local/apache wget http://www.apache.org/dist/httpd/apache_1.3.27.tar.gz tar -zxf * cd apache_1.3.27 ./configure --prefix=/usr/local/apache_1.3.27 mkdir /usr/local/modssl cd /usr/local/modssl wget

[PHP-DB] PHP4, Apache 1.3.x, and mod ssl install document?

2002-11-27 Thread RClark
Hello all, I have a FreeBSD server which has been updated to 4.7 STABLE. I have updated my ports collection and installed mysql server. Does anyone have an updated doc on how to install apache with PHP4 and modssl support either from ports collection or from source. I would greatly appreciate it.

Re: [PHP-DB] Resource id #2

2002-11-27 Thread Adam Voigt
Umm, he is putting them into an array, I quote: while ($row = mysql_fetch_array($result)) { > > $row['Books.Title']; > > $row['Books.Author']; > > $row['Books.ISBN']; > > $row['BookList.dbase']; > > $row['BookList.dbase_user']; > > $row['BoxSet.BoxSe

Re: [PHP-DB] Connecting to MS SQL 7

2002-11-27 Thread Adam Voigt
A. I think the "php3_" isn't a good sign. B. You should remove whatever you found on the web and downloaded. C. Copy all the DLL's in the dll folder (under your PHP folder) to C:\WINNT\SYSTEM32 D. Re-copy the php.ini-recommended from your PHP folder to C:\WINNT\php.ini and see if it stops

[PHP-DB] Re: MySQL: charset

2002-11-27 Thread Radovan Radic
"Radovan Radic" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi > > How can i change default charset for mysql database. > I want to change default charset on cp1251 just for one database > 'dblibrary'. I have seen something like > mysql --default-character-s

[PHP-DB] MySQL: charset

2002-11-27 Thread Radovan Radic
Hi How can i change default charset for mysql database. I want to change default charset on cp1251 just for one database 'dblibrary'. I have seen something like mysql --default-character-set=cp1251, but i dont know does it work? Thanks -- PHP Database Mailing List (http://www.php.net/) To uns

Re: [PHP-DB] Resource id #2

2002-11-27 Thread Chris Barnes
You need to put your $result into an array. you can use: $result_array = mysql_fetch_array($result); then, if you know the field names in the array, print them like so: echo $result_array["field1"]; echo $result_array["field2"]; or if you dont know their names you can refer to their position nu

[PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-27 Thread David Elliott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings John On 26 November 2002 at 18:54:04 -0500 (which was 23:54 where I live) John W. Holmes wrote and made these points >> This is OK for some simple trees, however it does have some limitations. >> >> (1) Adding another tree / series of nodes

Re: [PHP-DB] Undefined Constant

2002-11-27 Thread Tyler Whitesides
Hi, Thank you all for your quick help, it was just a "Youve been up too long working on this and it is the middle of the night" mistakes. Once I put quotes around my constant, everything worked. Thanks again, Tyler - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PRO