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.
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
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 here:
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? Thanks
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
]
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 code/query syntax?
I'm
: 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 the last id of the last insert statement - if you do any db
activity
after the insert, this won't
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()
{
global