[PHP] MySQL Newbie ? -Help!
Hi, Is there a way to go through a table and remove all duplicate entries so that there is only one? The way I am doing it now is taking FOREVER. Thanks, Matt Stone ___ This email may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you have received this email in error, please contact the sender and delete all copies. Opinions, conclusions or other information expressed or contained in this email are not given or endorsed by the sender unless otherwise affirmed independently by the sender. _ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL Newbie ? -Help!
Uhh not really, the table has about 3 entries. Don't really want to risk anything. I want to know how to do it through a MySQL statement, not a php script. -Original Message- From: Jason Brooke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 10 January 2001 2:39 PM To: Matt Stone; PHP List Subject: Re: [PHP] MySQL Newbie ? -Help! one simple way would be to make a duplicate, empty table and then do: insert into newtable select distinct * from oldtable then try adding a uniqueness constraint if you don't want duplicates in the future jason > Hi, > Is there a way to go through a table and remove all duplicate entries so > that there is only one? The way I am doing it now is taking FOREVER. Thanks, > > Matt Stone -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] MySQL Query Error
Hi, I have a MySQL statement, namely: SELECT COUNT(*) AS Count FROM images i LEFT JOIN categories c ON i.cat_id=c.id LEFT JOIN subcategories s ON i.subcat_id=s.id I want to change the LEFT JOINs to INNER JOINs like so: SELECT COUNT(*) AS Count FROM images i INNER JOIN categories c ON i.cat_id=c.id INNER JOIN subcategories s ON i.subcat_id=s.id But as soon as I do that I get this error message: MySQL Error: 1064 (You have an error in your SQL syntax near 'INNER JOIN categories c ON i.cat_id=c.id INNER JOIN subcategories s ON i.subcat_' at line 1) Session halted. Help please. Thanks, Matt Stone ___ This email may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you have received this email in error, please contact the sender and delete all copies. Opinions, conclusions or other information expressed or contained in this email are not given or endorsed by the sender unless otherwise affirmed independently by the sender. _ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL Query Error
No, that is exactly as the PHPLib Debug function is returning... :| -Original Message- From: Samantha Savvakis [mailto:[EMAIL PROTECTED]] Sent: Monday, 22 January 2001 3:21 PM To: Matt Stone Subject: RE: [PHP] MySQL Query Error I'm not sure why are getting that error. Is the statement you are running exactly the same as the one posted in the email? Check that you don't have a "comma" after the "images i" part. If i put a comma there, I can simulate your error. Otherwise, your syntax to me seems fine. > -----Original Message- > From: Matt Stone [mailto:[EMAIL PROTECTED]] > Sent: Monday, 22 January 2001 15:01 > To: PHP List > Subject: [PHP] MySQL Query Error > > > Hi, > I have a MySQL statement, namely: > SELECT COUNT(*) AS Count FROM images i LEFT JOIN categories c ON > i.cat_id=c.id LEFT JOIN subcategories s ON i.subcat_id=s.id > > I want to change the LEFT JOINs to INNER JOINs like so: > SELECT COUNT(*) AS Count FROM images i INNER JOIN categories c ON > i.cat_id=c.id INNER JOIN subcategories s ON i.subcat_id=s.id > > But as soon as I do that I get this error message: > MySQL Error: 1064 (You have an error in your SQL syntax near 'INNER JOIN > categories c ON i.cat_id=c.id INNER JOIN subcategories s ON i.subcat_' at > line 1) > Session halted. > > Help please. Thanks, > > Matt Stone > ___ > > This email may contain confidential and/or privileged information for the > sole use of the intended recipient. Any review or distribution by > others is > strictly prohibited. If you have received this email in error, please > contact the sender and delete all copies. Opinions, conclusions or other > information expressed or contained in this email are not given or endorsed > by the sender unless otherwise affirmed independently by the sender. > > _ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Help!!! MY ODBC!!!!
No idea dude, but I will bring the topic back to the top and some all-knowledgable guru will hopefully help you *hint hint* :) -Original Message- From: Bruno Freire [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 23 January 2001 3:01 AM To: '[EMAIL PROTECTED]' Subject: [PHP] Help!!! MY ODBC Hi everyone!! My name is BRUNO, and I'm in Brazil I dont know how to configure my_odbc!!! What I wanna do: I wanna make a report using The Crystal reports. My Mysql database is placed in a pc with LINUX. Then i have instaled Myodbc in may pc with Win98 but just install the MYODBC doesn't work!!! Please, If somebody knows that..HEEP! Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Aspell Function
Hi, I am trying to run this code from the manual but with no success: It returns this error: Fatal error: Call to undefined function: aspell_new() in /home/www/htdocs/sunsetstudios/photoscope/test.php on line 2 Is there a module have to enable to use Aspell? Or is there something I have to change in php.ini? Please help. --Nanda ___ This email may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you have received this email in error, please contact the sender and delete all copies. Opinions, conclusions or other information expressed or contained in this email are not given or endorsed by the sender unless otherwise affirmed independently by the sender. _ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Aspell Function
Ahh... found the answer :) So much for the PHP doc, it didnt say anything about what i needed, I had to use the Zend one :| -Original Message- From: Matt Stone [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 24 January 2001 12:54 PM To: PHP List Subject: [PHP] Aspell Function Hi, I am trying to run this code from the manual but with no success: It returns this error: Fatal error: Call to undefined function: aspell_new() in /home/www/htdocs/sunsetstudios/photoscope/test.php on line 2 Is there a module have to enable to use Aspell? Or is there something I have to change in php.ini? Please help. --Nanda ___ This email may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you have received this email in error, please contact the sender and delete all copies. Opinions, conclusions or other information expressed or contained in this email are not given or endorsed by the sender unless otherwise affirmed independently by the sender. _ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Aspell Function
I had to download a the aspell library :)
-Original Message-
From: Josh G [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 24 January 2001 1:03 PM
To: PHP User Group
Subject: Re: [PHP] Aspell Function
And the answer was?
Gfunk - http://www.gfunk007.com/
I sense much beer in you. Beer leads to intoxication, intoxication to
hangovers, and hangovers to... suffering.
- Original Message -
From: "Matt Stone" <[EMAIL PROTECTED]>
To: "Matt Stone" <[EMAIL PROTECTED]>; "PHP List"
<[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 2:02 PM
Subject: RE: [PHP] Aspell Function
> Ahh... found the answer :) So much for the PHP doc, it didnt say anything
> about what i needed, I had to use the Zend one :|
>
> -Original Message-
> From: Matt Stone [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 24 January 2001 12:54 PM
> To: PHP List
> Subject: [PHP] Aspell Function
>
>
> Hi,
> I am trying to run this code from the manual but with no success:
> $spellinglink = aspell_new ("english");
> if (aspell_check ($spellinglink, "testt")) {
> echo "This is a valid spelling";
> } else {
> echo "Sorry, wrong spelling";
> }
> ?>
>
> It returns this error:
> Fatal error: Call to undefined function: aspell_new() in
> /home/www/htdocs/sunsetstudios/photoscope/test.php on line 2
>
> Is there a module have to enable to use Aspell? Or is there something I
have
> to change in php.ini? Please help.
>
> --Nanda
>
> ___
>
> This email may contain confidential and/or privileged information for the
> sole use of the intended recipient. Any review or distribution by others
is
> strictly prohibited. If you have received this email in error, please
> contact the sender and delete all copies. Opinions, conclusions or other
> information expressed or contained in this email are not given or endorsed
> by the sender unless otherwise affirmed independently by the sender.
>
> _
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Aspell Function
Arghh!! Is aspell even supported on windows 2k?
-Original Message-
From: Matt Stone [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 24 January 2001 1:06 PM
To: Josh G; PHP User Group
Subject: RE: [PHP] Aspell Function
I had to download a the aspell library :)
-Original Message-
From: Josh G [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 24 January 2001 1:03 PM
To: PHP User Group
Subject: Re: [PHP] Aspell Function
And the answer was?
Gfunk - http://www.gfunk007.com/
I sense much beer in you. Beer leads to intoxication, intoxication to
hangovers, and hangovers to... suffering.
- Original Message -
From: "Matt Stone" <[EMAIL PROTECTED]>
To: "Matt Stone" <[EMAIL PROTECTED]>; "PHP List"
<[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 2:02 PM
Subject: RE: [PHP] Aspell Function
> Ahh... found the answer :) So much for the PHP doc, it didnt say anything
> about what i needed, I had to use the Zend one :|
>
> -Original Message-
> From: Matt Stone [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 24 January 2001 12:54 PM
> To: PHP List
> Subject: [PHP] Aspell Function
>
>
> Hi,
> I am trying to run this code from the manual but with no success:
> $spellinglink = aspell_new ("english");
> if (aspell_check ($spellinglink, "testt")) {
> echo "This is a valid spelling";
> } else {
> echo "Sorry, wrong spelling";
> }
> ?>
>
> It returns this error:
> Fatal error: Call to undefined function: aspell_new() in
> /home/www/htdocs/sunsetstudios/photoscope/test.php on line 2
>
> Is there a module have to enable to use Aspell? Or is there something I
have
> to change in php.ini? Please help.
>
> --Nanda
>
> ___
>
> This email may contain confidential and/or privileged information for the
> sole use of the intended recipient. Any review or distribution by others
is
> strictly prohibited. If you have received this email in error, please
> contact the sender and delete all copies. Opinions, conclusions or other
> information expressed or contained in this email are not given or endorsed
> by the sender unless otherwise affirmed independently by the sender.
>
> _
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] A NETWORK MARKETER?
Leaders of the industry with a geocities address... whopdee do -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 March 2001 1:09 PM To: [EMAIL PROTECTED] Subject: [PHP] A NETWORK MARKETER? ATTENTION: ANY SERIOUS NETWORK MARKETER TAKE A LOOK AT THE FOLLOWING OPPORTUNITY I CAME ACROSS!! IF YOU PLUG INTO THEIR PROVEN SYSTEM, THEY GUARANTEE YOU SUCCESS, AND PROVIDE YOU WITH FREE LEADS TO BUILD YOUR GROUP!! DO NOT LET THIS SLIP AWAY!! CLICK BELOW AND FIND OUT AS I DID, WHY THESE GUYS ARE THE LEADERS IN THE INDUSTRY!! http://www.geocities.com/businessupdates2000 * THIS EMAIL COMPLIES WITH ALL REGULATIONS. TO BE REMOVED WITHIN 24 Hours, SIMPLYEMAIL [EMAIL PROTECTED] FOR IMMEDIATE REMOVAL FROM ANY FUTURE EMAILS FROM OUR COMPANY. * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Cache
Hi, This might be a little of topic... I am having real trouble with cached PHP pages, they just never seem to refresh... I have dissabled my local cache (IE5.5 Win2k) to the best of my knowledge (suggestions on how to do this properly welcome) but are still having trouble. I am not sure whether it is my local cache my ISP's cache. Anyhow, can anyone suggest a tag or something for me to put in my page so it refreshes and bypasses the cache? It is getting _REALLY_ annoying :\ Thanks, Matt Stone -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Cache
That goes in the PHP code no?
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 21 March 2001 1:56 PM
To: Matt Stone; PHPlist
Subject: RE: [PHP] Cache
Hi Matt,
For a very extensive solution, check this out:
http://www.zend.com/codex.php?id=435&single=1
Or, if you just want all your pages to be forced to load all the time
regardless...
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Expires: Mon,26 Jul 1997 05:00:00 GMT");
-----Original Message-
From: Matt Stone [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 7:39 PM
To: PHPlist
Subject: [PHP] Cache
Hi,
This might be a little of topic...
I am having real trouble with cached PHP pages, they just never seem to
refresh... I have dissabled my local cache (IE5.5 Win2k) to the best of my
knowledge (suggestions on how to do this properly welcome) but are still
having trouble.
I am not sure whether it is my local cache my ISP's cache. Anyhow, can
anyone suggest a tag or something for me to put in my page so it refreshes
and bypasses the cache? It is getting _REALLY_ annoying :\
Thanks,
Matt Stone
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Cache
No prob, that works fine. Thanks so much :)
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 21 March 2001 2:04 PM
To: Matt Stone; PHPlist
Subject: RE: [PHP] Cache
Yup, at the beginning of your PHP script. Sorry, I should have mentioned
that... :)
-Original Message-
From: Matt Stone [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:04 PM
To: Tyrone Mills; PHPlist
Subject: RE: [PHP] Cache
That goes in the PHP code no?
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 21 March 2001 1:56 PM
To: Matt Stone; PHPlist
Subject: RE: [PHP] Cache
Hi Matt,
For a very extensive solution, check this out:
http://www.zend.com/codex.php?id=435&single=1
Or, if you just want all your pages to be forced to load all the time
regardless...
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Expires: Mon,26 Jul 1997 05:00:00 GMT");
-----Original Message-
From: Matt Stone [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 7:39 PM
To: PHPlist
Subject: [PHP] Cache
Hi,
This might be a little of topic...
I am having real trouble with cached PHP pages, they just never seem to
refresh... I have dissabled my local cache (IE5.5 Win2k) to the best of my
knowledge (suggestions on how to do this properly welcome) but are still
having trouble.
I am not sure whether it is my local cache my ISP's cache. Anyhow, can
anyone suggest a tag or something for me to put in my page so it refreshes
and bypasses the cache? It is getting _REALLY_ annoying :\
Thanks,
Matt Stone
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] HallMark uses PHP!!!!
lol -Original Message- From: Kath [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 7:18 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] HallMark uses PHP http://www.bbspot.com/News/2000/6/php_suspend.html - Kath - Original Message - From: "Joseph Blythe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 14, 2001 12:30 AM Subject: Re: [PHP] HallMark uses PHP > [EMAIL PROTECTED] wrote: > > > I was just looking at Hallmark Channels' website, and noticed them to be using PHP, wow, PHP has rocketed to something, eh. > > Yes, when I first started using php nearly 2 years ago not many people > even knew what it was (most thought it was some form of a drug). Now > days you are hard pressed not to at least come across one site using it > during a normal web browsing session. > > Long Live PHP, > > Joseph > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] The ubitquitous forum project
I dont like any of them, the UBB style is the best. -Original Message- From: Kath [mailto:[EMAIL PROTECTED]] Sent: Monday, 26 March 2001 2:02 PM To: Gfunk; Stephan Ahonen; PHP User Group Subject: Re: [PHP] The ubitquitous forum project I think what he means is this: This is newsgroup style: + Main Post | | - Reply 1 | | --- Reply 1 to Reply 1 | --- Reply 2 to Reply 1 | | --- Reply 1 to Reply 2 to Reply 1 | | - Reply 2 ( I hope that formatted ok) This is phorum style: + Main Post - Reply 1 - Reply 2 - Reply 3 - Reply 4 I'm partial to phorum style, myself. - Kath - Original Message - From: "Gfunk" <[EMAIL PROTECTED]> To: "Stephan Ahonen" <[EMAIL PROTECTED]>; "PHP User Group" <[EMAIL PROTECTED]> Sent: Sunday, March 25, 2001 10:48 PM Subject: Re: [PHP] The ubitquitous forum project > What's the difference between newsgroup-style and phorum style threads? > > I'm always doing messageboards, and this thread got my attention > > -- -- > Gfunk - [EMAIL PROTECTED] > http://www.gfunk007.com/ > -- -- > > > - Original Message - > From: "Stephan Ahonen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, March 26, 2001 1:46 PM > Subject: Re: [PHP] The ubitquitous forum project > > > > > Any advice? > > > > USENET style threads. I *really* hate Phorum-style threads, where > > everything's just tacked onto the end. Though Phorum-style is easier, it > > really detracts from the conversation when you have to write whose post > > you're replying to in your replies. > > > > Sig for a Day > > Stephan Ahonen, ICQ 491101 > > "That's very funny Scotty, now beam down my clothes!" > > Come back tomorrow for a different sig! > > Backspace a single "s" to reply by email > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] The ubitquitous forum project
Like so http://www.planetveggie.com/ubb-bin/Ultimate.cgi?action=intro Basically Topic 1 Topic 2 Topic 3 Topic 4 Topic 5 say I click on topic 5 then Topic 5 Post 1 Post 1 Post 1 Post 1 -Original Message- From: Felix Kronlage [mailto:[EMAIL PROTECTED]] Sent: Monday, 26 March 2001 2:52 PM To: Matt Stone Cc: PHP User Group Subject: Re: [PHP] The ubitquitous forum project On Mon, Mar 26, 2001 at 02:11:46PM +1000, Matt Stone wrote: > I dont like any of them, the UBB style is the best. what's UBB-style like? -fkr -- gpg-fingerprint: 076E 1E87 3E05 1C7F B1A0 8A48 0D31 9BD3 D9AC 74D0 |http://www.hazardous.org/ | whois -h whois.ripe.de FKR-RIPE | |all your base are belong to us | shame on me | fkr@IRCnet | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] The ubitquitous forum project
See http://www.planetveggie.com/ubb-bin/Ultimate.cgi?action=intro Basically it is like: Topic 1 Topic 2 Topic 3 Topic 4 Topic 5 When I click on topic 5 I get: Topic 5: Post 1 Post 2 Post 3 Post 4 Post 5 See for yourself. -Original Message- From: Felix Kronlage [mailto:[EMAIL PROTECTED]] Sent: Monday, 26 March 2001 2:52 PM To: Matt Stone Cc: PHP User Group Subject: Re: [PHP] The ubitquitous forum project On Mon, Mar 26, 2001 at 02:11:46PM +1000, Matt Stone wrote: > I dont like any of them, the UBB style is the best. what's UBB-style like? -fkr -- gpg-fingerprint: 076E 1E87 3E05 1C7F B1A0 8A48 0D31 9BD3 D9AC 74D0 |http://www.hazardous.org/ | whois -h whois.ripe.de FKR-RIPE | |all your base are belong to us | shame on me | fkr@IRCnet | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Random letter/number passwords
Hi, I have this code below which is supposed to be generating a password like QCCQCN2-IUZ with 10 characters - All but three in the first section (7) and three in the last part - but does not work in all cases. Sometimes it prints LPSA3WD-IM or G22G2G9-FC. Is there a catch in the code that will stuff up in certain circumstances? Please help, Matt stone ___ "; } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Random letter/number passwords
Oops sorry, this line is supposed to read: $passfirst = randomGen($length-3, 1); >>$passend = randomGen(3, 0); $pass = $passfirst.'-'.$passend; return $pass; -Original Message- From: Matt Stone [mailto:[EMAIL PROTECTED]] Sent: Monday, 26 March 2001 4:12 PM To: PHPlist Subject: [PHP] Random letter/number passwords Hi, I have this code below which is supposed to be generating a password like QCCQCN2-IUZ with 10 characters - All but three in the first section (7) and three in the last part - but does not work in all cases. Sometimes it prints LPSA3WD-IM or G22G2G9-FC. Is there a catch in the code that will stuff up in certain circumstances? Please help, Matt stone ___ "; } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Number/Letter Passwords
Hi,Hi, I have this code below which is supposed to be generating a password like QCCQCN2-IUZ with 10 characters - All but three in the first section (7) and three in the last part - but does not work in all cases. Sometimes it prints LPSA3WD-IM or G22G2G9-FC. Is there a catch in the code that will stuff up in certain circumstances? Please help, Matt stone _ "; } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Displaying query results
Hi, I have a excellent library for doing just that but it is very complicated and integrated into the other libraries. Perhaps check out http://www.phpbuilder.com/columns/rod2221.php3 which is an article on what you are trying to do. Good luck, Matt Stone -Original Message- From: elias [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 March 2001 6:24 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Displaying query results Dear Sir, Consider the following attached example. Hope it helps. Best regards, -Elias bachaalany. ""M. A. Ould-Beddi"" <[EMAIL PROTECTED]> wrote in message Pine.LNX.3.96.1010329091827.2931A-10@localhost">news:Pine.LNX.3.96.1010329091827.2931A-10@localhost... > > I wrote a PHP script which perfrom > a query on a MysQl databasis. i want > the result to be displayed by 10 records > in each page with hyperlinks to move to the > next or previous page and to each page. > > Something like this: > > XX records were found > Display 1-10 results > > 1- > 2 > . > > Next Previous. > > How can I do this > > > -- > | | > |Dr. Mohamed Abderrahmane Ould Beddi | > |Faculty of Sciences and Technology | > |University of Nouakchott | > | B.P. 5026, Nouakchott - MAURITANIA | > |Email: [EMAIL PROTECTED] | > |_| > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] PEAR
I think the PEAR class file comes with PHP4... si that correct? -Original Message- From: glenn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 4 April 2001 11:47 AM To: [EMAIL PROTECTED] Subject: [PHP] PEAR Does anyone know where I can get the basic pear class file from? I'm using the omni webserver on a windows machine. It has php built into it, but doesn't know anything about pear. -- -- Homepage: http://www.sfu.ca/~gpalmer ICQ#: 4930151 NH Off topic page: http://equestrianpleasures.da.ru/offtopic -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Stripping single quotes
Hi all,
I am trying to validate some email addresses before they are entered into
the database.
The problem is, some thick or malicious people are entering single quotes
into their email addresses.
I need to strip out all these single quotes but a little ole' str_replace
doesn't seem to be working.
Here it is:
$fldemail == str_replace("'","",$fldemail);
Nice and basic :)
Can anyone please enlighten me on this?
Thanks in advance,
Matt Stone
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Stripping single quotes
Darn, it still 'aint working. Ok, let's say $fldemail contains
"o\'[EMAIL PROTECTED]"
I then run these:
$fldemail == stripslashes($fldemail);
$fldemail == ereg_replace("'","",$fldemail);
And I get "o\'[EMAIL PROTECTED]" ... damn.
Any ideas? Thanks,
Matt Stone
-Original Message-
From: Chris Fry [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 28 July 2001 2:15 PM
To: Matt Stone
Cc: PHP list
Subject: Re: [PHP] Stripping single quotes
Matt,
Try ereg_replace:-
$fldemail == ereg_replace("'","",$fldemail);
Chris
Matt Stone wrote:
> Hi all,
> I am trying to validate some email addresses before they are entered into
> the database.
> The problem is, some thick or malicious people are entering single quotes
> into their email addresses.
> I need to strip out all these single quotes but a little ole' str_replace
> doesn't seem to be working.
> Here it is:
>
> $fldemail == str_replace("'","",$fldemail);
>
> Nice and basic :)
> Can anyone please enlighten me on this?
> Thanks in advance,
>
> Matt Stone
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Chris Fry
Quillsoft Pty Ltd
Specialists in Secure Internet Services and E-Commerce Solutions
10 Gray Street
Kogarah
NSW 2217
Australia
Phone: +61 2 9553 1691
Fax: +61 2 9553 1692
Mobile: 0419 414 323
eMail: [EMAIL PROTECTED]
http://www.quillsoft.com.au
You can download our Public CA Certificate from:-
https://ca.secureanywhere.com/htdocs/cacert.crt
**
This information contains confidential information intended only for
the use of the authorised recipient. If you are not an authorised
recipient of this e-mail, please contact Quillsoft Pty Ltd by return
e-mail.
In this case, you should not read, print, re-transmit, store or act
in reliance on this e-mail or any attachments, and should destroy all
copies of them.
This e-mail and any attachments may also contain copyright material
belonging to Quillsoft Pty Ltd.
The views expressed in this e-mail or attachments are the views of
the author and not the views of Quillsoft Pty Ltd.
You should only deal with the material contained in this e-mail if
you are authorised to do so.
This notice should not be removed.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Stripping single quotes
Thanks for your help everyone, I feel pretty embarrassed to have made a
mistake like that! :o
-Original Message-
From: Bojan Gajic [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 29 July 2001 12:44 AM
To: Matt Stone
Subject: Re: [PHP] Stripping single quotes
you are not assigning stripslashes($fldemail) to the $fldemail, you are
maching
them. use '=' instead of '= ='
hth,
bojan
Matt Stone wrote:
> Darn, it still 'aint working. Ok, let's say $fldemail contains
> "o\'[EMAIL PROTECTED]"
> I then run these:
> $fldemail == stripslashes($fldemail);
> $fldemail == ereg_replace("'","",$fldemail);
> And I get "o\'[EMAIL PROTECTED]" ... damn.
>
> Any ideas? Thanks,
>
> Matt Stone
>
> -Original Message-
> From: Chris Fry [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, 28 July 2001 2:15 PM
> To: Matt Stone
> Cc: PHP list
> Subject: Re: [PHP] Stripping single quotes
>
> Matt,
>
> Try ereg_replace:-
>
> $fldemail == ereg_replace("'","",$fldemail);
>
> Chris
>
> Matt Stone wrote:
>
> > Hi all,
> > I am trying to validate some email addresses before they are entered
into
> > the database.
> > The problem is, some thick or malicious people are entering single
quotes
> > into their email addresses.
> > I need to strip out all these single quotes but a little ole'
str_replace
> > doesn't seem to be working.
> > Here it is:
> >
> > $fldemail == str_replace("'","",$fldemail);
> >
> > Nice and basic :)
> > Can anyone please enlighten me on this?
> > Thanks in advance,
> >
> > Matt Stone
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
>
> Chris Fry
> Quillsoft Pty Ltd
> Specialists in Secure Internet Services and E-Commerce Solutions
> 10 Gray Street
> Kogarah
> NSW 2217
> Australia
>
> Phone: +61 2 9553 1691
> Fax: +61 2 9553 1692
> Mobile: 0419 414 323
> eMail: [EMAIL PROTECTED]
> http://www.quillsoft.com.au
>
> You can download our Public CA Certificate from:-
> https://ca.secureanywhere.com/htdocs/cacert.crt
>
> **
>
> This information contains confidential information intended only for
> the use of the authorised recipient. If you are not an authorised
> recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> e-mail.
> In this case, you should not read, print, re-transmit, store or act
> in reliance on this e-mail or any attachments, and should destroy all
> copies of them.
> This e-mail and any attachments may also contain copyright material
> belonging to Quillsoft Pty Ltd.
> The views expressed in this e-mail or attachments are the views of
> the author and not the views of Quillsoft Pty Ltd.
> You should only deal with the material contained in this e-mail if
> you are authorised to do so.
>
> This notice should not be removed.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] How secure is this?
On 2/22/06, tedd <[EMAIL PROTECTED]> wrote: > > > > PS: This site works for: Opera 8.5+, Safari, Netscape 7.2+, Mozillia > 1.6+, FireFox 1.0.7+, Konqueror 3.4.0+, and IE 5+ (except Mac) > > Doesn't work for me firefox 1.0.3 on fedora core 3. FYI, javascript consoles outputs: Error: document.getElementById(update[0]) has no properties Source File: http://www.xn--ovg.com/aja/test.js Line: 35 Cheers Matt
Re: [PHP] HOW update time and date-fields to mysql....
On 2/28/06, Gustav Wiberg <[EMAIL PROTECTED]> wrote: > > Hi there guys! > > I have used a date-field and a time-field in a mysql-database. > > > > > $sql = "UPDATE tbforum SET"; > $sql .= " question=" . safeQuote($frmQuestion); > $sql .= ", insertDate='" . $dat . "'"; > $sql .= ", insertTime='" . time() . "'"; > $sql .= " WHERE IDForum=" . safeQuote($idForum); > $querys = mysql_query($sql); Use NOW() for both your date and time fields if the fields have been set up as that. MySQL will then add the date and time according to whatever those values are on your db machine. Cheers Matt
Re: [PHP] Validating Email addrs
- Original Message - From: "Leonard Burton" <[EMAIL PROTECTED]> To: "PHP-General" Sent: Tuesday, November 15, 2005 4:16 PM Subject: [PHP] Validating Email addrs >Hi All, >I know that it is pretty darn impossible to come up with a regular >expression for validating emails. >How do you all validated emails on form submission? There's a good article on validating e mails here: http://tinyurl.com/9k5jh Cheers Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Autodeleting news when it has become yesterdays news
- Original Message - From: "twistednetadmin" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 23, 2005 7:02 AM Subject: [PHP] Autodeleting news when it has become yesterdays news >I have a news-script on a webpage. Or an eventscript you might call it. >This lists up events thats gonna happen on a given day. ie concerts and >sportsevents. >To get this deleted without having to log on to the adminpage when the event >s over would have been a great relief. >1. Is it just as simple as writing a query that executes and removes news >with yesterdays date? Yup, DELETE FROM your_table WHERE date_column = curdate() -1; Cheers Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Blocking Values From an External Source
- Original Message -
From: "Shaun" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 16, 2005 7:50 PM
Subject: [PHP] Blocking Values From an External Source
> Hi,
>
> I have a script on my site for processing values sent from a contact form
> and emailing them to the webmaster. The script has been abused by spammers
> and my hosting company has recommended that I change the script to only
> accept information posted from my own URL. Could someone tell me how this
> can be done please?
>
If your script is being abused through mail headers injection, making it
only accept information being posted from your own url won't work.
First set a max length in your "from e mail address" text box and validate
that. For example:
if (strlen($_POST['email']) > SOME_NUMBER ){
die ("E Mail Address Too Long");
}
Next, validate your e mail address to the rfc standard, there's a good
tutorial here: http://www.iamcal.com/publish/articles/php/parsing_email/
If you validate it using the function in the article your form will be
bulletproof as far as headers injection goes as the rfc standard does not
allow a '\' or ':' in the address. If you follow your isp's advice and still
allow invalid input from your form you're leaving yourself wide open to
header injection. For example someone can still input
[EMAIL PROTECTED]: [EMAIL PROTECTED]
into the from address field. Who needs a bot to post that info when a single
click on a form can see your script used to spam a stack of recipients? To
put it another way, is it worth validating the source of your input if
you're not going to validate the input itself?
HTH
Cheers
Matt
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Need help with modifying values
There's a big difference between the first and second scripts your using.
The second one isn't using a while loop so will only return the first row in
the recordset. See below.
HTH
Cheers
Matt
- Original Message -
From: "Anasta" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 18, 2005 8:21 AM
Subject: [PHP] Need help with modifying values
> while ($myrow = mysql_fetch_array($result)) {
>
> echo "" . $myrow['Name'] . "";
> echo "" . $myrow['Rating'] . "";
> echo " "'>Modify";
> }
> ?>
+
>
>
> $myrow = mysql_fetch_array($result);
>
> $Name = $myrow['Name'];
> $Rating = $myrow['Rating'];
>
> ?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Application Vuln. Testing
- Original Message - From: "Jason Gerfen" <[EMAIL PROTECTED]> To: "PHP General (E-mail)" Sent: Tuesday, February 07, 2006 4:54 PM Subject: [PHP] PHP Application Vuln. Testing > > Is there any product available, commercial or free which performs source > code auditing which *specificly searches PHP code for SQL, XSS type of > attacks or vulnerabilities? TIA. > http://www.parosproxy.org/index.shtml doesn't audit source code but if you can dump your code on a test box you can test it from another machine. Cheers Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
