Re: [PHP-DB] Subject Matter

2013-08-27 Thread Daniel Brown
On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt tijn...@gmail.com wrote: The problem is: there is no maintainer;) Sure there is. -- /Daniel P. Brown 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 Tue, Aug 27, 2013 at 12:10 PM, Matijn Woudt tijn...@gmail.com wrote: Uh, you're right. I meant moderator.. Yeah, as far as moderation, we only do in extreme circumstances. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List

Re: [PHP-DB] Gnome Desktop Button

2012-11-27 Thread Daniel Brown
On Tue, Nov 27, 2012 at 5:31 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com 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-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 js...@yahoo.com 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

Re: [PHP-DB] Unsubscribe me please

2012-09-21 Thread Daniel Brown
On Thu, Sep 20, 2012 at 9:29 PM, Alan Vickers alanvick...@cox.net 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. -- /Daniel P. Brown

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Daniel Brown
On Wed, Sep 19, 2012 at 6:43 PM, Graham H. mene...@gmail.com 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

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Daniel Brown
On Thu, Sep 20, 2012 at 11:51 AM, Valentin Nedkov mana...@bds.bg 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

Re: [PHP-DB] Unsubscribing

2012-09-11 Thread Daniel Brown
On Tue, Sep 11, 2012 at 3:37 AM, Aaron Wood - Slurpy Studios aa...@slurpystudios.com 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

[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, s@optusnet.com.au 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

Re: [PHP-DB] MOD_Rewrite

2011-09-20 Thread Daniel Brown
On Tue, Sep 20, 2011 at 17:01, Gavin Chalkley gavin.chalk...@gmail.com 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

Re: [PHP-DB] MSsql madness

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

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

2011-05-05 Thread Daniel Brown
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com 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

Re: [PHP-DB] testing

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

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 ron.pigg...@actsministries.org 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

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 li...@euca.us 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 never

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 naz...@jhu.edu 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

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 li...@euca.us 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. -- /Daniel P. Brown Network

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 li...@euca.us 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

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 gavin.chalk...@gmail.com 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

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 michaelgmann...@gmail.com 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

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

2011-01-06 Thread Daniel Brown
On Thu, Jan 6, 2011 at 02:52, Miriam Natanzon miriamna...@gmail.com 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

Re: [PHP-DB] Word Matching Application

2011-01-05 Thread Daniel Brown
On Wed, Jan 5, 2011 at 21:23, Ron Piggott ron.pigg...@actsministries.org wrote: I only know how to do one array at a time, using FOREACH, like this: === echo ul\r\n;    foreach($match_words as $word) {        echo li . $word . /li\r\n;    } echo /ul\r\n; === You could either swap

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

2010-12-31 Thread Daniel Brown
On Fri, Dec 31, 2010 at 09:11, Ethan Rosenberg eth...@earthlink.net 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

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

2010-12-31 Thread Daniel Brown
On Fri, Dec 31, 2010 at 12:05, Dmitriy Ugnichenko mitya.ugniche...@gmail.com 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. -- /Daniel P. Brown Network Infrastructure

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 eth...@earthlink.net 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.

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

2010-12-29 Thread Daniel Brown
On Wed, Dec 29, 2010 at 04:57, Hajo Locke hajo.lo...@gmx.de 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

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

2010-12-20 Thread Daniel Brown
On Sat, Dec 18, 2010 at 17:02, David Hutto smokefl...@gmail.com 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

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

2010-12-17 Thread Daniel Brown
On Fri, Dec 17, 2010 at 11:38, Ethan Rosenberg eth...@earthlink.net 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

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

2010-12-17 Thread Daniel Brown
On Fri, Dec 17, 2010 at 12:16, Richard Quadling rquadl...@gmail.com 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

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Daniel Brown
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg eth...@earthlink.net 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

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Daniel Brown
On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg eth...@earthlink.net 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

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Daniel Brown
On Tue, Dec 14, 2010 at 13:43, Toby Hart Dyke t...@hartdyke.com 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. -- /Daniel P. Brown Network Infrastructure

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

2010-11-10 Thread Daniel Brown
On Wed, Nov 10, 2010 at 10:03, Ron Piggott ron.pigg...@actsministries.org 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

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

2010-11-10 Thread Daniel Brown
On Wed, Nov 10, 2010 at 10:16, Ron Piggott ron.pigg...@actsministries.org 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.

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread Daniel Brown
On Fri, Nov 5, 2010 at 08:13, Lester Caine les...@lsces.co.uk 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

Re: [PHP-DB] php_warn

2010-02-11 Thread Daniel Brown
On Thu, Feb 11, 2010 at 08:49, madunix madu...@gmail.com 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

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.comh...@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

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

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 16:53, Govindagovinda.webdnat...@gmail.com 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

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

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 17:24, Govindagovinda.webdnat...@gmail.com 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 P. Brown daniel.br...@parasane.net || danbr...@php.net

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

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 19:28, Govindagovinda.webdnat...@gmail.com 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());  

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

