[PHP-DB] PHP and MS-SQL

obviously 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

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

Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP

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

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 in

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

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

[PHP-DB] Strange DB Error

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

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 i

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

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 pro

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

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 term='

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

log SET term='$search', returns='$arrayword', time=CURTIME(), date=CURDATE(), ip='$ip'"; echo $sql; $logit = mysql_query($sql) or die(mysql_error()); And check out what gets spit out to the browser when $sql is echoed? Maybe that'll point out someth

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

done 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 Messag

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

, time=CURTIME(), date=CURDATE(), ip='$ip'"; echo $sql; $logit = mysql_query($sql) or die(mysql_error()); 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 resu

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

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