Re: [PHP-DB] Trouble with uploading a file via ftp_put

2003-10-06 Thread Ruprecht Helms
Hi, Let me get this straight: You're trying to transfer a file from a local PC (A) to a server (B). And your code is running on (B)? If so, then, (assuming you have things setup correctly, ie have an ftpserver running on (A)), you should be using ftp_get() or similar. If not, could

[PHP-DB] Selecting two names from a table

2003-10-06 Thread Shaun
Hi, I have a table called Bookings and a table called User. Bookings are created and hold the User_ID of the User who created it (Booking.Booked_User) and the User who will be going on the booking (Booking.Booking_Creator). How can I create a report that lists both users on each row. If I do

[PHP-DB] pathinformation from file-field

2003-10-06 Thread Ruprecht Helms
Hi, how can I get the pathinformation you can see in the file-field if you chose one file within a formular for transfer. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] pathinformation from file-field

2003-10-06 Thread Fedde van Feggelen
how can I get the pathinformation you can see in the file-field if you chose one file within a formular for transfer. http://nl.php.net/manual/en/function.pathinfo.php ? laters, Fedde ~= Everybody lies, but it doesn't matter because nobody listens =~ -- PHP Database Mailing List

RE: [PHP-DB] Selecting two names from a table

2003-10-06 Thread Jacob A. van Zanen
Hi, Try something like this: SELECT U1.User_Name , U2.User_Name , B.Booking_Date FROMUSER U1 , USER U2 , BOOKING B WHERE B.Booking_Creator = U1.User_ID AND B.Booked_User = U2.User_ID' Jack -Original

Re: [PHP-DB] pathinformation from file-field

2003-10-06 Thread Jason Wong
On Monday 06 October 2003 18:31, Ruprecht Helms wrote: how can I get the pathinformation you can see in the file-field if you chose one file within a formular for transfer. If you mean when you do an HTTP upload, then no, you cannot get the path info. All you get is the file name. This is for

Re: [PHP-DB] Selecting two names from a table

2003-10-06 Thread Shaun
Thank you! Jacob A. Van Zanen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, Try something like this: SELECT U1.User_Name , U2.User_Name , B.Booking_Date FROM USER U1 , USER U2 , BOOKING B WHERE B.Booking_Creator = U1.User_ID AND B.Booked_User = U2.User_ID' Jack

Re: [PHP-DB] Trouble with uploading a file via ftp_put

2003-10-06 Thread Jason Wong
On Monday 06 October 2003 16:48, Ruprecht Helms wrote: I want that (B) can locate the file on (A) and upload it to the subdirectory on (B). This should also be possible in the case the user have no ftp-server on his local pc. If (A) does not have an ftp server installed then you're asking for

Re: [PHP-DB] pathinformation from file-field

2003-10-06 Thread Ruprecht Helms
On Mon, 2003-10-06 at 13:07, Jason Wong wrote: On Monday 06 October 2003 18:31, Ruprecht Helms wrote: how can I get the pathinformation you can see in the file-field if you chose one file within a formular for transfer. If you mean when you do an HTTP upload, then no, you cannot get the

Re: [PHP-DB] Trouble with uploading a file via ftp_put

2003-10-06 Thread Ruprecht Helms
On Mon, 2003-10-06 at 13:05, Jason Wong wrote: Now I tried the method with move_uploaded (http-upload). This is the testscript ?php // upload.php: PHP File Upload im Safe Mode21.5.02/vo // (http-Protokoll und POST-Mechanismus) // Skript funktioniert auch im Safe

[PHP-DB] Need help with a OpenLink ODBC driver error again

2003-10-06 Thread Don Myers
Ok this time I checked the SQL select syntax! So I hope it's not something that easy again (Well actually easy would be nice) The other day I Posted a email question about getting a 37000 sql error but my sql syntax was wrong. Yes I felt stupid but this time I corrected the syntax and I am

RE: [PHP-DB] Need help with a OpenLink ODBC driver error again

2003-10-06 Thread Jacob A. van Zanen
Hi Does the query return data when executed not through a browser but directly on the database? If yes, how much time does it take to return the data. I believe default time out for apache is 30 seconds. So maybe it's a webserver setting that needs to be increased. Jack -Original

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 =

[PHP-DB] Red Hat 9 + MS SQL

2003-10-06 Thread Chris Frederick
Hi, I could use some help here. I've been running a Red Hat 9 server for the last couple of months that uses FreeTDS/unixODBC to connect to a Microsoft SQL Server 2k Server. Lately I've added the Windows server to the Active Directory Domain, and now php cannot keep a persistant connection

RE: [PHP-DB] Trouble with uploading a file via ftp_put

2003-10-06 Thread Michael Scappa
Ruprecht, I've experienced this problem, its that you need to turn ftp_pasv on. ftp_pasv($connection_id,true); That should take care of it, don't' worry about anything else. Michael Scappa Lead Developer Verve Internet Solutions for higher education -Original Message- From:

Re: [PHP-DB] Is this redundant? {OT}

2003-10-06 Thread David Smith
Robin Kopetzky wrote: Good afternoon. I found this code in a program I'm renovating and think this is very redundant. Also, it does slow queries down while doing all of the conversions. prod_id in the mysql database is declared an integer. SQL above where prod_id = ' . (int)$prod_id . '

Re: [PHP-DB] Is this redundant? {OT}

2003-10-06 Thread John W. Holmes
Robin Kopetzky wrote: Good afternoon. I found this code in a program I'm renovating and think this is very redundant. Also, it does slow queries down while doing all of the conversions. prod_id in the mysql database is declared an integer. SQL above where prod_id = ' . (int)$prod_id . '

[PHP-DB] Wont connect to remote mysql

2003-10-06 Thread Blake Crosby
Hello, For some reason php will not connect to a remote mysql server.. Using the following code: ?php $link = mysql_connect('hostname:3306', username, password) or die(Could not connect: . mysql_error() . \n); print (Connected successfully); mysql_close($link); ? Returns

Re: [PHP-DB] Wont connect to remote mysql

2003-10-06 Thread Blake Crosby
That's not it. The user can connect to the database using the mysql client on the same machine as the webserver to the database machine. Blake On 07/10/2003 12:03 AM, Andy Green [EMAIL PROTECTED] wrote: check the permissions granted to the user to make sure that it's not restricted to

[PHP-DB] Another Question

2003-10-06 Thread zxx10
Hi, All: I have some information stored in the database. When I try to show them, sometimes it give me the following warning: Warning: printf(): Too few arguments ... Here is the problematic code: printf(textarea COLS=56 ROWS=7 name=\description\$des/textarea br); I figured out that if there