Re: [PHP-DB] Re: PHP IDE
I use homesite just to tag the functions in different colors - Original Message - From: "robert janeczek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 23, 2002 8:59 PM Subject: [PHP-DB] Re: PHP IDE > > After spending two frustrating hours tracking down a bug yesterday - only > to > > discover it was a misplaced quote mark. I've had it. > > > > I am looking for suggestions out there for a good IDE for PHP development, > > preferably one that doesn't cost an arm and a leg. I tried PHP4EE studio, > > but it is buggy as hell and kept crashing on me. > > try zend studio - www.zend.com > > rash > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] selecting question
Ahha, thats true :) Clever :) - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 1:31 AM Subject: Re: [PHP-DB] selecting question > That's what I'm talking about. Make that one table and put a 'status' > column. Because then, wouldn't you be concerned on adding an entry to > tbl.buildings and removing one from tbl.building_queue. > > -- > William Fong - [EMAIL PROTECTED] > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] > > > > > - Original Message - > From: "ACEAlex" <[EMAIL PROTECTED]> > To: "William Fong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, February 20, 2002 3:33 PM > Subject: Re: [PHP-DB] selecting question > > > : As i discribed (or did i??) building_info is for the different types of > : buildings. Buildings are for those who are currently built, and > : building_queue are for those who are on queue. I also have a key called > : planet_id that says on which planet we are looking at. > : > : /Alexander > : > : - Original Message - > : From: "William Fong" <[EMAIL PROTECTED]> > : To: <[EMAIL PROTECTED]> > : Sent: Thursday, February 21, 2002 12:24 AM > : Subject: Re: [PHP-DB] selecting question > : > : > : > Ok... so tbl.building_info contains all the different types of > buildings. > : > Didn't get that... :) > : > > : > So what are the other types for then? They seem to be identical. > : > > : > -- > : > William Fong - [EMAIL PROTECTED] > : > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > : > Wireless #: 805.490.7732| Wireless E-mail: > [EMAIL PROTECTED] > : > > : > > : > > : > > : > - Original Message - > : > From: "ACEAlex" <[EMAIL PROTECTED]> > : > To: "William Fong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > : > Sent: Wednesday, February 20, 2002 1:56 PM > : > Subject: Re: [PHP-DB] selecting question > : > > : > > : > : Because the buildings that are avaible are stored in building info. > : There > : > : are the info that says what the benifit is of that building to :) They > : are > : > : not identical. A building "type" can exist on several places :) > : > : > : > : /Alexander > : > : > : > : - Original Message - > : > : From: "William Fong" <[EMAIL PROTECTED]> > : > : To: <[EMAIL PROTECTED]> > : > : Sent: Wednesday, February 20, 2002 10:46 PM > : > : Subject: Re: [PHP-DB] selecting question > : > : > : > : > : > : > Hmmm... Why do you want two or three tables? Why not just one? > : > : > tbl.buildings and tbl.building_queue looks identical. Looks like > you > : > can > : > : > merge the two and stick it in tbl.building_info. Just add in > : > : > tbl.building_info a 'status' column. In that, I'd store say '1' for > : > : > building in progress, and '2' for finished buildings. > : > : > > : > : > ??? > : > : > > : > : > -w > : > : > > : > : > -- > : > : > William Fong - [EMAIL PROTECTED] > : > : > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > : > : > Wireless #: 805.490.7732| Wireless E-mail: > : > [EMAIL PROTECTED] > : > : > > : > : > > : > : > > : > : > > : > : > - Original Message - > : > : > From: "ACEAlex" <[EMAIL PROTECTED]> > : > : > To: "Rick Emery" <[EMAIL PROTECTED]>; "php-db" <[EMAIL PROTECTED]> > : > : > Sent: Wednesday, February 20, 2002 12:53 PM > : > : > Subject: Re: [PHP-DB] selecting question > : > : > > : > : > > : > : > : I could make a rutine in php to make it work but i want to make > the > : > : > : datagrabbing thing in mysql :( > : > : > : > : > : > : - Original Message - > : > : > : From: "Rick Emery" <[EMAIL PROTECTED]> > : > : > : To: "'ACEAlex'" <[EMAIL PROTECTED]> > : > : > : Sent: Wednesday, February 20, 2002 6:25 PM > : > : > : Subject: RE: [PHP-DB] selecting question > : > : > : > : > : > : > : > : > : > > : > : > : > I'm still trying to work this. There MUST be an easy answer... > : > : > : > rick > : > : > : > > : > : > : > --
Re: [PHP-DB] selecting question
As i discribed (or did i??) building_info is for the different types of buildings. Buildings are for those who are currently built, and building_queue are for those who are on queue. I also have a key called planet_id that says on which planet we are looking at. /Alexander - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 12:24 AM Subject: Re: [PHP-DB] selecting question > Ok... so tbl.building_info contains all the different types of buildings. > Didn't get that... :) > > So what are the other types for then? They seem to be identical. > > -- > William Fong - [EMAIL PROTECTED] > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] > > > > > - Original Message - > From: "ACEAlex" <[EMAIL PROTECTED]> > To: "William Fong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, February 20, 2002 1:56 PM > Subject: Re: [PHP-DB] selecting question > > > : Because the buildings that are avaible are stored in building info. There > : are the info that says what the benifit is of that building to :) They are > : not identical. A building "type" can exist on several places :) > : > : /Alexander > : > : - Original Message - > : From: "William Fong" <[EMAIL PROTECTED]> > : To: <[EMAIL PROTECTED]> > : Sent: Wednesday, February 20, 2002 10:46 PM > : Subject: Re: [PHP-DB] selecting question > : > : > : > Hmmm... Why do you want two or three tables? Why not just one? > : > tbl.buildings and tbl.building_queue looks identical. Looks like you > can > : > merge the two and stick it in tbl.building_info. Just add in > : > tbl.building_info a 'status' column. In that, I'd store say '1' for > : > building in progress, and '2' for finished buildings. > : > > : > ??? > : > > : > -w > : > > : > -- > : > William Fong - [EMAIL PROTECTED] > : > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > : > Wireless #: 805.490.7732| Wireless E-mail: > [EMAIL PROTECTED] > : > > : > > : > > : > > : > - Original Message - > : > From: "ACEAlex" <[EMAIL PROTECTED]> > : > To: "Rick Emery" <[EMAIL PROTECTED]>; "php-db" <[EMAIL PROTECTED]> > : > Sent: Wednesday, February 20, 2002 12:53 PM > : > Subject: Re: [PHP-DB] selecting question > : > > : > > : > : I could make a rutine in php to make it work but i want to make the > : > : datagrabbing thing in mysql :( > : > : > : > : - Original Message - > : > : From: "Rick Emery" <[EMAIL PROTECTED]> > : > : To: "'ACEAlex'" <[EMAIL PROTECTED]> > : > : Sent: Wednesday, February 20, 2002 6:25 PM > : > : Subject: RE: [PHP-DB] selecting question > : > : > : > : > : > : > > : > : > I'm still trying to work this. There MUST be an easy answer... > : > : > rick > : > : > > : > : > -Original Message- > : > : > From: ACEAlex [mailto:[EMAIL PROTECTED]] > : > : > Sent: Wednesday, February 20, 2002 9:30 AM > : > : > To: Markus Lervik > : > : > Cc: php-db > : > : > Subject: Re: [PHP-DB] selecting question > : > : > > : > : > > : > : > Ok. i think i have to make things clearer :).. Here, is my real > mysql > : > : thing. > : > : > I and a friend are trying to make a silly space game and i have > : problems > : > : > with this query. > : > : > Ok, if i set up a database with this > : > : > > : > : > CREATE TABLE building_info ( > : > : > id int(11) NOT NULL auto_increment, > : > : > name varchar(32) default NULL, > : > : > description text, > : > : > PRIMARY KEY (id) > : > : > ) TYPE=MyISAM; > : > : > INSERT INTO building_info VALUES (1,'Factory','N/A'); > : > : > INSERT INTO building_info VALUES (2,'Smaltvark','N/A'); > : > : > INSERT INTO building_info VALUES (3,'Superfarm','N/A'); > : > : > > : > : > CREATE TABLE buildings ( > : > : > id int(11) NOT NULL auto_increment, > : > : > planet_id int(11) default NULL, > : > : > building_id int(11) default NULL, > : > : > PRIMARY KEY (id) > : > : > ) TYPE=MyISAM; > : > : > > : > : > INSERT INTO buildings VALUES (1,1,1); > : > : > INSERT I
Re: [PHP-DB] selecting question
Because the buildings that are avaible are stored in building info. There are the info that says what the benifit is of that building to :) They are not identical. A building "type" can exist on several places :) /Alexander - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 10:46 PM Subject: Re: [PHP-DB] selecting question > Hmmm... Why do you want two or three tables? Why not just one? > tbl.buildings and tbl.building_queue looks identical. Looks like you can > merge the two and stick it in tbl.building_info. Just add in > tbl.building_info a 'status' column. In that, I'd store say '1' for > building in progress, and '2' for finished buildings. > > ??? > > -w > > -- > William Fong - [EMAIL PROTECTED] > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] > > > > > - Original Message - > From: "ACEAlex" <[EMAIL PROTECTED]> > To: "Rick Emery" <[EMAIL PROTECTED]>; "php-db" <[EMAIL PROTECTED]> > Sent: Wednesday, February 20, 2002 12:53 PM > Subject: Re: [PHP-DB] selecting question > > > : I could make a rutine in php to make it work but i want to make the > : datagrabbing thing in mysql :( > : > : - Original Message - > : From: "Rick Emery" <[EMAIL PROTECTED]> > : To: "'ACEAlex'" <[EMAIL PROTECTED]> > : Sent: Wednesday, February 20, 2002 6:25 PM > : Subject: RE: [PHP-DB] selecting question > : > : > : > > : > I'm still trying to work this. There MUST be an easy answer... > : > rick > : > > : > -Original Message- > : > From: ACEAlex [mailto:[EMAIL PROTECTED]] > : > Sent: Wednesday, February 20, 2002 9:30 AM > : > To: Markus Lervik > : > Cc: php-db > : > Subject: Re: [PHP-DB] selecting question > : > > : > > : > Ok. i think i have to make things clearer :).. Here, is my real mysql > : thing. > : > I and a friend are trying to make a silly space game and i have problems > : > with this query. > : > Ok, if i set up a database with this > : > > : > CREATE TABLE building_info ( > : > id int(11) NOT NULL auto_increment, > : > name varchar(32) default NULL, > : > description text, > : > PRIMARY KEY (id) > : > ) TYPE=MyISAM; > : > INSERT INTO building_info VALUES (1,'Factory','N/A'); > : > INSERT INTO building_info VALUES (2,'Smaltvark','N/A'); > : > INSERT INTO building_info VALUES (3,'Superfarm','N/A'); > : > > : > CREATE TABLE buildings ( > : > id int(11) NOT NULL auto_increment, > : > planet_id int(11) default NULL, > : > building_id int(11) default NULL, > : > PRIMARY KEY (id) > : > ) TYPE=MyISAM; > : > > : > INSERT INTO buildings VALUES (1,1,1); > : > INSERT INTO buildings VALUES (2,2,1); > : > INSERT INTO buildings VALUES (3,1,2); > : > INSERT INTO buildings VALUES (4,6,1); > : > INSERT INTO buildings VALUES (5,6,2); > : > > : > CREATE TABLE building_queue ( > : > id int(11) NOT NULL auto_increment, > : > building_id int(11) default NULL, > : > planet_id int(11) default NULL, > : > PRIMARY KEY (id) > : > ) TYPE=MyISAM; > : > > : > INSERT INTO building_queue VALUES (35,2,2); > : > INSERT INTO building_queue VALUES (22,2,7); > : > INSERT INTO building_queue VALUES (23,1,3); > : > INSERT INTO building_queue VALUES (25,1,5); > : > INSERT INTO building_queue VALUES (24,1,5); > : > INSERT INTO building_queue VALUES (26,2,5); > : > INSERT INTO building_queue VALUES (21,1,7); > : > INSERT INTO building_queue VALUES (28,1,4); > : > INSERT INTO building_queue VALUES (31,3,3); > : > > : > where building_info is the description of the building. I have removed > : some > : > info from it by the way :).. And building_queue is the queue of building > : > that is to be built that a planet has. And buildings is the buildings > : > actually pressent. > : > > : > I have another option that says planet_id that specifys the current > : planet. > : > > : > Ok, now i want to make a query that if i ask for planet_id=1 i will get > : the > : > building_info names of those buildings that are not in the queue and not > : > actually built.I cant get this to work :( > : > > : > For example,. if you load in this data and asks for planet_id=1 you > should > : > get > : >
Re: [PHP-DB] selecting question
I could make a rutine in php to make it work but i want to make the datagrabbing thing in mysql :( - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'ACEAlex'" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 6:25 PM Subject: RE: [PHP-DB] selecting question > > I'm still trying to work this. There MUST be an easy answer... > rick > > -Original Message- > From: ACEAlex [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 9:30 AM > To: Markus Lervik > Cc: php-db > Subject: Re: [PHP-DB] selecting question > > > Ok. i think i have to make things clearer :).. Here, is my real mysql thing. > I and a friend are trying to make a silly space game and i have problems > with this query. > Ok, if i set up a database with this > > CREATE TABLE building_info ( > id int(11) NOT NULL auto_increment, > name varchar(32) default NULL, > description text, > PRIMARY KEY (id) > ) TYPE=MyISAM; > INSERT INTO building_info VALUES (1,'Factory','N/A'); > INSERT INTO building_info VALUES (2,'Smaltvark','N/A'); > INSERT INTO building_info VALUES (3,'Superfarm','N/A'); > > CREATE TABLE buildings ( > id int(11) NOT NULL auto_increment, > planet_id int(11) default NULL, > building_id int(11) default NULL, > PRIMARY KEY (id) > ) TYPE=MyISAM; > > INSERT INTO buildings VALUES (1,1,1); > INSERT INTO buildings VALUES (2,2,1); > INSERT INTO buildings VALUES (3,1,2); > INSERT INTO buildings VALUES (4,6,1); > INSERT INTO buildings VALUES (5,6,2); > > CREATE TABLE building_queue ( > id int(11) NOT NULL auto_increment, > building_id int(11) default NULL, > planet_id int(11) default NULL, > PRIMARY KEY (id) > ) TYPE=MyISAM; > > INSERT INTO building_queue VALUES (35,2,2); > INSERT INTO building_queue VALUES (22,2,7); > INSERT INTO building_queue VALUES (23,1,3); > INSERT INTO building_queue VALUES (25,1,5); > INSERT INTO building_queue VALUES (24,1,5); > INSERT INTO building_queue VALUES (26,2,5); > INSERT INTO building_queue VALUES (21,1,7); > INSERT INTO building_queue VALUES (28,1,4); > INSERT INTO building_queue VALUES (31,3,3); > > where building_info is the description of the building. I have removed some > info from it by the way :).. And building_queue is the queue of building > that is to be built that a planet has. And buildings is the buildings > actually pressent. > > I have another option that says planet_id that specifys the current planet. > > Ok, now i want to make a query that if i ask for planet_id=1 i will get the > building_info names of those buildings that are not in the queue and not > actually built.I cant get this to work :( > > For example,. if you load in this data and asks for planet_id=1 you should > get > Superfarm > planet_id=2 should get > Superfarm > planet_id=3 should get > Smaltvark > > And so on :) > > Thanx again for responding > > /Alexander > > - Original Message - > From: "Markus Lervik" <[EMAIL PROTECTED]> > To: "ACEAlex" <[EMAIL PROTECTED]> > Cc: "php-db" <[EMAIL PROTECTED]> > Sent: Wednesday, February 20, 2002 2:31 PM > Subject: Re: [PHP-DB] selecting question > > > > On Wed, 2002-02-20 at 15:03, ACEAlex wrote: > > > > > Hi i have trouble with this mysql query. > > > > > > OK, i have 3 different tables. > > > > > > Tabel 1: building_info > > > id > > > name > > > price > > > and other > > > table 2:queue > > > id > > > building_id > > > table 3:buildings_built > > > building_id > > > > > > Ok, now i want to make a query that gets the data from building_info > where > > > it is not pressent in the queue and the buildings_built table. > > > > > > I have managed to get this to work with only 2 tables. So that i can get > the > > > things that are not present in the building_queue or in the > buildings_built > > > > > > Anyony have a nice solution for this? > > > > If I understood right, something like > > > > SELECT A.id,A.name,A.price > > FROM building_info AS A, queue AS B, buildings_built AS C > > WHERE (A.id != B.id AND B.building_id = C.building_id) > > > > should do it. I tested it on a simple db > > > > building_info("1","foo","200") > > building_info("2","bar","200") > > > > queue("1","1") > > > > buildings_built(&
Re: [PHP-DB] selecting question
Ok. i think i have to make things clearer :).. Here, is my real mysql thing. I and a friend are trying to make a silly space game and i have problems with this query. Ok, if i set up a database with this CREATE TABLE building_info ( id int(11) NOT NULL auto_increment, name varchar(32) default NULL, description text, PRIMARY KEY (id) ) TYPE=MyISAM; INSERT INTO building_info VALUES (1,'Factory','N/A'); INSERT INTO building_info VALUES (2,'Smaltvark','N/A'); INSERT INTO building_info VALUES (3,'Superfarm','N/A'); CREATE TABLE buildings ( id int(11) NOT NULL auto_increment, planet_id int(11) default NULL, building_id int(11) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; INSERT INTO buildings VALUES (1,1,1); INSERT INTO buildings VALUES (2,2,1); INSERT INTO buildings VALUES (3,1,2); INSERT INTO buildings VALUES (4,6,1); INSERT INTO buildings VALUES (5,6,2); CREATE TABLE building_queue ( id int(11) NOT NULL auto_increment, building_id int(11) default NULL, planet_id int(11) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; INSERT INTO building_queue VALUES (35,2,2); INSERT INTO building_queue VALUES (22,2,7); INSERT INTO building_queue VALUES (23,1,3); INSERT INTO building_queue VALUES (25,1,5); INSERT INTO building_queue VALUES (24,1,5); INSERT INTO building_queue VALUES (26,2,5); INSERT INTO building_queue VALUES (21,1,7); INSERT INTO building_queue VALUES (28,1,4); INSERT INTO building_queue VALUES (31,3,3); where building_info is the description of the building. I have removed some info from it by the way :).. And building_queue is the queue of building that is to be built that a planet has. And buildings is the buildings actually pressent. I have another option that says planet_id that specifys the current planet. Ok, now i want to make a query that if i ask for planet_id=1 i will get the building_info names of those buildings that are not in the queue and not actually built.I cant get this to work :( For example,. if you load in this data and asks for planet_id=1 you should get Superfarm planet_id=2 should get Superfarm planet_id=3 should get Smaltvark And so on :) Thanx again for responding /Alexander - Original Message - From: "Markus Lervik" <[EMAIL PROTECTED]> To: "ACEAlex" <[EMAIL PROTECTED]> Cc: "php-db" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 2:31 PM Subject: Re: [PHP-DB] selecting question > On Wed, 2002-02-20 at 15:03, ACEAlex wrote: > > > Hi i have trouble with this mysql query. > > > > OK, i have 3 different tables. > > > > Tabel 1: building_info > > id > > name > > price > > and other > > table 2:queue > > id > > building_id > > table 3:buildings_built > > building_id > > > > Ok, now i want to make a query that gets the data from building_info where > > it is not pressent in the queue and the buildings_built table. > > > > I have managed to get this to work with only 2 tables. So that i can get the > > things that are not present in the building_queue or in the buildings_built > > > > Anyony have a nice solution for this? > > If I understood right, something like > > SELECT A.id,A.name,A.price > FROM building_info AS A, queue AS B, buildings_built AS C > WHERE (A.id != B.id AND B.building_id = C.building_id) > > should do it. I tested it on a simple db > > building_info("1","foo","200") > building_info("2","bar","200") > > queue("1","1") > > buildings_built("1") > > This is what I got: > > mysql> SELECT A.id,A.name,A.price FROM building_info AS A, queue AS B, > buildings_built AS C WHERE (A.id != B.id AND B.building_id = > C.building_id)\G > *** 1. row *** >id: 2 > name: bar > price: 200 > 1 row in set (0.00 sec) > > mysql> > > > > Cheers, > Markus > > > -- > Markus Lervik > Linux-administrator with a kungfoo grip > Vaasa City Library - Regional Library > [EMAIL PROTECTED] > +358-6-325 3589 / +358-40-832 6709 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] selecting question
Hi i have trouble with this mysql query. OK, i have 3 different tables. Tabel 1: building_info id name price and other table 2:queue id building_id table 3:buildings_built building_id Ok, now i want to make a query that gets the data from building_info where it is not pressent in the queue and the buildings_built table. I have managed to get this to work with only 2 tables. So that i can get the things that are not present in the building_queue or in the buildings_built Anyony have a nice solution for this? /Alexander -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] addslashes()
Ahha, i see. Hmm well you can make your own addslashes function like this. Add the following line at the beginning of the php code function superaddslashes($input) { return ereg_replace ('"', '\"', $input); } Then you can do $Notes = superaddslashes($Notes); - Original Message - From: "Todd Williamsen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 11:54 PM Subject: Re: [PHP-DB] addslashes() > Ok.. > > i tried it out... and it almost works like I want it... weird though > > 1. when I put in this is BLUE > > it prints it in like a bright green. but if i use the RGB # then its fine. > weird > > 2. if there is an apostrophe in the notes, then it will add slashes it to > that as well > > so if I type blah blah blah I am going over to my friend's website later on > and here is the address... > > http://friends.com>Friends > > it will look like > > friend\\\'s > > Friends(link) > > . > "Acealex" <[EMAIL PROTECTED]> wrote in message > 002001c1b027$ec33b7b0$e4d22fc2@acealex">news:002001c1b027$ec33b7b0$e4d22fc2@acealex... > > Try > > $Notes = addslashes($Notes); > > > > You where almost right :) > > > > /Alexander > > > > - Original Message - > > From: "Todd Williamsen" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, February 07, 2002 11:32 PM > > Subject: [PHP-DB] addslashes() > > > > > > > I have a "Notes" field where users can add notes. Now, there will be > > times > > > when they use quotes "" or maybe even HTML, what is the correct way of > > using > > > this function? > > > > > > I have tried: > > > > > > addslashes($Notes); > > > > > > and > > > > > > $Notes addslashes($Notes); > > > > > > neither work.. > > > > > > I thought I would ask this great newsgroup! > > > > > > Thanks > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] addslashes()
Try $Notes = addslashes($Notes); You where almost right :) /Alexander - Original Message - From: "Todd Williamsen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 11:32 PM Subject: [PHP-DB] addslashes() > I have a "Notes" field where users can add notes. Now, there will be times > when they use quotes "" or maybe even HTML, what is the correct way of using > this function? > > I have tried: > > addslashes($Notes); > > and > > $Notes addslashes($Notes); > > neither work.. > > I thought I would ask this great newsgroup! > > Thanks > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php