Re: [PHP-DB] Error Checking

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 11:54 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - 1] What function(s) do you use for error checking? 2] What are the settings for the parameter(s) in the functions? 3] Do you have different php.ini files for development and production?

Re: [PHP-DB] ERROR W/ SQLSRV, PHP 5.4 SYMFONY!!!

2012-06-07 Thread Matijn Woudt
On Thu, Jun 7, 2012 at 7:42 AM, OJFR misabe...@infomed.sld.cu wrote: HI, Snip rude text OSAIN. Hi, You might want to read the PHP mailing list rules[1] and RFC 1855[2] before posting to this mailing list again. - Matijn [1] http://www.php.net/reST/php-src/trunk_README.MAILINGLIST_RULES

Re: [PHP-DB] error

2011-04-08 Thread Bastien
On 2011-04-08, at 1:57 AM, Karl DeSaulniers k...@designdrumm.com wrote: Ooops. Sry, forgot an escape. $q = UPDATE expiringleases SET Cricket_Region = '.mysql_real_escape_string($Cricket_Region).', Market = .mysql_real_escape_string($Market).' WHERE Search_Ring =

Re: [PHP-DB] error

2011-04-07 Thread Karl DeSaulniers
I believe this line should read.. ini_set('display_errors', 1); Just something I think I caught. Might not be your solution though. HTH, Karl On Apr 7, 2011, at 11:00 PM, Chris Stinemetz wrote: ini_set('display_errors', '1'); Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP

Re: [PHP-DB] error

2011-04-07 Thread Jim Giner
The two query statements are different - in one you quote $id and in the other you don't. It is definitely a mysql error so it's not the line you suggested. Karl DeSaulniers k...@designdrumm.com wrote in message news:6fe62364-f9fc-4612-8c5d-6ce48fc66...@designdrumm.com... I believe this line

Re: [PHP-DB] error

2011-04-07 Thread Chris Stinemetz
I am pretty sure it is in my code. I am just getting an error form one of my echoes. Still can't get it to work correctly though. Any help is greatly appreciated. Thank you, Chris ?php /* EDIT.PHP Allows user to edit specific entry in database */ // creates the edit record form // since

Re: [PHP-DB] error

2011-04-07 Thread Karl DeSaulniers
Hi Chris, I believe you only need to do a htmlspecialchars when displaying data as readable text that your retrieved from the database after inserting. And probably some other situations as well, but I don't think you need to do htmlspecialchars on the mysql_real_escape data when inserting

Re: [PHP-DB] error

2011-04-07 Thread Karl DeSaulniers
Hi Chris, Try this.. Or season to taste.. $q = UPDATE expiringleases SET Cricket_Region = '.mysql_real_escape_string($Cricket_Region).', Market = . $Market.' WHERE Search_Ring = '.mysql_real_escape_string($id).'; mysql_query($q) or die(mysql_error()); Best, Karl On Apr 8, 2011, at 12:13

Re: [PHP-DB] error

2011-04-07 Thread Karl DeSaulniers
Ooops. Sry, forgot an escape. $q = UPDATE expiringleases SET Cricket_Region = '.mysql_real_escape_string($Cricket_Region).', Market = .mysql_real_escape_string($Market).' WHERE Search_Ring = '.mysql_real_escape_string($id).'; mysql_query($q) or die(mysql_error()); Best, Karl On Apr

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

2011-03-01 Thread Richard Quadling
On 1 March 2011 10:25, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I have 2 simple php pages. One with the form just like some sales voucher. Another is to print in a proper format and to insert the form database into mysql. When I enter some data in the sales voucher everything

Re: [PHP-DB] error logging MySQL syntax errors?

2007-04-27 Thread Kevin Murphy
put: echo mysql_error(); right after the sql query. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Apr 27, 2007, at 10:15 AM, Tim McGeary wrote: I am getting semi-ambiguous messages in the browser like: You

RE: [PHP-DB] error logging MySQL syntax errors?

