Re: [PHP] PHP + SQL..

2007-02-23 Thread Richard Lynch
On Thu, February 22, 2007 7:53 pm, Liz Kim wrote: > When I try to get a really long string and print it out on a website, > it > tends to stop in the middle of the string. > Is this some sort of a limitation that I can change? It's probably a limit on the number of characters that can be stored in

Re: [PHP] PHP + SQL..

2007-02-22 Thread Robert Cummings
On Thu, 2007-02-22 at 17:53 -0800, Liz Kim wrote: > I am storing a lot of text into my mssql database. > Are there any special characters I should watch out for? > I think so far I've got ' covered. Skip the guesswork and use an appropriate quoting mechanism for your database -- that said I'm not

Re: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-19 Thread paulm
oh, just realized smth :) the tutorial is not mine i have used with success and also posted there but the credit for the tutorial is of: NickName: Gast Member Since: 03/26/2005 Location: Surrey, England Website:http://www.nmcmahon.co.uk he must have the credit for it :) dave

Re: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-19 Thread dave
as u wish :) tedd wrote: >> sry bout that it seems i was logged in :) try this on >> "http://www.ajaxfreaks.com/tutorials/6/0.php"; it's called "Making a >> Google Suggest-like application" > > > Dave: > > A most excellent example, but a horrible place to put it. The links are > all screwed up

Re: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-19 Thread tedd
sry bout that it seems i was logged in :) try this on "http://www.ajaxfreaks.com/tutorials/6/0.php"; it's called "Making a Google Suggest-like application" Dave: A most excellent example, but a horrible place to put it. The links are all screwed up and confusing. The pages are not designed we

RE: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-18 Thread Chrome
the DOM is a much better idea... It may be more lengthy by that can be cut down some with clever scripting :) HTH Dan --- http://chrome.me.uk -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: 18 March 2006 22:45 To: php-general@lists.php.net Cc: &

RE: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-18 Thread tedd
No. All of the examples I find are like the 'google' style suggest-thingy. I want to dynamically (AJAX) populate an actual: foo bar fee fum Basically the core problem is passing back an 'array' of data from mysql into JS to make the box. What I've 'hacked'

RE: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-18 Thread Daevid Vincent
So, I guess what I'm asking, is, is this the right way to solve this challenge, or is there a better/more accepted way? > -Original Message- > From: tedd [mailto:[EMAIL PROTECTED] > Sent: Saturday, March 18, 2006 1:02 PM > To: php-general@lists.php.net; Daevid Vincent > Sub

Re: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-18 Thread tedd
I need to dynamically update a select box with results from a SQL database using AJAX, but I can't find a single example of how to do this. Basically I have a text input field, and a select box. As someone types in the input field, I want the select box to fill in the results of matches. I can f

Re: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-18 Thread dave
hi, i used http://www.ajaxfreaks.com/tutorials/6/3.php?topic_id=73&hl=104#104 it works just fine, i implemented to one of my web, so far so good. Hope it's what u are looking for Daevid Vincent wrote: > I need to dynamically update a select box > with results from a SQL database using AJAX, > bu

RE: [PHP] PHP, SQL, AJAX, JS and populating a SelectBox?

2006-03-18 Thread Weber Sites LTD
Why invent the wheel? http://developer.ebusiness-apps.com/technologies/webdevelopment/codeandcompo nents/ebawebcombov3/default.htm Sincerely berber Visit the Weber Sites Today, To see where PHP might take you tomorrow. PHP code examples : http://www.weberdev.com PHP & MySQL Forums : http

RE: [PHP] PHP SQL Code

2003-03-02 Thread John W. Holmes
> > > I would like yo show the users in a list that have a date that is more > > > than > > > 60 days old. > > > > $sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() - INTERVAL 60 > > DAY AND sActive = 'Y' ORDER BY sUpdated DESC"; > > This one returns a 'Could not get Query' warning ... so

Re: [PHP] PHP SQL Code

2003-03-02 Thread Philip J. Newman
This one returns a 'Could not get Query' warning ... so thats out. - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'Philip J. Newman'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 5:3

RE: [PHP] PHP SQL Code

2003-03-02 Thread John W. Holmes
> I would like yo show the users in a list that have a date that is more > than > 60 days old. $sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() - INTERVAL 60 DAY AND sActive = 'Y' ORDER BY sUpdated DESC"; ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Ge

Re: [PHP] PHP SQL Code

2003-03-02 Thread Tim Ward
I'd use ... WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(sUpdated) > 60*60*24*60 but I'm sure someone will come up with something more efficient. Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: Philip J. Newman <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED

Re: [PHP] PHP/SQL - inserting into database null results

2002-08-21 Thread Tom Rogers
Hi, Wednesday, August 21, 2002, 11:25:30 PM, you wrote: n> I am a new person to PHP. I have purchased and read PHP fast & easy by n> Julie Meloni and have also read the 24 hours PHP book. I am able to connect n> to the SQL database and insert into the database via my html form. However, n> the