[PHP-DB] Trying to delete

2002-08-13 Thread César Aracena
Hi all. I have a small problem here. I have this full-PHP site working with a MySQL db and came to a dead road when trying to delete a record from it from the Administrator's page. I have PHP to make this decision after the Administrator selected the record to delete and answered YES to the ¿Are

[PHP-DB] RE: [PHP] Re: Trying to delete

2002-08-13 Thread César Aracena
Thanks. I must apology as I made a mistake when writing the incoming variable's name. I had it wrong so it would pass the variable but the incoming script was looking for a variable that wasn't passed. In the meantime, and now that I correct that, I'm still comparing artid to '$artid' (with

RE: [PHP-DB] Re: Percentage...

2002-07-29 Thread César Aracena
Hi JJ. I know we all should do what you did, but I've seen this kind of mails quite a lot lately in these lists. I'm sure that many of you, like me, keep these mails for further reading and reference... it would be nice if you also state what was the answer to your original question. I mean, if

[PHP-DB] Great tool

2002-07-10 Thread César Aracena
Hi all. I found in one of these DB lists a word about a tool called MySQL - Front so I went there, downloaded it and ran it today for the first time and well... ¡¡TWO THUMBS UP!!! It really seems like a great GUI app. I installed it over Win XP Pro and had no troubles with it so far.

RE: [PHP-DB] concatenating (was: RE: [PHP-DB] Retrieving/Displaying hyperlinked images with PHP)

2002-07-07 Thread César Aracena
Well, the string concatenation can be used to force PHP read and print a variable within a echoed or printed string. As far as I know, it should be used to make PHP handle a function inside a string. i.e. echo your total is:. total_function(); In your example, you might use as well: echo img

RE: [PHP-DB] Retrieving/Displaying hyperlinked images with PHP

2002-07-06 Thread César Aracena
Maybe I don't understand what your need is, but here's a shot. What you want to do, I've accomplished before just by placing a field in the database which points to the image name called i.e. product_image. What this field contains, is just the name of the picture i.e. prod_001.jpg. When the

RE: [PHP-DB] Retrieving/Displaying hyperlinked images with PHP

2002-07-06 Thread César Aracena
Sorry. The code down there should read: [snip] // Then show image and/or details echo img src=/image_folder/.$row[product_image].; [snip] -Original Message- From: César Aracena [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 12:46 AM To: 'markbm'; [EMAIL PROTECTED] Subject

RE: [PHP-DB] Having more problems

