Re: [PHP-DB] Subject Matter

2013-08-27 Thread Daniel Brown
On Tue, Aug 27, 2013 at 12:10 PM, Matijn Woudt wrote: > > Uh, you're right. I meant moderator.. Yeah, as far as moderation, we only do in extreme circumstances. -- Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Subject Matter

2013-08-27 Thread Daniel Brown
On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt wrote: > > The problem is: there is no maintainer;) Sure there is. -- Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql query

2013-08-21 Thread Daniel Krook
Ethan, What about: $result2 = mysqli_query(cxn, $sql2); Doesn't look like you're sending it a connection link as a variable ($cxn) and that's passed through as a literal? Thanks, Daniel Krook Software Engineer, Advanced Cloud Solutions, GTS IBM Senior Certified IT

Re: [PHP-DB] mysql query

2013-08-21 Thread Daniel Krook
ing to give you the same thing as the print_r below it. Thanks, Daniel Krook Software Engineer, Advanced Cloud Solutions, GTS IBM Senior Certified IT Specialist - L3 Thought Leader The Open Group Certified IT Specialist - L3 Distinguished Cloud, Java, PHP, BlackBerry, DB2 & Solaris Certi

Re: [PHP-DB] Gnome Desktop Button

2012-11-27 Thread Daniel Brown
On Tue, Nov 27, 2012 at 5:31 PM, Ethan Rosenberg, PhD wrote: > Dear list - > > Maybe this fell thru the cracks, so here it is again. > > Is there a way to have a button in the tray that will minimize all the > windows and show the desktop? Well, it's neither a PHP nor database question, s

[PHP-DB] Re: [PHP] Vulnerability Announced in phpMyAdmin

2012-09-25 Thread Daniel Fenn
Thank you for the heads up. On 9/26/12, tamouse mailing lists wrote: > On Tue, Sep 25, 2012 at 3:20 PM, Daniel Brown wrote: >> Just a three-list cross-post to bring it to everyone's attention >> at once, in case you weren't already aware. It was announced to

[PHP-DB] Vulnerability Announced in phpMyAdmin

2012-09-25 Thread Daniel Brown
Afternoon, folks; Just a three-list cross-post to bring it to everyone's attention at once, in case you weren't already aware. It was announced today that a compromised SourceForge mirror was distributing a malicious file with the phpMyAdmin package that allows an attacker to arbitrarily

[PHP-DB] Re: Unsubscribe me Please

2012-09-24 Thread Daniel Brown
On Fri, Sep 21, 2012 at 11:17 PM, Sam wrote: > I saw where you did it for others. I will just block your address thx > > Sent from Sam's IPad And yet you missed that I said I wouldn't be doing it in lieu of following the obvious unsubscription instructions. Please do block all of our addres

Re: [PHP-DB] Unsubscribe me please

2012-09-21 Thread Daniel Brown
On Thu, Sep 20, 2012 at 9:29 PM, Alan Vickers wrote: > Please remove me, too. Thanks! Please follow the unsubscription instructions as posted all over, included in the foot of every single list message, and as I posted twice in this thread yesterday. -- Network Infrastructure Manager http:

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Daniel Brown
On Thu, Sep 20, 2012 at 11:51 AM, Valentin Nedkov wrote: > Hello, > > please, unsubscribe me too. Sure. It seems no one knows the unsubscription instructions. So, for all others: From your subscribed email address, send a blank message to php-db-unsubscr...@lists.php.net.

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Daniel Brown
On Wed, Sep 19, 2012 at 6:43 PM, Graham H. wrote: > Hi, > > I tried unsubscribing from the list, but I was unsuccessful, I believe > because when I subscribed I cleverly added +php to the end of my email > address (for Gmail filtering). > > Could I be removed please? Thanks. No problem, I'll

Re: [PHP-DB] Unsubscribing

2012-09-11 Thread Daniel Brown
On Tue, Sep 11, 2012 at 3:37 AM, Aaron Wood - Slurpy Studios wrote: > Hello, > > I have been trying to unsubscribe from this list, but it doesn't seem to be > stopping - could you look into it for me and take me off the list? I've removed you from php-db@lists.php.net manually just now, Aaron

[PHP-DB] Re: Test 2 w/copy

2012-08-31 Thread Daniel Brown
Looks like your "mail from" string in your email headers is coming through blank to the server. Can you check your email client settings and see if that fixes it? Also, if you have access to Earthlink webmail, try sending an email from there. On Fri, Aug 31, 2012 at 1:23 PM, Ethan Rosenberg

