Re: [PHP-DB] detecting browser close or change of url

), concentrate on what happens when the user logs in. For example you could remove previous sessions for a particular user upon successful login. To remove abandoned sessions, use a separate cron-controlled script in conjunction with PHP's built-in session garbage collector. Pablo -- PHP Database Mailing

[PHP-DB] Agata Report: new version

. The labels will be generated in a 2 columns A4 paper (PostScript File); * Dia tool is a Diagram generator tool. Through this option you can generate a Diagram (DIA Format) with all the tables you are working on. Dia tool doesn't establish the lines among the tables in the Diagram yet. Pablo Dall'Oglio

[PHP-DB] Agata Report :: New Version 4 beta 002

or InterBase, lists its tables, fields and allows linking among tables, make constraints, orders, to group data, to apply functions and make queries. It generates results to PostScript or Text file. :: Pablo Dall'Oglio ([EMAIL PROTECTED]) :: Univates - IT Department +55 (51) 3714-7040 :: Linux

Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal next day

2004 print(br); $thisdate=date(d m Y,$next); print($thisdate); ? how come? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Pablo M. Rivas. http://pmrivas.ipupdater.com

[PHP-DB] pdo and oracle drivers

doing something wrong or if the oracle implementation is still so immature. If this is so, what are the plans to get this implementation along the status of mysql (which I tried and it works fine). I appreciate any feedback, Pablo Godel -- PHP Database Mailing List (http://www.php.net

[PHP-DB] DB2 - wrong number of parameters

\principal\Portal\Repositorio\Funcionarios.class.php on line 170 what´s the problem??? thanks Pablo Garay Ijuí - UNIJUI RS - Brasil

[PHP-DB] Using pdo in a server where php was compiled with --disable-pdo

. Is there a way to supply this dependence?? I cant change the servers, but I can manually modify php.ini variables from an .htaccess and add files to my content. -- Pablo Marchant Campos Estudiante Licenciatura en Astronomía PUC Miembro area TI SinergiaUC

[PHP-DB] Re: Using pdo in a server where php was compiled with --disable-pdo

. Is there a way to supply this dependence?? I cant change the servers, but I can manually modify php.ini variables from an .htaccess and add files to my content. -- Pablo Marchant Campos Estudiante Licenciatura en Astronomía PUC Miembro area TI SinergiaUC -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] new pair of eyes

Juan Pablo Aqueveque [EMAIL PROTECTED] Ingeniero de Sistemas Departamento de Redes y Comunicaciones http://www.drc.uct.cl Universidad Católica de Temuco. Tel:(5645) 205 630 Fax:(5645) 205 628 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Last ID from database?

-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002 Juan Pablo Aqueveque [EMAIL PROTECTED] Ingeniero de Sistemas Departamento de Redes y Comunicaciones http://www.drc.uct.cl Universidad

Re[2]: [PHP-DB] Beta Testers Needed

Hello Kenny, Hans is right, but i'll take the challenge, send me the code and I will look it for a while and tell you... -- Best regards, Pablomailto:[EMAIL PROTECTED] Tuesday, June 15, 2004, 12:17:48 PM, you wrote: HL Yeah, this is a joke, right? HL

Re: [PHP-DB] Fetch two mysql resource in while loop

trying to figure out why this is so... Perhaps operator precedence?... don't know for sure. -- Best regards, Pablomailto:[EMAIL PROTECTED] Thursday, June 17, 2004, 12:26:29 AM, you wrote: s Hi all: s i worte a piece of code like this s $result1 = mysql_query

Re: [PHP-DB] help with consecutive numbers in db

might test.. -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] help with consecutive numbers in db

Hello Pablo, I made a Typo: change this: while ($key80) echo $lastgroup. . ($key++) . is freebr\n; for this: while ($key255) echo $lastgroup. . ($key++) . is freebr\n; ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Dates and Count

clients have 5 operations, and each row will tell you: howmany (always = 5), id of the client, and name of the client. ¿is this what you where looking for?... -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] MySQL: Random select with specific count of a column

is not null group by a.category TR I would like to select 6 random rows where the language is 'de' AND make TR sure that I will always have 2 rows of EACH category in my result set: -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] More problems with searching

something wrong? SM this was Mr Holmes's solution (in part): SM $query = SELECT * FROM keyword WHERE 1 SM $words = explode(' ',$_GET['search_text']); SM foreach($words as $word) SM { $query .= AND keyword = '$word' ; } SM Ideas? SM Shiloh -- Best regards, Pablo -- PHP Database Mailing List

Re[2]: [PHP-DB] Dates and Count

I need the same scenario, however I want to search from a variety of SD different fields, show those that are between the dates and are equal to one SD other criteria. SD Any help on these two? SD Cheers, SD Shannon -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net

