Php/Mysql problem - undiefined method mysql_connect()

2005-05-16 Thread CIKALA Frédéric ROSI/SIPROD
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

Re: PHP/MySQL Problem

2004-11-07 Thread Ligaya Turmelle
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.

PHP/MySQL Problem

2004-11-05 Thread Yahoo Default User
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

RE: PHP/MySQL Problem

2004-11-05 Thread Chris Blackwell
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 conjunction with PHP so

Re: PHP/MySQL Problem

2004-11-05 Thread Gleb Paharenko
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:

php mysql problem

2004-05-13 Thread Jianping Zhu
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

RE: php mysql problem

2004-05-13 Thread Mike Johnson
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

Re: PHP + MySQL problem (strange behavior)

2001-12-06 Thread mjriding
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

PHP + MySQL problem (strange behavior)

2001-12-05 Thread Javier Muniz
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

PHP/MySQL Problem

2001-10-30 Thread Matthew Walker
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

RE: PHP/MySQL Problem

2001-10-30 Thread Matthew Walker
] 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

RE: PHP/MySQL Problem

2001-10-30 Thread rc
: 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

RE: PHP/MySQL Problem

2001-10-30 Thread Don Read
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