Re: [PHP-DB] echo into variable or the like

2012-08-21 Thread Daniel Brown
On Tue, Aug 21, 2012 at 12:01 AM, wrote: > Hi, this is my first post so forgive me if I missed a rule and do something > wrong. > > I have this code, > > echo $_SERVER['PHP_SELF']."?"; > foreach ($_GET as $urlvar=>$urlval) > echo $urlvar."=".$urlval."&"; > > It works by it’s self. > I want to in

Re: [PHP-DB] Installing IBM DB2 drivers onto an Apache Server under Fedora 16 x64 to access IBM POWER7 DB2 via PHP....

2012-05-11 Thread Daniel Krook
27;Connection to database succeeded.'; db2_close($conn_resource); } else { echo 'Connection to database failed.'; echo 'SQLSTATE: ' . db2_conn_error() . ''; echo 'Message: ' . db2_conn_errormsg(). ''; } Hope that get

Re: [PHP-DB] MOD_Rewrite

2011-09-20 Thread Daniel Brown
On Tue, Sep 20, 2011 at 17:01, Gavin Chalkley wrote: > Hey all, > > I am trying to use MOD_Rewrite with EasyPHP. > > I have this in my htaccess: > > RewriteEngine On > RewriteBase / > RewriteRule ^([0-9]+)/?$ main_index.php?key=$1 > > > My main page is MAIN_INDEX.PHP my db identifier is KEY > > Ho

Re: [PHP-DB] MSsql madness

2011-06-24 Thread Daniel Brown
On Fri, Jun 24, 2011 at 16:07, Paul Wilson wrote: > please remove me from this list Email php-db-unsubscr...@lists.php.net. -- Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] radio form submission

2011-06-23 Thread Daniel P. Brown
On Thu, Jun 23, 2011 at 14:18, Chris Stinemetz wrote: > So far I am good on creating the form and  submitting it to mysql > database and calling the submitting value from a different script. > > My question is: How can I make it so when a user selects radio option > value "1" it will then be displ

Re: [PHP-DB] radio form submission

2011-06-23 Thread Daniel P. Brown
On Thu, Jun 23, 2011 at 16:08, Chris Stinemetz wrote: > > I must be missing something. I am just getting a blank page. Your help > is greatly apprecieated. This is why you're supposed to take the advice and write it out yourself, not copy and paste the code. ;-P By copying and pasting t

Re: [PHP-DB] radio form submission

2011-06-23 Thread Daniel P. Brown
On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz wrote: >> >>    Use an if or a switch.  For example: >> > > I think your suggestions are exactly what I am looking for. I am not > sure exactly where to place it. Do I insert it after the query > statment? During your while() loop. This line her

[PHP-DB] Re: [PHP] mysql error

