Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Peter Beckman
hp.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter Beckman

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread Peter Beckman
he query: mysql> select count(*) from numbers where 3 and num like '1212%'; +--+ | count(*) | +--+ | 42 | +--+ Beckman ---

Re: [PHP-DB] Multiple Database Connection Using Prepard Statements

2012-05-19 Thread Peter Lind
gt; I want to connect to $database1 without loosing my $database3 connection > > Thoughts?  Comments? > Create a new PDO object with the connection details you need? Regards Peter -- WWW: plphp.dk / plind.dk LinkedIn: plind BeWelcome/Couchsurfing: Fake51 Twitter: kafe15 -- PHP Databa

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-11 Thread Peter Lind
out how bitmasks differ, then yes, you're very confused. It's a bitmask, summing plays no role. Rest assured that set will know the difference between different kinds of content in the column. Regards Peter -- WWW: plphp.dk / plind.dk LinkedIn: plind BeWelcome/Couchsurfing: Fake51 Twitter:

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-10 Thread Peter Lind
On Jan 11, 2012 7:13 AM, "Karl DeSaulniers" wrote: > > > On Jan 10, 2012, at 10:49 PM, Karl DeSaulniers wrote: > >> >> On Jan 10, 2012, at 9:30 AM, B. Aerts wrote: >> >>> On 08/01/12 23:35, Karl DeSaulniers wrote: On Jan 8, 2012, at 10:36 AM, Bastien wrote: > > > On

Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 22:38, Chris Stinemetz wrote: >> >> Yes, debug your code and figure out why it's looping twice instead. >> For instance, try the other query in the mysql console. >> > > Thank you! It was the first query. I put a LIMIT 1 on it and now it is > working correctly. I appreciate your h

Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 22:25, Chris Stinemetz wrote: >> >> Your php code had more than one query running (one inside the other). >> It's the outer query that runs twice, not the inner one returning >> double the results >> > > > Thanks Peter, > &

Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Peter Lind
> > When I dump the query and run it in console I get the results I want. Not > sure what I am doing wrong. Your php code had more than one query running (one inside the other). It's the outer query that runs twice, not the inner one returning double the results -- WWW: plphp.dk / plind.dk Link

Re: [PHP-DB] foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 21:23, Chris Stinemetz wrote: > > > >> > > > > What does your result look like? Hard to say what the problem is > > without seeing the result. > > > > I am echoing the query and printing the get array just for debugging > purposes, but below you can see how it is repeating its' s

Re: [PHP-DB] foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 20:49, Chris Stinemetz wrote: >> >> Is users.user_id unique? >> > > yes it is. > What does your result look like? Hard to say what the problem is without seeing the result. -- WWW: plphp.dk / plind.dk LinkedIn: plind BeWelcome/Couchsurfing: Fake51 Twitter: kafe15 -- PHP Da

Re: [PHP-DB] foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 20:31, Chris Stinemetz wrote: > Okay. I am pretty new to mysql so this may seem like a ridiculous > question to some people. > > I am trying to use a LEFT JOIN query, but the results I am finding > unusual. For every record occurrence there is for the query, the > results are dupl

Re: [PHP-DB] Left Join

2011-08-07 Thread Peter Lind
Maybe it's just me, but I can't see anything that would work as foreign key for you to join on - neither table seems to have a foreign key On 7 August 2011 21:53, Chris Stinemetz wrote: > I am tyring to build a query that will take the most recent > "stores.store_date" column then join it with "s

Re: [PHP-DB] mysql_num_rows == 0

2011-05-30 Thread Peter Lind
new value is entered. no > mysql_error msg. bla bla or die("more bla"); is a very bad way of handling error checks. In your particular case, your foot has been shot off because mysql_num_rows will return 0 (no rows match the query) and thus the die() is executed - but of course the

Re: [PHP-DB] printf

