Re: [PHP] MySQL Query Puzzle

Peter wrote: Hi All, I have a table which contain's some duplicate rows. I just want to delete the duplicate records alone not original records. Assume my table as look as below column1 column2 1 a 1 a 2 b 3 c 3 c i want the above table need to be as below, After exe

Re: [PHP] enabling domdocument

Ashley Sheridan wrote: OK, I seem to have answered my own question! It seems that even though PHP had the XML module enabled, I still needed to run 'yum update php-xml' in order for it to load in the DOM module. It's now working fine, and for those of you interested, the ./configure line in p

Re: [PHP] Determining the similarity between a user supplied short piece of text (between 5 and 15 characters) and a list of similar length text items.

On Mon, Jul 19, 2010 at 2:46 PM, tedd wrote: > At 12:39 PM +0100 7/19/10, Richard Quadling wrote: >> >> I'm using MS SQL, not mySQL. >> >> Found a extended stored procedure with a UDF. >> >> Testing it looks excellent. >> >> Searching for a match on 30,000 vehicles next to no additional time - >>

Re: [PHP] Determining the similarity between a user supplied short piece of text (between 5 and 15 characters) and a list of similar length text items.

At 12:39 PM +0100 7/19/10, Richard Quadling wrote: I'm using MS SQL, not mySQL. Found a extended stored procedure with a UDF. Testing it looks excellent. Searching for a match on 30,000 vehicles next to no additional time - a few seconds in total, compared to the over 3 minutes to search usin

Re: [PHP] MySQL Query Puzzle

Just to add more perspective : You will have a table with DISTINCT values. Drop the initial table (better take a back-up); copy from the temporary table which will have only DISTINCT values. Regards, Shreyas On Mon, Jul 19, 2010 at 7:58 PM, Shreyas Agasthya wrote: > How about this : > > CREATE

Re: [PHP] access violation

I switched to PHP 5.3.2 and to fastcgi and that seems to have cured the problem. Thanks for the reply -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] help using phpadmin

Hello Isaac Lee, I don't remember well, but I think this is the way to do it in Windows. You can try this: Start --> Run > cmd // Write it and press enter key. It will show you a MS-DOS window, Write there: mysql now: mysql> cd c:\location\mysql\bin Then you might try: mysqladmin -u

[PHP] Re: [MySQL] Re: MySQL select matching

On 7/19/2010 10:48 AM, Michael Dykman wrote: Not quite sure what the question is. from: mysql> select * from table where id='1'; +---+-+-+---+ | 1 | 123 | 0.0 | C | | 1 | 234 | 0.1 | D | | 1 | 345 | 0.0 | D | | 1 | 456 | 0.1 | C | | 1 | 567 | 0.1 | G | +

[PHP] Re: MySQL select matching

Not quite sure what the question is. from: > mysql> select * from table where id='1'; > +---+-+-+---+ > | 1 | 123 | 0.0 | C | > | 1 | 234 | 0.1 | D | > | 1 | 345 | 0.0 | D | > | 1 | 456 | 0.1 | C | > | 1 | 567 | 0.1 | G | > +---+-+-+---+ How do we d

[PHP] MySQL select matching

I may be going at this completely wrong but at the moment I'm stuck. I have a DB from a client and need to do several searches on it. This one sentence is important because it's their DB, not mine. So I can't modify the way the DB was created in the first place, I can only work with wh

[PHP] Copy documents for another site.

Hello I create one site like document menage system and nide to take some date information from another site. The problem is a don't have access to date base. The site from who I need to take infomations use .htdacces but I have user and password for enter to site and i look the information.

Re: [PHP] I need me a Good Book for PHP

I think php manual is one of the best thing to learn php -- Shafiq http://shafiq.pk --Original Message-- From: Joce Jovanov To: php-general@lists.php.net Subject: [PHP] I need me a Good Book for PHP Sent: Jul 19, 2010 8:54 PM Hello, I work only 6 mouth with PHP, and now star to like more

Re: [PHP] help using phpadmin

im using windows. On Mon, Jul 19, 2010 at 12:23 PM, Isaac Lee wrote: > thanks carlos, > > but where would i enter that command? > > and i tried editing the php.ini file but that didn't accomplish anything. > > isaac > > On Mon, Jul 19, 2010 at 1:29 AM, Carlos Sura wrote: >> Hello Isaac Lee. >> >

Re: [PHP] help using phpadmin

thanks carlos, but where would i enter that command? and i tried editing the php.ini file but that didn't accomplish anything. isaac On Mon, Jul 19, 2010 at 1:29 AM, Carlos Sura wrote: > Hello Isaac Lee. > > Are you running on Linux or Windows? > > You might try: > mysql> SET PASSWORD FOR ‘roo