2011-05-05 Thread Daniel Brown
On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote: > Can smbd please look  at this sentence - I got an error and do not > know how to fix it - I am still very unfamiliar with MYSQL: > > CREATE TABLE log (  idlog int auto_increment not null,  imepriimek > varchar(50),  clock timestamp,  action va

Re: [PHP-DB] sorce on php mysql 5.1.56

2011-04-21 Thread Daniel Brown
On Thu, Apr 21, 2011 at 14:50, Fred Silsbee wrote: >  Fatal error: Call to undefined function mysql_errors() in > /var/www/html/log_book_MySQLnew.php on line 261 The function is mysql_error(). -- Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://ww

Re: [PHP-DB] testing

2011-03-19 Thread Daniel Brown
On Fri, Mar 18, 2011 at 17:35, Jim Giner wrote: > first time poster There's no need to test. We've known it's worked for years. -- Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SELECT WHERE length of content question

2011-03-09 Thread Daniel Brown
On Wed, Mar 9, 2011 at 17:49, Ron Piggott wrote: > > Is there a command in mySQL that would allow me to SELECT the rows where the > `fax` column is more than 11 characters long? There is. SELECT * FROM tblName WHERE CHAR_LENGTH(fax) >= 11; (Presuming you meant greater than or equal

Re: [PHP-DB] Submitting data to MySQL database using HTML/PHP form

2011-02-21 Thread Daniel Brown
On Sun, Feb 20, 2011 at 16:43, Donovan Brooke wrote: >> >>         $insert = "INSERT INTO user_info(login,password) >> >> VALUES('".mysql_real_escape_string($login)."',"'.mysql_real_escape_string($password)."')"; > > > Look at that one more time Dan. ;-) Yeah, well, that's why one should neve

Re: [PHP-DB] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Daniel Brown
On Sun, Feb 20, 2011 at 14:11, Nazish Zafar wrote: > > $insert = "INSERT INTO user_info > (login, password) > VALUES > ("$login", "$password"); You're using double-quotes to encapsulate your $insert variable data, then never closing them. What's more, you're also using double-quotes to encap

Re: [PHP-DB] bool type (between MySQL and PHP)

2011-01-25 Thread Daniel Brown
On Tue, Jan 25, 2011 at 17:40, Donovan Brooke wrote: > > Thanks Dan, > > I think the error would still persist using DEFAULT.. because as mentioned, > I don't think MySQL likes: > > UPDATE tablename SET vbool= > > ..which is not great news for me since I'd like to avoid having to redo > all my boo

Re: [PHP-DB] bool type (between MySQL and PHP)

2011-01-25 Thread Daniel Brown
On Tue, Jan 25, 2011 at 17:05, Donovan Brooke wrote: > > What is the best PHP practice when using bools with > MySQL? Save 1's and 0's instead of true/false? You could either do an INT(1) DEFAULT 0 or an ENUM('Y','N') to make it easier on yourself. -- Network Infrastructure Manager Documen

Re: [PHP-DB] Connecting PHP to MySQL on Windows

2011-01-07 Thread Daniel Brown
On Fri, Jan 7, 2011 at 15:06, Gavin Chalkley wrote: > Mike, > > A plain HOST file should have the commented part at the top, and only 1 > reference to localhost unless you are creating Virtual hosts. > > I would suggest removing the "::1" line As long as he never plans to use IPv6 on there, t

Re: [PHP-DB] Connecting PHP to MySQL on Windows

2011-01-06 Thread Daniel Brown
On Thu, Jan 6, 2011 at 21:12, michael manning wrote: > Hi Daniel, > When testing with the CLI, netstat shows: [snip!] What happens when you swap out 'localhost' for '127.0.0.1' in the connection routine? If that works, check to make sure your hosts file proper

Re: [PHP-DB] using PDO vs mysql extension

2011-01-06 Thread Daniel Brown
On Thu, Jan 6, 2011 at 02:52, Miriam Natanzon wrote: > Hi, > > I want to build an internal module for common DB-involved tasks: starting > with connection, simple queries and go on to multiple pages of results and > connecting tables and so on. > > We are currently working with MySQL but maybe in

Re: [PHP-DB] Connecting PHP to MySQL on Windows

2011-01-06 Thread Daniel Brown
On Thu, Jan 6, 2011 at 01:13, michael manning wrote: > Hi, > > I have installed MySQL 5.1.52, Apache 2.2.15 and PHP 5.3.2 on my Windows > Vista computer. > The MySQL works fine with the command line client and I have tested the > Apache and PHP and it appears fine when I test this with the phpinfo

Re: [PHP-DB] Word Matching Application

2011-01-05 Thread Daniel Brown
On Wed, Jan 5, 2011 at 21:23, Ron Piggott wrote: > > I only know how to do one array at a time, using FOREACH, like this: > > === > echo "\r\n"; > >    foreach($match_words as $word) { >        echo "" . $word . "\r\n"; >    } > > echo "\r\n"; > === You could either swap that out for a simple

[PHP-DB] Re: [PHP] Regex for telephone numbers

2010-12-31 Thread Daniel P. Brown
On Fri, Dec 31, 2010 at 19:09, Jim Lucas wrote: > > Actually... > > Specified here [1] it says that the {1,} is the same as '+'.  I think you > should > drop the comma.  If you don't this would be valid 844-2345-123456 > > ^[2-9]{1,}[0-9]{2,}\-[2-9]{1,}[0-9]{2,}\-[0-9]{4,}$ > > should be > > ^[2-

[PHP-DB] Re: [PHP] Regex for telephone numbers

2010-12-31 Thread Daniel Brown
On Fri, Dec 31, 2010 at 12:05, Dmitriy Ugnichenko wrote: > I guess, this will work fine > > ereg('[0-9]{3}-[0-9]{3}-[0-9]{4}',  $phone_number); Not quite. Plus, all ereg* functions have been deprecated for some time now. -- Network Infrastructure Manager Documentation, Webmaster Teams htt

[PHP-DB] Re: [PHP] Job Search

2010-12-31 Thread Daniel Brown
On Fri, Dec 31, 2010 at 09:11, Ethan Rosenberg wrote: > Dear list - > > I am an entry level data base programmer [PHP/MySQL HTTP/CSS] looking for > work in the NY metropolitan area.  Any ideas? Search Google, but trust me, you're going to need more experience than entry-level to pick up a job

Re: [PHP-DB] Re: [PHP] Regex for telephone numbers

2010-12-30 Thread Daniel Brown
On Thu, Dec 30, 2010 at 14:07, Ethan Rosenberg wrote: > > Josh - > > I used use \d{3}-\d{3}-\d{4}. > > It works beautifully!! Just keep in mind that invalid numbers will also pass that check, such as 000-000- or 123-456-6789. That's why my example was a bit more involved. -- Network I

[PHP-DB] Re: [PHP] Regex for telephone numbers

2010-12-29 Thread Daniel P. Brown
On Wed, Dec 29, 2010 at 19:12, Ethan Rosenberg wrote: > Dear List - > > Thank you for all your help in the past. > > Here is another one > > I would like to have a regex  which would validate that a telephone number > is in the format xxx-xxx-. Congrats. People in Hell would like ice

[PHP-DB] Re: [PHP-INSTALL] php - libmysqlclient question

2010-12-29 Thread Daniel Brown
On Wed, Dec 29, 2010 at 04:57, Hajo Locke wrote: > Hello, > > i want to talk from php to different mysql-servers with different versions. > is it a recommend way to compile php always against newest libmysqlclient or > not so important? You should use the newest stable version so you can take

Re: [PHP-DB] Re: [PHP] Problems w/ goto

2010-12-20 Thread Daniel Brown
On Sat, Dec 18, 2010 at 17:02, David Hutto wrote: > or maybe it's saturday morning and i'm drunk? This seems to be the most likely, and considering how all messages are permanently and independently archived and propagate throughout the Internet, it might be a good reason not to go nuts in se

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-17 Thread Daniel P. Brown
On Fri, Dec 17, 2010 at 12:22, Robert Cummings wrote: > > I was one of the people that argued in favour of GOTO on the Internals list > a few years ago. GOTO has a use, and a very good one at that. It is by far > the most efficient construct when creating parsers or other similar types of > logic

Re: [PHP-DB] Re: [PHP] Problems w/ goto

2010-12-17 Thread Daniel Brown
On Fri, Dec 17, 2010 at 12:16, Richard Quadling wrote: > > And have you seen all the sad faces ... > > : { > > on http://docs.php.net/manual/en/control-structures.goto.php#92763 > > Can't be good for them. If only people knew how many hours - literally, hours - it took me to keep that page cl

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-17 Thread Daniel Brown
On Fri, Dec 17, 2010 at 11:38, Ethan Rosenberg wrote: > > I am trying to write a program that can have two(2) independent forms in one > PHP file.  When I run the code below [from PHP - A Beginner's Guide], to > which I have added a second form, it freezes. [snip!] > What did I do wrong? You

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Daniel Brown
On Tue, Dec 14, 2010 at 13:43, Toby Hart Dyke wrote: > > Use  'ALTER tablename AUTO_INCREMENT=1' rather than 'UPDATE tablename > AUTO_INCREMENT=1'. Yeah, again, my fault. Not enough coffee on this cold (~7F) winter's day, perhaps. -- Network Infrastructure Manager Documentation, Webmaster

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Daniel Brown
On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg wrote: >> >>    UPDATE tablename AUTO_INCREMENT=1; > > mysql> update Visit3 auto_increment=1; > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to use > ne

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Daniel Brown
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg wrote: > Dear List - > > Thanks for all your help. > > How do I reset auto_increment so that the primary key will start from 1. >  The primary key is now 2421.  I have deleted all the data in the table and > started over, and the primary key just incr

[PHP-DB] [PHP] mySQL query assistance...

2010-11-29 Thread Daniel P. Brown
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote: > Hi all, > > Is there a list/form to get some help on compiling mySQL queries? I am > executing them via PHP, but do not want to ask for help here if it is no the > appropriate forum. Thanks ;-)    Yes.    For MySQL queries, write to the MySQL G

[PHP-DB] Re: [PHP] Strange Query Error...

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 13:18, Don Wieland wrote: > On Nov 27, 2010, at 10:07 AM, Bastien wrote: > >> Try removing the backticks around the table names. If you do use them, >> then all values (field names and table names) need it. > > I tried that and still chokes... > > select m.* from Members m

[PHP-DB] Re: [PHP] Strange Query Error...

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 12:30, Don Wieland wrote: > Hi gang, > > I am executing a query via PHP that gives me a PHP error: > > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'AND > m.`Preferred_First_Name` LIK

Re: [PHP-DB] French and Spanish Accent Letters

2010-11-10 Thread Daniel Brown
On Wed, Nov 10, 2010 at 10:16, Ron Piggott wrote: > > I did Daniel --- php-db@lists.php.net ; Thank you for telling me about the > mySQL list. > > I failed to mention in my original e-mail the database is mySQL. My fault. Force of habit mentioning the php-db@ list. Sorry i

Re: [PHP-DB] French and Spanish Accent Letters

2010-11-10 Thread Daniel Brown
On Wed, Nov 10, 2010 at 10:03, Ron Piggott wrote: > > I have a column that is VARCHAR 250.  I need it to be able to accept french > and spanish accents.  The purpose of the column is organization names.  The > “Collation” default is “latin1_swedish_ci”  What do I need to do?  Ron You need t

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread Daniel Brown
On Fri, Nov 5, 2010 at 08:13, Lester Caine wrote: > Karl DeSaulniers wrote: >> >> Hi, Can anyone admin please explain this to me? > > If the email server gets bounce messages back for emails set out, then it > tries to check those emails. If the warning message gets through then > nothing really h

Re: [PHP-DB] php_warn

2010-02-11 Thread Daniel Brown
On Thu, Feb 11, 2010 at 08:49, madunix wrote: > some of my web pages having the following issue when i call them > Warning:main(main_page.html.php): failed to open stream: No such file > or directory in /www/htdocs/web/public/public.php on line 50 > Warning:main(): Failed opening 'main_page.html.p

Re: [PHP-DB] trying to dump out table info

2009-07-14 Thread Daniel Brown
On Tue, Jul 14, 2009 at 08:16, h...@deweywilliams.com wrote: > > The problem I have always had with the PHP Manual (online) has been the lack > of complete examples.  Yes, there are examples of how to use each function. > But functions such as the MySQL related ones require multiple steps to get >

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 20:17, Govinda wrote: > > Dan, I am really making the effort..  despite how it may look. I believe you. I sent you the function and code that should work for you, but it may have been lost in the chopped replies. So it'll be something like this: -- daniel.br...@p

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 19:28, Govinda wrote: > >        $db_billing=mysql_connect(localhost,metheuser,mypass,billing); >if (!$db_billing) { die('Could not connect: ' . mysql_error()); } if(!mysql_select_db('dbname',$db_billing)) die(mysql_error()); >        //$sql = "SHOW TAB

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 17:24, Govinda wrote: > > "No database selected" You're getting warmer How would you select a MySQL database in PHP? (Hint: there's a built-in function.) -- daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ C

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 16:53, Govinda wrote: > Hi all > > I am not sure why this is failing/giving error.  I am quite new at > PHP/Mysql, and apologize for what will undoubtedly end up being a trivial > error on my part. Hey, I recognize that code ;-P > Here is my code: > > $db_billing=m

[PHP-DB] Re: [PHP] A prepared statements question

2009-07-11 Thread Daniel Brown
[Redirected to PHP-DB: php...@lists.php.net] On Sun, Jul 12, 2009 at 00:31, Jason Carson wrote: > Hello everyone, > > I am having a problem getting my prepared statements working. Here is my > setup... > >    index.php -> authenticate.php -> admin.php > > 1)index.php has a login form on it so

