Re: [PHP-DB] Error Checking

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 11:54 AM, Ethan Rosenberg, PhD 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? This makes more sense answer

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 wrote: > HI, > > 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 [2] http://www.faqs.org/rfcs/rfc1855

Re: [PHP-DB] error

2011-04-08 Thread Bastien
On 2011-04-08, at 1:57 AM, Karl DeSaulniers 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 = > '".mysql_real_escape_strin

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 O

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

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 into

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 http://www.w3.org/TR/html4/strict.dtd";> Edit Record '.$error.''; } ?> ID: First Name: * L

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" wrote in message news:6fe62364-f9fc-4612-8c5d-6ce48fc66...@designdrumm.com... >I believe this line should read.. > >

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 D

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

2011-03-01 Thread Richard Quadling
On 1 March 2011 10:25, nagendra prasad 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 is going well, > howe

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

2007-04-29 Thread Chris
bedul wrote: plz remind to send to us your aplication.. the problem may cause from your sintax don't match the version No - *don't* send us your application. Only send us the relevant lines from the script if you can't work it out. -- Postgresql & php tutorials http://www.designmagick.com/ -

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: Sent: Saturday, April 28, 2007 12:15 AM Subject: [PHP-DB] error logging MySQL syntax errors? > I am getting semi-ambi

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

2007-04-27 Thread Dwight Altman
wight > -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_erro

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 h

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 creating tables

2007-02-28 Thread Frank Flynn
Good rule - to debug try to run the same command on the command line of the terminal tool, you'll get better errors. But I suspect you have not said what the PRIMARY KEY is - typically you would say: PRIMARY KEY(f_name, l_name) or perhaps account whatever, it should be unique. Good Luck, Fr

RE: [PHP-DB] error creating tables

2007-02-27 Thread Bastien Koert
check your permissions for the user, perhaps the create table permission is missing or the permissions need to be flushed to take effect bastien From: aconite <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] error creating tables Date: Tue, 27 Feb 2007 03:58:23 -0800 (PST) im

Re: [PHP-DB] Error for registration mail.

2007-01-09 Thread niel
Hi You have two functions between the if and else, the syntax you've used only allows one. Use braces. if(mysql_query($sql)) { mail ($email, "Thank you for registering!", $body, "From: [EMAIL PROTECTED]"); header("Location: thankYou.php"); } else { die("Error! Could not insert values".m

Re: [PHP-DB] Error for registration mail.

2007-01-07 Thread Niel Archer
Hi You have two functions between the if and else, the syntax you've used only allows one. Use braces. if(mysql_query($sql)) { mail ($email, "Thank you for registering!", $body, "From: [EMAIL PROTECTED]"); header("Location: thankYou.php"); } else { die("Error! Could not insert values".m

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 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 mails

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

2005-05-14 Thread Bastien Koert
Actually, that is exactly what you are doing. $result is the handle to the dataset, not the dataset itself. Try this: //log to the server $db=mysql_connect("localhost","root",""); if ($db) { //test if the connexion works $sel=mysql_select_db("test"); if ($sel) { $sql_query="SELEC

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 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 - Origin

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 wrong

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 c

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 \\premfs15\sites\p

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 frie

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, > > > > > > Wi

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 =$_PO

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 i

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

