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 php

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. I

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 =

[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

[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

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 FRAME NAME=queryframe 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

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 FRAME NAME=queryframe in the maindb window. Still not working :( The names has to match, so either you specify target=queryframe in the form or do FRAME

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 FORM ACTION=query.php TARGET=maindb METHOD=GET 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

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.

[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

[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. ?php //trying to select all tables

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 get

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

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: ?php $dbname = 'mysql_dbname'; if (!mysql_connect('mysql_host',

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:

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]

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: [PHP-DB]

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.

[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.

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 I need

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.

[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

[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

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

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

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 duplicate a

[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

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

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 Default values

[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=0NumHigh=10R=470 does anyone know what is the