Re: [PHP-DB] Checking Special Characters

2009-07-11 Thread Daniel Brown
On Sat, Jul 11, 2009 at 02:41, Manu Gupta wrote: > Dear All, > I have to design a databse where I need to check for date > using date as datatype in mysql I am having problems while inserting it > > Can you help me with it?? Google. > Also I am having problems with eregi(), erege(); This

Re: [PHP-DB] PHP- Mysql problem

2009-06-18 Thread Daniel Brown
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAH wrote: > > Warning: mysql_query() [function.mysql-query]: Access denied for user > 'ODBC'@'localhost' (using password: NO) in > C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 http://google.com/search?q=Access%20denied%20for%20user%

Re: [PHP-DB] Please help a newbie

2009-04-19 Thread Daniel Carrera
27;, '$address')"; if (mysql_query($query, $con)) echo "Values inserted"; else die('Unable to create table : '.mysql_error()); This is unsafe code. I suggest you lookup "prepared statements" and the PDO library (which is par

Re: [PHP-DB] Is Temporary table right approach

2009-04-15 Thread Daniel Carrera
binary tree search). Daniel. Manoj Singh wrote: Hi All, I have a query which returns the large number of ids which i am using in other queries. I am doing this in PHP. Now the first query can return unlimited number of ids which might create problem in PHP. I want to store this ids in MYSQL through

