Re: [PHP-DB] I'm completely lost here

2012-08-24 Thread Gary Chambers
assigning the values to the variables that you are trying to insert into the database? Do you have register_globals enabled? -- Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] I'm completely lost here

2012-08-24 Thread Gary Chambers
to validate and ensure that you're receiving sane input. -- Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Pg Transactional Function

2012-08-22 Thread Gary Chambers
. Thank you, Gary Chambers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] UPDATE IF

2011-03-14 Thread Gary
have been looking over the manual and boards but am not finding a solution. Can anyone point me in the right direction. -- Gary __ Information from ESET Smart Security, version of virus signature database 5952 (20110314) __ The message was checked by ESET Smart Security. http

[PHP-DB] Cant Get Data

2011-02-21 Thread Gary
['name']; echo $county$1; echo $counties; echo $row_name; */ ? -- Any Suggestions? Thank you. Gary __ Information from ESET Smart Security, version of virus signature database 5893 (20110221) __ The message was checked by ESET Smart Security. http://www.eset.com

[PHP-DB] Any good explanations of pg_send_execute and friends?

2010-04-27 Thread Gary .
Has anyone found anything in their travels around the web? The manual is okay, but the examples are so simplistic it's difficult to understand how it should really be used. For example, if I have a loop of pg_send_execute based INSERT statements inside a transaction*, and one of them fails, how

[PHP-DB] PDOException: could not find driver (postgres)

