Hello everyone,
I've installed mysql server on my fedora box and it works great when i use the
console =)
But, i want my php sources to work with these bases but it doesn't work =(
In fact it seems that the function mysql_connect() cannot be called, here is
the error on the web page :
Fatal e
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
uting the first query
you might have more luck if you post your php code to a php group
chris
-Original Message-
From: Yahoo Default User [mailto:[EMAIL PROTECTED]
Sent: 05 November 2004 08:52
To: [EMAIL PROTECTED]
Subject: PHP/MySQL Problem
Hi Guys,
I have a problem with MySQL in conjunct
Hi Guys,
I have a problem with MySQL in conjunction with PHP so
I also decided to post here:
I have a PHP script that contains two consecutive
MySQL queries, something like this:
Query 1: Delete some rows from Table A
Query 2: Insert some rows into Table A
The problem is, only Query 2 seems to
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 have redhat 9.0 and Server version: Apache/2.0.40.
i have installed rpms php-4.2.2-17.2.i386.rpm
php-mysql-4.2.2-17.2.i386.rpm
After i create a database called mydb and serveral tables in mysql,
I tried to run following testdb.php script
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
Hello,
I'm having trouble determining what's going wrong with a MySQL query that
I'm doing from PHP.
I have a table with the following columns:
id (int)
name (varchar 20)
starttime (int)
duration (int)
now, i have a row that has a starttime of 60, when i attempt to do the
following update with
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
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 $dbhandle;
global $OrderID;
global $CustomerID
16 matches
Mail list logo