Re: [PHP-DB] Dynamic text for every user

2009-03-14 Thread Daniel Carrera
AUTO_INCREMENT PRIMARY KEY, loginCHAR(30) CHARACTER SET utf8 UNIQUE, passwordCHAR(40) CHARACTER SET ascii, secretPhraseCHAR(40) CHARACTER SET utf8 ); Is this what you want? Or did I misunderstand your question? Cheers, Daniel. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re : Problem with PDO exceptions

2009-03-09 Thread Daniel Carrera
ime. Thanks! It works now. Cheers, Daniel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Daniel Carrera
I give them a broken query. That's another reason why I think that the problem is elsewhere. Any ideas? Thank you very much for your help. Best, Daniel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] oci_connect

2008-11-19 Thread Daniel Brown
On Wed, Nov 19, 2008 at 8:15 PM, Fred Silsbee <[EMAIL PROTECTED]> wrote: [snip!] "Fred," Please keep all of your posts in the same thread with the same subject. You're making it very difficult for others to follow along with your ramblings, and seem to even be confusing yourself a bit. C

Re: [PHP-DB] Kesalahan posting?

2008-11-03 Thread Daniel Brown
On Mon, Nov 3, 2008 at 11:46 AM, Alejandro Peña <[EMAIL PROTECTED]> wrote: > Hi, if you try on http://www.appliedlanguage.com/language_identifier.shtml > you'll see the Language: *Malay *;) The Don Komo emails have been hitting this list for a while. At least a year or two. They were on