2010-04-22 Thread Gary .
What could be causing this please? Going direct, using pg_connect, is not a problem. The code in question looks like $pdo = new PDO('pgsql:host=localhost;port=5432;dbname=mydb', 'dbuser', 'dbpass'); (I think - I've yet to be able to debug it down to a single line) -- PHP Database Mailing List

Re: [PHP-DB] PDOException: could not find driver (postgres)

2010-04-22 Thread Gary .
On 4/22/10, Niel Archer wrote: What could be causing this please? Going direct, using pg_connect, is not a problem. Make sure you have the PDO postgres driver enabled in your php.ini, it does not use the same driver as the Postgres extension. Aha! Okay, thanks! It's working now... -- PHP

Re: [PHP-DB] Postgres - how to skip 'sequence' columns

2010-04-13 Thread Gary .
On 4/13/10, Chris wrote: Gary . wrote: Is it possible to skip column(s) in the target table when using pg_copy_from? ... It seems not from looking at the php manual. You could use http://www.php.net/manual/en/function.pg-put-line.php instead. Yeah. I was hoping to use pg_copy_from to avoid

[PHP-DB] Fatal error: Call to undefined function pq_query()

2010-04-13 Thread Gary .
What the... What is causing this? I can use pg_connect without complaint, why does pq_query give this problem? PHP 5.3.1 FWIW. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fatal error: Call to undefined function pq_query()

2010-04-13 Thread Gary .
On Tue, Apr 13, 2010 at 10:40 AM, Firan Corneliu wrote: Are you sure you're not using q instead of g :) Err. My first thought was What a strange thing to ask. Then I looked... Thanks. I'd been looking at that for a good hour or so... *embarrassed* -- PHP Database Mailing List

[PHP-DB] Postgres - how to skip 'sequence' columns

2010-04-12 Thread Gary .
Is it possible to skip column(s) in the target table when using pg_copy_from? When I tried to bulk insert some data from a csv file by way of pg_copy_from I received the error Warning: pg_copy_from() [function.pg-copy-from]: Copy command failed: ERROR: permission denied for relation xyz, pretty

[PHP-DB] Injection Attack?

2010-02-25 Thread Gary
. Any thoughts? Gary __ Information from ESET Smart Security, version of virus signature database 4895 (20100225) __ The message was checked by ESET Smart Security. http://www.eset.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PHP- Mysql problem

2009-06-28 Thread Gary
Daniel, Now that is just funny stuff... Have you tried http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost or the newer http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost Daniel Brown danbr...@php.net wrote in message

RE: [PHP-DB] change coldfusion to mysql/php

2008-05-08 Thread Gary Wardell
Hi, I don't know of a tool, although there may be one. If the pages are really simple I would think that it wouldn't be that hard to redo them by hand. Gary -Original Message- From: Koller Michel [mailto:[EMAIL PROTECTED] Sent: Thu, May 08, 2008 7:26 AM To: php-db@lists.php.net

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

2008-04-15 Thread Gary Wardell
Hi, I suggest you echo $del_str to see exactly what your query is. There may be something unexpected in $_GET['Id']. Echo the whole query so you can see everything in context. Gary -Original Message- From: Javier Viegas [mailto:[EMAIL PROTECTED] Sent: Tue, April 15, 2008 5:56 PM

Re: [PHP-DB] webserver script to localhost MySQL?

2008-03-22 Thread gary balkam
/baddblog/wp-config.php:11) in /hermes/bosweb/web250/b2508/ipw.testgbalkam/public_html/baddblog/wp-includes/functions.php on line 1438 Error establishing a database connection - Original Message - From: Gary Wardell [EMAIL PROTECTED] To: 'gary balkam' [EMAIL PROTECTED] Sent

RE: [PHP-DB] webserver script to localhost MySQL?

2008-03-22 Thread Gary Wardell
to be changed to set the proper port number? (My guess is probably) Or is the host you're trying to connect to unreachable? Or is the port being blocked by a firewall? Once you get the connection working you can remove the echo. Gary -Original Message- From: gary balkam [mailto:[EMAIL PROTECTED

[PHP-DB] webserver script to localhost MySQL?

2008-03-21 Thread gary balkam
I'm pretty new to php and mysql. And I just found this news group about 4 minutes ago. What I need to know, is how do I connect a wordpress application, located on a web server to a database located on my own computer. The reason for doing this instead of syncing the dbs is the Sql server on

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
Hi, The way I think I'd approach it is to use an outer join where table a is joined to a subquery where the subquery returns only the max timestamp from table b. Gary -Original Message- From: Graham Cossey [mailto:[EMAIL PROTECTED] Sent: Thu, March 06, 2008 5:17 PM To: J. Hill; php

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL Server. Sorry if I caused confusion. Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
I know the feeling. I've been trying to hookup MYSQL as a linked server on MS SQL Server. There are a few articles out there that make mention of it but no where does anybody say exactly how to do it. Gary -Original Message- From: Graham Cossey [mailto:[EMAIL PROTECTED] Sent: Thu

RE: [PHP-DB] independent session data for multiple browser windows

2008-02-20 Thread Gary Wardell
forms on the pages in the different windows, why not put the UID of the record they are accessing in a hidden field in the form? Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Password decryption

2008-02-17 Thread Gary Wardell
password from the logon and compare the encrypted versions; rather than decrypting for the compare. Gary -Original Message- From: Nasreen Laghari [mailto:[EMAIL PROTECTED] Sent: Sat, February 16, 2008 10:18 PM To: php-db@lists.php.net Subject: [PHP-DB] Password decryption Hi

RE: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Gary Wardell
*fields* And both only result in one record for each CSV line? Or do PHP and MySql handle CSV files different from most other applications? Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] odbc_connect - urgent

2008-01-10 Thread Gary Wardell
to 10 seconds, but that doesn't change the socket timeout. It will still wait for the 30 or 60 seconds, or whatever it is, before abandoning the socket. This is a Windows thing and has to do with the way they implemented sockets. Gary -Original Message- From: iODBC Maintainer [mailto

RE: [PHP-DB] align

2008-01-01 Thread Gary Wardell
Or even if it's not in a table, put a div around it and use: style= text-align: right or equivalent css Of course this assumes he's using html to display it. Gary -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Tue, January 01, 2008 11:21 AM To: arafat

RE: [PHP-DB] Credit Card Encryption

2007-12-19 Thread Gary Wardell
? Also, in terms of the developer, would this be covered under errors and omissions insurance, or would they take the position that the developer should have known better and was negligent in creating a non-compliant system leaving the developer on the hook for damages? Gary -Original

RE: [PHP-DB] Credit Card Encryption

2007-12-18 Thread Gary Wardell
, or triple DES, not DES) But like Chris said: if you don't have to, dont do it. But if you must, encrypt all of the personal information data points, not just the CC info. Gary -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Tue, December 18, 2007 9:30 PM To: Keith Spiller Cc

RE: [PHP-DB] UPDATE syntax

2007-12-13 Thread Gary Wardell
Hi, I'm a beginner at PHP and MySql but a long time MS SQL server user. Maybe it should be `advertisements`.`displayed` instead? I just did a test and my Query browser doesn't like `interestcodes.id` but likes `interestcodes`.`id`. Notice the quotes (accents) on each side to the period. Gary

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

2007-12-09 Thread Gary Wardell
that perhaps the IP address of the web server has changed. Either way, whatever authentication is used may need to be looked at and corrected. I can't think of anything else that might be the problem. Gary -Original Message- From: Tim Daff [mailto:[EMAIL PROTECTED] Sent: Mon, December 10

[PHP-DB] Re: [PHP] RE: the opposite of a join?

2007-10-03 Thread Gary Josack
I agree with this. Never use a subquery when a join will work. The optimizer with thank you with performance. James Ausmus wrote: On 10/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi J, Checkout this, SELECT * FROM tbl_company where id not in (SELECT companyID from tbl_contacts)

[PHP-DB] Arrays from forms....

2006-11-30 Thread Gary E. Terry
I have a problem. I have done this before, but can't find the files. I am using the following function to upload files from a form. foreach ($_FILES[pictures][error] as $key = $error) { if ($error == UPLOAD_ERR_OK) { echo $error_codes[$error]; move_uploaded_file(

RE: [PHP-DB] Arrays from forms....

2006-11-30 Thread Gary E. Terry
- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 10:10 PM To: Gary E. Terry Cc: PHP DB Subject: Re: [PHP-DB] Arrays from forms Gary E. Terry wrote: I don't know if we are on the same page here... Maybe we are and I am just an idiot. The fields in my db are image1

RE: [PHP-DB] Arrays from forms....

2006-11-30 Thread Gary E. Terry
- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 10:39 PM To: Gary E. Terry Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Arrays from forms Gary E. Terry wrote: Sorry about that, not CC'ing the list... the values are not always empty, they should always have

RE: [PHP-DB] Arrays from forms....

2006-11-30 Thread Gary E. Terry
Nope... here is the output. -- -- Array ( [error] = ) -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 10:56 PM To: Gary E. Terry Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Arrays from forms Gary E. Terry wrote: If I print them

RE: [PHP-DB] Arrays from forms....

2006-11-30 Thread Gary E. Terry
OK.. I am a moron.. Forgot that I had changed the name of the field in the form, and got sidetracked and didn't change it in the php... But, still not working correctly. Here is the output: Array -- Array -- Array from: ?php include db.inc.back.php; foreach ($_FILES[pictures][error] as

RE: [PHP-DB] Arrays from forms....

2006-11-30 Thread Gary E. Terry
I know you really meant : ${image.($key+1)} = $_FILES['pictures']['name'][$key]; And it works!!! Thanks oh so very much! -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 11:46 PM To: Gary E. Terry Cc: php-db@lists.php.net Subject: Re: [PHP

RE: [PHP-DB] PHP 4 to 5 Upgrade Issue

2005-06-23 Thread Gary Every
I need to compare PHP 4 code with PHP 5 interpreter on same machine. I am following the examples in Adam Trachtenberg's Upgrading to PHP 5 (O'Reilly 2004) listed in Appendix C: Installing PHP 5 Alongside PHP 4 with regard to using virtual hosting and relative ports on Apache httpd. I have also

RE: [PHP-DB] adodb is slow

2005-05-23 Thread Gary Every
needs, but it's really a cure-all when what you need is an abstraction layer that works for YOUR needs! Don't be afraid to try slimming it down, but I'd keep an original copy somewhere in case you find that your paring knife was a little too sharp!! G.~ Gary Every Sr. UNIX Administrator Ingram

RE: [PHP-DB] What wrong with my Query??

2005-03-25 Thread Gary Every
','123.123.123.123'); Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: HarryG [mailto:[EMAIL PROTECTED] Sent: Thursday, March 24, 2005 11:27 PM To: php-db@lists.php.net Subject: [PHP-DB] What wrong

Re: [PHP-DB] Re: Passing url parameters

2004-10-07 Thread Gary Hotko
Got a question can one send a full array to another page with out having out put each value stored in it manually? On Sun, 03 Oct 2004 05:54:54 +0530, Amit Arora [EMAIL PROTECTED] wrote: You can set this to anything you want. http://www.url.com?new_field=value And you can get the value

RE: [PHP-DB] Help needed

2004-10-04 Thread Gary Every
Check to see if your register_globals is set to off in php.ini. If so (likely, since it defaults to that value) you'll need to access your POST and GET variables like this: GET vars: $var = $_GET['var']; POST vars: $var = $_POST['var']; Gary Every Sr. UNIX Administrator Ingram Entertainment

RE: [PHP-DB] PHP 5 Error Handling

2004-09-15 Thread Gary Every
, etc I assign $line_no = __LINE__ and if an exception gets thrown, the $line_no is captured, and I can use the info to print to the logs or the screen or ... G. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message

RE: [PHP-DB] Please help

2004-09-08 Thread Gary Every
the query, and it is valid Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 2:29 PM To: [EMAIL PROTECTED] Subject: [PHP-DB

RE: [PHP-DB] Search page

2004-09-08 Thread Gary Every
K, first off I'm brand new to PHP and databases. So I hope my question isn't stupid or unfitting to the list. Welcome! Only those that don't ask are unfitting I am creating a search and results page of, right now 3 fields with more to add. Perhaps not necessary to my question, I have

RE: [PHP-DB] Text area

2004-08-24 Thread Gary Every
You need to add slashes to your return: Return input type=textarea rows=\5\ cols=\70\ name=\\; Or use single quotes: Return 'input type=textarea rows=5 cols=70 name='; Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original

RE: [PHP-DB] Re: LAMP

2004-08-03 Thread Gary Every
The answer to that is SPEED. Nothing short of Oracle comes even close Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Lester Caine [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 1:15

[PHP-DB] Turning off Save Password

2004-07-01 Thread Gary Every
I'm trying to turn off the save password function so that I can do an auth page that refuses to save passwords on the client side. I've tried some JS but it works only in IE, not Netscape. So, I'm looking for a server-side solution to this. Any ideas? Gary Every Sr. UNIX Administrator Ingram

RE: [PHP-DB] Turning off Save Password

2004-07-01 Thread Gary Every
Fixed my own problem. Within the tag, you can use autocomplete=off To turn off the prompting or the autocompletion of any field. Apologize for this off-topic post, but I was searching for a non-javascript server-side solution Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram

RE: [PHP-DB] Re: [PHP] update count

2004-06-16 Thread Gary Every
If you aren't using a unique key, you can always use LIMIT 1 at the end of your query, but unless your ORDERing correctly to get the exact data row you want to update, this can have unexpected results. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN

RE: [PHP-DB] Sample Code

2004-06-15 Thread Gary Every
Here's a quick and easy one though: SELECT * from your_table WHERE your_date_field BETWEEN '2004-06-01' AND '2004-06-15'; Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Mike Koponick [mailto:[EMAIL

RE: [PHP-DB] Re: datetime update

2004-06-10 Thread Gary Every
Actually it would be: UPDATE table SET dateTime=NOW() WHERE record_id='$the_one_you_want'; Or INSERT INTO table (record_id,dateTime) VALUES ('$the_one_you_want',NOW()); Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original

RE: [PHP-DB] Re: automatic call reference creation

2004-06-10 Thread Gary Every
to store the call code, since you can recreate it using the autoincrement, the date field, and str_pad. Of course, if space is not an issue, you could always store the concatenated string into another column. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN

RE: [PHP-DB] Display mysql query results divided in dynamic numbered pages

2004-05-20 Thread Gary Every
Look at: http://www.phpclasses.org/browse/package/92.html It's a pager class that does: Previous 1 2 3 4 5 6 7 8 9 10 Next Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Kpromos [mailto:[EMAIL

[PHP-DB] [RESOLVED] RE: Secure MySQL Access md5()

2004-05-14 Thread Theisen, Gary
Thanks for the info Hans! I've got it working now. -Original Message- From: Hans Lellelid [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 7:28 PM To: Gary Theisen Cc: '[EMAIL PROTECTED]' Subject: Re: Secure MySQL Access md5() Hi, Passwords in the mysql.users table must

[PHP-DB] Secure MySQL Access md5()

2004-05-13 Thread Theisen, Gary
Hi all, I've got: WinNT php 4.3.1 phpmyadmin 2.5.6 MySQL 4.0.18-nt I can connect to my db via my php script using: [php] $connection = mysql_connect (localhost, root, ) [/php] That works no problem. This will not work however: [php] $somePass = md5(somePass); $connection =

[PHP-DB] No user table access to phpMyAdmin - How?

2004-05-10 Thread Theisen, Gary
to control that db table through the command line on the server itself. How/What do I need to configure?? Thanks, Gary

[PHP-DB] MySQL Password() PHP encryption?

2004-05-06 Thread Theisen, Gary
Hi all, I've recently upgraded my mysql to v 4.1.1 (on win nt 4.0) and set the Passwords in the user table to the mysql Password() function. Now, this doesn't work anymore when call from a php web script (which is a good thing, cause it's plain text): mysql_connect (localhost, theID,

[PHP-DB] Testing - no emails since 11:45 AM 3/23/04

2004-03-23 Thread Gary Every
Testing, have received no emails since 11:45 Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: How to simplify DB creation?

2004-03-23 Thread Gary Every
-engineering XML schema from database * Use Criteria OO query system instead of writing SQL queries * Generated methods to easily efficiently work with (foreign key) relationships Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward

RE: [PHP-DB] output formatting question

2004-03-09 Thread Gary Every
Smith/TDTD(213) 555-1212/TD/TR Some other formatting hints for this: $first = ucfirst(strtolower($first)); will give you John even if the DB has JOHN or john Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message

RE: [PHP-DB] How do you make an IN span multiple tables?

2004-03-04 Thread Gary Every
Select * from table1 t1, table2 t2, table3 t3 WHERE ((t1.thread_ref IN (1,2,3,4,5,6,7,8,9,10)) or (t2.thread_ref IN (1,2,3,4,5,6,7,8,9,10)) or (t3.thread_ref IN (1,2,3,4,5,6,7,8,9,10))) Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward

RE: [PHP-DB] Accessing my variables

2004-02-11 Thread Gary Every
You're missing a ' in your include statement, after .php Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: J. Kevin C. Burton [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 11:29 AM

RE: [PHP-DB] Results with ledger stripes?

2004-01-27 Thread Gary Every
Haven't been following this thread, but here's how we do it: If($bgc == '') { $bgc = #DD; } elseif($bgc == #FF) { $bgc = #DD; } else { $bgc = #FF; } Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay

RE: [PHP-DB] PHP export to CSV

2003-12-29 Thread Gary Every
You should try this: Header(Content-Type: text/plain); Header(Content-Disposition: attachment; filename=file.csv); Then output the text you want to send. Make sure you double-quote it so that the newlines work! $eol = \n; echo Field 1,Field 2,$field_variable,$eol .. This sends a stream of

RE: [PHP-DB] CREATE TABLE LIKE, error

2003-12-15 Thread Gary Every
Try: CREATE table new_table SELECT * from old_table limit 1; delete from new_table; This will give you the same structure in both tables, and the deletion will make the new_table empty. -Original Message- From: Adam i Agnieszka Gasiorowski FNORD [mailto:[EMAIL PROTECTED] Sent:

Re: [PHP-DB] Fake BDD

2003-12-02 Thread Gary Every
Check out SQLite BENARD Jean-philippe wrote: Hi, We use ORACLE DataBase for all our projects and we can't install mysql/postgresql on our server. A new project needs a little database (only 1 table). I heard about something like an API in order to use text files in place of real

Re: [PHP-DB] multiple queries

2003-12-02 Thread Gary Every
Or do the same with the BETWEEN keyword: SELECT * FROM dates WHERE store='$store' AND date BETWEEN DATE_SUB(now(), interval 3 day) AND DATE_ADD(now(), interval 3 day) Richard Davey wrote: Hello Cameron, Tuesday, December 2, 2003, 1:08:19 AM, you wrote: CS $sql = SELECT * from dates where

RE: [PHP-DB] form not working...

2003-11-10 Thread Gary Every
Don't you need to start your form BEFORE your input type's -Original Message- From: jas [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 11:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] form not working... For some reason my form to edit selected items is not working, I think I

RE: [PHP-DB] Re: Page counter from a query ?

2003-11-04 Thread Gary Every
Just do an extract on your $_GET var (if security concerns are negligible) Say you get line is: ?sid=123form=12 // Execute this extract($_GET) // You end up with: $sid == 123; $form == 12; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL

RE: [PHP-DB] Page counter from a query ?

2003-11-03 Thread Gary Every
[$pagid] // which would equal 0,10 $sql = SELECT columns from table limit $lim; and so on . .. Does that help? Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Larry

RE: [PHP-DB] Help installing phpmysearch

2003-10-29 Thread Gary Every
But do you have php compiled --with-curl? check phpinfo(); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Joseph Allard [mailto:[EMAIL PROTECTED] Sent: Tuesday

RE: [PHP-DB] Round a number

2003-10-03 Thread Gary . Every
Try the rtrim function in php Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 10:12 AM To: [EMAIL PROTECTED

RE: [PHP-DB] show list of values and new values

2003-10-01 Thread Gary . Every
that have select_id='1'. You can use the same table with different select_id's for different dropdowns. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Hull, Douglas D [mailto

RE: [PHP-DB] mySQL vs pgSQL | php vs others

2003-09-24 Thread Gary . Every
El Mié 24 Sep 2003 07:24, nabil escribió: Dear all; I have been using Mysql for a long time, but I have a benchmark Q. Is pgsql , better ? faster ? more reliable than mysql ? Maybe not faster in FTS, but surely MORE reliable!!! any comment ? Some people say that php is not

RE: [PHP-DB] Re: UPDATE part of a column

2003-09-23 Thread Gary . Every
The best way to do this is a text field, NOT a textarea, and if need be, use multiple fields. A textarea, by look and definition is inviting carriage returns to be used. Limit the users to the input you want, and remember, GIGO (garbage in, garbage out) Gary Every Sr. UNIX Administrator Ingram

RE: [PHP-DB] Selection problem

2003-09-08 Thread Gary . Every
Try unset after the if statement if ($nameb == ){ $query = SELECT * FROM recipes WHERE points $pointsb; } else { $query = SELECT * FROM recipes WHERE name = '$nameb'; $new_nameb = $nameb; unset($nameb); } Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876

RE: [PHP-DB] determining if a query returns no value

2003-08-14 Thread Gary . Every
Youy could use: if(!$result) { // Don't display } else { echo Title; } You fill in the blanks Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Wendall Williams

RE: [PHP-DB] Condition for Adding data

2003-07-22 Thread Gary . Every
Well, you're initializing $food to ; then testing to see if it has a value, which it never will. If you're getting the $food variable from a POST or a GET op, you'll need to grab it from the appropriate array, $food = $_POST['food']; echo $food; to see what is being passed. Gary Every Sr

RE: [PHP-DB] commas

2003-07-17 Thread Gary . Every
Check out the php function number_format($field,0) Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Chris Mach [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:43 AM

RE: [PHP-DB] Date problem

2003-07-14 Thread Gary . Every
snip // Do some number crunching here // $newnow = $now-$numweeks; echo $now; $converted_date = date(d-m-y,$now); echo br$converted_date; /snip You should be running your $convewrted_date on $newnow, not $now Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876

RE: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Gary . Every
Do you have select permissions on that DB/table? If you have GRANT permissions, try GRANS SELECT, INSERT, UPDATE, DELETE ON db.tablename to 'youruser'@'your.ip.address' IDENTIFIED BY 'yourpassword'; your.ip.address can be substituted with localhost if you're on the same box. Gary Every Sr

RE: [PHP-DB] Reading from a file

2003-07-01 Thread Gary . Every
Looks like the first question was answered correctly, for the second one look at the ltrim and rtrim functions. $var = ; $var = rtrim($var); echo :$var:; output is :: Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http

RE: [PHP-DB] Splitting Product Catalogue Over Multiple Pages?

2003-06-27 Thread Gary . Every
the values in the column, just the amount of records you want to return Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Boa Constructor [mailto:[EMAIL PROTECTED] Sent

RE: [PHP-DB] Splitting Product Catalogue Over Multiple Pages?

2003-06-27 Thread Gary . Every
20,10 it will return 10 records starting at record 20. More info at http://www.mysql.com/doc/en/SELECT.html Search for limit on that page. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original

RE: [PHP-DB] md5 question!

2003-06-24 Thread Gary . Every
different hash strings. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:47 AM To: JeRRy; [EMAIL

RE: [PHP-DB] Two-column display of data, second method

2003-06-20 Thread Gary . Every
by changing the $cols_wanted variable Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 5:01 PM To: [EMAIL

RE: [PHP-DB] Limit return Size

2003-06-20 Thread Gary . Every
Or $sql = SELECT concat(LEFT(columnName,255),...) FROM tableName; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: Friday

RE: [PHP-DB] Problems with formvalues by using Suse 8.2

2003-06-19 Thread Gary . Every
the $$key assigns whatever $key is to a variable with that value, e.g. $key = sid; $value = W; So: $$key = $value; will make the following true: $sid == W; It's a pretty good way of re-doing pages that were written with register_globals=on to run with register_globals=off Gary Every

RE: [PHP-DB] Ignoring specific values in an inner join query?

2003-06-10 Thread Gary . Every
like '%$name%' AND whatever_field_you_want IS NOT NULL AND whatever_other_field IS NOT NULL; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Andr Sannerholt [mailto:[EMAIL

RE: [PHP-DB] Calling Stored Procedures of Oracle in php

2003-06-06 Thread Gary . Every
If this is a cut-n-paste of the code, check the line below for spelling: begin prcoedurename('[EMAIL PROTECTED]','3');end;; ^^^ Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-05 Thread Gary . Every
1. Change your field name from date to something like datefield (or backtick it) 2. Place single quotes within your VALUES parens, e.g. $denylog = INSERT INTO deny (account, td, datefield ) VALUES ('$tmp', '$td', NOW() ) Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay

[PHP-DB] Test

2003-06-04 Thread Gary . Every
Sorry about the test, but . . .

RE: [PHP-DB] Array Question

2003-06-03 Thread Gary . Every
CartArray['itemid'] = $itemid; note where $qty = CartArray['qty']; /note Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Boa Constructor [mailto:[EMAIL PROTECTED] Sent

RE: [PHP-DB] Permission Denied; Upload

2003-04-04 Thread Gary . Every
Unable to open '' for reading: That means you're not actually sending a filename to be read! I get this error during test of the above page: Warning: Unable to open '' for reading: Permission denied in C:\SammiWWW\entry.php on line 27 Couldn't copy the file!

[PHP-DB] Anybody out there?

2003-04-03 Thread Gary . Every
Is the list active? I've seen nothing all day. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com

RE: [PHP-DB] Login and link back...

2003-03-19 Thread Gary . Every
); # update_logged_in_status($PHP_AUTH_USER,'Y'); } } liability_statement_check(); return(TRUE); } else { # USER NOT KNOWN auth_header($PHP_AUTH_REALM); } } Gary Every Sr. UNIX Administrator Ingram Entertainment (615

RE: [PHP-DB] SELECT * FROM Command *REVISED*

2003-03-19 Thread Gary . Every
SELECT * FROM tablename WHERE zipcode='$zipcode' ORDER BY entered_date; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Michelle Whelan [mailto:[EMAIL PROTECTED] Sent

RE: [PHP-DB] Column Sort Question

2003-03-05 Thread Gary . Every
Shouldn't you be using $_GET or, since register_globals are set to off, $order_by should contain FIRSTNAME Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Jerry [mailto:[EMAIL

  1   2   >