Are you running the 2 queries at the same time? they should be run 1 at
a time. What does mysql_error() say? use it when you are checking the
result set (if (!$result) { echo "Error: " . mysql_error();}Are the
result sets being sent to 2 different identifiers? Just a few
possibilities.
Re
Hi.
How did you check that Query 2 has been executed?
You may add to your php.ini file
mysql.trace_mode = On
to see some warnings and errors.
Yahoo Default User <[EMAIL PROTECTED]> wrote:
> Hi Guys,
>
> I have a problem with MySQL in conjunction with PHP so
> I also decided to post h
when asking a question, it always helpful to post you code/queries so we
can see what is happening.
but tbh, this sounds like it's a php code problem.
you have established that both queries work, on there own
I'm don't know anything about php, but it sounds like you are not
executing the first quer
From: Jianping Zhu [mailto:[EMAIL PROTECTED]
>but i got error message with:
>http://coopunit.forestry.uga.edu:8080/testdb.php
>the error is:
>Fatal error: Call to undefined function:
>mysql_connect() in /var/www/html/testdb.php on line 13
>
>How can Fix this problem? Thank
I've had a few queries that worked strangely worked in Mysql monitor,
but did not work from PHP.
I was able to solve every one of them by ensure that the query in PHP did
not have any line breaks in it. It normally doesn't matter if there are
line breaks in the code, but on occassion, a line
On 30-Oct-2001 Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class for PHP. When this runs, it correctly inserts
> the row to the table, but is failing to retrieve the last_insert_id().
>
> function StartOrder()
> {
> globa
rd PHP functions won't work. (And yes, I did just test it.)
>
> -Original Message-
> From: rc [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:58 PM
> To: Matthew Walker
> Cc: [EMAIL PROTECTED]
> Subject: Re: PHP/MySQL Problem
>
> Mysql_Inse
rc wrote:
> Mysql_Insert_ID($dbhandle->connection);
>
> gets the last id of the last insert statement -
> if you do any db activity
> after the insert, this won't work.
In other words:
> $res = $dbhandle->query("select
last_insert_id()");
> $dbhandle->query("UNLOCK TABLES");
> $res
s, I did just test it.)
>
> -Original Message-
> From: rc [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:58 PM
> To: Matthew Walker
> Cc: [EMAIL PROTECTED]
> Subject: Re: PHP/MySQL Problem
>
> Mysql_Insert_ID($dbhandle->connection);
>
> gets th
PROTECTED]
Subject: Re: PHP/MySQL Problem
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db
activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following c
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class f
11 matches
Mail list logo