2004-09-18 Thread Yasuhiro Saito
Original code didn't get radio check box's value. You can use $_POST[ ] . -- Yasuhiro Saito -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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 PROTE

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, unexpec

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 > >

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)) { > > re

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, 2004-09-0

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 lo

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 Daniel Clark
Another person had the same problem, found this. http://forums.devshed.com/archive/t-23692 They suggested: Try setting the extension dir to C:/WINNT/SYSTEM or where your dll-files resides >>Yes, and as I was writing earlier, the message talks about a missing >>procedure. If I remove the

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 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 informat

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

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 data

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 expe

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 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

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

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

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, August

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 t

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

Re: [PHP-DB] error message print

2003-01-14 Thread Kent Roper
echo "$message_new"; 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 color red as

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

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 @ to the function name.". How can you get the error string into a local variable? Look a

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 @ > to > the function name.". > How can you get the error string into a local variable? Look at the "track_errors"

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 h

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 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 info

RE: [PHP-DB] Error: ./configure --with-pgsql

2002-07-31 Thread Pritschow, Christian
hi ... you need to install flex http://www.sunfreeware.com/programlistsparc9.html regards ChrisPr > -Original Message- > From: Jan Feller [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 08:36 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Error: ./configure --with-pgsq

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 Softwa

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

2002-07-27 Thread JJ Harrison\\
In the mysql command line ; is used to signify the ending of the current query "Jj Harrison" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > It turns out phpMyAdmin actually splits up the queries and does them > singaly. > > > -- > JJ Harrison > [EMAIL PROTECTED

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 err

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? 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: > require '/path/to/database/connection/class/db.php'; > $table = "portfolio"; > $portfolio = @mysql_query("SELECT * FROM $table",$dbh); > while ($sections = mysql_fe

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 names?

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. HTH

Re: [PHP-DB] Error creating new table

2002-04-10 Thread Michael Andersson
Newbie question that maybe should belong in a mysql group, but how and why does a varchar fragment a dbase? //Micke "Remco Oosten" <[EMAIL PROTECTED]> skrev i meddelandet 003c01c1ded7$72877760$[EMAIL PROTECTED]">news:003c01c1ded7$72877760$[EMAIL PROTECTED]... > I don't think you can use text(50),

Re: [PHP-DB] Error creating new table

2002-04-08 Thread Russell Griechen
>You can't have NOT NULL assigned to a text field. So...should it be maintext text NULL, or just maintext text ??? Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Error creating new table

2002-04-08 Thread Alex Behrens
Q: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "George Pitcher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Lisi" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 3:13 A

RE: [PHP-DB] Error creating new table

2002-04-08 Thread Rick Emery
The problem is that he assigned a length to a TEXT field. You cannot do that. -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:13 AM To: [EMAIL PROTECTED]; Lisi Subject: Re: [PHP-DB] Error creating new table You can't have NOT

Re: [PHP-DB] Error creating new table

2002-04-08 Thread George Pitcher
You can't have NOT NULL assigned to a text field. george - Original Message - From: "Lisi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 10:11 AM Subject: [PHP-DB] Error creating new table > I am trying to create the following table using PHPMyAdmin: > > CRE

Re: [PHP-DB] Error creating new table

2002-04-08 Thread Remco Oosten
"PHP-DB" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 11:33 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 s

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 t

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: Mond

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 help needed

2001-12-07 Thread Andrey Hristov
find the section where error_reporting is set in php.ini and set i to 0 This is not an error but an warning (E_WARNING). Regards, Andrey Hristov - Original Message - From: "Chris Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 11:28 PM Subject: [PHP-DB]

Re: [PHP-DB] Error help needed

2001-12-07 Thread Bruno Gimenes Pereti
it looks like the command mysql_db_query() is not used any more. Try to use mysql_select_db() and mysql_query() instead: $conn = mysql_connect($host, $user, $password); mysql_select_db($db, $conn); $result = mysql_query($sql); [...] close($conn); Hope it helps... Bruno. - Original Message -

Re: [PHP-DB] Error help needed

2001-12-07 Thread Jason Wong
On Saturday 08 December 2001 05:28, Chris Payne wrote: > Hi there everyone, > > I've just reinstalled Windows 2000 for the second time, and I am still > getting errors when I try to read MySQL databases - especially from within > Myadmin (But also through other code I have written myself). > > I'm

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

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 >/hom

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 lo

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 sy

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 Mailin

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 with in_use() from Beginning PHP4 book.

2001-08-25 Thread Paul Burney
on 8/25/01 12:11 PM, sam at [EMAIL PROTECTED] wrote: > > > Hi Wrox guys and all, > > Can anyone help me out on this?? > > I've been using this code for quite some time now. I got it from the > "Beginning PHP4 by Choi, Kent, Lea, Prasad, and Ullman". All those times, I > don't get any errors U

Re: [PHP-DB] error on post

2001-08-13 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 URL/in

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

2001-08-08 Thread Dave Watkinson
DB List (E-mail) 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( ",", "

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( "\"", " ", $

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 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 o

Re: [PHP-DB] Error 127

2001-07-19 Thread John Pickett
Howdy ;-) I have a problem when trying to display data in HTML from a MySQL query. Here's what happens: 1) I convert the text entered using htmlentities (). I then insert it into the database table. If I do a query from a terminal on the data it looks fine. 2) When I do a select query on th

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 ORA-12699

2001-06-29 Thread Anthony Carlos
to resolve it into a protocol, 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

Re: [PHP-DB] error ORA-12699

2001-06-28 Thread Wayne Bastow
Try using $connect_string="ORCL"; Wayne sang wrote: > > 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 o

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 ,

  1   2   >