[PHP-DB] Re: [PHP] CREATE question

2008-10-30 Thread Daniel Brown
On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > > Is it possible for us to use PHP to create temp tables in our database? [snip!] > > But all that does is give me an "ifx_prepare fails" message. (Forwarded to PHP-DB as well.) Dan, make sure Informix is set to allo

Re: [PHP-DB] moved code to a new server

2008-10-24 Thread Daniel P. Brown
Forwarded to General, since this doesn't belong on DB. On Fri, Oct 24, 2008 at 6:18 PM, Marc Fromm <[EMAIL PROTECTED]> wrote: > We moved our website to a new linux server. The code was running on a > different linux server. Thus the OS environment is the same. > We are receiving this error: >

Re: [PHP-DB] OCI

2008-07-21 Thread Daniel Brown
On Mon, Jul 21, 2008 at 12:22 PM, Mad Unix <[EMAIL PROTECTED]> wrote: > How could I build the OCI8 extension module for php5 under CentOS5? > I have installe PHP/APACHE/MYSQL through yum install ... OCI8 is a PECL extension. 'pecl install oci8' If you need more help with that, you ca

[PHP-DB] CURL and ASP

2008-07-09 Thread Daniel Brown
On Wed, Jul 9, 2008 at 9:35 AM, ioannes <[EMAIL PROTECTED]> wrote: > Has anyone here experience of CURLing .asp pages which use session cookies > as I am having difficulty doing so on two different sites, both asp. Forwarded to PHP-General, John. If you're not already subscribed there, please

Re: [PHP-DB] php upload questions --move_uploaded_file

2008-06-26 Thread Daniel Brown
Hai, I'm forwarding this email over to the PHP-General list, since it's not database-related. If you're not already subscribed there, please subscribe and I'm sure you'll get some responses. ORIGINAL MESSAGE FOLLOWS: On Thu, Jun 26, 2008 at 6:21 AM, Liu, Hai Tao (Taylor) <[EMAIL PRO

Re: [PHP-DB] Recommended web developers

2008-06-24 Thread Daniel Brown
On Tue, Jun 24, 2008 at 3:45 PM, Ken Keefe <[EMAIL PROTECTED]> wrote: > I'm a little surprised no one else has commented on this, but for a > website that complicated, 10k is way too low. I actually did this morning, but the message included other information (no advertisement or offers or any

