Thanks a lot guys. Alter 1/2 litter of black coffee and your help... made it... must be the snooze...
César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 > -----Mensaje original----- > De: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Enviado el: Sábado, 08 de Junio de 2002 06:14 a.m. > Para: César L. Aracena; PHP DB List > Asunto: RE: [PHP-DB] HUGE problem here > > "DELETE FROM auth WHERE name=$deletename LIMIT 1"; > > needs quotes > > "DELETE FROM auth WHERE name='$deletename' LIMIT 1"; > > This may be the problem. > > > HTH > > Peter > > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: César L. Aracena [mailto:[EMAIL PROTECTED]] > > Sent: 08 June 2002 10:04 > > To: PHP DB List > > Subject: [PHP-DB] HUGE problem here > > Importance: High > > > > > > Hi all, > > > > I have a deadline for tomorrow morning (4 more hours) and have one small > > problem I’ve been working on for 3 hours now. I want the Administrators > > of a site to be able to delete or create new Admin users from within one > > admin’s page. > > > > >From the “Aministrators page” they will see a list of available > > administrators with a “DELETE” link aside each one. This works just > > fine, and the link I made looks like this: > > > > [snip] > > echo “<a > > href=\"manageusers.php?mode=deleteuser&deletename=$row[name]\">DELETE > > USER</a>”; > > [snip] > > > > I also made a FORM to insert new ADMINS from the same page which > > displays the list of ADMINS which looks like this: > > > > [snip] > > <FORM ACTION="manageusers.php?mode=adduser" METHOD=POST> > > <P><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=5 WIDTH="100%"> > > <TR> > > <TD> > > <P><INPUT TYPE=text NAME=newuser VALUE="USER" > > SIZE=20 MAXLENGTH=10></P> > > </TD> > > <TD> > > <P><INPUT TYPE=text NAME=newpass VALUE="PASSWORD" > > SIZE=20 MAXLENGTH=30></P> > > </TD> > > <TD> > > <P><INPUT TYPE=submit NAME=Submit VALUE="ADD > > ADMIN"></P> > > </TD> > > </TR> > > </TABLE> > > > > </FORM> > > [snip] > > > > When the page manageusers.php is called, it looks like this: > > > > [snip] > > <? > > if ($mode) > > { > > if ($mode == 'deleteuser') > > { > > $query = "DELETE FROM auth WHERE > > name=$deletename LIMIT 1"; > > $result = mysql_query($query); > > > > if ($result); > > { > > echo "User deleted"; > > } > > } > > else if ($mode == 'adduser') > > { > > $query = "INSERT INTO auth VALUES (' > > ".$newuser." ', password(' ".$newpass." '))"; > > $result = mysql_query($query); > > > > if ($result) > > { > > echo User Added"; > > } > > } > > } > > ?> > > [snip] > > > > It works just fine for adding new ADMINS but when I want to delete one, > > despite the fact it does tell me that it was deleted, the ADMIN is still > > there… What the heck is going on??? > > > > Thanks so much in advance… did I mentioned I have to get it fized in 4 > > hours ;-) ??? > > > > Cesar <mailto:[EMAIL PROTECTED]> Aracena > > CE / MCSE+I > > Neuquen, Argentina > > +54.299.6356688 > > +54.299.4466621 > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