Re: [PHP] I need me a Good Book for PHP

Joce, 6 mouth? I assume it's months. :) You can choose Head First with PHP and MySQL. Very good and I am currently learning form it; I am no veteran with the language but it's AWESOME. Also, good to know (for the PHP-veterans) will be : 1. Why are you learning PHP? 2. How do you plan to put your

[PHP] I need me a Good Book for PHP

Hello, I work only 6 mouth with PHP, and now star to like more and more. Do you someone know samo good books (tutorials) for PHP and MySQL. Thanks Best Regard Jovanov Jordan

RE: [PHP] Recent Influx of Unrelated Discussions

[snip] Also, once they implement and get things working, I would like to request all the members to let us know the code or even the pseudo-code to let us know how they made it work. We can collect those snippets and also ask not repeated questions. [/snip] You cannot stop the repeated questions,

Re: [PHP] Recent Influx of Unrelated Discussions

I completely agree with Dan's voice. I hear the tone. I am sure most of us here would spend a lot of time here to help each other out. Why not spend time on genuine PHP issues? Outside the scope of the discussion : Also, once they implement and get things working, I would like to request all the

Re: [PHP] Dynamic menu

On Sat, Jul 17, 2010 at 5:17 PM, jordan wrote: > I am new in this group and first whant to say hello to all. > Need me menu who have different link if user is login or logout, something > like dynamic menu. Somebody can tall me how can i use and create this > menu.

[PHP] Dynamic menu