2009-07-13 Thread Daniel Brown
On Mon, Jul 13, 2009 at 20:17, Govindagovinda.webdnat...@gmail.com 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

Re: [PHP-DB] Checking Special Characters

2009-07-11 Thread Daniel Brown
On Sat, Jul 11, 2009 at 02:41, Manu Guptamanugu...@gmail.com 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(),

[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 Carsonja...@jasoncarson.ca 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

Re: [PHP-DB] PHP- Mysql problem

2009-06-18 Thread Daniel Brown
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAHnsivasut...@live.com 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

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.

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

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 can

[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

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

[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, 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 the database but also

[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

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_ELSE

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

[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 LEFT JOIN

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

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: $tab = \t;

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='$Record1';

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

[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 = SELECT

[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 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. Again, I

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); ? $sql = SELECT reference_number FROM table WHERE this='whatever' OR that NOT LIKE

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

2008-02-29 Thread Daniel Brown
On Fri, Feb 29, 2008 at 2:18 PM, VanBuskirk, Patricia [EMAIL PROTECTED] wrote: Someone from this list (sorry I cannot remember the name), a while back, gave me the following function to use to get rid of unwanted characters coming in on forms: function convert_smart_quotes($string) {

Re: [PHP-DB] Password Reset

2008-02-27 Thread Daniel Brown
On Wed, Feb 27, 2008 at 1:52 AM, Nasreen Laghari [EMAIL PROTECTED] wrote: Hi, I have encrypted password in database and I encrypted using MD5(). As it is a one-way Hash so I cant get password back to original text !!! What encrypting technique I used to encrypt password so if user

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

2008-02-27 Thread Daniel Brown
On Wed, Feb 27, 2008 at 9:52 AM, Tobias Franzén [EMAIL PROTECTED] wrote: Consider this, if you have not already: What if two users happen to have the same password? It is wrong to assume that no two users will never have the same password. Doing an update like that, just based on the

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

2008-02-27 Thread Daniel Brown
On Wed, Feb 27, 2008 at 6:44 PM, Nasreen Laghari [EMAIL PROTECTED] wrote: I am creating a SEARCH, by only using one table. The search form is same as Inserting item (search has form of all fields in table ), difference is SEARCH page doesnt have validation . Therefore user can enter

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

2008-02-26 Thread Daniel Brown
On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton [EMAIL PROTECTED] wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered

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

2008-02-26 Thread Daniel Brown
On Mon, Feb 25, 2008 at 8:15 PM, Nasreen Laghari [EMAIL PROTECTED] wrote: Hi, I need help to insert date into two tables when tables have primary and foreign key relationship using php. I tried simple INSERT query but foreign key colum is storing NULL. What's your SQL query string,

Re: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Daniel Brown
On Tue, Feb 26, 2008 at 10:49 AM, Lasitha Alawatta [EMAIL PROTECTED] wrote: Hello Everybody, We have 6 multi-master MySql instances within a LAN , that are replicating is a sequential manner. Server Environment : Six identical Linux Enterprise version 4 running, servers with having MySQL

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

2008-02-22 Thread Daniel Brown
On Fri, Feb 22, 2008 at 6:01 AM, Tim Daff [EMAIL PROTECTED] wrote: Hi, This is my first time using php in my site navigation, I have the code for all the pages in one file and I am using the switch statement to change between them. [snip!] None of your code included a case/switch

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

2008-02-19 Thread Daniel Brown
On Feb 18, 2008 6:56 PM, Chris [EMAIL PROTECTED] wrote: Which bit breaks exactly? Nobody's going to read through 200 lines of code.. Normally, you're right but today I did just to be a jerk and prove you wrong. ;-P Nasreen Laghari wrote: Hi All, First of all A very big thank

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

2008-02-19 Thread Daniel Brown
On Feb 18, 2008 6:56 PM, Chris [EMAIL PROTECTED] wrote: $query = INSERT INTO artist (name,about_u,imgdata, profile_url) VALUES('$aname','$aboutu','$uploadedImage','$url_provided'); You have an sql injection problem here. Read up about that on the phpsec.org site:

Re: [PHP-DB] Best ORM?

2008-02-19 Thread Daniel Brown
On Feb 19, 2008 5:46 PM, D Unit [EMAIL PROTECTED] wrote: Hi, I have an existing database and an existing set of classes. As my code base is growing, manually writing SQL to map between the two is getting old. My classes/database do not match up ActiveRecord style. Which is the best ORM for

Re: [PHP-DB] Password decryption

2008-02-17 Thread Daniel Brown
On Feb 16, 2008 10:17 PM, Nasreen Laghari [EMAIL PROTECTED] wrote: Hi, I'm junior in PHP and stuck on Encryption. I have encrypted password using SQL : $query = insert into user (userid,password,) values ('$username',Password('$pass'));; It's a one-way encryption method, so you won't

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Daniel Brown
On Feb 17, 2008 10:59 AM, Velen [EMAIL PROTECTED] wrote: Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the number with all the

Re: [PHP-DB] PHP help question

2008-02-13 Thread Daniel Brown
On Feb 13, 2008 10:52 AM, Rudy sleiman [EMAIL PROTECTED] wrote: To whom it may concern I'm working on a network, i don't have internet access and the application i'm working on is not published online. Platform used: PHP with MySQL. The Database is created on PC A... I'm working on PC B...

Re: [PHP-DB] Copying an image from one server to another

2008-02-05 Thread Daniel Brown
On Feb 5, 2008 9:49 AM, ioannes [EMAIL PROTECTED] wrote: OK but I could execute the script on the target server, which is also mine. So the jpg on the source is actually the remote server, I would be reading a remote file and writing it to the server which is executing the script. Then

Re: [PHP-DB] Copying an image from one server to another

2008-02-05 Thread Daniel Brown
On Feb 5, 2008 2:57 PM, ioannes [EMAIL PROTECTED] wrote: Am I right in thinking that exec() executes a string as a call to a program which executes in a shell? So am I to write: $callthis=the contents of my rsynch file; exec($callthis); Filtered :-\ -- /Dan Daniel P. Brown Senior

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Daniel Brown
On Feb 4, 2008 11:03 AM, Daniel Brown [EMAIL PROTECTED] wrote: On Feb 3, 2008 11:03 PM, Chris [EMAIL PROTECTED] wrote: FTP. There's no way fopen is going to be able to write to a remote url, that'd just be such a huge security issue it's not funny. I must've missed when the W3C

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Daniel Brown
On Feb 3, 2008 11:03 PM, Chris [EMAIL PROTECTED] wrote: FTP. There's no way fopen is going to be able to write to a remote url, that'd just be such a huge security issue it's not funny. I must've missed when the W3C and IETF forced a disable on POST. ;-P -- /Dan Daniel P. Brown Senior

Re: [PHP-DB] [Fwd: Kesalahan posting: Don Komo]

2008-01-31 Thread Daniel Brown
2008/1/31 Evert Lammerts [EMAIL PROTECTED]: Is anybody else getting similar emails after sending an email to the php-db list? I don't understand any of this 2006 google group with 5 members. Original Message Subject:Kesalahan posting: Don Komo Date: Thu, 31 Jan

Re: [PHP-DB] md5() function

2008-01-14 Thread Daniel Brown
On Jan 14, 2008 2:26 PM, Miguel Guirao [EMAIL PROTECTED] wrote: Hi!! I'm using the md5() function to encrypt a password and store it into a database. Now I want to retrieve that MD5 password and convert it into it's human readable condition. Is there a function opposite to md5()??

Re: [PHP-DB] forms and method POST - variables

2008-01-09 Thread Daniel Brown
On Jan 9, 2008 11:25 AM, Lukáš Moravec [EMAIL PROTECTED] wrote: Hi, I have one question about forms and php (which I use for Mysql too). Do I need for variables from any form in html and method POST (then in php script) to set these variables with: $variable=$_POST['variable']; [snip!]

Re: [PHP-DB] Another new PHP programmer question...

2008-01-04 Thread Daniel Brown
On Jan 3, 2008 3:56 AM, Ben Stones [EMAIL PROTECTED] wrote: Hello, Thank you for your help previously everyone, I was able to fix that problem. The thing now, is that I want to add smileys to the messages; i.e. :) would equal to a smiley image when posting a message. Where you want that,

Re: [PHP-DB] XSS

2007-12-26 Thread Daniel Brown
On Dec 26, 2007 3:05 PM, Mad Unix [EMAIL PROTECTED] wrote: Am facig problem with XSS cross Site scripting general on our web site, and i think its a coding issue since our dedicated server run Linux with apache mysql and php... any recommendation to resolve this issue Recode the site,

Re: [PHP-DB] What is country codes?

2007-12-20 Thread Daniel Brown
On Dec 20, 2007 3:09 AM, $$$jame [EMAIL PROTECTED] wrote: hi what is country codes Where can I find a database of country codes? I came across this really cool website called Google, where I can find all kinds of things! Country codes are generally the ISO two-letter representations

Re: [PHP-DB] Credit Card Encryption

2007-12-20 Thread Daniel Brown
On Dec 19, 2007 11:59 PM, Bastien Koert [EMAIL PROTECTED] wrote: I take the view that I warn our customers about the dangers, and if really concerning ask for an indemnity or a very formal request for change. I really try to convince them of the correct path and keep any emails regarding the

Re: [PHP-DB] Credit Card Encryption

2007-12-19 Thread Daniel Brown
On Dec 19, 2007 2:41 AM, Keith Spiller [EMAIL PROTECTED] wrote: Ok I've done some research and some thinking. What about storing orders in the database (product info and customer info) and then using GnuPG or PGP to send the credit card info to the merchant? This way the credit card

Re: [PHP-DB] Credit Card Encryption

2007-12-19 Thread Daniel Brown
On Dec 19, 2007 4:45 PM, Bastien Koert [EMAIL PROTECTED] wrote: Nope, I still would not recommmend it. The only place the CC data should travel to is the payment gateway. Anything else is a security risk. Why does your client process by hand? They should be using a payment gateway.

Re: [PHP-DB] force to download file

2007-12-17 Thread Daniel Brown
On Dec 17, 2007 3:13 PM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi all, i have this on top of my php page: header(Content-Type: application/vnd.ms-excel); header(Content-Disposition: inline; filename=excelfile.xls); but it is not prompt to save the file instead it opens right in IE. my

Re: [PHP-DB] Form mail() problem

2007-12-10 Thread Daniel Brown
On Dec 10, 2007 1:05 AM, Tim Daff [EMAIL PROTECTED] wrote: [snip!] Here is the error code I am getting: Warning: mail() [function.mail]: SMTP server response: 550 5.7.1 Unable to relay for [EMAIL PROTECTED] in C:\Domains\logosunlimited.com.au \wwwroot\contact\processquote3.php on line 284