Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Ross Honniball
Norland [EMAIL PROTECTED] Reply-To: php-db@lists.php.net To: php-db@lists.php.net Subject: Re: [PHP-DB] Help. I am losing the plot... Date: Tue, 05 Jul 2005 09:41:55 -0500 Ross Honniball wrote: script1.php: echo 'script 1 before'; require_once('script2.php'); echo 'script 1 after'; script2

Re: [PHP-DB] Help. I am losing the plot.. (NOW good code editor)

2005-07-05 Thread Philip Hallstrom
Um. Anyone know of a good code editor? I normally use vim, but on my windows box sometimes use http://www.pnotepad.org/ when looking at log files and what not... (yes, I know there's a windows version of vim) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Bastien Koert
zend is excellent, i use editpad at work, have engisite for php (also good) phpedit, context all depends on how much you want to spend and what features you want bastien From: Ross Honniball [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Help. I am losing the plot.. . Date

RE: [PHP-DB] Help!!!

2005-05-19 Thread Juffermans, Jos
In the second loop you do an array_shift($entry) which should be array_shift($all). Perhaps a foreach loop would be easier: ?php foreach ($entry as $value) { $update = UPDATE accounts SET ctime=NOW() WHERE id_sys=' . $value. '; $results = mysql_query($update, $Prod) or

RE: [PHP-DB] Help with PHP

2005-04-25 Thread ReClMaples
I apologize but I figured out my mistake. Thanks -Rich -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 10:05 PM To: PHP Subject: [PHP-DB] Help with PHP I'm not sure if this is the correct distro to be sending this question to, if it's not,

RE: [PHP-DB] help wanted for install php with mysql support on windows

2005-04-22 Thread Bastien Koert
uncomment the mysqli library functions in the ini file and use those functions instead... bastien From: zheng [EMAIL PROTECTED] Reply-To: zheng [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] help wanted for install php with mysql support on windows Date: Fri, 22 Apr 2005 18:10:10

Re: [PHP-DB] help query is so slow

2005-01-24 Thread Samar
Hello Ron, I guess it would really help all of us helping you in giving any real help if you post some code here. :) Regards, Samar M. = Warning: Dates in Calendar are closer than they appear. On Mon, 24 Jan 2005 23:18:33 +0800, ron [EMAIL PROTECTED] wrote: Hi All, What seems to be the

RE: [PHP-DB] Help in learning PHP and MySQL

2004-12-31 Thread Peter Lovatt
Hi from php 5 onwards mysql is not enabled by default http://www.php.net/manual/en/ref.mysql.php Note: Windows users will need to enable php_mysql.dll inside of php.ini and either copy libmysql.dll into the Windows system directory, or make it available to the PATH. from memory... (To

Re: [PHP-DB] Help in learning PHP and MySQL

2004-12-31 Thread Novice Learner
Janet and Peter, Thank you for your help. It worked and I was able to populate the database through the next script that was in the book. I am on my way to learning PHP and MySQL. I hope it also works on my web hosting servers in a few days time. Thank you again. My New Year is starting in

Re: [PHP-DB] Help in learning PHP and MySQL

2004-12-30 Thread Janet Valade
Novice Learner wrote: I apologize if this is a very basic question. I just started learing PHP and MySQL, I am reading PHP and MySQL by Larry Ullman, I also have access to PHP 5 by Julie Meloni. I reached Chapter 6 of Ullman's book and got stuck. I have the following code: ?php //This file

Re: [PHP-DB] help newbies :)

2004-12-23 Thread Nayyar Ahmed
On Thu, 23 Dec 2004 10:57:55 -0500, Bastien Koert [EMAIL PROTECTED] wrote: you have a mysql account with that particular user identification? yes this connections works well when i query table user, in specified db. bastien From: Nayyar Ahmed [EMAIL PROTECTED] Reply-To: Nayyar Ahmed

RE: [PHP-DB] help newbies :)

2004-12-23 Thread Bastien Koert
you have a mysql account with that particular user identification? bastien From: Nayyar Ahmed [EMAIL PROTECTED] Reply-To: Nayyar Ahmed [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] help newbies :) Date: Thu, 23 Dec 2004 20:54:23 +0500 Hello All, I am developing attendence mangement

Re: [PHP-DB] help newbies :)

