RE: [PHP-DB] Resource id #5

Been a positive integer, it jeans that the SQL query was succesfully executed, read the function description. __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 -- -Original Message- -- From: Richard Dunne [mailto:[EMAIL PROTECTED

RE: [PHP-DB] Not updating certain fields in same row

! __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 -- -Original Message- -- From: Jason Pruim [mailto:[EMAIL PROTECTED] -- Sent: Tuesday, March 25, 2008 11:14 AM -- To: Daniel Brown -- Cc: php-db@lists.php.net -- Subject: Re: [PHP-DB

RE: [PHP-DB] Password Reset

authentication. __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 -- -Original Message- -- From: Nasreen Laghari [mailto:[EMAIL PROTECTED] -- Sent: Miércoles, 27 de Febrero de 2008 12:52 a.m. -- To: php-db@lists.php.net -- Subject: [PHP

RE: [PHP-DB] PHP help question

Chances are that the port on PC A is blocked for the DB service. Or that your DB server has been configured to not to accepp connections ffrom the outside. __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 -- -Original Message

RE: [PHP-DB] PHP help question

Chances are that the port on PC A is blocked for the DB service. Or that your DB server has been configured to not to accepp connections ffrom the outside. __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 -- -Original Message

RE: [PHP-DB] PHP help question

Chances are that the port on PC A is blocked for the DB service. Or that your DB server has been configured to not to accepp connections ffrom the outside. __ Miguel Guirao Aguilera, Linux+, ITIL Sistemas de Información Informática R8 Ext. 7540 -- -Original Message

[PHP-DB] md5() function

Hi!! I'm using the md5() function to encrypt a password and store it into a database. Now I want to retrieve that MD5 password and convert it into it's human readable condition. Is there a function opposite to md5()?? Best Regards, M Guirao -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Select...

tinyint(4) unsigned 0 select,insert,update,references -Original Message- From: Daniel Brown [mailto:[EMAIL PROTECTED] Sent: Lunes, 14 de Enero de 2008 01:55 p.m. To: Miguel Guirao Cc: php-db@lists.php.net Subject: Re: [PHP-DB] md5() function On Jan 14, 2008 2:26 PM

RE: [PHP-DB] md5() function

Steven Cruz wrote: Hello; I maybe wrong, but I believe it is one way. What you need to do is take your input and encrypt it and check if matches your current encrypted value. :) peace and hugs. Miguel Guirao wrote: Hi!! I'm using the md5() function to encrypt a password and store

RE: [PHP-DB] forms and method POST - variables

Well, it depends if you use an old version of PHP, in the latest version both arrays $_POST and $_GET are used to get passed variables!! I can't remember since what version PHP started to use these arrays!! MG -Original Message- From: Lukáš Moravec [mailto:[EMAIL PROTECTED] Sent:

RE: [PHP-DB] Connection error!

No, the DB server has MySQL 5.0.18 -Original Message- From: Matteo Cisilino [mailto:[EMAIL PROTECTED] Sent: Lunes, 18 de Junio de 2007 09:47 a.m. To: php-db@lists.php.net Subject: Re: [PHP-DB] Connection error! Alle 16:26, lunedì 18 giugno 2007, MIGUEL ANTONIO GUIRAO AGUILERA ha

RE: [PHP-DB] handling a SELECT that returns nothing

The mysql_query function executes a query againts a DBM and just that, it delivers the query to the DBM, if the DBM can execute the query, it returns a positive integer, if the DBM can not execute the query, it returns 0 or false, can't remember exactly right now. So, it will return a positive

RE: [PHP-DB] Re: [PHP-WIN] (DRW) Ordenar por fecha

You have to issue the following query: select id,publico_privado,usuario,fecha,categoria,pequena_comentario,comentario,arc hivo from mi_sitio_personal_menu order by fecha Tienes que usar la siguiente consulta: select id,publico_privado,usuario,fecha,categoria,pequena_comentario,comentario,arc

RE: [PHP-DB] List menus

The solution has been posted before, check the archives! -Original Message- From: David Skyers [mailto:[EMAIL PROTECTED] Sent: Martes, 05 de Diciembre de 2006 07:20 a.m. To: php-db@lists.php.net Subject: [PHP-DB] List menus Hello, How do you create a database driven list menu, and

RE: [PHP-DB] Fulltext SELECTing only part of a field entry

I guess you will still need to get the whole texts, but do the selecting befores displaying results. There are functions to to select an amount of text of certain lenght, starting at certain point of the string. -Original Message- From: benmoreassynt [mailto:[EMAIL PROTECTED] Sent:

RE: [PHP-DB] Just two PHP questions

1) What exactly I need to download for running PHP on Apache. PHP the latest version 2) What should be the location of the downloaded PHP folder/file/executable so that it interacts easily with Apache. Any, but if you prefer tu indicate an installation directory you may do that by specifing it

RE: [PHP-DB] MySQL SQL Query Help

select max(bar) from mytable where unique fkid order by bar asc as far as I remember!! -Original Message- From: Peter Beckman [mailto:[EMAIL PROTECTED] Sent: Lunes, 13 de Noviembre de 2006 04:59 p.m. To: PHP-DB Mailing List Subject: [PHP-DB] MySQL SQL Query Help I have a table: id

RE: [PHP-DB] Converting text field to barcode CODE 39

Jorge, If you have downloaded FPDF you will se that it comes with a couple of examples that you can use to learn. Miguel Guirao -Original Message- From: Jorge Giménez [mailto:[EMAIL PROTECTED] Sent: Viernes, 27 de Octubre de 2006 04:49 p.m. To: php-db@lists.php.net Subject: [PHP-DB

RE: [PHP-DB] ORDER BY

Yes! Just separate your columns with commas! Check out the proper sintax!! -Original Message- From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED] Sent: Miércoles, 18 de Octubre de 2006 06:58 p.m. To: PHP DB Subject: [PHP-DB] ORDER BY Is it possible to do an ORDER BY column_a column_b

RE: [PHP-DB] Google Code Search

I hope never!! Specially with disruptive technologies!! Miguel Guirao -Original Message- From: Jeremy Peterson [mailto:[EMAIL PROTECTED] Sent: Martes, 10 de Octubre de 2006 06:29 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Google Code Search Another resource for source code

RE: [PHP-DB] Diff between 2 date

I use CalcDateDiff.php class and it works pretty good! I got it at PHP Classes.org -Original Message- From: Nandar [mailto:[EMAIL PROTECTED] Sent: Jueves, 05 de Octubre de 2006 10:16 p.m. To: php-db@lists.php.net Subject: [PHP-DB] Diff between 2 date How to know diff between 2 date ?

[PHP-DB] SQL query

Hello list, Whats wrong with my SQL query: $query=select email from usuarios where userName = (select username from fussv where folio = 'FUSS-130-2006'); I get an error! I have tested the two individual sentences and they worked OK! --- Miguel Guirao Aguilera

RE: [PHP-DB] SQL query

were only added in MySQL Version 4.1. Regards, Dwight -Original Message- From: Edwin Cruz [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 10:53 AM To: 'Miguel Guirao'; php-db@lists.php.net Subject: RE: [PHP-DB] SQL query Make sure that your second query is returning only

RE: [PHP-DB] Strange problem!

Hi all, I resolved the problem moving the ob_end_flush() function to the end of the scrip and calling the mail function before! -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Miércoles, 23 de Agosto de 2006 09:55 p.m. To: Miguel Guirao Cc: php-db@lists.php.net Subject

[PHP-DB] Strange problem!

below that, the script returns to live again. Any ideas of what is going on? BEST REGARDS, --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion

[PHP-DB] Taking care of an auto_increment field!

by all the processes running in the server? Or actually creating the auto_increment fields by inserting as many rows needed, but what if the user cancels the operatuion? Or another different approach to solve this problem? Regards, Miguel Guirao Este mensaje es exclusivamente para el uso de la

[PHP-DB] Populating an array to the next script!

at the target script by coding the following: $hw=$_POST['hwt']; $hwGSM=$hw[0]; for($i=0;$i=$maxpoint;$i++){ echo($hwGSM[$i]); } It should be pretty easy but I have not done it ever! Regards, Miguel Guirao P.S. I can not get rid of of the below crap!! I know is annoying, but it's a policy

RE: [PHP-DB] mysqldump via php

You could use exec() within PHP! -Original Message- From: Adrian Bruce [mailto:[EMAIL PROTECTED] Sent: Jueves, 29 de Junio de 2006 06:31 a.m. To: Jeffrey Cc: PHP DB Subject: Re: [PHP-DB] mysqldump via php mysqldump is a .exe, and therefore it will not work within mysql_query(); You

RE: [PHP-DB] Converting to Decimal

You could actually do (int) $var or use the sprintf(%d, $var); -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Miércoles, 28 de Junio de 2006 06:04 p.m. To: [EMAIL PROTECTED] Cc: Php-Db Subject: Re: [PHP-DB] Converting to Decimal Mark Bomgardner wrote: I am query

RE: [PHP-DB] PHP/Mysql search

CREATIVITY is what you are looking for. -Original Message- From: Eustace [mailto:[EMAIL PROTECTED] Sent: Lunes, 22 de Mayo de 2006 07:59 a.m. To: php-db@lists.php.net Subject: [PHP-DB] PHP/Mysql search Hello, Please be patient and assist meI am building a web application where a

RE: [PHP-DB] Duplicate rows

!! -Original Message- From: Ade Olonoh [mailto:[EMAIL PROTECTED] Sent: Miércoles, 01 de Marzo de 2006 12:19 p.m. To: Miguel Guirao Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Duplicate rows Assuming you're using MySQL, instead of using INSERT INTO, you can use REPLACE INTO instead. If you have

[PHP-DB] Duplicate rows

the is a sentence in SQL to only show ONE row of duplicated rows, maybe if I do a select using this sentence and then put this new recordset in another table, it will work!! Any ideas? --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 Este mensaje es exclusivamente para

RE: [PHP-DB] PHP, MySQL and Apache

Answer 1. No, you do not need Apache. You could be using IIS along with PHP and MySQL if that is what you need! But talking about natural relationships, there is nothing better that the great combitation formed by XAMP. Answer 2. There is a MySQL API specially done for PHP, so there is no need

RE: [PHP-DB] webhosting with php/mysql and disk quota

You could also use the suid bit enable in your permission scripts!! Miguel -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Lunes, 27 de Febrero de 2006 02:23 p.m. To: php-db@lists.php.net Subject: Re: [PHP-DB] webhosting with php/mysql and disk quota Yes,

RE: [PHP-DB] Formatting a form box

One approach is to ask the user to input a text delimiter, like a @, for example, in every point where there should be a new line or paragraph. Then, you should parse the text, and at every point you find a @, tu place a BR or P or any other HTML tag that best suits your need!! This is just one

RE: [PHP-DB] No posts in 36 hours??

Very active!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Miercoles, 11 de Enero de 2006 03:06 p.m. To: php-db@lists.php.net Subject: [PHP-DB] No posts in 36 hours?? List Active? David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] Connecting to two MySQL databases

I agree with this solution!! -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Jueves, 29 de Septiembre de 2005 01:10 p.m. To: php-db@lists.php.net Subject: Re: [PHP-DB] Connecting to two MySQL databases I don't see a reason to duplicate the class code, just make

RE: [PHP-DB] begginer question

First, you need to normalize your DB, maybe going up to the Third Normal Form will give you a good DB design. Second, there is a SQL parameter that let's you display only one record from many duplicated records, equal records, I guess it is UNIQUE. -Original Message- From: ziv gabel

[PHP-DB] Storing an array on a table?

Hi!! I want to store an array into a field on a MySQL table, Is it posible to save it? Maybe into a string field? Best Regards, --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 Este mensaje es exclusivamente para el uso de la persona o entidad a quien

RE: [PHP-DB] Storing an array on a table?

Thanks to you all for your replies!! They are of great help --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 -Original Message- From: Jordan Miller [mailto:[EMAIL PROTECTED] Sent: Jueves, 01 de Septiembre de 2005 10:28 a.m. To: [EMAIL

RE: [PHP-DB] mysql_connect($server,$user,$password);

Remember that PHP is a server-side scripting language, so all PHP code is parsed at the server side and you will never see the code but the results, second, the .php files should have permissions that do not allow direct acces to them, but thru the web browser!! So, basically there is no

RE: [PHP-DB] show tables

there are a set of functions that you should use in order to get the names of the tables, for short, this is the function that you should use: mysql_field_name() But again, you have to use this function along with other functions that list all the tables in a DB. Chicolinux -Original

RE: [PHP-DB] Letters loop

with letters, Is this possible? for ($i = 'A'; $i = 'Z'; $i++){ // code } -- MIGUEL GUIRAO AGUILERA Logistica R8 - Telcel Tel: (999) 960.7994 Cel: 9931-6 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database

RE: [PHP-DB] RE : Subject: Letters loop

: [EMAIL PROTECTED] MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Subject: Letters loop Hi!! I wanna a do a for loop with letters, Is this possible? for ($i = 'A'; $i = 'Z'; $i++){ // code } -- MIGUEL GUIRAO AGUILERA Logistica

RE: [PHP-DB] Limiting Results

I believe you need a main table where youn list all the colleges with columns for STATE, CONGRESSIONAL DISTRICT and REPRESENTATIVE. And those three columns would be pulled from three table catalogs: STATES, CONGRESSIONAL DISTRICTS and REPRESENTATIVES. Maybe there is a better approach, but I

RE: [PHP-DB] INSER INTO not working!

Acctually my problem was in that I was using the name of the table in uppercase rather than in lowercase. So MySQL was looking for table REV instead of rev. So for MySQL, REV and rev are very different tables!! Regards, Miguel Guirao -Original Message- From: Constantin Brinzoi [mailto

[PHP-DB]Emisor de respuesta automática: [PHP-DB] Showing the next entry

We need to see your script or at least the portion where you do the query to the database. In general, you need to concatenate your different case-note for a given student as the while cycle goes thru your fetch statement for such a given student. -- MIGUEL GUIRAO

RE: [PHP-DB] multiple queries, one transaction

There is a function that gets the last auto increment value for an ID field!! -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Martes, 17 de Mayo de 2005 10:27 a.m. To: php-db@lists.php.net Subject: [PHP-DB] multiple queries, one transaction I would like to get the itemID

RE: [PHP-DB] INSER INTO not working!

Acctually my problem was in that I was using the name of the table in uppercase rather than in lowercase. So MySQL was looking for table REV instead of rev. So for MySQL, REV and rev are very different tables!! Regards, Miguel Guirao -Original Message- From: Constantin Brinzoi [mailto

RE: [PHP-DB] novice on table design

The schema of your table is wrong, is you do bnormalize it you will find out that you need two tables for this approach. One table for your people and another one for the n addresses of your people. If you keep your current schema, you will have as many rows for one person as many addresses for

RE: [PHP-DB] Drop Down Menus

Some body asked for it! -Original Message- From: chintan [mailto:[EMAIL PROTECTED] Sent: Jueves, 05 de Mayo de 2005 07:36 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Drop Down Menus hey guys i wrote this code from another code of zend.php Can anyone tell me how do i update the value

RE: [PHP-DB] Transfering post data to a series of pages. .

I agree!! -Original Message- From: Martin Norland [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Mayo de 2005 08:39 a.m. To: php-db@lists.php.net Subject: Re: [PHP-DB] Transfering post data to a series of pages. . Perry, Matthew (Fire Marshal's Office) wrote: Is there a way to

RE: [PHP-DB] Problem Using Sessions

Why dont'n you use soma classes from www.phpclasses.com about User Management!! There are great classes in this site!! -Original Message- From: Shawn Singh [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Mayo de 2005 03:14 p.m. To: php-db@lists.php.net Subject: [PHP-DB] Problem Using

[PHP-DB] List-Unsubscribe

Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 21 de Mayo de 2004 12:04 p.m. Para: [EMAIL PROTECTED] Asunto: WELCOME to php-db@lists.php.net Hi! This is the ezmlm program. I'm managing the php

[PHP-DB] sending e-mails

Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx

[PHP-DB] Array

|---|--|---| |---|--|---| |---|--|---| How do I declare Duch an array like this??, let's call it Parts. Miguel Guirao Servicios

[PHP-DB] Checkboxes in a table

this: checkbox[n], where n=1 is for the first row and so on. So, my question is, upon receiving all the variables in the second script, if I navigate thru each of the elements, I will see which one is selected and which one is not? Am I all right?? Miguel Guirao Servicios Datacard www.SIASA.com.mx

RE: [PHP-DB] Dropdown menus from DB query

Actually is named a Scape Character Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Cole Ashcraft [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 18 de Junio de 2004 11:06 a.m. Para: [EMAIL PROTECTED] Asunto: Re: [PHP-DB] Dropdown menus from DB query

RE: [PHP-DB] Re: Anyone using MSQL Server with PHP?

Thanks a lot Hans for your great explanation about this type of passwords, salted passwords. I will google for that term, time-memory Tradeoff. Thanks one more time!! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Hans Lellelid [mailto:[EMAIL PROTECTED

[PHP-DB] password () function.

Is this function, password() available at PHP Ander Windows? I get an undefinied function error message! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: James Harrell [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10 de Junio de 2004 09:50 a.m. Para: Philip

RE: [PHP-DB] password () function.

OK, now I understand why it doesn't works under SQL Server.!! Thanks! P.S. Yes, I do hijacked someone else's thread. I won't do it again! THANKS! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Larry E. Ullman [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10

[PHP-DB] Anyone using MSQL Server with PHP?

Hi!! Anybody here using PHP with SQL Server? I would like to use a similar function to password () from MySQL under SQL Server. Anybody knows of a similar function under SQL Server? Kind Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx

RE: [PHP-DB] Re: Anyone using MSQL Server with PHP?

Thanks!! It Works out pretty nice!! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Justin Patrin [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10 de Junio de 2004 05:51 p.m. Para: [EMAIL PROTECTED] Asunto: [PHP-DB] Re: Anyone using MSQL Server with PHP

[PHP-DB] Undefined variable

using Windows 2000 Server and PHP for Windows. Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx

RE: [PHP-DB] Undefined variable

Thanks so much!!! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Viorel Dragomir [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 26 de Mayo de 2004 09:55 a.m. Para: Miguel Guirao; PHP DB List Asunto: Re: [PHP-DB] Undefined variable echo $_REQUEST['Name

RE: [PHP-DB] undefined function

OK, I added it!! But it still does work. BTW, I have four different PHP.ini files in my system, where I can see which one is using it? I added it to all of them!! IIS PHP 4.x SQL Server Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Bruno Ferreira [mailto

RE: [PHP-DB] undefined function

Thank you everybody!! I was missing that bloody dll. Is working now!!! Best Regards, and thanks again Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: John W. Holmes [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 24 de Mayo de 2004 01:06 p.m. Para: Miguel

[PHP-DB] undefined function

= ; $BDnombre = ProyectoRMA; So, basically, any ideas of the source of this error? Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx

RE: [PHP-DB] undefined function

First, I do not have that line in my php.ini file. In what section should I add it? I forgot, I'm using Windows 2000 Server, SQL Server, PHP4 and coding in DreamweaverMX Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Bruno Ferreira [mailto:[EMAIL PROTECTED