[PHP-DB] bcrypt ideas

2008-06-08 Thread Daniel
Hey folks, I was just wondering if anyone has tried to write a bcrypt cypher script in php (in a similar fashion to php pear's 'crypt_blowfish') - my experience with compiling suhosin (which includes the one-way crypt_blowfish used in bcrypt) hasn't been pretty and I'm wondering whether a

[PHP-DB] Re: [PHP] question, about mysql query

2008-06-03 Thread Daniel Brown
This isn't a PHP question at all. It's a MySQL question. However, answers are below, with forwards to the appropriate lists for archiving purposes. On Mon, Jun 2, 2008 at 9:19 PM, LKSunny <[EMAIL PROTECTED]> wrote: > two table, tablea and tableb > tablea > uid, col1, col2, col3 > 1,xx, xx

Re: [PHP-DB] Parse error: syntax error, unexpected T_ELSE

2008-04-16 Thread Daniel Brown
On Tue, Apr 15, 2008 at 5:56 PM, Javier Viegas <[EMAIL PROTECTED]> wrote: > Thanks Daniel i ´ve removed the unexpected else secction. Now it works but > it tells me that there might be a syntax error on the query, this is good > news because now i know i´m having connection with t

Re: [PHP-DB] Parse error: syntax error, unexpected T_ELSE

2008-04-15 Thread Daniel Brown
On Tue, Apr 15, 2008 at 4:49 PM, Javier Viegas <[EMAIL PROTECTED]> wrote: > Hi, i have this script wich basically connects to a database and delete a > record according to the Id parameter given. The problem is that when i test > it i get this error: > > *Parse error*: syntax error, unexpected T

[PHP-DB] Re: [Stored Procedure] - Error handling

2008-04-15 Thread Daniel Brown
Ratheesh, There's a specific list for PHP database functions, "Databases and PHP" (PHP-DB), which you can find at http://php.net/mailinglists . I'm forwarding your message over to there, and recommend that you subscribe to that list. You'll probably get more direct responses by narrowing-

Re: [PHP-DB] Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019

2008-04-09 Thread Daniel Brown
On Wed, Apr 9, 2008 at 5:09 PM, A. Joseph <[EMAIL PROTECTED]> wrote: > The question is. > > Some nestled calculation. > How did club freedom did the calculation, or how will the database structure > looks like? > > *The example is -: * > > *Joseph* gave birth to *John*, *James,* and *Johnson*

[PHP-DB] Re: [PHP] joins issues again

2008-04-08 Thread Daniel Brown
On Tue, Apr 8, 2008 at 7:28 AM, Steven Macintyre <[EMAIL PROTECTED]> wrote: > Hi all, > > I have the following SQL statement; > > SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID > FROM sales > LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid > L

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Daniel Brown
On Tue, Mar 25, 2008 at 1:14 PM, Jason Pruim <[EMAIL PROTECTED]> wrote: > > the actual query I'm using is this: > > $chpwsql = "UPDATE current SET customerName='$customerName', > loginName='$loginName', loginPassword='$PW', email='$email', > adminLevel='$adminLevel' WHERE Record='$Record

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Daniel Brown
On Tue, Mar 25, 2008 at 12:59 PM, Jason Pruim <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I am attempting to update a record for a login system while leaving > certain fields untouched if they arn't changed, and am running into > issues. [snip!] > > I have tried this code: > $

Re: [PHP-DB] HTML & CSS (Off Subject) 911 Help! :-)

2008-03-25 Thread Daniel Brown
On Tue, Mar 25, 2008 at 12:24 AM, Karl James <[EMAIL PROTECTED]> wrote: [snip!] > > I need some help on formatting issues. [snip!] > > Right now the page looks like this. > [snip!] > http://www.theufl.com/2003/reports/rosters/fantasyrosters.htm [snip!] > > It is almost, their. However, as you c

Re: [PHP-DB] ini_set ...

2008-03-21 Thread Daniel Brown
On Fri, Mar 21, 2008 at 10:20 AM, VanBuskirk, Patricia <[EMAIL PROTECTED]> wrote: > > I have the line "ini_set('display_errors', 'on');" in my code, but it is > not working. Does it need to be the first command on the page? [merge] > I have full access to the php.ini file, which is what I do no

[PHP-DB] Re: [PHP] Fastest way to get table records' number

