[PHP-DB] SQL server procedore how to

2003-02-23 Thread Noam Giladi
i have a aprocedure simple_proc i try to call her with mssql_query like this: $q=exec simple_proc; $ret = mssql_query($q,$__[db connection]); the result i get is:

[PHP-DB] Difficult Dilemma Details Dodged

2003-02-23 Thread Kevin P
Greetings All; We have constructed a reservation system for a chain of travel agents. Our former PHP'er wrote the booking section but it appears to be very fragile, as it breaks regularly. We are now rewriting this section. Our problem. page 1 is a form to fill in up to 4 names so as to search

Re: [PHP-DB] SQL server procedore how to

2003-02-23 Thread Mark
You need to ue mssql_fetch_*() to actually put the data into an array. --- Noam Giladi [EMAIL PROTECTED] wrote: i have a aprocedure simple_proc i try to call her with mssql_query like this: $q=exec simple_proc; $ret =

RE: [PHP-DB] Difficult Dilemma Details Dodged

2003-02-23 Thread John W. Holmes
We have constructed a reservation system for a chain of travel agents. Our former PHP'er wrote the booking section but it appears to be very fragile, as it breaks regularly. We are now rewriting this section. Our problem. page 1 is a form to fill in up to 4 names so as to search the

Re: [PHP-DB] mysql to cvs file to excel

2003-02-23 Thread Ruth Zhai
This is what I use to generate a comma delimited csv file: $sql = SELECT * FROM table INTO OUTFILE 'file.csv' . FIELDS TERMINATED BY \',\' . ENCLOSED BY \'\\'; Hope this helps. Ruth - Original Message - From: Snijders, Mark [EMAIL PROTECTED] To: [EMAIL

[PHP-DB] PHP4 on Windows using MSSQL

2003-02-23 Thread Kevin Gordon
Hi Everyone, From a Linux session: ~ # telnet 10.1.1.1 1433 Trying 10.1.1.1... Connected to 10.1.1.1. Escape character is '^]'. Connection closed by foreign host. From within NT4 Primary Domain Server: SQL Server Query Analyzer using the user login password applied in PHP (and created in MSSQL)