2010-10-28 Thread Peter Lind
Mysql doesn't have a printf function Regards Den 2010 10 29 00:47 skrev "Ethan Rosenberg" : > Dear List - > > I am afraid that I am missing something in a major way. > > mysql> printf("%b %d %f %s\n", 123, 123, 123, "test"); > ERROR 1064 (42000): You have an error in your SQL syntax; check the

Re: [PHP-DB] products order

2010-09-29 Thread Peter Lind
On 29 September 2010 14:00, Emiliano Boragina wrote: > Hello, > > A client wants to control the order, the position of the products he > load. How do I do this? > You store positional data per product, defaulting to no priority in position. Regards Peter -- WWW: http://

Re: [PHP-DB] how to explain such a regular syntax

2010-08-12 Thread Peter Lind
ressions. Try consulting http://www.regular-expressions.info/ or get a good book on the topic like Mastering Regular Expresssions by Jeffrey Friedl. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind BeWelcome/Couchsurfing: Fake51 Twitter: http://twit

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Peter Lind
ovide the input that is actually sent to mysql. Look at the error code: "... for the right syntax to use near 'Brien', 'Class registration confirmation', ' This email '" - "Class registration confirmation" does not appear anywhere in the output section you posted but it appears in the mysql error. I'd do as Bret suggested and turn on query logging in mysql to see what is actually received. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind BeWelcome/Couchsurfing: Fake51 Twitter: http://twitter.com/kafe15 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Peter Lind
   257, >    'Brian O\'Brien',NULL, >    '612-456-5678', >    'paul_s_john...@mnb.uscourts.gov' > ) > 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 > 'Brien', 'Class regis

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Peter Lind
ow what exactly this means. > > Best, > Guru. > It means that either the password you're using is wrong or the user doesn't have access to the DB server (the user doesn't exist or doesn't have the proper rights). Regards Peter -- WWW: http://plphp.dk / http://plind

Re: [PHP-DB] Session start

2010-05-14 Thread Peter Lind
n.html"); > exit; > } > > But that did not work? Please I am stuck for ideas? > Read the manual on session_destroy. Specifically, if you want to complete destroy the session, unset the session cookie as well. On a separate note: why do you care if the session has started or not?

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Peter Lind
On 1 May 2010 11:00, Karl DeSaulniers wrote: > Thank you Peter... again.. :) > Which would be the source field and which the target field? You place the constraint on the table that has the foreign key. Using your example: Table 1 = products * id = primary key Table 2 = producto

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Peter Lind
dual options and some group options - these have nothing to do with each other and you need to be able to set them without regard for each other. 2. Remove the productOptionID from the product options table. A product only has option groups, no individual options. 3. Remove the groupOptionID fro

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Peter Lind
On 30 April 2010 20:49, Karl DeSaulniers wrote: > No, please confuse me. I need to know this stuff. > > @Peter thanks for that introduction to foreign keys. Since my productoptions > table is based off of items in products, optionGroups and options, would I > use foreign keys for t

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Peter Lind
On 30 April 2010 13:41, DZvonko Nikolov wrote: > > Hi, > > don't confuse the guy. Don't talk down to the man. He asked questions and got usable answers including links to where he could find more info. -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr:

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Peter Lind
On 30 April 2010 12:26, Karl DeSaulniers wrote: > Thanks Peter. > So what is the logic behind foreign keys? Why use them? Constraints. When using, for example, the InnoDB engine in MySQL, you can set foreign key fields on tables. These ensure that your record will always be bound to a

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Peter Lind
tables with the SELECT syntax: SELECT table1.blah, table2.blah FROM table1, table2 WHERE table1.id = table2.foreign_key; Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing:

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
nly need *ONE* row containing your *TWO* fields. mysql_fetch_assoc() retrieves that *ONE* row from a MySQL result set as an array - so having those two while statements will do you no good. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
if($benutzername == $dbbenutzer && $pass == $dbpasswort){ This would work but only if you're storing passwords in the database in clear text - which is a Bad Thing and should be avoided. Hash the passwords before storing and compare with a hashed version, not the cleartext. Regards Peter --

Re: [PHP-DB] Fwd: Apache log: database shutdown

2010-04-20 Thread Peter Lind
0/ I'd guess it's a bad connection between Apache and your DB - or Apache dropping the connection for some other reason. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Co

Re: [PHP-DB] Fwd: Apache log: database shutdown

2010-04-20 Thread Peter Lind
t; 4) Go back to point 1) > > > I have no idea what is going on. Any help will be appropriated. Have you checked the database logs? Just a thought. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL vs. Session array

