Hi,
We have recently upgraded our mysql server from 4.0.X to 4.1.7.
But now, the mysql_fetch_array() & mysql_fetch_assoc() doesn't work anymore
when escaping fields names like that:
SELECT `name` FROM `db`;
mysql_fetch_assoc() returns a associative arrays, but not with good key
names (somes b
After all, I have try my queries into mysql directly... and finally my
problem comes from mysql 4.1.7 itself ("production ready certified" gr)!
Private message to php: I'm so sorry <;o)
--
Clement Moulin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.p
I'm running into a syntax error:
You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the
right syntax to use near ') AND Prof.WorkExp IN () AND
Prof_Industries.
Now I printed out the query and that works as I dumped
it into a mysql client and i
Looks like your $expLevl value is empty. It's probably set, but has no
value in it. Check that.
-TG
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 02, 2004 1:46 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] 5 hours later - sql error
After a lot of tests, this bug is not mandatory! I mean, sometimes
associative array is okay... and sometimes it is not! Just changing fields
orders or adding a field and the result became okay!! :-$
But it seems it occurs only when escaping fields (that I do systematically).
Thanks for your su
Funny, questions about MySQL 4.1.x seem to be popping up a lot recently. With
good reason. There are some changes that make old mysql_*() functions not work
anymore. I don't know all the ins and outs yet, but I ran into it last
weekend and everything I saw seemed to recommend switching to th
--- "Gryffyn, Trevor" <[EMAIL PROTECTED]>
wrote:
> Looks like your $expLevl value is empty. It's
> probably set, but has no
> value in it. Check that.
>
No sorry to say that isn't it. It seems that for
every field i submit in the search, it's the field
right after where the syntax error is re
Stuart Felenstein wrote:
No sorry to say that isn't it. It seems that for
every field i submit in the search, it's the field
right after where the syntax error is reported. So ,
maybe it's not truly a syntax error.
Print out the entire query before you run it. Syntax errors are usually
pretty obv
can you post the code that creates the sql statement
bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: "Gryffyn, Trevor" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
CC: Stuart Felenstein <[EMAIL PROTECTED]>
Subject: RE: [PHP-DB] 5 hours later - sql error.
Date: Thu, 2 Dec 2004 14:50:24 -0800 (PS
Hi all !
I'd like to establish an encrypted line between php and
postgres. I was able to build apache with ssl (https: works),
I was able to make postgres to use ssl (postgres.conf,
ssl=true). But when I try phpinfo I get:
pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.0
10 matches
Mail list logo