2008-03-19 Thread Daniel Brown
On Wed, Mar 19, 2008 at 1:19 PM, Andrew Ballard <[EMAIL PROTECTED]> wrote: > On Wed, Mar 19, 2008 at 1:04 PM, TG <[EMAIL PROTECTED]> wrote: > > > > It seems that count(*) pulls all the data from the row then performs a > count > > increment whereas count(did) only pulls the 'did' column. > >

[PHP-DB] Re: [PHP] question about php with sql database

2008-03-19 Thread Daniel Brown
Again, another question better-asked on the PHP-DB list, so it's being CC'd there. Responses in-line On Wed, Mar 19, 2008 at 1:08 AM, Sudhakar <[EMAIL PROTECTED]> wrote: > instead of using mysql database which is conventionally used as database > with php, if sql server database is used

[PHP-DB] Re: [PHP] Fastest way to get table records' number

2008-03-19 Thread Daniel Brown
On Tue, Mar 18, 2008 at 11:43 PM, Shelley <[EMAIL PROTECTED]> wrote: > Hi all, > > What do you think is the FASTEST sql to get the total number of a table > with millions of records? That question would be better on the PHP-DB list, so for archive's sake, I'm CC'ing that list. $sql = "S

Re: [PHP-DB] str_replace removing unwanted characters...

2008-02-29 Thread Daniel Brown
'"', "-", "number",

Re: [PHP-DB] Query table / results to an array

2008-02-29 Thread Daniel Brown
On Fri, Feb 29, 2008 at 12:22 AM, Ron Piggott <[EMAIL PROTECTED]> wrote: > $reference_number = mysql_result($search_result,$i,"reference_number"); > $description = mysql_result($search_result,$i,"description"); Just mind the line-wrapping in this mess

Re: [PHP-DB] SELECT query with multiple "WHERE" Clause

2008-02-27 Thread Daniel Brown
,fieldX FROM tableName WHERE (colA='value' OR colB LIKE 'Hello%') AND colC='Active'; -- Daniel P. Brown Senior Unix Geek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-27 Thread Daniel Brown
unique key. Just a thought. ;-P For all other intents and purposes, however, you're 100% correct. Using a unique auto_increment key would be your best bet. -- Daniel P. Brown Senior Unix Geek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Password Reset

2008-02-27 Thread Daniel Brown
ed. Blowfish, Twofish, DES, et cetera. Hash:CAN NOT be "de-hashed". MD5, SHA1, *nix salts, et cetera. -- Daniel P. Brown Senior Unix Geek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Daniel Brown
our comments are highly appreciated. Ask on a MySQL list. It has nothing to do with PHP. http://lists.mysql.com/ Specifically: Replication - http://lists.mysql.com/replication -- Daniel P. Brown Senior Unix Geek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] INSERT query with Primary and foreign key

2008-02-26 Thread Daniel Brown
What's your SQL query string, Nasreen? -- Daniel P. Brown Senior Unix Geek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Daniel Brown
particular record that holds the password value entered. Henry (AKA: "Max"), Try this: Password: Date of birth (mm/dd/): Status: Married Single Widowed Divorced Wishing I Was Single -- Danie

Re: [PHP-DB] How to recognize which 'case' is being echoed by switch statement

2008-02-22 Thread Daniel Brown
code included a case/switch piece. This is probably what you mean: "; break; case "portfolio.php": $css = ""; break; case "whoweare.php": $css = ""; break; default: $css = ""; br

Re: [PHP-DB] Best ORM?

2008-02-19 Thread Daniel Brown
ack and ask any questions you need to clarify. -- Daniel P. Brown Senior Unix Geek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Uploading Image using PHP and mySQL

2008-02-19 Thread Daniel Brown
problem here. Read up about that on the > phpsec.org site: > > http://phpsec.org/projects/guide/3.html#3.2 > > and a really good basic guide here: > > http://unixwiz.net/techtips/sql-injection.html And in addition to the links Chris suggested, also RTFM on mysql_real_escape_strin

Re: [PHP-DB] Uploading Image using PHP and mySQL

2008-02-19 Thread Daniel Brown
oadedImage','$url_provided')"; > > You have an sql injection problem here. Read up about that on the > phpsec.org site: > > http://phpsec.org/projects/guide/3.html#3.2 > > and a really good basic guide here: > > http://unixwiz.net/techtips/sql-injection

  1   2   3   4   >