2010-04-07 Thread Peter Lind
On 8 April 2010 00:13, 3dgtech wrote: > Quick question. I have an AJAX component that fires a "like" query for each > "key up" event (since it's a like % query there is no indexing or caching > possible). While everything works fine, I was contemplaining downloading the > ~1500 rows into a session

Re: [PHP-DB] Random pick

2010-01-25 Thread Peter Beckman
eful though -- sometimes 0 will be returned on a failure, depending on your SQL. Beckman --- Peter Beckman Internet Guy beck...@angryox.com http://www.angryox.com/ -

Re: [PHP-DB] Random pick

2010-01-25 Thread Peter Beckman
if (in_array($req_user_level, array(0,1,2,3,4,5,6,7,8,9,"Guest",...))) { // do stuff } --- Peter Beckman Internet Guy beck...@angryox.com http://www.angryox.com/ --

Re: [PHP-DB] Authenticating user using a web service

2009-01-23 Thread Peter Beckman
help. --- Peter Beckman Internet Guy beck...@angryox.com http://www.angryox.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubs

Re: [PHP-DB] MySQL query executes outside of PHP, but not in PHP

2009-01-23 Thread Peter Beckman
{ This will always result in TRUE, as the assignment will always succeed. Change it to: if (($result = $client2->use_result())) { (added parenthesis) What DB library are you using? --- Peter Beckman

Re: [PHP-DB] php crashes on mysql_connect

2008-12-11 Thread Peter Degen-Portnoy
Thanks, Chris. - Peter On Fri, Dec 12, 2008 at 1:10 AM, Chris wrote: > Peter Degen-Portnoy wrote: > >> Hi Folks, >> >> I've been banging against this for a while and have narrowed it down to a >> completely repeatable and tiny test case. >> > >

[PHP-DB] php crashes on mysql_connect

2008-12-11 Thread Peter Degen-Portnoy
certain that it had to do with an old libmysql.dll on my path, until I tracked the bugger down and eliminated it, but to no avail. Thanks in advance for your thoughts. Yours, Peter

[PHP-DB] Re: A very basic PHP question

2008-04-25 Thread Peter Westergaard
I'm not sure this has to do with Variable Scope. (Scope has to do with when you can or can't reference a variable ... for example, that you may have defined in a different function than the currently-running code). I don't actually understand your question that well, either. Can you elaborat

[PHP-DB] Re: php and mssql on seperate servers

2008-04-24 Thread Peter Westergaard
Rick Taylor wrote: I'm new to PHP and having issues. We have seperate servers for them. We can use ODBC to test the connection and it works fine. However, when we try to run the site we get a message of *** Error: Unable to Connect to Database. Please Try Again Later. *** We are using a cu

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

2008-03-19 Thread Peter Westergaard
Oops, I'm sorry, recovering from a 102 fever the other day. :) You don't want duplicate field IDs anywhere, really. The hidden fields are probably completely unnecessary; what do you use them for? It's the latter section you really need to correct, however, where each data field's name is b

[PHP-DB] Re: php-db Digest: Sending multiple values from a form having same field names.

2008-03-19 Thread Peter Westergaard
Your line : Should probably be: So that each field's name isn't the string "field_id", but rather is each field's unique ID. Hi, How can I send multiple values from a form to be stored in a database, as name of the fields is the same? For example: "; } elseif ($dataty

[PHP-DB] Re: A little SQL help

2008-01-31 Thread Peter Westergaard
Bastien, I think it would help if you described what result you were expecting, what version of SQL you're using, and where your error is occurring. I'm going to assume you're looking for a list of tours (including event start and end dates, event name, and result) for a specific angler (in

[PHP-DB] Re: php-db Digest 14 Jan 2008 19:48:27 -0000 Issue 3947

2008-01-14 Thread Peter Westergaard
x27;t figure out the passwords of users. A hash is a little like a checksum. Two files can have the same checksum even if they're completely different files. But good luck to you if you want to CREATE a file with a specific checksum. -Peter Is there a function opposite to md5(

[PHP-DB] Re: Beginners Problem

2008-01-08 Thread Peter Westergaard
Ben, I would say that the only reason $select_sql_two = mysql_query($select_sql); if($select_sql_two) { would refuse to execute is if $select_sql represents an invalid SQL statement. Whether it has records or not, you should (if I'm not very much mistaken) get a resource returned in sele

[PHP-DB] pdo_firebird: PDOStatement->closeCursor

2007-11-12 Thread Hans-Peter Oeri
Hi! I fell out of bed as I noticed that PDOStatement->closeCursor is not implemented for pdo_firebird. Again, I'm not a php guru, but patched my version with the attached diff. HPO --- php5-orig/ext/pdo_firebird/firebird_statement.c 2007-11-12 21:54:13.0 +0100 +++ php5/ext/pdo_fireb

[PHP-DB] pdo_firebird: "RETURNING" patch (Bug #43246)

2007-11-12 Thread Hans-Peter Oeri
Hi! I have bug #43246 open and just posted a "patch comment" there. As I don't know how to (or cannot) upload patches in the bug system. The problem is: Queries ending in "RETURNING ..." get qualified as stored procedure calls. Contrary to the docs, the PDOStatement->execute call is returning the

[PHP-DB] Job : Looking for a php / mysql programmer in or near Birmingham uk.

2007-10-23 Thread peter lovatt
would consider a freelancer or full time employee, rates - generous for the right person. Peter

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

2007-10-11 Thread peter lovatt
much delay. You could always try both permutations and see, but that has been my experience. Peter On 12/10/2007, Chris <[EMAIL PROTECTED]> wrote: > > Tony Grimes wrote: > > Have any of you tried running a PHP website using a remote database > > connection? > > >

Re: [PHP-DB] First and Last ID of a table

2007-07-11 Thread Peter Beckman
Just something I figured out recently :) or use select min(id) min, max(id) max from mytable then access as $array['min'] and $array['max'] --- Peter Beckman

Re: [PHP-DB] A good PHP Ajax tutorial

2007-02-25 Thread Peter Beckman
. --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http

Re: [PHP-DB] Access denied for user...sometimes???

2007-02-21 Thread Peter Beckman
]/[page]/[on]/[server]/index.php on line 66 This leaves the question: since MySQL is behaving normally otherwise, I'm using a host of '%' and my IP isn't changing, does anybody know what the problem is with PHP??? TIA, James flush privileges

php-db@lists.php.net

2007-02-12 Thread Peter Beckman
a reference to a variable that doesn't exist, but the expected result is a warning/error, not for PHP to populate an array. we should cross check again. I don't know what you mean. --- Peter Beckm

php-db@lists.php.net

2007-02-12 Thread Peter Beckman
t a reference to a variable that doesn't exist, but the expected result is a warning/error, not for PHP to populate an array. Beckman ------- Peter Beckman

Re: [PHP-DB] Session Problem

2007-01-11 Thread Peter Beckman
ll the web server & MySQL, but it still not running... Please advice... Thanks & Regards, Anita --- Peter Beckman Internet Guy [EMAIL PROTECTED]

[PHP-DB] This won't work in MySQL 4.1.10

2006-12-27 Thread Peter Karlsson
> 0.2 ORDER BY relevance DESC Best regards, Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL SQL Query Help

2006-11-13 Thread Peter Beckman
Notice how 3459 is supposed to be green but reports brown, and 345 should be yellow but reports red? Any other solutions that maintain row integrity? Beckman Miguel Guirao wrote: select max(bar) from mytable where unique fkid order by bar asc as far as I remember!! -Original Message-

[PHP-DB] MySQL SQL Query Help

2006-11-13 Thread Peter Beckman
ts, bar is a varchar. Beckman --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ --- -- P

RE: [PHP-DB] Direct Access to an Array Item?

2006-08-09 Thread Peter Beckman
query and outside of. Your solution is valid, but not what I'm looking for. --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purpleco

[PHP-DB] Direct Access to an Array Item?

2006-08-08 Thread Peter Beckman
ent; I am addicted to trying to cut down the amount and complexity of code. Even if you disagree with my goal as good computing practices, I simply want to know if what I ask is possible, and if so, how. :-) Beckman --

Re: [PHP-DB] detecting negative numbers

2006-07-16 Thread Peter Beckman
nt < 0) { echo "You don't have that many!"; } --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ -

[PHP-DB] spell checking and "did you mean?"

2006-03-23 Thread peter lovatt
eturns "did you mean seat ?" Any suggestions which is best - SOUNDEX in MySql or the php functions levenshtein(), soundex(),metaphone() or similar_text() on the returned result. Any other suggestions welcome. Thanks Peter -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Text file (rw) question...

2006-03-14 Thread Peter Beckman
t/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter Beckman Internet Guy [EMAIL PROTECTED]

Re: [PHP-DB] Re: Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-06 Thread Peter Beckman
On Fri, 6 Jan 2006, Dan Baker wrote: "Peter Beckman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. I'm also thinking about how t

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-06 Thread Peter Beckman
On Fri, 6 Jan 2006, Neil Smith [MVP, Digital media] wrote: Peter Beckman wrote: So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. Yes yes, lawsuits, scary, etc. I'm glad you're so blase about this an

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Peter Beckman
t leaves things unreversable, and if someone got a hold of your data AND your code, they could reverse-engineer... It seems security is only as good as your weakest link -- obscure code, private key, etc... Beckman --

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Peter Beckman
On Thu, 5 Jan 2006, John Meyer wrote: Peter Beckman wrote: So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. Why, is the first question I would ask you. So I'm thinking about how to save credit card numbers

[PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread Peter Beckman
#x27;m thinking some abstract process in code, or something -- security through obscurity. Beckman --- Peter Beckman Internet Guy [EMAIL PROTECTED]

[PHP-DB] RE: Really dumb Question - Select Many & Display Records

2005-09-03 Thread Peter Justus
hope there is somebody that can help me, and do forgive me if this seems to be a really noob question, but im pulling my hair out here! Regards Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pre-Include File -- Global Include Pre/Post by filename

2005-04-05 Thread Peter Beckman
Dear Peter -- Had you waited two more minutes to post (after looking for only a paltry 47 minutes), you would have found the auto_prepend_file and auto_append_file php.ini configuration directives which do what you want. Though it is a little difficult to find them on the PHP site, and Google

[PHP-DB] Pre-Include File -- Global Include Pre/Post by filename

2005-04-05 Thread Peter Beckman
executed. Was this depreciated, or does it still exist? I can't remember what to call it, and I can't seem to find the right page in the manual. Any help? Beckman --- Pet

[PHP-DB] Content Management

2005-03-22 Thread Peter Westergaard
needs aren't very complicated. Anyone have any practical experience to share? Apologies if this has been rehearsed a thousand times before, I see discussions pop up in the archive but they never seem to come to a concensus so I'm going to risk asking again... -P -- Peter @ westergaard .

[PHP-DB] Re: Double Inserts

2005-02-02 Thread Peter K. Lee
submit to happen twice. The double insert has vanished since. See if your page is getting posted twice for whatever reason. -Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] last record

2005-01-24 Thread Peter Lovatt
hi using mysql as you describe is probably the most elegant and efficient way to do it is there a reason for asking php to do it? Peter > -Original Message- > From: neil [mailto:[EMAIL PROTECTED] > Sent: 25 January 2005 03:12 > To: php-db@lists.php.net > Subject: [PHP-

RE: [PHP-DB] i am lost (php warning)

2005-01-18 Thread Peter Lovatt
* FROM cm_customer WHERE email='$user'"); if you add an error trap it makes this knd of thing easier to spot $sql_query = mysql_query("SELECT * FROM cm_customer WHERE email='$user'") or die(mysql_error()); HTH Peter > -Original Message-

RE: [PHP-DB] Security Question

2005-01-17 Thread Peter Lovatt
Hi The page/form will be requested over a non secure connection. When the form is submitted the browser establishes a secure connection to the server and then sends the data, so the data is sent securely. Peter > -Original Message- > From: Micah Stevens [mailto:[EMAIL PRO

RE: [PHP-DB] Security Question

2005-01-16 Thread Peter Lovatt
t the login page on a non secure server but post the form to a secure server. Peter > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: 17 January 2005 02:46 > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Security Question > > >

RE: [PHP-DB] Help in learning PHP and MySQL

2004-12-31 Thread Peter Lovatt
enable it, edit php.ini - find the reference to php_mysql.dll and remove the ; which comments it out ) Peter > -Original Message- > From: Novice Learner [mailto:[EMAIL PROTECTED] > Sent: 31 December 2004 03:35 > To: php-db@lists.php.net > Subject: [PHP-DB] Help in learnin

Re: [PHP-DB] Site optimization

2004-12-28 Thread Peter Jay Salzman
On Tue 28 Dec 04, 12:11 PM, Joseph Crawford <[EMAIL PROTECTED]> said: > i was wondering this as well :D > > are there any tools out there to simulate high traffic on your web > server say where you specify how many users hit the site at one time > and the tool actually hits your server that many t

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 > > > > > > > > and saved . > > > > but when i run this file and click on submit butt

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread Peter Jay Salzman
On Mon 27 Dec 04, 8:48 PM, S Kumar <[EMAIL PROTECTED]> said: > Hello Pete: > > However, in the case of checkboxes, I do not know how > to make variables out of them depensing on what user > selects. Say whatever user cheks in the checkbox, > that variable has to be searched in TABLE-C and > vari

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread Peter Jay Salzman
On Mon 27 Dec 04, 9:22 PM, p said: > > > > Select age_group from patient_data where age_group = > > young and old ; > > > > > > I am truly stuck here. Can any one please help me out > > to pass this situation. > > > > Thank you in advance. > > > > Kumar. > > PS- How can a single patient

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread Peter Jay Salzman
On Mon 27 Dec 04, 5:22 PM, S Kumar <[EMAIL PROTECTED]> said: > Dear group, > I am a novice programmer started doing php to process > a query form of my patients. > > I have a database and one table in it deals with my > patient information. Depending on their condition I > divided their age

[PHP-DB] Update keeps failing with php/sqlite

2004-12-27 Thread Peter Jay Salzman
Hi all, I made a toy database. Two tables are "students" (a collection of student info) and "message" (private messages I want individual students to read). The "message" table is indexed by a student's social security number. student last, first, ssn, address, city, state, zip, email messag

[PHP-DB] Undefined indicies

2004-12-26 Thread Peter Jay Salzman
Slightly off topic, I apologise. Total newbie. In many php DB tutorials I've seen, it's recommended to set register_globals off, and error reporting to E_ALL. When I looked at my system, register_globals was enabled and error reporting was set to E_FATAL. I changed them to the suggested values

[PHP-DB] php4 + sqlite - quoting stuff

2004-12-25 Thread Peter Jay Salzman
Hi all, I'm a kinda-sorta newbie to php -- I basically just futz around with it because it's pretty cool. However, I'm brand spanking new to databases. Never did anything with them. I taught myself a little SQL because it looked fun to learn, but I just thumbed through some books. I never reall

RE: [PHP-DB] Re: HTTP Auth for PHPMyAdmin

2004-12-22 Thread Peter Lovatt
set auth type to cookies Peter > -Original Message- > From: Mark Benson [mailto:[EMAIL PROTECTED] > Sent: 22 December 2004 10:55 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: HTTP Auth for PHPMyAdmin > > > Martin Norland wrote: > > >What do you m

RE: [PHP-DB] forgetting to close db connection

2004-12-12 Thread Peter Lovatt
hosts. Hope this gives a clearer picture. Peter > -Original Message- > From: Matthew Perry [mailto:[EMAIL PROTECTED] > Sent: 12 December 2004 15:23 > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] forgetting to close db connection > > > On my forms

RE: [PHP-DB] save as you type

2004-12-12 Thread Peter Lovatt
You could use JavaScript onblur executes when the user leaves the box, and will submit the form HTH Peter > -Original Message- > From: Matthew Perry [mailto:[EMAIL PROTECTED] > Sent: 12 December 2004 05:12 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] save as yo

RE: [PHP-DB] password encryption

2004-11-18 Thread peter
Quoting "Gryffyn, Trevor" <[EMAIL PROTECTED]>: > If you want to be cheesy, you can also use something like an MD5 has on > "dog" and get whatever it gets Then every time someone enters "dog" > it always ends up with the same MD5 hash. How is using MD5 cheesy? I've implemented exactly that so

[PHP-DB] PHP on an Windows intranet with MSOffice-like templates

2004-11-16 Thread peter
I don't even know if this is possible, or if I'll have to go the route of .NET development to get this sort of functionality (I'm sure it's possible if I jump through enough hoops). But here's what I'm trying to accomplish... - users are all on a local intranet with access to a shared drive (no pr

RE: [PHP-DB] Problem with script

2004-11-02 Thread Peter Lovatt
Try echoing the actual query being run. It will give you more info to work with. Peter > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 02 November 2004 16:42 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Problem with script >

RE: [PHP-DB] PHP versions - Development server & live server...

2004-10-14 Thread Peter Borcherds
I don't recall installing any optimising or encrypting extensions?? Are they perhaps installed with mySQL? How do I reinstall them, that is assuming I need them? -Original Message- From: M Saleh EG [mailto:[EMAIL PROTECTED] Sent: 14 October 2004 03:24 To: Peter Borcherds Cc: [

Re: [PHP-DB] PHP versions - Development server & live server...

2004-10-13 Thread Peter Borcherds
installed - "Robby Russell" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Peter, Yes, if you build PHP5 code, it's very possible it will not work o

RE: [PHP-DB] PHP versions - Development server & live server...

2004-10-13 Thread Peter Borcherds
Hi Robby, Thanks for the swift reply! Okay, so it should be fine to install the 4.3.9 version then - okay...now I assume I should hold-off on the 5.0.2 release then...? -Original Message- From: Robby Russell [mailto:[EMAIL PROTECTED] Sent: 13 October 2004 22:01 To: Peter Borcherds Cc

[PHP-DB] PHP versions - Development server & live server...

2004-10-13 Thread Peter Borcherds
What do I need to be looking out for with regard to conflicts? Thanks! Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Short Names

2004-09-25 Thread Peter Ellis
t you wrote and why... Hope this helps. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Sat, 2004-09-25 at 14:23 -0700, Cole S. Ashcraft wrote: > Is it considered bad / sloppy to define the short names of varibales at >

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Peter Lovatt
Hi try $db = mysql_connect("localhost", "myuser","mypassword") - without it you are not submitting a password Peter > -Original Message- > From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] > Sent: 24 September 2004 13:31 > To: [EMAIL PROT

RE: [PHP-DB] Please help

2004-09-08 Thread Peter Lovatt
HI try $result = mysql_query($sql . " " . $sql_ext . " limit 0,1") or die("Invalid query".mysql_error()); which will give more detail on the error. HTH Peter > -Original Message- > From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > Sen

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

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

Re: [PHP-DB] Please help

2004-09-08 Thread Peter Ellis
What are the variables $sql and $sql_ext set to? The query format is fine. It's probably in your variables. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Wed, 2004-09-08 at 12:29 -0700, Stuart Felenstein wrote: > I

  1   2   3   4   5   6   >