2002-07-06 Thread César Aracena
On the other hand... what are you closing of PHP after the form? Maybe you should consider writing your code in a more clear way... try indenting it all. -Original Message- From: César Aracena [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 2:16 AM To: 'Shiloh Madsen'; [EMAIL

RE: [PHP-DB] Having more problems

2002-07-06 Thread César Aracena
Read my second answer... I find very strange that closing curly bracket *}* after the /FORM tag. Try to remove the closing one from the *ELSE* statement. -Original Message- From: Shiloh Madsen [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 2:33 AM To: César Aracena Subject

[PHP-DB] RE: [PHP] Re: ARRAY, IF INSERT

2002-06-24 Thread César Aracena
the name 0 was a sql-query - it will return a ressource which will enable you to make something like $i=0; while($row = mysql_fetch_assoc($nameless_result){ #psuedo-code# # mysql_query=(insert into table set relativenumber = 'jr$i' where ID=$row[ID]); } [César L. Aracena] I think

RE: [PHP-DB] Re: password()... is it possible?

2002-06-22 Thread César Aracena
;) César aracena wrote: Hi all, I need the administrators of one site to actually see the user's passwords. I like using password() for encrypting but doesn't know if it can be retrieved in common English. Thanks, Cesar Aracena mailto:[EMAIL PROTECTED] CE

[PHP-DB] ARRAY, IF INSERT

2002-06-21 Thread César Aracena
Hi all. I have this form in which one Administrator can insert new members and after that, in another page, a form where he/she can insert the new member’s sons daughters. I want to display a table with “text inserts” into the admin can type let’s say a maximum of 5 kids in the second page.

[PHP-DB] RE: [PHP] Re: ARRAY, IF INSERT

2002-06-21 Thread César Aracena
:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Re: ARRAY, IF INSERT (i am new to these groups, but shouldn't there be a follow-up-to on a X-post?) César aracena wrote: I have this form in which one Administrator can insert new members and after that, in another page

[PHP-DB] password()... is it possible?

2002-06-21 Thread César Aracena
Hi all, I need the administrators of one site to actually see the user’s passwords. I like using password() for encrypting but doesn’t know if it can be retrieved in common English. Thanks, Cesar Aracena mailto:[EMAIL PROTECTED] CE / MCSE+I Neuquen, Argentina +54.299.6356688

[PHP-DB] Arraying JOINED tables

2002-06-16 Thread César Aracena
Hi all. Hope you’re all alright since I don’t see any of you writing for some time now ;-) This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = SELECT * FROM logins,auth WHERE

[PHP-DB] Arraying JOINED tables

2002-06-16 Thread César Aracena
Hi all. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = SELECT * FROM logins,auth WHERE logins.authname = $variable1 AND auth.authid = $variable2; $result =

[PHP-DB] Arraying JOINED tables

2002-06-16 Thread César Aracena
Hi all and sorry if this message is sent many times, but I’m having problems switching mailing lists from one email address to another. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this:

[PHP-DB] Arraying JOINED tables

2002-06-16 Thread César Aracena
Hi all. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = SELECT * FROM logins,auth WHERE logins.authname = $variable1 AND auth.authid = $variable2; $result =

[PHP-DB] Extracting Time??

2002-06-16 Thread César Aracena
Hi all and sorry for bothering again. I need to fetch one time and date from a MySQL DB where is stored as TIMESTAMP (MMDDHHMMSS) to print it in a page but in common format (DD MM at HH:MM:SS). Actually, I don’t care ‘bout the st, nd and th extensions after the day. Thanks for any help

RE: [PHP-DB] Arraying JOINED tables --- SOLVED

2002-06-16 Thread César Aracena
Thanks a lot. It was an error... a HUGE one though :-) César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 -Mensaje original- De: Denis Arh [mailto:[EMAIL PROTECTED]] Enviado el: Domingo, 16 de Junio de 2002 04:28 a.m. Para: [EMAIL PROTECTED] Asunto: Re: [PHP

RE: [PHP-DB] Extracting Time??

2002-06-16 Thread César Aracena
+54.299.4466621 -Mensaje original- De: César Aracena [mailto:[EMAIL PROTECTED]] Enviado el: Domingo, 16 de Junio de 2002 05:12 a.m. Para: PHP General List; PHP DB List Asunto: [PHP-DB] Extracting Time?? Hi all and sorry for bothering again. I need to fetch one time and date from

[PHP-DB] Querying for MAX

2002-06-12 Thread César Aracena
I’m sorry if this mensaje is posted twice. I sent it yesterdays, but then my ISP had problems with e-mail and I lost dozens of them and don’t know if sent OK. Hi all, What I’m trying to do here is not inside PHP nor MySQL books I have. I need to query the DB to look the max result in a column.

[PHP-DB] RE: [PHP] Querying for MAX

2002-06-12 Thread César Aracena
Thanks Natalie Ed. This Works just fine. What I want to do, is let a person subscribe new affiliates without having to look up what the last affiliate's number was and show the next one in the new affiliate form. César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621

[PHP-DB] RE: [PHP] Querying for MAX -- solved

2002-06-12 Thread César Aracena
of you who helped me. César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 -Mensaje original- De: John Holmes [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 12 de Junio de 2002 08:51 p.m. Para: 'César Aracena'; 'PHP DB List'; 'PHP General List' Asunto: RE: [PHP