Authenticating users

2003-01-16 Thread Cesar Aracena
Hi all, I have this admin site where the administrators can add new ones of their kind (admin level) and now I'm trying to make a query so no usernames are duplicated in MySQL. The query goes like this: $query1 = "SELECT * FROM r2k_admin WHERE adminuser = $user"; $result1 = mysql_query($query1);

Dumping remote DB

2003-01-10 Thread Cesar Aracena
Hi all, I use MyCC 0.8.6 to work around remote data bases, and I need to dump the structures of all of them (also their contents). Can it be done? What SQL query should I use? Thanks in advance, Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argenti

RE: RE: UPDATE

2002-12-11 Thread Cesar Aracena
Exaclty, 0 rows affected, but no password changed... why's that? Thanks, Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina -Mensaje original- De: Egor Egorov [mailto:[EMAIL PROTECTED]] Enviado el: jueves, 05 de diciembre de 2002 11:0

RE: UPDATE

2002-12-05 Thread Cesar Aracena
The problem shows up when receiving the response of the query which tells me that the query was OK but rows affected. Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina -Mensaje original- De: Egor Egorov [mailto:[EMAIL PROTECTED]] En

UPDATE

2002-12-03 Thread Cesar Aracena
Hi all, I'm using MyCC to make changes to a remote DB, but I found a problem while trying to update a record... does anyone knows what's wrong with this? UPDATE maraadmins SET adminpassword = password("1234") WHERE adminid = 3 Thanks in advance, Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECT