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 PRO
ing the passwd
field
My two niquel cents!
__
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 Bro
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
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 Mess
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 Mess
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 Mess
eferences
idcattinyint(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 1
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
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/)
To
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: Miércole
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
scritt
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 i
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
hi
a web site!
Best Regards,
Miguel Guirao
Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta
dirigido; contiene informacion estrictamente confidencial y legalmente
protegida, cuya divulgacion es sancionada por la ley. Si el lector de este
mensaje no es a quien
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 rec
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: Viern
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 d
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 fk
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
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 AS
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
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 ?
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
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!
-------
Mi
You haven't searched at all, go to www.php.net and look up for
mysql_field_name() and related functions!!
-Original Message-
From: Grant Griffith [mailto:[EMAIL PROTECTED]
Sent: Jueves, 14 de Septiembre de 2006 10:22 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] Help displaying Column
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
If a remove or comment out any code
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
Use the trim function, or anoter function that just takes the n first
characters.
-Original Message-
From: Benjamin Adams [mailto:[EMAIL PROTECTED]
Sent: Martes, 18 de Julio de 2006 12:25 p.m.
To: PHP DB
Subject: [PHP-DB] Only a section from the database result
I have articles in a MyS
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!
Este mensaje es exclusivamente para el uso de la persona o entidad
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
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 ma
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
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
s
00 records!!
-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 instea
r 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 excl
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, howeve
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
t
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 "" or "" or any other HTML tag that best suits your need!!
This is just
Hi all,
I remember reading in a book that there is a function to import the content of
a CSV file into a MySQL table, am I alright?
what is that function?
Of course, the first option could be reading the CSV file line by line and
using explode() to get each column value for each row.
Best Re
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,
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 i
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 [mai
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
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
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 probl
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 Mes
p-db@lists.php.net
>Message-id: <[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';
5 20:37:47 -0700
>
>Hi!!
>
>I wanna a do a for loop with letters, Is this possible?
>
>for ($i = 'A'; $i <= 'Z'; $i++){
>// code
>}
>
>--
>MIGUEL GUIRAO AGUILERA
>Logistica R8 - Telcel
>Tel: (999) 960.7994
>Ce
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 don't
You are right David, I have an auto_increment field!!
What about this:
$items2 = mysql_query("SELECT DISTINCT rev FROM rev ORDER BY rev", $link);
where rev is a revision field for parts in my wharehouse!!!
Does it will work in this case?
Thanks
-Original Message-
From: David Robley [mai
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 nu
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
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
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
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 t
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
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 Sess
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 transf
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 th
mail? If so,
how?
Best Regards,
Miguel Guirao
Servicios Datacard
www.SIASA.com.mx
|---|--|---|
|---|--|---|
|---|--|---|
How do I declare Duch an array like this??, let's call it Parts.
Miguel Guirao
Serv
them like 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
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
No, the
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
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
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
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
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
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['
I'm using Windows 2000 Server and PHP for Windows.
Regards,
Miguel Guirao
Servicios Datacard
www.SIASA.com.mx
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
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
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 PROT
$usuario = "sa";
$password = "";
$BDnombre = "ProyectoRMA";
So, basically, any ideas of the source of this error?
Regards,
Miguel Guirao
Servicios Datacard
www.SIASA.com.mx
74 matches
Mail list logo