Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I wish to accomplish the following with prepared statements: $stmt = mysqli_stmt_init($cxn); if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site, MedRec, Fname, Lname,

Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Ethan Rosenberg, PhD
Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 09/02/2012 08:33 AM, Matijn Woudt wrote: On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Ethan Rosenberg, PhD
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I wish to accomplish the following with prepared statements: $stmt = mysqli_stmt_init($cxn); if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site, MedRec, Fname, Lname,

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I wish to accomplish the following with prepared statements: $stmt =

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread kesavan trichy rengarajan
Remove the quotes around the variables in all your statements. For example, this statement: mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin', sha1('$password'), '$email'); could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin, sha1($password), $email);

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
That worked, thanks! Remove the quotes around the variables in all your statements. For example, this statement: mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin', sha1('$password'), '$email'); could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows,

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Christopher Jones
kesavan trichy rengarajan wrote: could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin, sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be passed by reference This is also true in earlier

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Done. Thanks for letting me know about that. kesavan trichy rengarajan wrote: could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin, sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Bilal Ahmad
Hi i wanna ask a question. I am trying to create an image on fly, please do help me , following is the code. *File Name : Font.php Code: * html head titleImage Creation/title script language=javascript var xmlhttp; function showPic() { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) {

Re: [PHP-DB] MySQL update statement problem

2006-03-04 Thread Chris
You need to separate the SET arguments with commas, not ANDs... It's really doing something like this: UPDATE shop_customer SET eu_vat_number = (SK1234567890 AND vat_amount = 0 AND total_amount = 8.4925) WHERE customer_id = 7 AND hash=dcd5e751 (SK1234567890 AND vat_amount = 0 AND total_amount =

RE: [PHP-DB] MySQL update statement problem

2006-03-04 Thread Kevin Davies - Bonhurst Consulting
Message- From: Jenaro Centeno Gómez [mailto:[EMAIL PROTECTED] Sent: 04 March 2006 17:35 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL update statement problem Maybe I am wrong, biut isn´this the rigth way to do this: UPDATE shop_customer SET eu_vat_number = SK1234567890, vat_amount = 0

RE: [PHP-DB] MySQL in PHP5 - problem with charset

2005-09-11 Thread Bastien Koert
does your web server, php and db all use the same charset? they all should match From: Dominik Fi¹er [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] MySQL in PHP5 - problem with charset Date: Sun, 11 Sep 2005 14:35:44 +0200 I have problem with MySQL in PHP 5.0.4 (WIN XP). I

Re: [PHP-DB] MySQL in PHP5 - problem with charset

2005-09-11 Thread Dominik Fi�er
I think yes. PHP default_charset = win-1250, mysql: def. char. set cp1250, apahce 2: AddDefaultCharset WINDOWS-1250 (AddCharset WINDOWS-1250 .cp-1250 .win-1250) With php4 with same configuration apache2 and mysql server is all OK. Bastien Koert [EMAIL PROTECTED] pí¹e v diskusním pøíspìvku

Re: [PHP-DB] load data infile -- problem

2005-08-18 Thread Miles Thompson
I could be 100% wrong on this, but I do not think that a command line statement can be executed through mysql_query() - try exec(). If I remember correctly mysql load data infile ... is not executed from within mysql, but at the command line. (Hint: look at the source for phpMyAdmin and copy

Re: [PHP-DB] load data infile -- problem

2005-08-18 Thread dpgirago
You can definitely do a load file from within the mysql client, so I'd guess you can do it through mysql_query, too. I'm wondering about the semi-colon within the query. Maybe it needs to be escaped, too. David I could be 100% wrong on this, but I do not think that a command line statement

Re: [PHP-DB] load data infile -- problem

2005-08-18 Thread Bastien Koert
where you open the file and read it in, parsing thru it to access the data elements and running sql statements thru a loop Bastien From: [EMAIL PROTECTED] To: Miles Thompson [EMAIL PROTECTED] CC: php-db-list php-db@lists.php.net Subject: Re: [PHP-DB] load data infile -- problem Date: Thu, 18

Re: [PHP-DB] Newbie with mail problem

2005-06-07 Thread Andrés G . Montañez
Use a real hostname, not 'localhost'.- -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Newbie with mail problem

2005-06-07 Thread Wings
Andrés G. Montañez [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Use a real hostname, not 'localhost'.- Will give that a try. Thank you. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] strtotime: Last Month problem

2005-03-30 Thread Bastien Koert
try the mktime function bastien From: Shay [EMAIL PROTECTED] Reply-To: Shay [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] strtotime: Last Month problem Date: Wed, 30 Mar 2005 15:02:27 -0700 Hi, I'm trying to use strtotime(last month), strtotime(-1 month), or strtotime(1 month ago)

Re: [PHP-DB] is this a problem ?

2004-12-28 Thread John Hicks
amol patil wrote: hallo, i have changed file signup1.php with login1.php, in action fied of form form name=form1 method=POST action=-- and saved . but when i run this file and click on submit button, it still shows old sighnup1.php. and data is also not entering in database. while it

Re: [PHP-DB] is this a problem ?

2004-12-28 Thread Miles Thompson
There are scores of examples / tutorials on this. Google turned up 6,070 hits on this expression: add user php mysql example Here's one of them, although it assumes register globals is on http://www.php-scripts.com/php_diary/072000.php3 Why don't you pick one, work with it and

Re: [PHP-DB] is this a problem ?

2004-12-28 Thread Peter Jay Salzman
On Tue 28 Dec 04, 11:44 AM, Miles Thompson [EMAIL PROTECTED] said: At 09:25 AM 12/28/2004, amol patil wrote: hallo, i have changed file signup1.php with login1.php, in action fied of form form name=form1 method=POST action=-- and saved . but when i run this file

RE: [PHP-DB] Multi-User Update Problem

2004-12-01 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 30 November 2004 14:45, SCALES, Andrew wrote: Thanks very much for your help. The main difficulty I was having really was unlocking the record again if the user crashed out

RE: [PHP-DB] Multi-User Update Problem

2004-11-30 Thread SCALES, Andrew
though. Andy -Original Message- From: Norland, Martin [mailto:[EMAIL PROTECTED] Sent: Monday, 29 November 2004 15:36 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Multi-User Update Problem -Original Message- Does anyone know a good way of locking out access to a record on a MySQL

RE: [PHP-DB] Multi-User Update Problem

2004-11-30 Thread SCALES, Andrew
try that. Thank you both for the advice, Andy -Original Message- From: Gryffyn, Trevor [mailto:[EMAIL PROTECTED] Sent: Monday, 29 November 2004 15:44 To: [EMAIL PROTECTED] Cc: Bastien Koert; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Multi-User Update Problem Yeah, all good thoughts

RE: [PHP-DB] Multi-User Update Problem

2004-11-30 Thread Gryffyn, Trevor
have issues. :) Good luck! -TG -Original Message- From: SCALES, Andrew [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 9:45 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Multi-User Update Problem Thanks very much for your help. The main difficulty I was having

RE: [PHP-DB] Multi-User Update Problem

2004-11-29 Thread Bastien Koert
Its a tough one. My personal fav is to mark the record as locked by changing a field called 'locked' from 0 to 1. Check for this when extracting the record and if is present, alert the user this record is locked (if you want to get fancy you could even track who locked it and the tell the user

RE: [PHP-DB] Multi-User Update Problem

2004-11-29 Thread Norland, Martin
-Original Message- Does anyone know a good way of locking out access to a record on a MySQL database when someone has the update page open? The problem is that we have a local intranet site which is accessed by members of different departments. Now at the moment when someone loads the

RE: [PHP-DB] Multi-User Update Problem

2004-11-29 Thread Gryffyn, Trevor
-Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Monday, November 29, 2004 10:22 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Multi-User Update Problem Its a tough one. My personal fav is to mark the record as locked by changing

Re: [PHP-DB] MSSQL INSERT query problem

2004-08-05 Thread John Holmes
Chris wrote: Here is the code I use: [snip] $sql = $db-prepare(INSERT INTO ExitSurveyAnswers (session_id, Question_id, answer) VALUES ?,?,?); [snip] When I execute it I keep recieving and error message stating: DB Error: syntax error Not a MSSQL expert, but shouldn't the ?,?,? in your query have

Re: [PHP-DB] Easy reg expression problem

2004-07-16 Thread Tim Van Wassenhove
In article [EMAIL PROTECTED], Jason Wong wrote: On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage of using a regex is that you can perform some form of

Re: [PHP-DB] Easy reg expression problem

2004-07-16 Thread Jason Wong
On Friday 16 July 2004 16:01, Tim Van Wassenhove wrote: In article [EMAIL PROTECTED], Jason Wong wrote: On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage of

Re: [PHP-DB] Easy reg expression problem

2004-07-15 Thread Jason Wong
On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage of using a regex is that you can perform some form of validation on the address. -- Jason Wong - Gremlins

Re: [PHP-DB] Re: Extremely Urgent: Problem with PHP and Oracle

2004-06-10 Thread Christopher Jones
Justin Patrin wrote: Charles Morris wrote: putenv(ORACLE_SID=PROJ); putenv(ORACLE_HOME=/home/oracle9); I have tried putenv myself and it doesn't seem to work for Oracle connections. Putting those in your shell environment, then restarting apache. Check to see if the env vars are set

RE: [PHP-DB] Load data infile problem

2004-06-07 Thread Justin.Baiocchi
] Subject: Re: [PHP-DB] Load data infile problem does your server have the post variables set as globals? you might have to use $_POST['submit'] instead. On Jun 7, 2004, at 9:17 PM, [EMAIL PROTECTED] wrote: Hello, I have a page with a button that when clicked loads a pre-determined text file

Re: [PHP-DB] mysql - SELECT DISTINCT problem

2004-05-08 Thread Daniel Clark
Very odd. I would think it would return every record seeing as the auto_increment ID field is different for every record. I use SELECT DISTINCT tip, marca, model FROM modele to select records without duplicates on the field tip. This works ok, BUT if I use SELECT DISTINCT tip, marca, model, id

Re: [PHP-DB] another strange MYSQL problem

2004-05-08 Thread Marcjon Louwersheimer
- Original message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Sat, 8 May 2004 23:23:05 +0300 Subject: [PHP-DB] another strange MYSQL problem Hello, First, I use this, and all is ok: SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC. Then, I use

Re: [PHP-DB] another strange MYSQL problem

2004-05-08 Thread Radek Zajkowski
Run those queries again and send in the result set. Maybe they're being sorted but it looks off, also what is the data type for you 'tip' column. Post your db schema if possible. R Quoting Marcjon Louwersheimer [EMAIL PROTECTED]: - Original message - From: [EMAIL PROTECTED]

Re: [PHP-DB] another strange MYSQL problem

2004-05-08 Thread John W. Holmes
[EMAIL PROTECTED] wrote: First, I use this, and all is ok: SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC. Then, I use this: SELECT * FROM modele WHERE marca='Cagiva' ORDER BY tip ASC and the records are not ordered ascending by the field tip. In the first case, the records were

Re: [PHP-DB] Re: PHP OO Problem

2004-04-15 Thread Chris Boget
Is there any way to destroy the object in PHP? http://us2.php.net/manual/en/function.unset.php Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] INSERT dynamic values problem - Need help urgently!

2004-02-27 Thread Mikael Grön
Irin, First of all, you need to do this instead of what you're doing: while ($row = mysql_fetch_row($sql)) Second, this value should be storable just as any other values. i.e. mysql_query(insert into database (table) values(' . $_POST['class_code'] . ')); I hope this helps you a bit. Regards,

Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)

2004-02-27 Thread Ricardo Lopes
. - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: Robin 'Sparky' Kopetzky [EMAIL PROTECTED] Cc: Erwin Kerk [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:04 AM Subject: Re: [PHP-DB] SQL File Import problem (Was: HELP!!!) On Fri, 27 Feb 2004 01:16:20

Re: [PHP-DB] INSERT dynamic values problem - Need help urgently!

2004-02-27 Thread Pavel Lobovich
Hi all: I am trying to create a registration form whereby one of the user input is as follows: (a drop down menu with values retrieved from DB): - td class=lighter width=350Class Code:/td td class=lighter

Re: [PHP-DB] INSERT dynamic values problem - Need help urgently!

2004-02-27 Thread Daniel Clark
Try: OPTION VALUE=\$row['class_code']\ .$row[class_code]. /option; while ($row = mysql_fetch_array($sql)) { print OPTION VALUE=\$class_code\ .$row[class_code]. /option; } $result = $db-query($sql); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)

2004-02-26 Thread Doug Thompson
On Fri, 27 Feb 2004 01:16:20 +0100, Erwin Kerk wrote: Robin 'Sparky' Kopetzky wrote: Good afternoon! I used SQLYOG to export the tables and data from a Mysql database. Now, when i try to re-import the data back into a different database, I get an error stating Error : MySQL server has gone

RE: [PHP-DB] SQL File Import problem (Was: HELP!!!)

2004-02-26 Thread Robin 'Sparky' Kopetzky
Thank you to all who helped. I was able using UltraEdit to chop up the sql file and created all of the individual INSERT statements. Now, I'm up and running again. Slow but it worked! Thanks again! Robin Kopetzky -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)

2004-02-26 Thread Erwin Kerk
Robin 'Sparky' Kopetzky wrote: Good afternoon! I used SQLYOG to export the tables and data from a Mysql database. Now, when i try to re-import the data back into a different database, I get an error stating Error : MySQL server has gone away. What is happening and how do I fix this. I NEED this

Re: [PHP-DB] Re: PHP Java problem

2004-01-14 Thread Donovan Hutchinson
Thanks Justin, thats a handy function. I've been testing my code and found that it works up until I start passing objects into methods. This is the code I'm using to set up some objects (they are being passes variables that have been settype()'d): $sessioniser = new Java('com.SessionManager',

RE: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script

2003-10-03 Thread Michael Scappa
, not the file itself, try both). -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 8:15 AM To: Michael Scappa Cc: [EMAIL PROTECTED] Subject: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script On Thu, 2003-10-02 at 22:28

Re: [PHP-DB] To many connections problem with LAMP

2003-09-05 Thread Mika Tuupola
On Thu, 4 Sep 2003, Balaji H. Kasal wrote: It is usually better not to use persistenc connections. So drop the pmysql_connect or if you really need to use them set set max connections higher for mysql. Which problem it has? On a really busy site persistent

Re: [PHP-DB] To many connections problem with LAMP

2003-09-04 Thread Mika Tuupola
On Wed, 3 Sep 2003, Merlin wrote: After doing some research it looks like this is a problem because I am using pmysql_connect instead of mysql_connect. It is usually better not to use persistenc connections. So drop the pmysql_connect or if you really need to use them

Re: [PHP-DB] To many connections problem with LAMP

2003-09-04 Thread Balaji H. Kasal
After doing some research it looks like this is a problem because I am using pmysql_connect instead of mysql_connect. It is usually better not to use persistenc connections. So drop the pmysql_connect or if you really need to use them set set max connections higher

Re: [PHP-DB] PHP - Apache config problem

2003-07-14 Thread dpgirago
FYI: OOPS!! I dug around in the install.txt file in PHP, and found that php4ts.dll needs to be relocated to either where apache.exe resides, where php4apache.dll resides, or in the windows system directory. All now works as expected. David [EMAIL PROTECTED] on 07/14/2003 11:35:42 AM To:

Re: [PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2

2003-06-19 Thread Thorsten Krner
Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? As I said before, this the wrong way. You

Re: [PHP-DB] actualy result of problem with formfieldvalues underSuse 8.2

2003-06-19 Thread Ruprecht Helms
On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ?

Re: [PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2

2003-06-19 Thread Thorsten Krner
HI Am Donnerstag, 19. Juni 2003 23:54 schrieb Ruprecht Helms: On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same

Re: [PHP-DB] 4.2.3 session login problem...

2003-06-17 Thread CPT John W. Holmes
I have an application that is currently working fine under 4.1.2, and I am in the process of upgrading to 4.2.3. The problem is that after upgrading PHP the application login no longer works. Additionally, this same application works fine on another machine running 4.2.3. The only

RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using 'a href=mailto: ... function

2003-06-06 Thread Mark
' - it is only text in this case and it will be part of the email body. Thanks anyway, Martin -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 June 2003 3:02 p.m. To: 'Martin Rajcok'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] I have a problem to add

RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using 'a href=mailto: ... function

2003-06-04 Thread John W. Holmes
I have a problem to add a new line to the body of my email when I am using 'a href=mailto: ... function. This is my code: $details[email] //email of the user from the form $details[contact_name] //name of the user from the form $email_subject = subject text...; $email_form = Welcome

RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using 'a href=mailto: ... function

2003-06-04 Thread Martin Rajcok
PROTECTED] Sent: Thursday, 5 June 2003 3:02 p.m. To: 'Martin Rajcok'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using 'a href=mailto: ... function I have a problem to add a new line to the body of my email when I am using 'a href

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Andrey Hristov
Hi, Does mysql user has rights to write in this directory or permissions over this file? Andrey - Original Message - From: conbud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 03, 2003 11:00 AM Subject: [PHP-DB] MySQL Database connection Problem Hello can someone

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Jason Wong
On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give me some possible reasons this error happens when I use the mysql client to add a tabe to a database. mysql create table home (id int not null, heading blob not null, - primary key (id), unique id (id)); ERROR 3: Error

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread conbud
Jason Wong wrote: On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give me some possible reasons this error happens when I use the mysql client to add a tabe to a database. mysql create table home (id int not null, heading blob not null, - primary key (id), unique id (id));

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Andrey Hristov
- Original Message - From: conbud [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 03, 2003 11:11 AM Subject: Re: [PHP-DB] MySQL Database connection Problem Jason Wong wrote: On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give me some

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread conbud
Hristov - Original Message - From: conbud [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 03, 2003 11:11 AM Subject: Re: [PHP-DB] MySQL Database connection Problem Jason Wong wrote: On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Andrey Hristov
what about the permissions? are they ok? Andrey - Original Message - From: conbud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 03, 2003 11:30 AM Subject: Re: [PHP-DB] MySQL Database connection Problem Andrey thanks, but I seen that already and theres over 80 gig left

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Jason Wong
On Friday 03 January 2003 17:11, conbud wrote: Jason Wong wrote: On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give me some possible reasons this error happens when I use the mysql client to add a tabe to a database. mysql create table home (id int not null, heading blob

Re: [PHP-DB] file upload array problem

2002-12-21 Thread Jason Wong
On Saturday 21 December 2002 05:25, Seabird wrote: Hi everyone, every time I try to upload a picture I get the same problem in return. First of all, it's not being uploaded (but this is for later concern I'm afraid). Trying to display the info of the (not)uploaded file should be done with:

Re: [PHP-DB] default-character-set problem

2002-11-06 Thread Tjoumaidis
You have to put the same under [server] Nikos wrote: Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart

RE: [PHP-DB] mssql select db problem

2002-10-14 Thread Jeffrey_N_Dyke
: Subject: RE: [PHP-DB] mssql select db problem 10/14/2002 11:30 AM

RE: [PHP-DB] mssql select db problem

2002-10-14 Thread Jeffrey_N_Dyke
] 10/14/2002 cc: 'Kadir Leblebici' [EMAIL PROTECTED], [EMAIL PROTECTED] 11:32 AM Subject: RE: [PHP-DB] mssql select db problem(Document link: Jeff Dyke

Re: [PHP-DB] Global variables, $_GET problem

2002-07-24 Thread Andrey Hristov
- Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 6:45 AM Subject: Re: [PHP-DB] Global variables, $_GET problem On Wednesday 24 July 2002 11:38, Ruth Zhai wrote: We just upgraded our PHP to version 4.2.1. I realized

RE: [PHP-DB] Global variables, $_GET problem

2002-07-23 Thread Beau Lebens
Ruth, your reference to $_GET('var') is close, but as you have seen - no cigar :) using the () after GET makes it refer to a function, but it is actually an array which is automatically created, so you need to use $_GET['var'] (note the square brackets as for point 2 (register_globals) did you

Re: [PHP-DB] Global variables, $_GET problem

2002-07-23 Thread Jason Wong
On Wednesday 24 July 2002 11:38, Ruth Zhai wrote: We just upgraded our PHP to version 4.2.1. I realized that $var is no longer available from www.url.com/myphp.php?var=3 . As instructed in the document, we have tried two things: Good, someone who reads the docs :) 1. I tried to use

RE: [PHP-DB] Form select field problem

2002-07-09 Thread Keiran Wynyard
:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 2:50 AM To: 'Keiran Wynyard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Form select field problem Keiran, A couple possibilities for you; 1. Try referring to the field (in JavaScript) as something like; (might have to play around

RE: [PHP-DB] Form select field problem

2002-07-08 Thread Beau Lebens
Keiran, A couple possibilities for you; 1. Try referring to the field (in JavaScript) as something like; (might have to play around with this) document.existing[groupchoice[]].selectedIndex 2. Make it so that each selection on the select tag is mirrored into another hidden input field

Re: [PHP-DB] Strange MySQL Query Problem

2002-07-03 Thread Martin Clifford
From your query, it looks as if you are letting the user select the table that they can query with $pop-up1. Is that correct? If so, do all the available choices of tables have the same column names? Other than that I can't see why this query would fail. Martin eat pasta type fasta [EMAIL

RE: [PHP-DB] Strange MySQL Query Problem

2002-07-03 Thread Jen Swofford
Could this be as simple as a typo? textfield texfield Jen Swofford [EMAIL PROTECTED] -Original Message- From: eat pasta type fasta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 3:27 PM To: PHP LIST Subject: [PHP-DB] Strange MySQL Query Problem I already got some

Re: [PHP-DB] Strange MySQL Query Problem

2002-07-02 Thread Jason Wong
On Wednesday 03 July 2002 12:42, eat pasta type fasta wrote: I have a simple form which queries the database based on 2 pop-up menu choices and keywords entered by the user, it passes on the variables as follows: pop-up1=choice1, pop-up2=choice2, textfield=user specified data the query is

Re: [PHP-DB] Re: PHP/Access problem

2002-03-27 Thread George Pitcher
Adam, Thanks for the assist. The query works fine without the ( ) arount the conditions. Now on to the next part. George - Original Message - From: Adam Royle [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:03 PM Subject: [PHP-DB] Re: PHP

Re: [PHP-DB] load data infile problem

2002-01-19 Thread Miles Thompson
You running Windows or *nix? File permissions will play a part in this, but use PHP's exec() function to execute MySQL's load data infile. The manual has a number of well annotated examples. The big problem may be that you'll be executing the command as whatever user the web server is running

Re: [PHP-DB] php3-php4 mysql problem with nl2br coding

2001-11-24 Thread Raquel Rice
On Fri, 23 Nov 2001 14:04:00 -0600 Terry Romine Terry Romine [EMAIL PROTECTED] wrote: I seem to have run into a strange bug where when I enter text through a form, and use the nl2br call in PHP, instead of getting BR I get BR / and then my parsing fails on the display side (where I use

RE: [PHP-DB] Re: UPDATE table Problem

2001-10-18 Thread Nally, Tyler G.
, October 17, 2001 12:13 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: UPDATE table Problem Dear Sir George Liomis, But there is still the update command issue why didn't my update command work when i tryed it in my php source it didn;t work but in the mysql shell it updated it for me

Re: [PHP-DB] RE: bizarre ocilogon problem

2001-09-07 Thread Thies C. Arntzen
On Wed, Sep 05, 2001 at 10:24:28AM -0500, Brian Mauter wrote: Are you running out of logons? You should only need the client libraries on the machine with the PHP pages. You do not need them anywhere else. (That's the beauty of the web!) Make sure you have ocilogoff in your PHP page when

Re: [PHP-DB] simple odbc insert problem

2001-08-20 Thread Justin Buist
On Mon, 20 Aug 2001, LondonVibe wrote: new to php so be nice :) win2k iis5.ms access.. what is the order for adding var's to a access DB ?? code i tried... with data from form don't work... // connect to system dsn odbc name login and password or die $connect =

Re: [PHP-DB] Re: Group By problem

2001-08-13 Thread Sharif Islam
Thanks for your reply You don't show your SQL, but I assume it's something like SELECT grp,svc,mach FROM table ORDER BY grp,svc,mach Thats right. But its displaying the same as my code: --- Group:Desktop Service:BACKUP AITSBKUP Service:E-Mail AITSMAIL Service:E-Mail JEEVES Group:Unix

Re: [PHP-DB] Sql result loop problem !

2001-05-18 Thread Jason Stechschulte
On Fri, May 18, 2001 at 04:32:51PM +0200, Keith Whyman wrote: while ($p = mysql_fetch_array($result1)) { $msg .= $p[s_bereich_name]; $msg .= $p[s_news_text]; $msg .= $p[s_users_real_name]; I'm not sure if this is what you want, but something like this maybe?? ?php while($p =

RE: [PHP-DB] urgent postgresql date problem ...

2001-05-09 Thread Steve Brett
fixed it. code is below: (output 1 is screen output 2 is csv). it seemed to like fetch_row better than fetch_array .. if anyone could explain i would be really grateful. there's nothing worse than fixing something and not knowing how you did it !;-) for ($x=0; $x$numcdbs; $x++) {

Re: [PHP-DB] PHP4 to PHP3 problem

2001-04-11 Thread fabrizio . ermini
On 10 Apr 2001, at 13:49, Rob Griffiths wrote: **50** print "tr bgcolor=#66td{$A["fname"]}/td" . "td{$A["lname"]}/td" . " td{$A["dept"]}/td" . " td{$A["manager"]}/td" . "td{$A["extension"]}/td/tr\n"; Notation with "{" parenthesis is not

Re: [PHP-DB] A Real PHP problem for a change...

2001-04-10 Thread Rasmus Lerdorf
That said, (Now on to actual PHP) I've noticed (in my own scripting) and a few other problems posted here quite a bit of confusion with PHP's single ' and double " quotes. Reading the material I was led to believe that ' ' outputs exactly what is in the quotes and " " outputs variables

Re: [PHP-DB] PHP + interbase connection problem

2001-02-25 Thread Meir Kriheli - MKsoft
Looks like your PHP installation is not compiled with interbase support. Can you guve us some more details ? What is the OS you're using and the code the caused you problems. Meir Kriheli MKsoft computer systems 'There's someone in my head but it's not me" - Pink Floyd - Original

RE: [PHP-DB] CONNECT BY PHP problem

2001-02-19 Thread David Benson
With HORA, it is no problem to display the hierarchic structure via the CONNECT BY clause. I tried the same statement in PHP3 and it I'm using php4pl1 with Oracle 8.1.6 and this works: select c.cvsn_id, c.parent_cvsn_id, level from cvsn c where start with

Re: [PHP-DB] Apache, PHP4, access problem to MS SQL 7.0

2001-02-14 Thread Darryl Friesen
Can anybody help me about my serious problem to connect to MS SQL 7.0. I tried to use the freetds-driver but i'm not able to connect with it. They said that I must define the Serverconnection in the interfaces-file. I found one in the freetds-directory but i don't know how to write it