[PHP-DB] mssql problems

2002-04-19 Thread Rob Fraser
Dear All, I hope somebody can help me. I am new to PHP (I've used ASP for three years:-( ) and I'm loving PHP and trying to get my work to convert but I've coming across a error with mssql_query() explorer its just crashes with a php.exe 'memory could not be read error'. I'm sure it a school boy

[PHP-DB] Connection error

2002-04-19 Thread Ciprian Trofin
Bisexuality doubles the chance of getting a date. Hi All! In order to make my job easy, a choose the following approach: settings.php ? $dbserver = 'server'; $dbname = 'name'; $dbpass = 'password'; ? main_file.php ? include settings.php;

Re: [PHP-DB] Connection error

2002-04-19 Thread Jason Wong
On Friday 19 April 2002 18:29, Ciprian Trofin wrote: Bisexuality doubles the chance of getting a date. Hi All! In order to make my job easy, a choose the following approach: settings.php ? $dbserver = 'server'; $dbname = 'name'; $dbpass = 'password'; ? main_file.php

[PHP-DB] Re:[PHP-DB] Connection error

2002-04-19 Thread adi
Ciprian Trofin [EMAIL PROTECTED] wrote on 4/19/2002 5:29:00 PM: Bisexuality doubles the chance of getting a date. Hi All! In order to make my job easy, a choose the following approach: settings.php ? $dbserver = 'server'; $dbname = 'name'; $dbpass = 'password'; ?

Re: [PHP-DB] Re:[PHP-DB] Connection error

2002-04-19 Thread Ciprian Trofin
Monday is an awful way to spend 1/7th of your life. a try double quote instead single quote. a $dbserver = server; Tried that, no effect. -- Ciprian Oxymoron: Government budget -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Connection error

2002-04-19 Thread Sam Masiello
Instead of suppressing the error message using the @ sign, why not remove it and your die() statement and see what error is produced on your live server? HTH --Sam -Original Message- From: Ciprian Trofin [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 6:29 AM To: [EMAIL

[PHP-DB] PHP Compiling issues

2002-04-19 Thread Chris O'Brien
Background: Server version: Apache/1.3.24 (Darwin) MySQL: Ver 8.23 Distrib 3.23.49, for apple-darwin5.2 on powerpc PHP version 4.1.2 from the Darwin CVS repository -- After much hassle and grief, I was able to make and install PHP 4.1.2 from the Darwin CVS source repository using this

[PHP-DB] RE: troubles with select * from... to a ms-sql-server

2002-04-19 Thread Oliver Cronk
Have you tried removing the [] brackets? And what is ReferencesComplete - a standard table, a view or a stored procedure? Ollie -Original Message- From: Hermann Otteneder [mailto:[EMAIL PROTECTED]] Sent: 17 April 2002 16:30 To: [EMAIL PROTECTED] Subject: troubles with select * from...

[PHP-DB] RE: mssql problems

2002-04-19 Thread Oliver Cronk
Hi PHP Is quite cool isn't it As for your problem you might want to try a few things: - Running PHP as the ISAPI module make sure you have the latest version (you should get the latest version anyway). - Removing this line : $r = mssql_rows_affected ( $link); - as there is a mysql function

RE: [PHP-DB] page expires

2002-04-19 Thread Oliver Cronk
How about this incorporated somewhere: $s = (SERVER_PROTOCOL == HTTP/1.0) ? Pragma: no-cache : Cache-Control: no-cache, must-revalidate; header($s); This code must be at the start of the script BEFORE anything is output to the browser - as it sends an additional HTTP header (hence the function

[PHP-DB] Date of Birth From Form

2002-04-19 Thread Brandon Paul
Hey all, I have a credit application form, and one of the required elements is the applicant's Date of Birth. I have creditapp table with a birthdate field and it is a DATE datatype. On the form, I want to be able to have them enter their Date of Birth as mm/dd/ and have it go into the

Re: [PHP-DB] Date of Birth From Form

2002-04-19 Thread Duncan Hill
On Fri, 19 Apr 2002, Brandon Paul wrote: going about it wrong? Any help would be greatly appreciated. 1) Validate that the input is correct. 2) Tokenize the string based on the /s 3) Re-format the date. Or, use the date functions - I'd swear one of them can re-write dates. -- PHP Database

Re: [PHP-DB] Date of Birth From Form

2002-04-19 Thread Steve Cayford
A combination of strtotime() and date() can make this easy. date(Y-m-d, strtotime($birthday)) Or see docs and comments at http://www.php.net/manual/en/function.strtotime.php -Steve On Friday, April 19, 2002, at 01:29 PM, Brandon Paul wrote: Hey all, I have a credit application form, and

[PHP-DB] IP Address?

2002-04-19 Thread Rob Day
How can I find out the IP address of the client requesting a given php file? I know that you can use $HTTP_SERVER_VARS[REMOTE_ADDR] in more recent versions of PHP. Unfortunately, we only have PHP3.0.14 and I don't think that this option is available in our ancient version. I also can't use server

RE: [PHP-DB] IP Address?

2002-04-19 Thread Craig Vincent
How can I find out the IP address of the client requesting a given php file? I know that you can use $HTTP_SERVER_VARS[REMOTE_ADDR] in more recent versions of PHP. Unfortunately, we only have PHP3.0.14 and I don't think that this option is available in our ancient version. I also can't use

RE: [PHP-DB] IP Address?

2002-04-19 Thread Rob Day
Thanks, Craig. That was exactly what I was looking for! -Rob -Original Message- From: Craig Vincent [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:35 PM To: Rob Day; [EMAIL PROTECTED] Subject: RE: [PHP-DB] IP Address? How can I find out the IP address of the client

RE: [PHP-DB] IP Address?

2002-04-19 Thread Boaz Yahav
? phpinfo(); ? should give you all of the info you need. Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Rob Day [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 9:29 PM To: 'Craig Vincent';

[PHP-DB] Help with a JOIN statement

2002-04-19 Thread Michael Robbins
I have 2 tables, 'users' and 'files' (defined below) Can I construct a single SELECT statement so that it will return ONLY users that have files and ONLY the last file that the user has? So it would return 1 row per user containing their most recent file. users Id int

RE: [PHP-DB] Help with a JOIN statement

2002-04-19 Thread Robert V. Zwink
You could try: SELECT users.Name, Files.Filename FROM Files LEFT JOIN users ON Files.Userid = users.Id GROUP BY Files.Userid ORDER BY Files.Stamp DESC I'm not sure if this would work, depends on if MySQL ORDER's before GROUP. You could try it though. Capitolization may be incorrect, I

[PHP-DB] Re: mssql problems

2002-04-19 Thread Frank Flynn
I had this exact same problem and after a lot of time I switched to an ODBC connection (no mssql_connect... Just use the ODBC commands) and everything has worked flawlessly since. There's probably some right combination and way to use the mssql specific commands but life it too short and the

[PHP-DB] Complex (for me) table join - help please?

2002-04-19 Thread Peter Westergaard
I'm trying to perform a join that seems like it should be simple, but I'm just ending up in a morass. Hopefully someone who's standing a step or two back from the problem can help me solve this one... What I have: Table A (Category): with a 3-tier category structure: -Nature -Category

Re: [PHP-DB] Complex (for me) table join - help please?

2002-04-19 Thread Mike
Peter, I've you tried doing a inner join, left outer join, right outer join? What db program are you using? Could you post what your current select statement looks like? Mike - Original Message - From: Peter Westergaard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19,

Re: [PHP-DB] Complex (for me) table join - help please?

2002-04-19 Thread szii
Try SELECT TableA.Category, TableB.PersonID FROM TableA LEFT JOIN TableB ON (TableA.CategoryID = TableB.TableAID) WHERE TableB.ClientID = $cid ORDER BY TableA.Category ASC LEFT JOIN states that you should return all TableA, inserting NULL for TableB if there is no match. 'Luck -Szii