2004-12-23 Thread Jochem Maas
Nayyar Ahmed wrote: Hello All, I am developing attendence mangement system, its my first application in PHP, I want to compaire the input text box value with table records the follwing is the code _index.htm___ .. form name = 'loginfrm' method = post action =

Re: [PHP-DB] Help me please

2004-11-08 Thread Arné Klopper
Have you set up a ODBC connection ? You must set up a ODBC connection in the ODBC Sources that is usually in you Control Panel or Administrator Tools. You must put it as a System DNS and set up the connection, so your local system know where to find the database. Kind Regards Arné

RE: [PHP-DB] Help me please

2004-11-08 Thread Bastien Koert
have you created a dsn for this connection? Bastien From: Petrus Ali Saputra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Help me please Date: Mon, 08 Nov 2004 10:55:45 +0700 Can anyone here help me how to connect to an ODBC data? Here is my code: $odbc = odbc_connect(Ta Fara,,); And

Re: [PHP-DB] Help me please

2004-11-08 Thread Petrus Ali Saputra
Arné klopper wrote: Have you set up a ODBC connection ? You must set up a ODBC connection in the ODBC Sources that is usually in you Control Panel or Administrator Tools. You must put it as a System DNS and set up the connection, so your local system know where to find the database. I

Re: [PHP-DB] Help me please

2004-11-08 Thread Petrus Ali Saputra
Bastien Koert wrote: have you created a dsn for this connection? Bastien From: Petrus Ali Saputra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Help me please Date: Mon, 08 Nov 2004 10:55:45 +0700 Can anyone here help me how to connect to an ODBC data? Here is my code: $odbc =

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread John Holmes
Stuart Felenstein wrote: If you see the code I have the begin , then the $query follows. With both statements present, only the second one does the insert. If I // or remove the second, the first one takes. Am I missing something here ? Yep... you're missing a mysql_query() call for each

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
That made a world of difference! :) Thank you. But - I want to confirm, am I still using transactions even though I'm issuing individual query calls for each insert. And, if I can ask another question to the list : In this line (from the second insert) VALUES (null, LAST_INSERT_ID(), ..);

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
John, Big thank you! for your help. I had been trying out the mysql_insert_id and was not having luck. It's working great (with just a few more bumps to get over). --- John Holmes [EMAIL PROTECTED] wrote: Stuart Felenstein wrote: But - I want to confirm, am I still using transactions

Re: [PHP-DB] Help: Transactions working but question / issue

2004-10-15 Thread Stuart Felenstein
Here is my situation , not sure how I should handle it. I have this multi page form, at the end I use mysql transaction to get the data into all the tables. All the tables are innodb with the exception of one. The last page has one field which takes a copy/paste of a document, so it's a text

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Bastien Koert
Hi Stu 1. why not check it on every page, then if it fails the user won't need to make it to the end and then have to go back to the beginning to fix something minor. 2. You could use hidden fields to pass the data back and for or just use a session, otherwise the variables expire on that page

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
See interspersed: --- Bastien Koert [EMAIL PROTECTED] wrote: Hi Stu 1. why not check it on every page, then if it fails the user won't need to make it to the end and then have to go back to the beginning to fix something minor. 2. You could use hidden fields to pass the data back

