[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] 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 ?php $header = mysql_query (SELECT * FROM chart ORDER BY acct ); if ($row =

[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

Re: [PHP-DB] Generating readio buttons

2002-11-03 Thread David Jackson
type=radio name=gl_acct value=2000 input type=radio name=gl_acct value=3000 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: Howdy -- How do I dynamically generate the value for radio buttons off the DB

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

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 input type='radio' name='gl_acct' value='{$acct[4]}'; 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

[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 - html headtitleOperation Sticky Bun/title/head body h3 align=centerOperation Sticky Bun /h3 ?php require('connect.php'); ? ?php print 'form action=hello.php method=post'; $header = mysql_query

[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