[PHP-DB] PHP and MS-SQL

2002-10-25 Thread Axel
sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me

RE: [PHP-DB] PHP and MS-SQL

2002-10-25 Thread Axel Bergmann
Great, thanks a bunch! -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke;Keane.com] Sent: Friday, October 25, 2002 3:11 PM To: Axel Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and MS-SQL yes this works. if your code is going to remian on Unix you'll have to install

RE: [PHP-DB] PHP and MS-SQL

2002-10-28 Thread Axel Bergmann
Thanks Frank! -Original Message- From: Frank M. Kromann [mailto:frank;kromann.info] Sent: Sunday, October 27, 2002 4:22 AM To: Axel Bergmann; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info

[PHP-DB] Strange DB Error

2004-02-25 Thread Axel IS Main
When returning to the main page of my script sometimes I'll get the following error: Warning: mysql_fetch_array(): 8 is not a valid MySQL result resource in /home/nick/http/search/includes/main.inc on line 13 This happens only AFTER the first element in the resource has been processed. Here's

Re: [PHP-DB] Strange DB Error

2004-02-25 Thread Axel IS Main
Error trapping is not really relevant here as the server is properly configured so the errors are going to show up in either event. In fact, using the die() function on my server just makes thing worse. In any case, the var_dump was a good idea as I was able to find out that what is happening

[PHP-DB] Re:[PHP-DB] Strange DB Error

2004-02-25 Thread Axel IS Main
What you propose makes sense of course, but no matter what I do, where I send the errors, even to the system log, the mysql_fetch_array () error is the only one that shows up. It would appear that either the query is failing is some way that PHP isn't recognizing, or the fetch isn't working

[PHP-DB] What's wrong with this query?

2004-02-26 Thread Axel IS Main
I've just tried to do something I've done a thousand times. It does not work. I've checked all of the syntax, made sure the field and variable names are correct. No matter what I do it just doesn't work. The table remains empty. Here's the query: $logit = mysql_query(INSERT INTO log SET

Re: [PHP-DB] What's wrong with this query?

2004-02-26 Thread Axel IS Main
what gets spit out to the browser when $sql is echoed? Maybe that'll point out something that's going wrong. If nothing is apparent, post the results of echo $sql back to the list and maybe one of us will find something. HTH. Rich -Original Message- From: Axel IS Main

Re: [PHP-DB] What's wrong with this query?

2004-02-26 Thread Axel IS Main
that a thousand times - the syntax is wrong :). You are using a combo of INSERT and UPDATE syntax there. Try INSERT INTO log (term, returns, time, date, ip) VALUES ('$search', '$arrayword',CURTIME(), CURDATE(), '$ip'); Cheers, Paul -Original Message- From: Axel IS Main [mailto:[EMAIL

Re: [PHP-DB] What's wrong with this query?

2004-02-26 Thread Axel IS Main
()); And check out what gets spit out to the browser when $sql is echoed? Maybe that'll point out something that's going wrong. If nothing is apparent, post the results of echo $sql back to the list and maybe one of us will find something. HTH. Rich -Original Message- From: Axel IS Main

Re: [PHP-DB] What's wrong with this query?

2004-02-26 Thread Axel IS Main
Ok, ok. I get the message about the syntax. Since I've used this syntax for a long time and so far there hasn't been a problem I'll assume that's not the problem. I will, however, review this and probably make some changes for the sake of compliance if nothing else. In any event, the syntax is