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 > wrote: > > Hi. > > >

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

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

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

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] DB2 - wrong number of parameters

C:\Arquivos de programas\Apache Group\Apache2\htdocs\principal\Portal\Repositorio\Funcionarios.class.php on line 170 what´s the problem??? thanks Pablo Garay Ijuí - UNIJUI RS - Brasil

[PHP-DB] pdo and oracle drivers

ame results. Any ideas if I am 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 Maili

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

I'm sorry 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

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

th "../configure --with-mssql=shared" and "copied with cp modules/mssql.so /usr/lib/php4/20020429/". 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

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

=mysql_query("SHOW COLUMNS 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 $value\n&quo

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 ""; //There you go: Show all fields, one to each cell echo "" . implode("",$row) . ""; ec

Re: [PHP-DB] Pagination problems

t;\n"; } } To read: http://www.php.net/implode http://ar.php.net/mssql_fetch_row Pablo. On 9/2/05, Jenaro Centeno Gómez <[EMAIL PROTECTED]> wrote: > Hello everybody, > > This is my first message to the list and as usual is to try to solve a > problem. > &g

[PHP-DB] OOP vs Functions and includes

ue learning about OOP and when to use 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]

PHP submenu can be created 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 > >

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

ECT * FROM mytable", $db) or die("Query > > > failed : " . mysql_error()); > > > > > > The script does not proceed beyond the "mysql_select_db" line. I get > > > this error: > > > SELECT_DB failed: Access denied for user ''@'l

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

*60*24; //86400 > //add 86400 should give next unix date > //date based on this is also 31 10 2004 > print(""); > $thisdate=date("d m Y",$next); > print($thisdate); > ?> > > how come? > > -- > PHP Database Mailing

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

those problem M> + 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

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.

mails. JAM> You won't 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] Re: sendmail

gain with AT> different data and it doesnt work. Any ideals on this? mmmhhh... REFRESH... maybe you are not calling your script again, and using a cached version of the send page... try this: and look your mylog.log AT> Thanks, AT> Aaron -- Best regards, Pa

Re[2]: [PHP-DB] Empty query result

27;phone1', $_userName, $link); $phone2 = getMysqlSelectResultForUsername('phone2', $_userName, $link); $lastLogin = getMysqlSelectResultForUsername('lastLogin', $_userName,$link); if ((!$roomNum) or (!$phone1) or (!$phone2) or (!$lastLogin)) {

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, whene

Re: [PHP-DB] Joining Tables for Search

AGAINST ('$keywords' IN BOOLEAN MODE) AS score HG> FROM members HG>WHERE MATCH(firstname, 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[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, Pa

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

ST['username'],"'"; AT> It does however work for all the echo commands and It is also correct when AT> I echo the statement: AT> echo "SELECT * FROM users WHERE email='",$_POST['username'],"'"; AT> Am I missing something? AT> Thanks again, 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] 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: [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 unsubscr

Re[2]: [PHP-DB] Table locking

change logic of all software for this. R> I have an idea to try something - whould be working ? : R> I want to create some fictive table with one record and before start R> appending data in table 1 and table 2 to lock this fictive table. R> Thanks in advance, R> Rosen -- Bes

Re: [PHP-DB] Multiple SELECT

27;database_database'].".forumusers,".$godlyness['database_database'].".forumuserprofiles ".$filterbu." M> ORDER BY username M> " -- 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)

lts per row to be displayed - so if I had 10 returned CP> results from my Database, it would display 2 per column on 5 rows. How can CP> I do this dynamically? CP> Any help would be really appreciated. CP> Thanks CP> Chris -- Best regards, Pablo -- PHP Databa

Re: [PHP-DB] Storing Date in mysql

the date in the following format from PHP: MG> date("d/m/Y") which creates the following entry "05/07/2004" (example). MG> 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[2]: [PHP-DB] Re: MySQL query, using DISTINCT...

;> > I want to only see it once.) >> > >> > What am I doing wrong...? >> > >> > SELECT DISTINCT(file_name, email) FROM `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[2]: [PHP-DB] MySQL: Random select with specific count of a column

a"]][]=$data["nameb"]; $lastcat=$data["categorya"]; } echo "de" . $lastcat . "" . $myarray[$lastcat][rand()%count($myarray[$lastcat])]; echo "de" . $lastcat . "" . $myarray[$lastcat][rand()%count($myarray[$lastcat])]; mhhh... i don't like... 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] Dates and Count

can ask again or provide an example... ;) SD> Second 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> Shanno

Re: [PHP-DB] More problems with searching

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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

7; and b.name 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

Re: [PHP-DB] Dates and Count

_id group by clients.client_id having howmany=5 Then... mysql_num_rows will give you how many 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

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

Hello Pablo, I made a Typo: change this: while ($key<80) echo "$lastgroup." . ($key++) . " is free\n"; for this: while ($key<255) echo "$lastgroup." . ($key++) . " is free\n"; ;) -- Best regards, Pablo -- PHP

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

e." . ($key++) . " is free\n"; echo "$one.$two.$three.$four IS NOT FREE\n"; $lastgroup="$one.$two.$three"; $key++; } while ($key<80) echo "$lastgroup." . ($key++) . " is free\n"; ?> P.S. I DONT KNOW IF THIS IS TOO SLOW.. you 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] problem....

> >> > why doesn't this work: > >> > $pic=mysql_query('SELECT Rune, username FROM RuneRunner > >> > RuneRunner_1 WHERE (User_ID = 3)',$connection); > >> > $pic=mysql_fetch_array($pic); P.S. if you need to trace, y

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

k... i'm 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 lik

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 jok

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

oesn't), 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-DB] Agata Report :: New Version 4 beta 002

ix 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-704

[PHP-DB] Agata Report: new version

like. 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. P

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

;--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002 > ____ Juan Pablo Aqueveque <[EMAIL PROTECTED]> Inge

Re: [PHP-DB] new pair of eyes

r_id >Any help would be great! >Jas > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php Juan Pablo Aqueveque <[EMAIL PROTECTED]> Ingeniero de Sistemas Depart