[PHP-DB] [4.3.3] How to buildi with SQLite support ?

2004-03-04 Thread DAvid Jackson
I looked the the configure --help but didn't see sqlite? Or did I just miss it? How can I build the module for sqlite. David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Generating readio buttons

2002-11-03 Thread David Jackson
OK, this works but there has to be a pretty way? David - Works - Operation Sticky Bun Operation Sticky Bun '; $header = mysql_query ("SELECT * FROM chart ORDER BY acct "); if ($row = mysql_fetch_array($header)) { do { print ''; prin

Re: [PHP-DB] Generating readio buttons

2002-11-03 Thread David Jackson
Peter Beckman wrote: Here's your problem: "acct[]" doesn't equal anything. $acct[4] might. So: echo ""; Peter -- Thanks again for you help. I wonder if it's not a quoting issue on my part? How would I use the $row["column_name"], in the above statement? Since it not a $_POST[] filed? Thank

Re: [PHP-DB] LIKE statement or IN statement?

2002-11-03 Thread David Jackson
Chris Barnes wrote: Yeah I really need to search for multiple words. Can anyone confirm if the IN statement will work for me in this situation? Chris -- Why not just try it you self and let's us know. Also check to MySQL doc at http://mysql.org David On Mon, 2002-11-04 at 09:31, [EMAIL PROT

Re: [PHP-DB] Generating readio buttons

2002-11-03 Thread David Jackson
edger accounts for a account app. ( http://mustardandrelish.com/ledger) Query returns (from HTML table): Expected results might be: And then "gl_acct" will be passed to the G/L entry screen (sticky forms?) TIA, David Peter On Sun, 3 Nov 2002, David Jackson wrote: Ho

[PHP-DB] Re: LIKE statement

2002-11-03 Thread David Jackson
Chris Barnes wrote: Hi, I've got a dilly of a problem. I'm probably doing something wrong but I don't know what. I'm trying to use the LIKE statement in a query where more than one word is used in with LIKE..e.g. select count(distinct itemid) from business where name or description like 'word1 wo

[PHP-DB] Generating readio buttons

2002-11-03 Thread David Jackson
Howdy -- How do I dynamically generate the "value" for radio buttons off the DB (MySQL) backend? Here's some code that almost works TIA, David - Almost works $header = mysql_query ("SELECT * FROM chart ORDER BY acct "); if ($row = mys

[PHP-DB] Resolved: Inserting current date(MySQL)?

2002-10-30 Thread David Jackson
John, Jeffery, Alex and Jason -- Thanks for you response. As you all suggested it was as simple as CURDATE(). without any quotes or backticks. Thanks again, David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Inserting current date(MySQL)?

2002-10-30 Thread David Jackson
Howdy -- I'm my trying to insert to current date from a php form? I know that MySQL has a CURDATE() fucntion and PHP has several date function, but I cann't seem to get either to work? Here is my existing code: TIA, David Jackson -- client_add.php $ADDDATE=d