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
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
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.
Also, when I retrieved the string later on...
The ' is printed out with a \ in the front. How do I get rid of the \?
When I try to get a really long strin
Does anyone know of a PHP class/function(s) which will generate SQL with
support for JOIN's to other tables.
I have used SQL Query Builder by David Regla Demaree, which is great for
simple SQL but lacks support for JOIN's.
Many thanks in advance, Kris.
--
PHP General Mailing List (http://www
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
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
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
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: &
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'
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
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
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
rums : http://www.weberforums.com
Free Uptime Monitor : http://uptime.weberdev.com
SEO Data Monitor http://seo.weberdev.com
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 18, 2006 4:43 AM
To: php-general@lists.php.net
Subject: [PHP] PHP, SQL, AJAX, JS
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 ca
> > > 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
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
> 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
ED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 7:46 AM
Subject: [PHP] PHP SQL Code
> 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 <
> from_unixtime(unix_time
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 <
from_unixtime(unix_timestamp(now())-(15760*60)) AND sActive = 'Y' ORDER BY
sUpdated DESC";
This don't quite work ..
Any suggestions?
--
Philip J. Newman
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
I am a new person to PHP. I have purchased and read PHP fast & easy by
Julie Meloni and have also read the 24 hours PHP book. I am able to connect
to the SQL database and insert into the database via my html form. However,
the values are null. When I look at the data in my database, it reads "
Group,
My consulting company has a fulltime open position located in Vancouver
WA. We are a fast-moving/flexible/customer driven company looking for
the same in our new PHP/SQL programmer. If interested please send your
resume and salary history to: [EMAIL PROTECTED]
Thank you for your time,
Ok guys,
I've been pondering over setting up a free PHP/SQL
hosting service for some time now, but never really
actually done it.
It looks like just the mention of it got some seriously
positive feedback, so I'm keen to actually do it
properly. But...
I need some help with security. With a bit
I am having problems connecting and pulling data from a local SQL server. I
have set up a user and, as far as I can tell, all the settings for the user
are correct. However, when I try to pull data using the user, I get empty
result sets--almost as if I don't have SELECT permissions. When I log
I created a little php script to run and display stuff on my browser for
printing.
When I run the command I get a blank page though.
I tested the syntax of my command in mysql and on phpMyAdmin to make sure
it worked.
Here is the code:
-
25 matches
Mail list logo
