Re: [PHP-DB] SQL statement

PHPDiscuss - PHP Newsgroups and mailing lists wrote: Hello everybody, I'm building a small application and I have trouble passing a POST variable form one page to another inside the SQL statement. The query displayed below works great without the .$_POST['CompanyName']. $query_company_listing =

[PHP-DB] how can PHP 4 extension for SQLite 3

hi,all I want to use sqlite 3 in php4,and I found this: PHP 4 extension for SQLite. (Official) http://pecl.php.net/package/SQLite but it only support sqlite 2,Have anyone hacked it to support sqlite 3? regards gary 2005-1-7

[PHP-DB] Re: SQL statement syntaxis

Hello everybody, I just want to thank you all for your help!! I got three emails helping me out. The problem was that I wasn't including the ' around the . When I typed '.$_POST['CompanyName'].' it worked great! Thank you!! Jorge PHPDiscuss - PHP Newsgroups and mailing lists wrote: Hello

RE: [PHP-DB] SQL statement syntaxis

missing the singles quotes around the company name text element $query_company_listing = SELECT CompanyID, CompanyName, CompanyOrDepartment, BillingAddress, City, PostalCode, PhoneNumber FROM company WHERE company.CompanyName='.$_POST['CompanyName'].' ORDER BY CompanyName ASC; bastien From:

Re: [PHP-DB] select text from a text file

Hi, Thanks for answering the question. I'm going to make it write to a database rather than text file after searching google and coming accross common problems with text files. I've now just got to figure out how to mark the message as read in the database so it does not re-appear next time the

Re: [PHP-DB] setFetchMode problem with mssql/w2003/php503

ltlists wrote: I'm getting this error when attempting to use setFetchMode() PHP Fatal error: Call to undefined method DB_result::setFetchMode() in new.php on line 27 which means that class DB_result does not have a setFetchMode() method. did you read past the colon (:) in the error message? did

Re: [PHP-DB] SQL statement

Jason, can you please turn off the return receipts on emails you send to the list. it's bloody annoying to have 'The Sender wishes to be notified' popup messages everytime I read one of your emails (and, alas, I don't have the skill to hack the return receipt crap right out of Tbird). BTW

[PHP-DB] Fetch data from dbf file?

hi all, did anyone know how to fetch data from dbf file (Clipper) ? best regards, suprie -- Jangan tanyakan apa yang Indonesia telah berikan pada mu tapi bertanyalah apa yang telah engkau berikan kepada Indonesia -BEGIN GEEK CODE BLOCK- Version: 3.1 GU/IT d- s: a-- C++ UL P L++ E W++

RE: [PHP-DB] Trying to connext to MySQL with PEAR

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 21:10, Norland, Martin wrote: -Original Message- From: Ford, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 1:13 PM Subject: RE:

RE: [PHP-DB] PHP query to mysql database returns emtpy data, but Query Browser shows records

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 07 January 2005 03:25, Jason Walker wrote: Graeme - you were moving in the right direction. Since the data in the field is varchar(250), the only thing that changes is the

Re: [PHP-DB] select text from a text file

Ed wrote: Hi, Thanks for answering the question. I'm going to make it write to a database rather than text file after searching google and coming accross common problems with text files. I've now just got to figure out how to mark the message as read in the database so it does not re-appear next

Re: [PHP-DB] select text from a text file

Hi, The timestamp idea is an intresting idea and i'll give that method some thought. I only want it to pull one private message at a time out of the private message field so it might start getting very messy doing that method - but it certainly does make it worth considering. Ed - Original

Re: [PHP-DB] select text from a text file

Ed wrote: Hi, The timestamp idea is an intresting idea and i'll give that method some thought. I only want it to pull one private message at a time out of the private message field so it might start getting very messy doing that method - but it certainly does make it worth considering. I see (I

Re: [PHP-DB] Fetch data from dbf file?

Supri anto wrote: hi all, did anyone know how to fetch data from dbf file (Clipper) ? use some code. don't expect too much help if all you can be bothered to write are single line questions. I googled 'DBF + PHP' and came up with this: http://half2.mirrors.phpclasses.org/browse/package/1302.html

Re: [PHP-DB] select text from a text file

simple, add a 'read flag' column to the table, when the record is viewed, activate this flag (say 0 for unread and 1 for read) (Note: read is a mysql keyword don't use that for a column name) and then only show the ones unread bastien From: Ed [EMAIL PROTECTED] To: Andrew Kreps [EMAIL

RE: [PHP-DB] I'm trying to out perform Martin Norland....

-Original Message- From: Jochem Maas [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 3:26 PM Subject: [PHP-DB] I'm trying to out perform Martin Norland in terms of helpfulness and volume of replies to Q's on this list ;-) but it doesn't help that my mails seem

Re: [PHP-DB] select text from a text file

Hi, I've been looking at ways todo this, and as yet haven't figured out howto pull something from the database plus at the sametime update the record, can someone tell me how this is done or where i could learn? i've looked all over phpbuilder and a few other php forums but can't seem to find the

Re: [PHP-DB] SQL statement

Hi, To stop the return receipt dialog appearing in Tbird... Tools... Options... Advanced... Return Receipt and select Never send a return receipt. Or you can choose some of the other selections. graeme Jochem Maas wrote: Jason, can you please turn off the return receipts on emails you send to