[PHP-DB] Re: Error fetching a second row from a result set (mysql)

2014-11-14 Thread Jim Giner
On 11/14/2014 1:46 PM, Mark Murphy wrote: Problem is that for the resource, the type is changed to Unknown by a different mysql_query within the loop. Any idea what will cause this? Maybe show us the whole code so we can see what you are telling us? -- PHP Database Mailing List (http://www.ph

[PHP-DB] Re: Error while inserting data into mysql

2011-03-01 Thread nagendra prasad
Hi All, I have attached the table structure and the PHP code. Best, Guru. ===Database dream == Table structure for table dream |-- |Field|Type|Null|Default |-- |mwool40|varchar(100)|Yes|NULL |gwool25|varchar(100)|Yes|NULL |wmesh24|varchar(100)|Yes|NULL |shkote30|varchar(100)|Yes|NULL |s

Re: [PHP-DB] Re: Error

2007-06-26 Thread Roberto Mansfield
ith binding parameter to oracle procedures in php. > If I remove the binding the procedure works. If I add it it fails. > > Any ideas > > David > > -Original Message- > From: Roberto Mansfield [mailto:[EMAIL PROTECTED] > Sent: 26 June 2007 16:09 > To: php-db@

RE: [PHP-DB] Re: Error

2007-06-26 Thread David Skyers
I believe it is a problem with binding parameter to oracle procedures in php. If I remove the binding the procedure works. If I add it it fails. Any ideas David -Original Message- From: Roberto Mansfield [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 16:09 To: php-db@lists.php.net Subject:

[PHP-DB] Re: Error

2007-06-26 Thread Roberto Mansfield
This could be a problem with your ORACLE_HOME and/or NLS_LANG environment variables. These need to be set for your user account running the web server BEFORE the web server is started. Don't try to set these in your php script or you'll get strange results. David Skyers wrote: > Hi > > I have a p

[PHP-DB] RE: error

2004-09-28 Thread JeRRy
Suggestion, please note out where "line 9" is exactly. Some mail clients will use wordwrap and some not so the lines may not be the same on "every" mail client so "line 9" could be more like "line 14" on some and "line 9" on others. Just "//comment" where "line 9" is so we know and can answer you

[PHP-DB] Re: error

2004-09-28 Thread David Robley
On Tue, 28 Sep 2004 20:28, [EMAIL PROTECTED] wrote: > Dear friends, > > Script writes to database, however gives this error while on internet web > server, on local host doesn't give same error. > > Any guidance, please > > Thank you > - > Back to Main >

[PHP-DB] RE: Error settings

2003-10-22 Thread Dillon, John
Thanks to those who helped on this. It helped to re-start the server. But the other problem I found out was that register_globals was turned off by default, so variables passed, as for instance ?ID=3 in the URL, were not recognised. I turned register_globals on in the Apache config file: php_fla

[PHP-DB] Re: Error is SQL(works in phpMyAdmin)

2002-07-27 Thread JJ Harrison
Here is one line of my new query: INSERT INTO article_keyword (aid,keyword,weight) VALUES (3, 'gases', 13.42282); I get the same error: You have an error in your SQL syntax near '; INSERT INTO article_keyword (aid,keyword,weight) VALUES (3, 'gases', 13.42282)' at line 1 -- JJ Harrison [EMAIL P

Re: [PHP-DB] Re: Error Loading File <-- Sort of Fixed

2002-06-13 Thread Bryan Gintz
Ok, if anyone else is having the same trouble with PHP 4.2.1, David Robley's suggestion (Thank you David!) works. I am not to proud to have missed the obvious :) If you are having trouble loading files (LOAD INFILE...) with PHP into MySQL, just do a chmod($file, 0777), and it works. Not sure

Re: [PHP-DB] Re: Error Loading File

2002-06-12 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Whoops :), > Yes, this is using phpMyAdmin, trying to use the "Insert data from a > textfile into table" function, which uploads a file and the attempts to > LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when > upg

Re: [PHP-DB] Re: Error Loading File

2002-06-12 Thread Bryan Gintz
Whoops :), Yes, this is using phpMyAdmin, trying to use the "Insert data from a textfile into table" function, which uploads a file and the attempts to LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when upgraded to PHP 4.2.1, it gave the error : "The file '/tmp/phpr4WYQY'

[PHP-DB] Re: Error Loading File

2002-06-11 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > I am getting this error with a new install of PHP4.2.1 and Zend > Optimizer 1.3.1: > > The file '/tmp/phpr4WYQY' must be in the database directory or be > readable by all > > I just updated PHP and the Zend Optimizer, and it had worke

Re: [PHP-DB] Re: Error creating new table

2002-04-08 Thread Lisi
For the record, the problem was assigning a length to a text field. The NOT NULL part is fine. Thanks everyone for your input! -Lisi At 04:59 PM 4/8/02 -0700, Jennifer Downey wrote: >I to have about 16 text fields in my db that are NOT NULL and they work >fine. >Just an observation. > >Jenni

[PHP-DB] Re: Error creating new table

2002-04-08 Thread Jennifer Downey
I to have about 16 text fields in my db that are NOT NULL and they work fine. Just an observation. Jennifer "Lisi" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am trying to create the following table using PHPMyAdmin: > > CREATE TABLE IF NOT EXISTS ayny(

[PHP-DB] Re: Error: No such file or directory

2001-11-01 Thread Greg Robinson
Ok, solution seems to be eliminating comments in the script. When comments are removed, script errors also disappear. "Greg Robinson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hmm, > Seems if I execute ./configure (with arguments) from termial (shell pro

[PHP-DB] Re: Error: No such file or directory

2001-11-01 Thread Greg Robinson
Hmm, Seems if I execute ./configure (with arguments) from termial (shell prompt) no error. But when executed from shell script there is an error. Does this make sense? "Greg Robinson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Executing from a script file

[PHP-DB] Re: Error on connecting to mysql database

2001-09-26 Thread Jae
After recompile, the error still occurs. pls help "Jae" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I got this message when i call the php script, > > "Fatal error: Call to undefined function: mysql_connect() in > /home/jaelee/public_html/test01.php on line 6" >

[PHP-DB] Re: Error 127

2001-07-19 Thread Steve Brett
the only time i've had this (not sure if it was 127) but i couldn't get the properties etc was after i named a table with a name that was a keyword. check the list in the docs as the list is quite long. i called mine 'returns' doh! Steve "Cami" <[EMAIL PROTECTED]> wrote in message [EMAIL PROT