Re[2]: [PHP-DB] MySQL: Random select with specific count of a column

... but i think this will work and you can make it better!! -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] Re: MySQL query, using DISTINCT...

`completed_downloads` WHERE TPrsc `bu` = 'reech' AND date BETWEEN '2004-06-01' AND '2004-06-30' Tris... -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Storing Date in mysql

I would like to know fro the list is ... is this the best way to store the date ? Would this be easy to select against ? MG Michael. -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Column help needed (Table)

-- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Multiple SELECT

-- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Restrict account access to single user

Hello veditio, You can use sessions: http://www.php.net/manual/en/ref.session.php and pay attention to: http://www.php.net/manual/en/function.session-cache-expire.php and session.use_cookies = 0 -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

Hello Ross, why don't use: explain select . and you'll see what mysql is thinking... ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] Begining PHP...Have Questions

-- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] Wait Statement... ?

Hello John, sleep() is the brute deffense of the brute force attack... You can make a script that opens simultaneous attacks JWH I'm not saying using sleep is the solution to security problems, but JWH it can be one layer of your defense. -- Best regards, Pablo -- PHP Database

Re: [PHP-DB] Joining Tables for Search

, middlename, familyname, fathername) AGAINST ('$keywords' IN BOOLEAN MODE) ORDER BY score DESC; HG Thanks HG Harmeet -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Empty query result

Hello Philip, pse.. can you paste the error information? There is no known empty set problem. -- Best regards, Pablo PT Hi all. PT I am querying a database of single information multiple times using a PT simple 'select' statement. However, whenever the data in the DB is PT empty

Re: [PHP-DB] Re: sendmail

); mail() ? and look your mylog.log AT Thanks, AT Aaron -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php-db@lists.php.net is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails.

have to do this again. CLICK THE LINK SO HE CAN RECEIVE YOUR MAIL, and you won't have to do this again ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Apache / PHP Page built from a MySQL Database Diplay Problems

+database-instance-name does not fix it. M Anyone see this before? Could it be a special character that the web M browser cannot handle? I am at a loss on this one. M Any advice on the problem and how to trouble shoot would be M appreciated! Mitch -- Best regards, Pablo -- PHP Database

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

: http://www.php.net/unsub.php -- Pablo M. Rivas. http://pmrivas.ipupdater.com http://www.r3soft.com.ar --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB]

under menu so that user put his mouse over the menu and submenu automatically displayed. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Pablo M. Rivas. http://pmrivas.ipupdater.com http

[PHP-DB] OOP vs Functions and includes

it ? If you read it all the way down here THANKS ! :D Pablo Fernandez-Stearns BA. Argentina. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pagination problems

=mssql_fetch_row($rs)) { if (($counter=$start) and ($counter($start+ $Page_Size)) { echo tr; //There you go: Show all fields, one to each cell echo td . implode(/tdtd,$row) . /td; echo /tr\n; } } To read: http://www.php.net/implode http://ar.php.net/mssql_fetch_row Pablo

Re: [PHP-DB] Pagination problems

upsss.. y forgot $counter++ $counter=0; while ($row=mssql_fetch_row($rs)) { if (($counter=$start) and ($counter($start+ $Page_Size)) { echo tr; //There you go: Show all fields, one to each cell echo td . implode(/tdtd,$row) . /td; echo /tr\n; } $counter++; } -- Pablo M

Re: [PHP-DB] retrieving field names in ascending order

FROM table,$db); if (mysql_num_rows($result) 0) { while ($row = mysql_fetch_assoc($result)) { $k[$row['Field']]=$row['Type']; } ksort($k); while (list($key,$value)=each($k)) echo $key $valuebr\n; } Pablo. -- Pablo M. Rivas. http://www.pmrivas.com http://www.r3soft.com.ar

[PHP-DB] mssql_query returns a boolean false instead an empty recordset when the query doesn't match any record

/. I know it could be a bit strange doing things in this way but it was the one I got to have a stable debian and apache and php and freetds installed with packages. I hope there is someone who could help me. Pablo smime.p7s Description: S/MIME Cryptographic Signature

[PHP-DB] mssql_query returns a boolean false instead an empty recordset when the query doesn't match any record

for the repetition of the topic, but I'm very interested in having a better solution than putting if's in each query. Thank you. Pablo smime.p7s Description: S/MIME Cryptographic Signature

Re: [PHP-DB] Group by

Hi i recommend always use indexes when programming. developers tend not to.. and when the databases grows it's difficult to modify or make them modify the code. El mié, 09-12-2009 a las 14:22 -0300, Julio Araya escribió: On Wed, Dec 9, 2009 at 12:52 PM, Philip Thompson philthath...@gmail.com