2007-04-27 Thread Dwight Altman
-Original Message- From: Kevin Murphy [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 12:49 PM To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Subject: Re: [PHP-DB] error logging MySQL syntax errors? put: echo mysql_error(); right after the sql query. -- Kevin Murphy

Re: [PHP-DB] error logging MySQL syntax errors?

2007-04-27 Thread bedul
plz remind to send to us your aplication.. the problem may cause from your sintax don't match the version - Original Message - From: Tim McGeary [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Saturday, April 28, 2007 12:15 AM Subject: [PHP-DB] error logging MySQL syntax errors? I am

Re: [PHP-DB] error creating tables

2007-03-03 Thread Haydar TUNA
Hello, I tried to run your SQL query with my private database and there wasn't any problem. You can use primary key like your PHP code because I run your SQL in the mysql command line succesfully. Did you connect root account to your mysql server? If the account is root, there isn't any

Re: [PHP-DB] Error when trying to connecting to an Oracle database

2006-09-26 Thread Tony Grimes
Hi Janet, This is a PHP 5 only function. Are you running PHP 5? If not, try using ocilogon() instead. If you are running 5, then maybe the Oracle library wasn't included when PHP was compiled. HTH, Tony On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote: I am trying to use a program

Re: [PHP-DB] Error when trying to connecting to an Oracle database

2006-09-26 Thread Tony Grimes
Hi Janet, This is a PHP 5 only function. Are you running PHP 5? If not, try using ocilogon() instead. If you are running 5, then maybe the Oracle library wasn't included when PHP was compiled. HTH, Tony On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote: I am trying to use a program

RE: [PHP-DB] Error testing MySQL

2005-06-28 Thread Bastien Koert
Error 0 means that there were no errors in the execution of the query. It does not mean that the query actually returned results that you expect. Bastien From: Michiel Jordens [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Error testing MySQL Date: Tue, 28 Jun 2005 10:23:55

Re: [PHP-DB] Error: Resource id #3

2005-05-14 Thread Firan Corneliu
The message that you receive is not an error, it is a description of the object $result after the query is done. So, you will not get anywhere just by echo $result, you have to process that information using one of the mysql_fetch_array(),mysql_fetch_assoc(), mysql_result(). In your case try :

RE: [PHP-DB] Error: Resource id #3

2005-05-14 Thread Marc Henri
Hello, Thank you very much to Bastien Koert and Firan Corneliu. You both solved my problem. Shame on me! _ Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos

Re: [PHP-DB] Error with Where Clause

2005-03-16 Thread Mark Cain
use backticks (read -- not single quotes, not double quotes, but backticks) to quote your fields such as where `1091vote038.state` = `109caucuses1.state` It is possible that the code is interpreting the 109 part of your table name as a integer. That just might do it. Mark Cain -

Re: [PHP-DB] error handling in query execution

2005-03-04 Thread Jochem Maas
Chenri wrote: i have a script that update records with this construct: while( ){ query_string='UPDATE ...'; updateRecord(query_string); } the problem is when there are wrong query_string (such as incorect syntax) can i make sure that the other query, the next one after the

RE: [PHP-DB] Error Help

2004-11-30 Thread Mike Johnson
From: Chris Payne [mailto:[EMAIL PROTECTED] I do have a final question, had a look online but couldn't find what I needed. It's hard to explain why, but basically individuals have my program on their HD, the DB is on their HD etc And it connects on startup to a remote server to

RE: [PHP-DB] error

2004-09-28 Thread Bastien Koert
try checking for the value if (isset($_POST[op] != addpost)) { or to supress the error, use the '@' symbol in fron of the $_POST or $_GET if (@$_POST[op] != addpost) { Bastien From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] error Date: Tue, 28 Sep 2004 06:58:10 EDT Dear friends,

Re: [PHP-DB] error

2004-09-28 Thread Janet Valade
[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 Notice: Undefined index: op in

[PHP-DB] Re:[PHP-DB] Error radio buttons

2004-09-18 Thread Yasuhiro Saito
?php $variable = $_POST['R'] ; --- if ($variable == 3) { echo Score 1; } else { echo Score 0; }; ? Original code didn't get radio check box's value. You can use $_POST[ ] . -- Yasuhiro Saito -- PHP Database Mailing List

Re: [PHP-DB] Error with addition of second

2004-09-18 Thread Mark
--- [EMAIL PROTECTED] wrote: Dear friends, With 4 radio buttons and php snippet, it gives desired output, however when I add second question in the html form and variable for the same like $variable =$_POST['q'] in Php snippet it gives me error. I have pasted php code when it works

Re: [PHP-DB] Error with addition of second

2004-09-18 Thread Cole S. Ashcraft
It doesn't like the }; On Sat, 2004-09-18 at 19:04, Mark wrote: --- [EMAIL PROTECTED] wrote: Dear friends, With 4 radio buttons and php snippet, it gives desired output, however when I add second question in the html form and variable for the same like $variable =$_POST['q'] in

Re: [PHP-DB] Error with addition of second

2004-09-18 Thread randy
echo Score 1; You'll get an error here too...missing quotes () On Sat, 18 Sep 2004 22:07:37 -0700, Cole S. Ashcraft [EMAIL PROTECTED] wrote: It doesn't like the }; On Sat, 2004-09-18 at 19:04, Mark wrote: --- [EMAIL PROTECTED] wrote: Dear friends, With 4 radio buttons

Re: [PHP-DB] error form check box and database

2004-09-08 Thread zareef ahmed
Hi, --- [EMAIL PROTECTED] wrote: Dear friends, Any guidance to the error , please. -- --- Warning: Unexpected character in input: '\' (ASCII=92) state=1 in C:\HOME\doctorbush\check.php on line 11 Parse

Re: [PHP-DB] error of check box form

2004-09-08 Thread John Holmes
[EMAIL PROTECTED] wrote: Any guidance to the error , please. Resubmitting, -- --- Warning: Unexpected character in input: '\' (ASCII=92) state=1 in C:\HOME\doctorbush\check.php on line 11 Parse error: parse error,

Re: [PHP-DB] error of check box form

2004-09-08 Thread Peter Ellis
In addition, please send your messages once and only once. I have two copies of the same e-mail, both sent to the list successfully with two different replies to both messages. You're more likely to get help if you post and wait for a reply to your original message. -- Peter Ellis - [EMAIL

Re: [PHP-DB] error on count()

2004-09-07 Thread Peter Ellis
You need to pass the functions a variable to work with because you've specified parameters. Try: $okuan = orderquantity($una); Ditto for the other function call. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue,

Re: [PHP-DB] error on count()

2004-09-07 Thread zareef ahmed
1. I tired to get the array like this: $una = $check[uname]; function orderquantity ($una) { $pss = mysql_query(SELECT OID FROM orders WHERE una = '.trim($una).') or die (mysql_error(Query error on Order search)); while($pisao=mysql_fetch_array($pss)) { return count($pisao);

Re: [PHP-DB] Error loading module: Unable to load dynamic library

2004-06-07 Thread Philippe
Thank you, that got me in the right direction. The OCI.DLL file on my system was an older version and dependency walker determined this. After that it was a simple matter of finding the right file version. Thanks! Christopher Jones wrote: Philippe wrote: Well, the exact message is: Unable to

Re: [PHP-DB] Error loading module: Unable to load dynamic library

2004-06-06 Thread Christopher Jones
Philippe wrote: Well, the exact message is: Unable to load dynamic library php_oci8.dll: The specified procedure could not be found If I remove the library the message becomes The specified module could not be found. It seems to be able to find the library (all the paths are correct) but it

Re: [PHP-DB] Error loading module: Unable to load dynamic library 'c:\tools\php\extensions\php_oci8.dll' - The specified procedure could not be found

2004-06-05 Thread Phlippe
Yes, and as I was writing earlier, the message talks about a missing procedure. If I remove the file temporarily, the message talks about a missing library. So I think it can find the file OK, but that this php_oci8.dll file is the wrong version or that it is looking for an additional DLL that

Re: [PHP-DB] Error loading module: Unable to load dynamic library 'c:\tools\php\extensions\php_oci8.dll' - The specified procedure could not be found

2004-06-04 Thread Christopher Jones
Philippe wrote: Hi, I am experiencing the message in the title of this message when starting or restarting Apache. I have the following configuration: - Windows XP - Apache 2.0.49 - PHP 4.3.6 - Oracle Client 8i If anyone has any information as to why this is happening and how I can solve it, I

Re: [PHP-DB] Error loading module: Unable to load dynamic library

2004-06-04 Thread Philippe
Thanks for your quick reply, Chris. My oracle 8i client setup does work on XP independently of PHP. I can connect to Oracle using PERL, ODBC, Java as well as a database management tool called Aqua Data Studio which uses native connections. Christopher Jones wrote: Philippe wrote: Hi, I am

Re: [PHP-DB] Error loading module: Unable to load dynamic library

2004-06-04 Thread Christopher Jones
The error sounds like an environment problem. Check phpinfo() to see what paths are being used - see the FAQ. Chris Philippe wrote: Thanks for your quick reply, Chris. My oracle 8i client setup does work on XP independently of PHP. I can connect to Oracle using PERL, ODBC, Java as well as a

Re: [PHP-DB] Error loading module: Unable to load dynamic library

2004-06-04 Thread Philippe
Well, the exact message is: Unable to load dynamic library php_oci8.dll: The specified procedure could not be found If I remove the library the message becomes The specified module could not be found. It seems to be able to find the library (all the paths are correct) but it seems that this

Re: [PHP-DB] Error loading module: Unable to load dynamic library 'c:\tools\php\extensions\php_oci8.dll' - The specified procedure could not be found

2004-06-04 Thread Daniel Clark
Is the file in c:\tools\php\extensions\php_oci8.dll ? Hi, I am experiencing the message in the title of this message when starting or restarting Apache. I have the following configuration: - Windows XP - Apache 2.0.49 - PHP 4.3.6 - Oracle Client 8i If anyone has any information as to why this

Re: [PHP-DB] Error settings

2003-10-21 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] How do I get rid of the undefined variable errors I get on a new (default) set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works on the internet on my host providers server but I am running this on localhost. I also get undefined offset

RE: [PHP-DB] Error settings

2003-10-21 Thread Dillon, John
From: Dillon, John [EMAIL PROTECTED] How do I get rid of the undefined variable errors I get on a new (default) set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works on the internet on my host providers server but I am running this on localhost. I also get undefined offset

Re: [PHP-DB] Error settings

2003-10-21 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] Hm. Adjusted error_reporting to none. Why would I still get: Forbidden You don't have permission to access /method=post on this server. -- -- Apache/1.3.28 Server at

RE: [PHP-DB] Error updating db when using a '

2003-08-21 Thread Hutchins, Richard
The only thing I see in your code that looks a bit odd are the parens around your sql statement. I'm not saying that they're causing the problem, just that I've not seen them used in that manner before. May I suggest that you echo out the $sql statement to the browser? Then copy and paste all of

RE: [PHP-DB] Error updating db when using a '

2003-08-21 Thread Aleks @ USA.net
Found the problem.. seems that spanning the sql statement with a carriage return messed something up. It works fine now.. Sorry about the return receipt earlier... won't happen again.. Thanks Aleks -Original Message- From: Aleks @ USA.net [mailto:[EMAIL PROTECTED] Sent: Thursday,

Re: [PHP-DB] Error notice

2003-07-12 Thread David Smith
You are referencing variables that you have not created (or perhaps array indexes that don't exist). To suppress these messages, fix your code to not do such things, or just put this at the top of your scripts: error_reporting( E_ALL ^ E_NOTICE ); Or edit php.ini to make it happen globally:

RE: [PHP-DB] error checking question

2003-06-27 Thread Ford, Mike [LSS]
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 20:22 What I would like to do is somehow have a redundant error check on the server side and then display an error message above the form on the main page should fields be left blank or

Re: [PHP-DB] error message print

2003-01-14 Thread Kent Roper
echo font color=red$message_new/font; Is that what you wanted? - Original Message - From: Addison Ellis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 5:01 PM Subject: [PHP-DB] error message print hello, how can i get an error message to print in the

Re: [PHP-DB] Error in retrieving a blob from oracle DB.

2002-11-28 Thread Naif M. Al-Otaibi
So, what can I do to retrieve a blob in oracle? Any one has a code for this. - Original Message - From: Mark [EMAIL PROTECTED] To: Naif Al-Otaibi [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 4:37 PM Subject: Re: [PHP-DB] Error in retrieving a blob from oracle DB. Load() does

Re: [PHP-DB] error messages to variables

2002-11-04 Thread Bob Lockie
Jason Wong wrote: On Monday 04 November 2002 12:10, Bob Lockie wrote: You can suppress the error message on failure by prepending a http://www.php.net/manual/en/language.operators.errorcontrol.php to the function name.. How can you get the error string into a local variable? Look at

Re: [PHP-DB] error messages to variables

2002-11-03 Thread Jason Wong
On Monday 04 November 2002 12:10, Bob Lockie wrote: You can suppress the error message on failure by prepending a http://www.php.net/manual/en/language.operators.errorcontrol.php to the function name.. How can you get the error string into a local variable? Look at the track_errors setting

RE: [PHP-DB] Error query : mysql_result

2002-10-10 Thread Snijders, Mark
would be nice if you would tell which line is 140 -Original Message- From: Burgess [mailto:[EMAIL PROTECTED]] Sent: donderdag 10 oktober 2002 11:14 To: [EMAIL PROTECTED] Subject: [PHP-DB] Error query : mysql_result Hi I have used the mysql_result function to return some specific

Re: [PHP-DB] Error query : mysql_result

2002-10-10 Thread Thomas Lamy
Burgess [mailto:[EMAIL PROTECTED]] wrote: Hi I have used the mysql_result function to return some specific information from database. The information is returned as it should but I keep getting this error message: Warning: Unable to jump to row 0 on MySQL result index 4 in

RE: [PHP-DB] Error query : mysql_result

2002-10-10 Thread John W. Holmes
This usually means your query failed. Check for errors using mysql_error(). ---John Holmes... -Original Message- From: Burgess [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Error query : mysql_result Hi I have used

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

2002-07-28 Thread Jason Wong
On Sunday 28 July 2002 15:24, JJ Harrison\\ wrote: In the mysql command line ; is used to signify the ending of the current query Yes, but executing MySQL queries through PHP requires that you leave out the ';' -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software

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

2002-07-27 Thread Cornelia Boenigk
Hi You have an error in your SQL syntax near '; ^ As far as I know MySQL doesn't require a trailing *;* at the end of the query. Regards Conni -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-07-27 Thread JJ Harrison
It turns out phpMyAdmin actually splits up the queries and does them singaly. -- JJ Harrison [EMAIL PROTECTED] www.tececo.com Cornelia Boenigk [EMAIL PROTECTED] wrote in message 00ef01c23580$2ed210c0$7f54fea9@zwerg98">news:00ef01c23580$2ed210c0$7f54fea9@zwerg98... Hi You have an error in

Re: [PHP-DB] Error? new set of eyes...

2002-05-28 Thread Ed Gorski
Why don't you try this instead: while(list($id, $2d, $3d, $web, $prog, $tut, $proj)=mysql_fetch_array($portfolio)) { do whatever.. } the list construct only works with numerical arrays and it might not like the $section array (doesn't it get stored as number indicies AND column

Re: [PHP-DB] Error? new set of eyes...

2002-05-28 Thread Jason Wong
On Tuesday 28 May 2002 21:15, Jas wrote: Hello all, I have an error and I will be darned if I know why. Here is the code: ?php require '/path/to/database/connection/class/db.php'; $table = portfolio; $portfolio = mysql_query(SELECT * FROM $table,$dbh); while ($sections =

Re: [PHP-DB] error

2002-05-07 Thread Maureen
One thing I noticed quickly. You have too many opening ( on the line that says: while (($row = mysql_fetch_array($result, MYSQL_ASSOC)) 3 opening and 2 closing. This would cause a parse error. Without knowing which line is line 11, it is hard to say if there is anything else.

Re: [PHP-DB] Error creating new table

2002-04-08 Thread Remco Oosten
I don't think you can use text(50), It should be one of the following tinytext, mediumtext or text Or you should use char(50). I would try to avoid using varchar() it fragments the database. Remco - Original Message - From: Lisi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday,

Re: [PHP-DB] Error creating new table

2002-04-08 Thread Lisi
Worked like a charm, thanks. How do I avoid varchar if I the size of the text will vary with each entry? It's going to be a pretty small database anyway so I'm not that worried, but how often do I optimize the table to avoid fragmentation? -Lisi At 10:29 AM 4/8/02 +0200, you wrote: I don't

Re: [PHP-DB] Error creating new table

2002-04-08 Thread Remco Oosten
AM Subject: Re: [PHP-DB] Error creating new table Worked like a charm, thanks. How do I avoid varchar if I the size of the text will vary with each entry? It's going to be a pretty small database anyway so I'm not that worried, but how often do I optimize the table to avoid fragmentation

RE: [PHP-DB] Error insert into MS-access through ODBC not aviable

2002-02-13 Thread Andrew Hill
Penockio, You might find this helpful: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168 Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From:

Re: [PHP-DB] Error help needed

2001-12-07 Thread Dario Fernando Escobar R.
I suggest to get the new version of phpMyAdmin. I downloaded it few days ago and I don't have any problem. bye. _ Dario Fernando Escobar Risueño Webmaster Telesat S.A. [EMAIL PROTECTED] Cali - Valle - Colombia - Original Message - From: Chris Payne

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

2001-09-25 Thread Jason Wong
-Original Message- From: Jae [mailto:[EMAIL PROTECTED]] Sent: 26 September 2001 12:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Error on connecting to mysql database I got this message when i call the php script, Fatal error: Call to undefined function: mysql_connect() in

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

2001-09-25 Thread Jae
thx a lot Jason Wong [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó 01c14646$74b41ae0$[EMAIL PROTECTED]">news:01c14646$74b41ae0$[EMAIL PROTECTED]... -Original Message- From: Jae [mailto:[EMAIL PROTECTED]] Sent: 26 September 2001 12:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Error on connecting

Re: [PHP-DB] Error making php with informix

2001-08-29 Thread Paul Gardiner
Hello again, What version of Informix are you now running? Last time we spoke you were only on 5. AFAIK you need at least ver 7 In the current version(4.0.6) of PHP the Informix libraries must be specified in LIBS when compiling Apache. Jani has hopefully fixed this problem for 4.0.7. Have a

RE: [PHP-DB] Error in SQL syntax

2001-08-28 Thread Rick Emery
Have you tried typing this SELECT statement directly into MySQL? If not, try it; MySQL may indicate a more precise error. rick -Original Message- From: Alex V.Varavva [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 1:03 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Error in SQL

Re: Re: [PHP-DB] Error with in_use() from Beginning PHP4 book.

2001-08-26 Thread John Lim
See http://php.weblogs.com/adodb_csv You create a proxy on Windows server and query access via the Windows server. Vijay Anand [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... how to access MS Access database using adodb in unix -- PHP Database Mailing

Re: Re: [PHP-DB] Error with in_use() from Beginning PHP4 book.

2001-08-25 Thread Vijay Anand
how to access MS Access database using adodb in unix -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] error on post

2001-08-14 Thread Renze Munnik
On Mon, Aug 13, 2001 at 03:38:50PM -0700, John Telesh wrote: I have created a form which I cannot duplicate the error which is coming up only sometimes. An affiliate to my client had received emails regarding the following error: The requested method POST is not allowed for the

RE: [PHP-DB] Error checking and escaping before running a query (MySQL)

2001-08-08 Thread Beau Lebens
Dave, sounds like you are on the right track, but rather than use the comparatively bulky regular expression engine, why not just the light-weight string function str_replace( ,, , $searchbox ); (see String Functions in the manual) and you should be able to do str_replace( \, , $searchbox

RE: [PHP-DB] Error checking and escaping before running a query (MySQL)

2001-08-08 Thread Dave Watkinson
) Subject: RE: [PHP-DB] Error checking and escaping before running a query (MySQL) Dave, sounds like you are on the right track, but rather than use the comparatively bulky regular expression engine, why not just the light-weight string function str_replace( ,, , $searchbox ); (see String

Re: [PHP-DB] Error 127

2001-07-19 Thread John Pickett
Cami, Here's what I found on the error and what to do about it: http://www.mysql.com/doc/R/e/Repair.html Hope that helps! My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist - Original Message -

RE: [PHP-DB] Error 127

2001-07-19 Thread Cami
Thanks everybody for pointing me to the right place. I manage to recover it. Thank God. Cami -Original Message- From: Cami [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Error 127 Hi everybody, All of the sudden I got an error

Re: [PHP-DB] Error 127

2001-07-19 Thread Steve Brett
you know i did this last week and can't remember the functions is used. i had exactly the same problem but had to dump the records as plain text files. i used get_html_translation_table . if you look at the example in the compiled html help file for php there is a section of code that uses this

RE: [PHP-DB] error ORA-12699

2001-06-29 Thread Anthony Carlos
, address, and sid. In other words, ORCL is shorthand notation for all of the TCP/IP info and then some. I hope this makes sense, Anthony -Original Message- From: sang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] error ORA

Re: [PHP-DB] error ORA-12699

2001-06-27 Thread Anthony Carlos
Sang, Since you're trying to connect from another computer to the Oracle server, you probably need to specify a connect string in the OCILogon command. OCILogon('system', 'manager', $connect_string); What's the value for $connect_string? It depends on how you've set-up your Oracle networking.

Re: [PHP-DB] error ORA-12699

2001-06-27 Thread sang
I have read some doc. $connect_string is set to equal from tnsnames.ora. $connect_string=(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = ORCL))); I can connect my local oracle server before when using OCILogon(system,manager); But now , i

Re: [PHP-DB] error

2001-05-23 Thread Johannes Janson
Hi, Warning: MySQL Connection Failed: Unknown MySQL Server Host '0f2scom' (2) in /web/sites/139/gamie/www.game-boy-advance.f2s.com/addartikel.php on line 22 Unable toconnect to database [...snip...] mysql_connect(db.game-boy-advance.f2s.com,*,**) or die(Unable toconnect to

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Robert Hennig
Hi Paul, thanks for your fast reply. Maybe you could help me again :-) We are working a lot with informix, so we thought to know every Programm, but isql is completely unknown. Is this a special programm? We have executed this select with a sql-editor on the server also as with dbaccess, on

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Paul Gardiner
, 2001 3:40 PM Subject: Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux Hi Paul, thanks for your fast reply. Maybe you could help me again :-) We are working a lot with informix, so we thought to know every Programm, but isql is completely

Re: [PHP-DB] Error Msg: Wrong data type when performing extract()

2001-04-19 Thread Shahmat Dahlan
You're right, no row was returned by the query when i did tried to fetch it. So I suppose the next viable thing to do is to figure what went wrong with the query. Thanks CC Zona wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Shahmat Dahlan") wrote:

Re: [PHP-DB] Error Msg: Wrong data type when performing extract()

2001-04-19 Thread Russ Michell
Hmmm not sure - You could try to strip out much of the sql by simply using: $sqlstmt ="SELECT * FROM stock_in, equip, vendor"; $sqlstmt.="WHERE equip.id=equip_id and vendor.id=vendor_id and equip.id='$id'"; $sqlstmt.="ORDER BY equip.id ASC"; # print $sqlstmt; $result=mysql_query($sqlstmt); #

Re: [PHP-DB] Error Msg: Wrong data type when performing extract()

2001-04-18 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Shahmat Dahlan") wrote: $result=mysql_query($sqlstmt); # print $result; $row=mysql_fetch_array($result) extract($row); If I do the above, I get the results below: Warning: Wrong datatype in call to extract() in

Re: [PHP-DB] Error messge regarding session variables

2001-04-17 Thread Johannes Janson
Hi, cookies are sent as header information. This means you can't send any output (html-tag, whitespaces before ?php) at all before sending cookie/header information. As your error message tells you the output already started in line 4. Move the cookie-part from line 6 to the beginning and it

Re: [PHP-DB] error code = -504 Cursor unknow

2001-04-06 Thread Mauricio Junqueira
Mauricio Junqueira wrote: Mauricio Junqueira wrote: Hello, this is my first attempt to query and print a result coming from a database, in this case interbase6. I got the following error: InterBase: Dynamic SQL Error SQL error code = -504 Cursor unknown in maingeral.htm on line 8

Re: [PHP-DB] Error in non existing line

2001-04-06 Thread kuk
Hello, Dan You did not close { } statement. DG Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90 DG And I have just 89 lines DG Here are the last linse from index.html: DG ?php DG if ($verify ==7){ DG $connection = mysql_connect("localhost", "user", "password") DG

Re: [PHP-DB] Error in non existing line

2001-04-06 Thread Julio Cuz, Jr.
Dan, I think you're missing the end quotes (") here: ... where image='$arr_Images[$randID]' " ; ... At 10:57 PM 4/6/2001 +0300, Dan Guja wrote: Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90 And I have just 89 lines Here are the last linse from

Re: [PHP-DB] error code = -504 Cursor unknow

2001-03-27 Thread Mauricio Junqueira
Mauricio Junqueira wrote: Hello, this is my first attempt to query and print a result coming from a database, in this case interbase6. I got the following error: InterBase: Dynamic SQL Error SQL error code = -504 Cursor unknown in maingeral.htm on line 8 Here's the code: ?

Re: [PHP-DB] error code = -504 Cursor unknow

2001-03-27 Thread Mauricio Junqueira
If just comment the following lines, everything works Please help... I'm getting nut !! ? include("php/header.php"); ibase_pconnect(BANCO,DBUSER,DBPASSWD) or die ("script language='javaScript' alert('" . ibase_errmsg() . "'); /script"); $stmt = "select count(*) from

Re: [PHP-DB] Error Control

2001-03-26 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Jason Bell") wrote: Hello! I'm writing a script that validates a form It creates users in a mysql table, where there are 2 unique columns 'username' and 'email'. I'm putting mysql_error() into a variable, but I don't want the end user

Re: [PHP-DB] error and general problems

2001-03-26 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Liz Bander) wrote: I am getting a parse error for the return line every time I try and view the page. Can anyone tell me why? The code is below. $results = "select req, source, number from orders where req=" . $GLOBALS["req"] . ",

RE: [PHP-DB] Error prevention

2001-03-13 Thread Michael Rudel
Hi Martin, ... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in the PHP-Manual in the MySQL Functions. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20

RE: [PHP-DB] Error prevention

2001-03-13 Thread Martin Skjöldebrand
Michael Rudel wrote: Hi Martin, ... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in the PHP-Manual in the MySQL Functions. Thanks Mike (and everyone else who pointed this out), Sometimes you're blind. When you think you pass the "complete-and-utter-newbie" phase

Re: [PHP-DB] Error in accessing the database through MySQL

2001-01-30 Thread phobo
Why are you using php3.0.17? That is atleast 6 months old! You have downloaded a version of PHP which doesn't have MySQL functions built in. Beacuse you are using the Win32 version, you should just use PHP4 (the latest version), which WILL have MySQL functions built in. Go to