Re: [PHP-DB] pictures into MySQL

2002-12-17 Thread Jason Wong
On Tuesday 17 December 2002 04:27, Seabird wrote: > Hi everyone, > > I know that inserting actual pictures into a MySQL DB is not the best > solution, but since I know the size is going to be limited I want to do it > anyways. How do I upload a picture into a DB? (what type of table etc.). google

Re: [PHP-DB] login won't log in, HELP

2002-12-17 Thread Jason Wong
On Tuesday 17 December 2002 14:42, David wrote: > Hello, > > I am pretty new to PHP and I am trying to create a admin login page so my > client can view thier product line and orders. I have MySQL set-up > properly and have data in it and I am able to view information from the db > with no problem

[PHP-DB] Win2K DC - Safe way to add domain user

2002-12-17 Thread Vladislav Malicevic
Hi, any ideas on how to safely add user to the Windows 2000 AD(with PHP of course)? I experimented with exec() and net user /add ... any suggestion will do. Windows 2000 Server, IIS, PHP 4.2.3 (CGI) Regards, Vlado -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http:/

[PHP-DB] IBASE (beginner)

2002-12-17 Thread Kepes Krisztian
Hi ! I am beginner in PHP. I want to connect an IB database. When I was execute this cgi code, the php send error message to me. #!c:\php\php.exe email . "\n";} ibase_close ($dbh); print 'DISCONNECT\n'; ?> Fatal error: Class db_common: Cannot inherit from undefined class pear in c:\php\pear\D

RE: [PHP-DB] How can I use PHP to duplicate a mysql template database? [hack]

2002-12-17 Thread Daevid Vincent
Seems to me there should be a built in SQL or PHP command to duplicate a database. Jeepers. Or to read in a .sql file from PHP and create a database out of it (which was the original intent). Anyways, here's a 'hack'. I'd still love to hear anyone else's more elegant solution. $V2DB = "V2_SL".$Co

[PHP-DB] random select

2002-12-17 Thread Bruce Levick
Bruce Levick - VivamotionI was curious as to what is the best way to select a random row from a table in my database. I have currently five rows and will be expanding on that as well. I have tried this code. //retrieve rando

[PHP-DB] Getting database output into another frame in another window

2002-12-17 Thread Chris Jewell
Hi, I've got a set up where I would like my query output to appear in a frame in a main window. Since my queries require stepwise user input, they are going to be built up in a pop-up window. When the query form (in the popup) is sent, it calls a php script which drags the data out of a Postg

Re: [PHP-DB] Getting database output into another frame in another window