Hello All, I am new in this group and first whant to say hello to all. Need me menu who have different link if user is login or logout, something like dynamic menu. Somebody can tall me how can i use and create this menu. Thansk -- PHP General Mailing List (http://www.php.net/) To unsubscrib

Re: [PHP] access violation

On Mon, Jul 19, 2010 at 9:54 AM, SteveW wrote: > I have various database / php apps running on a hosted windows machine. > > All apps run ok. > > We have installed a windows 2003 server machine and the apps run fine. > However if 2 users hit the Search button at the same time we get a PHP > access

Re: [PHP] enabling domdocument

Makes sense. Core would be more stripped down if it has modules available as separate packages. On Jul 19, 2010, at 4:19 AM, Ashley Sheridan wrote: > On Mon, 2010-07-19 at 12:09 +0100, Ashley Sheridan wrote: > >> Hi all, >> >> I'm having a bit of a problem here with getting DomDocument on PHP

Re: [PHP] MySQL Query Puzzle

How about this : CREATE TEMPORARY TABLE bad_temp1 (id INT,name VARCHAR(20)); INSERT INTO bad_temp1 (id,name) SELECT DISTINCT id,name FROM SAMPLE; Regards, Shreyas On Mon, Jul 19, 2010 at 7:31 PM, Richard Quadling wrote: > On 19 July 2010 05:44, Peter wrote: > > Hi All, > > > > I have a table

[PHP] access violation

I have various database / php apps running on a hosted windows machine. All apps run ok. We have installed a windows 2003 server machine and the apps run fine. However if 2 users hit the Search button at the same time we get a PHP access violation and I have to restart IIS. This is not happeni

Re: [PHP] MySQL Query Puzzle

On 19 July 2010 15:01, Richard Quadling wrote: > On 19 July 2010 05:44, Peter wrote: >> Hi All, >> >> I have a  table which contain's some duplicate rows. I just want to delete >> the duplicate records alone >> not original records. >> >> Assume my table as look as below >> >> column1 column2 >>

Re: [PHP] MySQL Query Puzzle

On 19 July 2010 05:44, Peter wrote: > Hi All, > > I have a  table which contain's some duplicate rows. I just want to delete > the duplicate records alone > not original records. > > Assume my table as look as below > > column1 column2 > 1 >        a > 1 >        a > 2 >        b > 3 >        c >

[PHP] Re: handing over data between two PHP connections

On 19/07/2010 12:21, Tobias Mueller wrote: > My question is: can this be done without a database? Can one PHP instance > (thread, process, ...) hand over data to another PHP instance? > > > (Actually there is an Apache Server that executes PHP scripts. Typical LAMP > configuration.) Hi, Yo

Re: [PHP] MySQL Query Puzzle

Hi Shiplu, Thanks for reply. Distinct function hide the duplicate records while we selecting the record through the Query i want to remove the duplicate entries in my table i need a Delete Query instead of Select Query shiplu wrote: Use distinct. SELECT DISTINCT COLUMN1, COLUMN2 FROM

Re: [PHP] function exists in command line but not in browser

On 19 July 2010 10:04, Nilesh Govindarajan wrote: > On Mon, Jul 19, 2010 at 2:22 PM, Shelley wrote: >> Hi all, >> >> The problem is imagettfbbox(). >> jpgraph uses it to create truetype font images. >> >> I have a phpinfo() script. >> >> The command line output: >> >> php i.php | grep Free >> Fre

Re: [PHP] Convert excel time to date time

On 17 July 2010 12:47, Mohd Shakir bin Zakaria wrote: > Hi, > > I've been trying to convert this excel date to the date time format, > but only managed to get it up to the seconds; > > The following code; > > # > $data=39604.62164; > date("Y-m-d",mktime(0,0,0,1,$data-1,1900)); > #

Re: [PHP] handing over data between two PHP connections

On Mon, 2010-07-19 at 13:21 +0200, Tobias Mueller wrote: > Am Sunday 18 July 2010 23:10:58 schrieb Floyd Resler: > > On Jul 18, 2010, at 3:27 PM, tobias.muelle...@web.de wrote: > > > Hello everybody > > > > > > For a science project I am working on a mechanism that hands over > > > data from a sma

Re: [PHP] MySQL Query Puzzle

Use distinct. SELECT DISTINCT COLUMN1, COLUMN2 FROM ... ... Shiplu Mokadd.im My talks, http://talk.cmyweb.net Follow me, http://twitter.com/shiplu SUST Programmers, http://groups.google.com/group/p2psust Innovation distinguishes bet ... ... (ask Steve Jobs the rest) -- PHP General Mailing List

Re: [PHP] handing over data between two PHP connections

Am Sunday 18 July 2010 23:10:58 schrieb Floyd Resler: > On Jul 18, 2010, at 3:27 PM, tobias.muelle...@web.de wrote: > > Hello everybody > > > > For a science project I am working on a mechanism that hands over > > data from a smartphone to a web-browser (=Internet PC). Both connect > > to a PHP ser

Re: [PHP] enabling domdocument

On Mon, 2010-07-19 at 12:09 +0100, Ashley Sheridan wrote: > Hi all, > > I'm having a bit of a problem here with getting DomDocument on PHP. I've > got a Fedora 11 system and have used the package manager to install PHP > and its various modules, at no point have I compiled PHP myself (which > has

[PHP] enabling domdocument

Hi all, I'm having a bit of a problem here with getting DomDocument on PHP. I've got a Fedora 11 system and have used the package manager to install PHP and its various modules, at no point have I compiled PHP myself (which has never worked when I've tried it, ever, but that's another issue) I've

Re: [PHP] function exists in command line but not in browser

On Mon, Jul 19, 2010 at 2:22 PM, Shelley wrote: > Hi all, > > The problem is imagettfbbox(). > jpgraph uses it to create truetype font images. > > I have a phpinfo() script. > > The command line output: > > php i.php | grep Free > FreeType Support => enabled > FreeType Linkage => with freetype > F

[PHP] function exists in command line but not in browser

Hi all, The problem is imagettfbbox(). jpgraph uses it to create truetype font images. I have a phpinfo() script. The command line output: php i.php | grep Free FreeType Support => enabled FreeType Linkage => with freetype FreeType Version => 2.2.1 But when the script is loaded in the browser,

Re: [PHP] functions and global variables

On Mon, 19 Jul 2010 13:37:12 +0530 Shreyas Agasthya wrote: > My two cents on this one. > > Modify the $name within the function and print it. > > Modify the$name outside the function (means the non-global-declared $name) > and print it. You will know the difference. > > --Shreyas > > On M

[PHP] Re: How to set socket_read time out

On Mon, Jul 19, 2010 at 9:45 AM, Gary wrote: > How can I get calls to scoket_read to timeout if the server stops > responding? Sorry. Found it: socket_set_option($sock, SOL_SOCKET, SO_RCVTIMEO, array('sec' => 1, 'usec' => 0)); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, vis

Re: [PHP] functions and global variables

My two cents on this one. Modify the $name within the function and print it. Modify the$name outside the function (means the non-global-declared $name) and print it. You will know the difference. --Shreyas On Mon, Jul 19, 2010 at 7:41 AM, Paul M Foster wrote: > On Sun, Jul 18, 2010 at 06:37:30

[PHP] How to set socket_read time out

How can I get calls to scoket_read to timeout if the server stops responding? It's not clear exactly what's happening, but occasionally the server simply stops sending data and my php code (client) then sits there waiting endlessly. I know about set_time_limit but I don't want to abandon the entire