Re: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Matt M.
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/lurkkcom/public_html/Multi2Return.php:2) in /home/lurkkcom/public_html/Multi2Return.php on line 3 read a little more about sessions. session_start is trying to set a cookie but output has

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Murray @ PlanetThoughtful
://www.planetthoughtful.org Building a thoughtful planet, One quirky comment at a time. -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Saturday, 9 October 2004 1:57 AM To: Bastien Koert; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Help: First Time Form with Sessions See

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Saturday, 9 October 2004 1:57 AM To: Bastien Koert; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Help: First Time Form with Sessions See interspersed: --- Bastien Koert [EMAIL PROTECTED] wrote: Hi Stu 1. why not check it on every

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Bastien Koert
see interspered again ;) From: Stuart Felenstein [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: [PHP-DB] Help: First Time Form with Sessions Date: Fri, 8 Oct 2004 08:56:48 -0700 (PDT) See interspersed: --- Bastien Koert [EMAIL PROTECTED] wrote: Hi Stu 1

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Well I guess too much success at once is a bad thing. For some unapparent reason, the variables here are not carrying over. Anyone see anything wrong here ? Page1 (Somewhat snipped) ?php session_start(); if ( empty( $_SESSION['l_education'] ) ) { $_SESSION['l_education']=array(); } if (

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Figured it out. Page 2 had to have the field name in the $SESSION parameters, not the holder from the Page1 array register. Stuart --- Stuart Felenstein [EMAIL PROTECTED] wrote: Well I guess too much success at once is a bad thing. For some unapparent reason, the variables here are not

Re: [PHP-DB] Help: Arrays with Session Variables not happening

2004-10-08 Thread Stuart Felenstein
K ..my problem seems to be combining echo on the menu values with the print array. If I echo $array[0]; that seems to work fine !? Stuart --- Stuart Felenstein [EMAIL PROTECTED] wrote: Back again , sorry :) I had my form set up with 7 multi selects , on the return page, all 7 arrays were

RE: [PHP-DB] Help needed

2004-10-04 Thread Gary Every
Check to see if your register_globals is set to off in php.ini. If so (likely, since it defaults to that value) you'll need to access your POST and GET variables like this: GET vars: $var = $_GET['var']; POST vars: $var = $_POST['var']; Gary Every Sr. UNIX Administrator Ingram Entertainment

Re: [PHP-DB] Help please, back to an error

2004-09-15 Thread Stuart Felenstein
Micah, Your right! I regretted this post after I hit send. The code generator is actually okay. I'm learning more about PHP, and what the code actually means, in the event it needs to be modded / edited. Sorry again for the post and thanks for the reply! Stuart --- Micah Stevens [EMAIL

Re: [PHP-DB] Help please, back to an error

2004-09-14 Thread Micah Stevens
I'm thinking you should either get a better code generator, or learn more about php.. :) -Micah On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote: Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off

RE: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread Peter Lovatt
Hi php runs as the same user as apache. Depending on any other security/system issues you could set apache to run as postgres. Otherwise why not connect to postgres using the php functions and write the text file using php? You might also be able to su to postgres. HTH Peter -Original

Re: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread Mário Gamito
Hi Peter, Thank you for your answer. php runs as the same user as apache. Depending on any other security/system issues you could set apache to run as postgres. Unfortunately, i can't. There's too much variables involved :( Otherwise why not connect to postgres using the php functions and write

Re: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread eoghan
This is my favourite. How can i execute this query: $myresult2 = pg_query($pgsql_conn, SELECT url_negado from urls_negados /tmp/urls_negados.txt); from inside a PHP file as user postgres ? cant you do this...? select url_negado into outfile '/tmp/urls_negados.txt' from urls_negados -- PHP

Re: [PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Peter Ellis
This isn't really a database question, so I'm not sure why it went to a database-related list. Have you checked your Apache configuration to make sure it's set to handle the PHP extensions? Check the PHP manual on how to set this (I believe relevant instructions are under Installation). --

Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...

2004-08-17 Thread Jeffrey Moss
Gotta recompile php with the --with-mysql option (or something like that). Try running configure --help You can see what options you compiled with by grepping for CONFIGURE in your Makefile. Here's what I got: [EMAIL PROTECTED] php-5.0.0b4 # grep CONFIGURE Makefile CONFIGURE_COMMAND =

Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...

2004-08-17 Thread Jeffrey Moss
://www.macromedia.com/devnet/mx/dreamweaver/articles/php_iis.html) -Jeff - Original Message - From: Jeffrey Moss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:08 PM Subject: Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()... Gotta

RE: [PHP-DB] Help with search form using multiple fields

2004-07-23 Thread Hutchins, Richard
I use PHP to check the search form's input fields then add them to the SQL statement if they contain data. And if you want the search to return all records from the table (let's hope there's not many then) if no search terms are provided then make the WHERE part of your SQL query an option based

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-17 Thread Pablo M. Rivas
Hello Ross, why don't use: explain select . and you'll see what mysql is thinking... ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-16 Thread Jason Wong
On Saturday 17 July 2004 09:31, Ross Honniball wrote: Attention all Sql gurus, Is there a way to FORCE mysql resolve specific conditions within a query before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] help with consecutive numbers in db

2004-06-24 Thread Matt Matijevich
[snip] The IP's (for example 192.168.1.1) are all in a single field. [/snip] If it is a possiblity, I would store each IP in its own row, with a column in that row being some kind of flag, like: is_issued as a logical column. Can you change you db layout or is it set in stone? -- PHP Database

Re: [PHP-DB] help with consecutive numbers in db

2004-06-24 Thread Pablo M. Rivas
Hello redhat, Hey... look at this: CREATE TABLE `testip` ( `id` int(10) unsigned NOT NULL auto_increment, `theip` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `theip` (`theip`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; SELECT theip, SUBSTRING_INDEX( theip, ., 1

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Ignatius Reilly
Hi the Third, have you considered dumping the table into a text file? SELECT * FROM mytable INTO OUTFILE c:/... this (AFAI) does not cause memory issues Ignatius _ - Original Message - From: Leo G. Divinagracia III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Leo G. Divinagracia III
would be nice... but since this is a hosted site and no shell access or anything, i thought i would write the php script to dump the file to my web path... Ignatius Reilly wrote: Hi the Third, have you considered dumping the table into a text file? SELECT * FROM mytable INTO OUTFILE c:/...

RE: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread tech.evisionmgr.com
I agree to use mysqldump to export the data to a text file. If you want to save time, you could write a php script to ftp the text file from the dead host to the new host. Then load the data back into the new database. I guess if you have broadband connection, then you might not be saving

Re: [PHP-DB] HELP: mySQL table name

2004-04-06 Thread John W. Holmes
From: Adrian Donoiu [EMAIL PROTECTED] I need information about how can I get the table name from this query : select * from test_table as t when I use : $field=mysql_fetch_field($result, $i); $field-table return the name of the table as t but I need the real name of the table

RE: [PHP-DB] help desk software

2004-04-06 Thread Will
Go to http://hotscripts.com -Original Message- From: redhat [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 1:21 PM To: phplist; fedoralist Subject: [PHP-DB] help desk software Anybody out there familiar with some helpdesk software? I found some called teacup that runs as a

Re: [PHP-DB] Help please

2004-03-05 Thread mustafa ocak
Hi, You can use LEFT OUTER JOIN Table1 : software list Table2 : installed ones $res=mysql_query(select table1.software_name, table2.software_name from table1 left outer join table2 on table1.software_name=table2.software_name); Check if there is not a matching record on table 2

Re: [PHP-DB] help w/ multidementional array in mysql

2004-02-25 Thread PHELPS, SCOTT
Sorry for accidentally posting twice: I wanted to point out a typo. At the bottom I meant advancing the array not table in regards to next() On Wed, 25 Feb 2004 11:12:10 -0600 PHELPS, SCOTT [EMAIL PROTECTED] wrote: Thanks in advance for reading this: I am trying to take a query based on

Re: [PHP-DB] help w/ multidementional array in mysql

2004-02-25 Thread Jason Wong
On Thursday 26 February 2004 01:04, PHELPS, SCOTT wrote: The problem is that it only prints one name. Also next() doesn't seem to be advancing the table so I am getting duplicates of the one name it does print to the table For starters, you're using next() incorrectly. It returns a value.

Re: [PHP-DB] Help With An UPDATE Query Please

2004-02-10 Thread Ignatius Reilly
UPDATE table SET column = CONCAT( MID( column, 2, LENGTH( column ) - 1 ), MID( column, 1, 1 ) ) WHERE column LIKE 'M%' HTH Ignatius _ - Original Message - From: Shaun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 14:15 Subject:

Re: [PHP-DB] Help with an UPDATE query please

2004-02-05 Thread Stuart Gilbert
Presuming you have the date in your PHP code you could simply add 172800 (seconds in 2 days) to the current value and insert it in the same way as you are doing with your current dates. If you post how you're inserting your dates, what format you're using and stuff like that then you'll

[Fwd: Re: [PHP-DB] Help with an UPDATE query please]

2004-02-05 Thread Stuart Gilbert
[Forwarded for Paxson Jr. because this was only sent to me.] you can also easily use the mysql date functions http://www.mysql.com/doc/en/Date_and_time_functions.html On 05. Feb 2004, at 11:23 Uhr, Stuart Gilbert wrote: Presuming you have the date in your PHP code you could simply add 172800

Re: [PHP-DB] Help with an UPDATE query please

2004-02-05 Thread John W. Holmes
I have (among others) two DATE columns in a table; Booking_Date and Booking_Completion_Date. How can I run a query that updates Booking_Completion_Date to be 2 days after Booking_Date where Booking_Completion_Date is NULL? UPDATE table SET Booking_Completion_Date = Booking_Date + INTERVAL

Re: [PHP-DB] Help with a COUNT / SELECT query

2004-01-23 Thread Shaun
Thanks for your reply, but that only tells me how many complete Bookings there are. I need to know how many Areas are complete i.e. for each Area where Bookings take place, all of those Bookings have been completed. Any ideas? Oòvn?Oòsis [EMAIL PROTECTED] wrote in message news:[EMAIL

Re: [PHP-DB] Help with a COUNT / SELECT query

2004-01-23 Thread Micah Stevens
SELECT COUNT(WMS_Area.Area_ID) AS complete_areas FROM WMS_Area, WMS_Bookings WHERE WMS_Area.Area_ID = WMS_Bookings.Area_ID AND MIN(WMS_Bookings.Booking_Status) = 2 GROUP BY WMS_Area.Area_ID Or something like that.. there's probably a better way to do it.. On Fri January 23 2004 1:05 pm,

RE: [PHP-DB] HELP!

2003-12-08 Thread Angelo Zanetti
your post is abit vague, give more details or code then we can try help. Its kinda like you saying, help my car wont go. -Original Message- From: Akmal [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 5:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] HELP! I'm trying to create

Re: [PHP-DB] help newbie

2003-12-08 Thread Tim Nilimaa
Hadi wrote: Hi , please help this newbie , how to make my database view from [1] [2] [3] [4] [5] [6] [7] [8] to 1 2 34 Thanks very much Hadi ***removed code*** You could convert the array into a string but why would you like to do that? Not a good way but a possible way

Re: [PHP-DB] help newbie

2003-12-08 Thread roy.a.jones
Return Receipt Your Re: [PHP-DB] help newbie document

Re: [PHP-DB] HELP!

2003-12-06 Thread Tyler Lane
Why don't you post the code you are trying to work with and we could help you from that point on. Akmal wrote: I'm trying to create a guestbook and... I'm having trouble getting a certain amount of entries per page. Please help, a snippet of a code would be nice. Thanks! -Akmal- --- Outgoing

Re: [PHP-DB] Help: do ... while, reverse data query

2003-11-05 Thread CPT John W. Holmes
From: Douglas Freake [EMAIL PROTECTED] I need to do a loop where the mysql query starts at the bottom and goes up, as if the data was in reverse order. This is for building a category/ sub_category menu. Data structure: (cat_id, cat_sub, cat_name) sample routine: do { $sql = SELECT *

Re: [PHP-DB] Help: do ... while, reverse data query

2003-11-05 Thread Boyan Nedkov
you can do it at sql level by using ORDER BY ... DESC like: SELECT * FROM categories WHERE cat_id = '$cat' ORDER BY cat_id DESC and then proceed the returned recordset in 'normal' way (order) -- Douglas Freake wrote: Hi there, I need to do a loop where the mysql query starts at the bottom and

RE: [PHP-DB] Help installing phpmysearch

2003-10-29 Thread Gary Every
But do you have php compiled --with-curl? check phpinfo(); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Joseph Allard [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Re: [PHP-DB] Help installing phpmysearch

2003-10-29 Thread Joseph Allard
Could you be a little more explicit? I don't understand check phpinfo()? Gary Every [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] But do you have php compiled --with-curl? check phpinfo(); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward

Re: [PHP-DB] Help with file upload

2003-10-21 Thread bunmi
PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bunmi Akinmboni [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Content-Type: text/plain Message-Id: [EMAIL PROTECTED] Mime-Version: 1.0 Date: 16 Oct 2003 15:12:38 +0200 Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DB] Help with file upload On Thu, 2003-10-16

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Bunmi Akinmboni
I used this code now: if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { move_uploaded_file($_FILES['ufile1']['tmp_name'],'./' . $_FILES['ufile1']['name']); This is the reply I got: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Gabriel Peugnet
For the message: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 you have to change the permissions of the file folder where you are copying the file. If you created it via FTP then you can't use

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Ruprecht Helms
On Thu, 2003-10-16 at 07:14, John W. Holmes wrote: Bunmi Akinmboni wrote: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 PHP runs as the web server and it does not have permission to write

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Bunmi Akinmboni
I just changed the permission on fu folder to 777 but it gives me the same problem. I'm writing this script so that I can use it to upload to jpeg files. The code is hereby attached. Gabriel Peugnet wrote: For the message: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream:

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Budelak
I just changed the permission on fu folder to 777 but it gives me the same problem. I'm writing this script so that I can use it to upload to jpeg files. The code is hereby attached. Bunmi Gabriel Peugnet wrote: For the message: Warning: move_uploaded_file(./ayservenet.jpg): failed to open

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Neil Smth
+0100 From: Bunmi Akinmboni [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DB] Help with file upload I used this code now: if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { move_uploaded_file

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Bunmi Akinmboni
: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DB] Help with file upload I used this code now: if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { move_uploaded_file($_FILES['ufile1']['tmp_name'],'./' . $_FILES['ufile1']['name

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Bunmi Akinmboni
; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DB] Help with file upload I used this code now: if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { move_uploaded_file($_FILES['ufile1']['tmp_name'],'./' . $_FILES['ufile1']['name']); This is the reply I got: Warning

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Nitin
permission is ok but it's got to be inside the home directory of web server, which is /var/www by default for apache Nitin - Original Message - From: Bunmi Akinmboni [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 1:28 PM Subject: Re: [PHP-DB] Help with file

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Bunmi Akinmboni
] To: [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 1:28 PM Subject: Re: [PHP-DB] Help with file upload Thanks Neil. My ultimate aim to update my database with the details of the upload after it uploads successfully, but I need to solve this problem first. The folder already has permission 777

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Nitin
, October 16, 2003 1:56 PM Subject: Re: [PHP-DB] Help with file upload HI Nitin, Is that not dangerous as it will affect the entire server structure? Bunmi Nitin wrote: permission is ok but it's got to be inside the home directory of web server, which is /var/www by default for apache

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Ruprecht Helms
On Thu, 2003-10-16 at 09:58, Bunmi Akinmboni wrote: Thanks Neil. My ultimate aim to update my database with the details of the upload after it uploads successfully, but I need to solve this problem first. The folder already has permission 777. Dateiname:

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Neil Smth
: 7bit Subject: Re: [PHP-DB] Help with file upload On Thu, 2003-10-16 at 09:58, Bunmi Akinmboni wrote: Thanks Neil. My ultimate aim to update my database with the details of the upload after it uploads successfully, but I need to solve this problem first. The folder already has permission 777. Re

Re: [PHP-DB] Help with file upload

2003-10-15 Thread John W. Holmes
Bunmi Akinmboni wrote: Pls Help. I have done a lot of reading prior to this yet I just can't seem make it work. I wrote an upload program as seen below but the response I got was: Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1] = Array ( [name] = ayservenet.jpg [type] =

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
His is the new code: ?php if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { copy($_FILES['ufile1']['tmp_name'], .); echo $ufile1_name ; echo DONE; echo ; print_r($_FILES); } else { echo Possible file upload attack. Filename: . $_FILES['ufile1']['name']; echo ;

Re: [PHP-DB] Help with file upload

2003-10-15 Thread John W. Holmes
Bunmi Akinmboni wrote: His is the new code: ?php if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { copy($_FILES['ufile1']['tmp_name'], .); You should be using move_uploaded_file() instead of copy(), first of all. Next, the two arguments passed to either copy() or move_uploaded_file()

Re: [PHP-DB] Help with file upload

2003-10-15 Thread George Patterson
This in in the php manual (http://www.php.net/manual/en/features.file-upload.php) but anyway... The value contained in $_FILES['ufile1']['name'] is not the name of the temporary file on the server. Try $_FILES['ufile1']['tmp_name'] instead Hence the lines if

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
This is reply I got: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 Warning: move_uploaded_file(): Unable to move '/tmp/phpfJyDSw' to './ayservenet.jpg' in

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
I used this code now: if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { move_uploaded_file($_FILES['ufile1']['tmp_name'],'./' . $_FILES['ufile1']['name']); This is the reply I got: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in

Re: [PHP-DB] Help with file upload

2003-10-15 Thread John W. Holmes
Bunmi Akinmboni wrote: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 PHP runs as the web server and it does not have permission to write to the current directory. If you're using IIS, PHP runs as

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
So what could be the problem? I reaaly don't know. Bunmi John W. Holmes wrote: Bunmi Akinmboni wrote: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 PHP runs as the web server and it does not have

Re: [PHP-DB] HELP With UPDATE Query in mySQL

2003-10-06 Thread pete M
and put it inside a transaction cos in case something goes wrong part of the way through pete Jeff Shapiro wrote: This should do it: UPDATE Bookings SET Booking_Start_Date = CONCAT(DATE_FORMAT(Booking_Start_Date, '%Y-%m-%d'), '09:00:00'), Booking_End_Date =

Re: [PHP-DB] HELP With UPDATE Query in mySQL

2003-10-04 Thread Jeff Shapiro
This should do it: UPDATE Bookings SET Booking_Start_Date = CONCAT(DATE_FORMAT(Booking_Start_Date, '%Y-%m-%d'), '09:00:00'), Booking_End_Date = CONCAT(DATE_FORMAT(Booking_End_Date, '%Y-%m-%d'), '17:30:00'); If you are using version 4.1.1 or newer the DATE_FORMAT function could be replaced

Re: [PHP-DB] Help With Another UPDATE Query Please!

2003-10-04 Thread Jeff Shapiro
It all depends on what database server (and version) you are using. I'm not really sure what you are asking, and could use a little more detail about the tables and what are needing to do. On Sat, 4 Oct 2003 13:45:56 +0100, Shaun spoke thusly about [PHP-DB] Help With Another UPDATE Query

Re: [PHP-DB] Help With Another UPDATE Query Please!

2003-10-04 Thread Shaun
I am using mySQL 3.23 Each project has a work type associated with it, currently the Work Type column of the Project table holds the work type name, however i have now added a Work_Type_ID column to the Work_Type table and i would like Projects to hold the Work_Type_ID as opposed to the Work Type

Re: [PHP-DB] HELP-PHP install

2003-10-01 Thread Robert Hennig
Jason Wong wrote: On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote: cd /apache/apache-xxx ./configure --prefix=/www cd /php/php-xxx ./configure --with-mysql --with-apache=/apache/apache-xxx --enable-track-vars make make install cd /apache/apache-xxx ./configure

Re: [PHP-DB] HELP-PHP install

2003-09-30 Thread Jason Wong
On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote: cd /apache/apache-xxx ./configure --prefix=/www cd /php/php-xxx ./configure --with-mysql --with-apache=/apache/apache-xxx --enable-track-vars make make install cd /apache/apache-xxx ./configure

RE: [PHP-DB] Help needed with variable scoping? or mysql problem

2003-08-23 Thread Mike Klein
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 8:10 AM To: Mike Klein Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Help needed with variable scoping? or mysql problem best way to tell is to place .'or die(mysql_error())' after any call to mysql_query

Re: [PHP-DB] Help with filling a second drop down List from a prior listselection in the same page

2003-08-18 Thread jeffrey_n_Dyke
Sounds like you're on the right track. in the select list, add -- onChange=document.form.submit() -- this will submit the form when the user selected the an option from the list, then you could catch the submitted variable and pass it to the second drop down list and third and so on. Realizing

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread Andrew D. Luebke
Well, as one of the last posts said, if you are displaying in a web browser, via HTML, you need to insert br tags where you want the text to go to the next line. HTML doesn't respond to /r/n pairs. So if that is how the user types them in (with a enter key at the end of lines) you need to

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread Budelak
You guys thanks for the encouragement. I finally solved it with this: ?php $text= preg_replace(/(\015\012)|(\015)|(\012)/,nbsp;br /, $rsDailynewsDetail-Fields('newsfull')); echo $text; ? Help came of course from the link Holmes gave. Thanks. Budelak wrote: Yes. Itis with enter key. It will not

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread Budelak
Yes. Itis with enter key. It will not be possible to pre-determine the length as this field is supposed to be a news field. I'm lost as to how to go about this as the enter key does not generate chr(13) when saving. I'm really lost. Holmes directed me to http://us2.php.net/nl2br. I'm

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread John W. Holmes
Budelak wrote: Hello, Can someone help with this problem I've been trying to solve but don't how to. I have a field of type longtext that contains text with paragraphs at the time of entry. But when I display this text content, the paragraphs are not shown. Everything will just appear in one

<    1   2   3   4   >