2002-12-17 Thread Chris Jewell
The name specified in (2) is maindb.queryframe. I have a frame defined as in the maindb window. Still not working :( On Tuesday 17 December 2002 11:04, you wrote: > At 10:59 17-12-02 +, you wrote: > >Hi, > > > >I've got a set up where I would like my query output to appear in a frame > >in

Re: [PHP-DB] Getting database output into another frame in another window

2002-12-17 Thread Wico de Leeuw
At 11:06 17-12-02 +, Chris Jewell wrote: The name specified in (2) is maindb.queryframe. I have a frame defined as in the maindb window. Still not working :( The names has to match, so either you specify target="queryframe" in the form or do Gr, Wico On Tuesday 17 December 2002 11:04

Re: [PHP-DB] Getting database output into another frame in another window

2002-12-17 Thread Chris Jewell
New development! It seems that if I just specify that the results go into the main window - just not into the frame. So the main problem is now persuading browser to put the output into the frame instead of the whole window. Chris On Tuesday 17 December 2002 10:59, Chris Jewell wrote: > Hi,

Re: [PHP-DB] random select

2002-12-17 Thread Jason Wong
On Tuesday 17 December 2002 18:46, Bruce Levick wrote: > Bruce Levick - VivamotionI was curious as to what is the best way to select > a random row from a table in my database. > > I have currently five rows and will be expanding on that as well. I have > tried this code. > > ##

Re: [PHP-DB] random select

2002-12-17 Thread Bruce Levick
thankyou that seemed to work well. - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 9:32 PM Subject: Re: [PHP-DB] random select > On Tuesday 17 December 2002 18:46, Bruce Levick wrote: > > Bruce Levick - VivamotionI was

[PHP-DB] Oracle/PHP question...

2002-12-17 Thread Anthony Carlos
Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup conne

[PHP-DB] random rows...what about tables

2002-12-17 Thread Bruce Levick
Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table working. Error performing query: " .

Re: [PHP-DB] random rows...what about tables

2002-12-17 Thread Jason Wong
On Tuesday 17 December 2002 21:38, Bruce Levick wrote: > Bruce Levick - Vivamotion > Been searching for an answer to selecting a random table and then a random > row within the selected table. > > I have this code which successfully selects a random row within a hard > coded table. But just can't g

Re: [PHP-DB] random rows...what about tables

2002-12-17 Thread Wico de Leeuw
At 23:38 17-12-02 +1000, Bruce Levick wrote: Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table

[PHP-DB] session ID

2002-12-17 Thread xxx xxxx
Hi, i'm having a problem with session Id. I want to pass it through the pages of my site but I use a menu, a javascript menu with links... i have a main page with authentification.. i register variables like name and password...but on the page linked by the menu there is started another session

Re: [PHP-DB] random rows...what about tables

2002-12-17 Thread Bruce Levick
Sorry, Have updated my script with a little help. Upon output i am recieving this. Warning: Argument to array_rand() has to be an array in C:\WORKING\portfolio\vivamotion\site\php\request.php on line 51 this is the code below. //

[PHP-DB] real time output

2002-12-17 Thread Art Chevalier
Hello, I want to start a native process and capture the output while it is being generated and display it to the screen. I dont want to output to be displayed on the screen all at once after the process completes. As the process returns output I would like it dynamically displayed to the screen.

RE: [PHP-DB] random rows...what about tables

2002-12-17 Thread Hutchins, Richard
I think it's because mysql_list_tables returns a resource identifier ($result). You have to iterate through the resource identifier ($result) with a while() loop to get the actual table names out. From the PHP.NET site: In the example above, I think the output would just be one table name. Howev

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread xxx xxxx
Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote > Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] > > -Original Message- > From: N

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread xxx xxxx
Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment and restart the server cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote > Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] > > -Orig

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread Andrey Hristov
AFAIK he uses *nix, not windows. (.so-s are possible sollution but prebuilt ones are not shipped with php). Andrey - Original Message - From: "xxx " <[EMAIL PROTECTED]> To: "Anthony Carlos" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 4:32 PM Subject: Re:

