thanks. Stupid me. I've been banging by head for the last two hours.
"Bastien Koert" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> limit is a mysql keyword...change that field name and the corresonding
names
> in your sql
>
> bastien
>
> >From: "HarryG" <[EMAIL PROTECTED]>
> >To:
limit is a mysql keyword...change that field name and the corresonding names
in your sql
bastien
From: "HarryG" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] What wrong with my Query??
Date: Fri, 25 Mar 2005 16:26:38 +1100
What the hell is wrong with this MYSQL query?? PHP keeps
What the hell is wrong with this MYSQL query?? PHP keeps giving me the error
message:
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 'limit=2,
name='test1', email='[EMAIL PROTECTED]', password='t
$query
Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select
statement DATE fields are returned in the Oracle default DD-MON-RR format.
I can successfully set NLS_DATE_FORMAT using either an environment variable
and restarting apache or by using ALTER SESSION SET NLS_DATE_FORMAT =
The error message and when I have problems I find it's very helpful to
print the actual value of the $query variable.
In your case it looks like
AND acct_db.key1 LIKE \"%\".AllMid_Data.CPU_Hostname
is adding AND acct_db.key1 LIKE "%".AllMid_Data.CPU_Hostname
and you can't join two stri
On Thursday 24 March 2005 17:26, JeRRy wrote:
>
> I was getting an error earlier stating round1 does not
> exist, however it does. round1 table does not exist.
> So does not say round1.game1 does not exist.
Does a table named round1 exist in your database?
If so and you are using mysql > 4.0.4 yo
missing single quotes around text
UPDATE tipping SET score = 3 WHERE round1.game1 =' H'
AND tipping.username = 'jerry';
bastien
From: JeRRy <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Why not ?
Date: Fri, 25 Mar 2005 04:05:28 +1100 (EST)
Why does this NOT work?
UPDATE tipping SET
--- "Larry E. Ullman" <[EMAIL PROTECTED]>
wrote:
> > Why does this NOT work?
> >
> > UPDATE tipping SET score = 3 WHERE round1.game1 =
> H
> > AND tipping.username = jerry;
>
> For starters, you should quote strings in a query.
> There may also be a
> problem with the round1 reference.
>
> Lar
JeRRy wrote:
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
Please inform?
You're not linking table round1 to table tipping in any way, and you've
got some quoting issues.
something like this:
UPDATE tipping SET score=3 WHERE round1.game1
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
For starters, you should quote strings in a query. There may also be a
problem with the round1 reference.
Larry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http:
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
Please inform?
J
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.ph
Juffermans, Jos wrote:
I understand your point but since I wasn't getting any response and never
received a confirmation email from the system telling me that my email
account had been verified, I wasn't sure that the original post was actually
sent to the community. Oddly enough I got an email fro
OK. I think I have resolved this issue. The problem I am
having now is that I have a simple table that is a list of systems to
exclude from the display. I am having trouble figuring out how to
structure my query to actually exclude the systems in this table. Here
is what I tried, and it
Hi,
Martin Norland wrote:
MN> I'm afraid phrasing a question multiple ways over a course of days tends
MN> not to have much success. In an effort to avoid populating google with
MN> just the question, I will give to you what I would try.
I understand your point but since I wasn't getting any r
Juffermans, Jos wrote:
Hi,
[snip]
Hello, again.
I'm afraid phrasing a question multiple ways over a course of days tends
not to have much success. In an effort to avoid populating google with
just the question, I will give to you what I would try.
( please note the irony of this now. )
I'm
Not quite correct, "No valis MySQL resource" means the query and/or link
failed in connection in some way. A correct and proper query MAY easily
return 0 rows and that is correct and will give you a valid resource
(handle) and simply no data.
Bastien
From: "J. Connolly" <[EMAIL PROTECTED]>
CC:
yeah...errora are important. I do not escape my quotation marks in a
query. I use single quotes within my insert and select statements.
If it says "No valis MySQL resource then you are returning 0 records
which may be caused by escaping the quotations.
I follow this pattern
$sql ="INSERT INTO V
Hi,
I have a script that connects to a database which is in another country and
connected to our network thru a VPN.
The script tries to connect using ocilogon() and checks if a connection is
established. If not, it presents the visitor with a nice errorpage.
However, ocilogon takes a very lon
18 matches
Mail list logo