RE: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
Correct. I am working on Unix, specifically HP-UX 11.00. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:38 AM To: xxx ; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle/PHP question... AFAIK he uses *nix, not windows. (.s

[PHP-DB] unsuscribe please

2002-12-17 Thread ALONSO CARDENAS MARQUEZ
unsuscribe please [EMAIL PROTECTED] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread Andrey Hristov
As Anthony Carlos said - compile your php with oracle and oci support. Then you will have all the functions from the modules. The next thing to do after the compile (and web server restart). You said that you configured the SID and the HOME so that's fine. Just compile new binary Regards, Andrey

Re: [PHP-DB] random rows...what about tables

2002-12-17 Thread Jason Wong
On Tuesday 17 December 2002 22:18, Bruce Levick wrote: > Sorry, > Have updated my script with a little help. Upon output i am recieving this. > > Warning: Argument to array_rand() has to be an array in > C:\WORKING\portfolio\vivamotion\site\php\request.php on line 51 > OK, start from the basics. T

RE: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
I am running Oracle 8.0.6.3. Do I need both --with-oracle and --with-oci8? I was under the impression that I only needed the option --with-oci8. Thanks. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:46 AM To: NIPP, SCOTT V

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread Andrey Hristov
Compile with --with-oci8 Andrey - Original Message - From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 4:56 PM Subject: RE: [PHP-DB] Oracle/PHP question... > I am running Oracle 8.0.6.3. Do

RE: [PHP-DB] real time output

2002-12-17 Thread Gary . Every
Check out the flush() and ob_flush commands on www.php.net Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Art Chevalier [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17

Re: [PHP-DB] login won't log in, HELP

2002-12-17 Thread David
Thank You Jason for replying back. I am still new to this and sometimes it is hard to ask question because I don't know all the terms or how to word my problem. Ok I switch my php.ini to error reporting to maximum (error_reporting = E_ALL) and write off the bat I got this error message. Notice

[PHP-DB] PHP/Oracle Install questions...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for connectivity to both a MySQL and a remote Oracle server. I am not having much luck with this right now. Currently I am getting a couple of different errors that are of concern for me. First of all, in the Apache error log I am see

RE: [PHP-DB] login won't log in, HELP

2002-12-17 Thread Ryan Marrs
With an error level of E_ALL, you will also get warnings. What this means, is that any time there is a situation where a value is not passed to $HTTP_POST_VARS['Submit'], it will throw a warning. You can avoid getting those warnings by using the empty function. IE: If(!empty($HTTP_POST_VARS['Su

[PHP-DB] FW: PHP/Oracle Install questions...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
More information for someone to hopefully come to my rescue on this... root@torvalds:/usr/local/apache/bin> ./apachectl startssl /usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /us r/lib/libcl.2 /usr/lib/dld.sl: Exec format error Syntax error on line 207 of /us

Re: [PHP-DB] here's my problem in PHP & relational tables

2002-12-17 Thread Phanivas Vemuri
hi, I have two tables. 1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id. and each id may have 2 or three categories. 2.Category( number,category). categories are : Beef , diary, horticulture etc; I am using PhpMyAdmin as the interface for the mySql Database. The PhpMyAdmin uses

RE: [PHP-DB] here's my problem in PHP & relational tables

2002-12-17 Thread SELPH,JASON (HP-Richardson,ex1)
When you look at the properties for your table and see the field you wish to setup like that. click change on the field. You can change the field to what you want, just follow the instructions. If field type is "enum" or "set", please enter the values using this format: 'a','b','c'... If you ev

Re: [PHP-DB] How can I use PHP to duplicate a mysql template database?

2002-12-17 Thread Rick Widmer
At 07:59 PM 12/16/02 -0800, Daevid Vincent wrote: I need to use PHP to duplicate the schema of a database. This seems like it should be a simple task -- taking a 'template' db and cloning it with a new name. The easiest way I know of is at the command line: >mysqldump -p -u root name_of_exist

RE: [PHP-DB] My question in precise reg PHP and relational tables.

2002-12-17 Thread Phanivas Vemuri
hi, I have added my question , my main Aim at the end of this explanation. I have two tables. 1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id. and each id may have 2 or three categories. 2.Category( number,category). categories are : Beef , diary, horticulture etc; I am using

RE: [PHP-DB] How can I use PHP to duplicate a mysql template database? [hack] bug

2002-12-17 Thread Daevid Vincent
DAMNIT! This method copies the data, but doesn't copy 'Extra' stuff like "auto_increment". UGH!!! > -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 2:33 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] How can I use PHP to duplic

[PHP-DB] MySQL Ques: default for date field be current date

2002-12-17 Thread Michael Zornek
I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a question regarding MySQL. In Access one can create a date field and set the default to "Date()" to get the current date but according to the mysql manual: http://www.mysql.com/doc/en/CREATE_TABLE.html > Default values must be c

Re: [PHP-DB] MySQL Ques: default for date field be current date

2002-12-17 Thread David Smith
This can be done using the 'timestamp' type for your column. Note that this field will be updated to the current time any time the row is modified (including when it is created). An alternative is to do it on the scripting side with the MySQL NOW() command like so: INSERT INTO your_table (field1,

RE: [PHP-DB] MySQL Ques: default for date field be current date

2002-12-17 Thread John W. Holmes
> I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a > question regarding MySQL. > > In Access one can create a date field and set the default to "Date()" to > get > the current date but according to the mysql manual: > > http://www.mysql.com/doc/en/CREATE_TABLE.html > > > Defa

[PHP-DB] problem with PHP+flash programming

2002-12-17 Thread Hermanto Kurniawan
i have a problem with this flash actionscript : loadVariablesNum ("GuestBook.php?NumLow="+NumLow+"&NumHigh="+NumHigh+"&R="+random(999), 0); when i run this script i got an error message like this : error opening URL "file:///C|/path/GuestBook.php?NumLow=0&NumHigh=10&R=470" does anyone know what