[PHP-DB] HUGE problem here

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

RE: [PHP-DB] HUGE problem here

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

[PHP-DB] MyCC Problem

Hi all. I know that this isn’t probably the best place to make this question, but I uses that some of you uses MyCC to connect to a remote MySQL DB. My connection is no problem, but when I issue a SQL command, which tells the DB to INSERT multiple rows into one table, It gives me an error every

[PHP-DB] Strange need

Hi all, I know this is not used a lot, but I'm building a site that will show up a some kinda strange content. It will have diferent tables inside diferent pages. Each table will show a diferent header with several colums showing diferent diameters of the products. The table header will not

Re: [PHP-DB] Last record

Bernabei [EMAIL PROTECTED] To: César L. Aracena [EMAIL PROTECTED]; PHP DB List [EMAIL PROTECTED] Sent: Monday, June 03, 2002 5:14 AM Subject: [PHP-DB] Last record If I have just inserted one set of values with mysql_query(INSERT ...) how can I get the values just inserted (I needed to get

[PHP-DB] Strange need

Hi all, I know this is not used a lot, but I'm building a site that will show up a some kinda strange content. It will have diferent tables inside diferent pages. Each table will show a diferent header with several colums showing diferent diameters of the products. The table header will not

[PHP-DB] Remote Update ONCE a day

Hi all, Two days ago I was requested to make a proyect for a non-profit company, and I'm doing the drwaings for the databases and programming which I will use. This company wants to run the program in a PC which will not hold the main DB (which will will at HQ), but they also not need the new

[PHP-DB] INSERT no posible in MySQL

Hi all, I have a 3-page form input, where the variables are passed from one page to another using HTTP_POST_VARS and stored in the next one in HIDDEN fields (just to make sure). At the end of the 3rd page, is another one where I thank the visitor and proccess all the data. The data proccess

Re: [PHP-DB] INSERT no posible in MySQL

Thanx... it worked using double quotes around the variable name ({$HTTP_POST_VARS[varname]} - Original Message - From: Marcelo Leitner [EMAIL PROTECTED] To: César L. Aracena @hellfire.leitner.homeip.net [EMAIL PROTECTED]@hellfire.leitner.homeip.net, Cc: PHP DB List [EMAIL PROTECTED] Sent

[PHP-DB] Fames Included?

Hi all, I have a problem in a site I am developing, which is generated by the use of too many tables inside tables. I can avoid using that many tables by using frames instead and I would like to make every page of the site, using the following schema: include(framed_header.php);

Re: [PHP-DB] Fames Included?

Thanx a lot. It works just fine. - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: César L. Aracena [EMAIL PROTECTED]; PHP DB List [EMAIL PROTECTED] Sent: Saturday, May 25, 2002 6:01 PM Subject: RE: [PHP-DB] Fames Included? Hi just use a frameset with php pages

Re: [PHP-DB] sessions

There is a great-3-part-tutorial writen by Ying Zhang at DevShed.com. You can find this tutorial at: http://www.devshed.com/Server_Side/PHP/Commerce/Commerce1 It's a tutorial which guides you through the creation of a e-commerce site with LOTS of things and capabilities. You should check it

[PHP-DB] PHP-DB Mailing list problem

Hi. Every time I post a new message or reply to a message to this mailing list, an e-mail is sent to me from Mailer-Daemon and says which follows: Sorry. Your message could not be delivered to: mailing list (Mailbox or Conference is full.) Can you see this message? please tell me in order to

[PHP-DB] Re: Adding totals

It works... Thanks a lot. - Original Message - From: Adam Royle To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 2:11 AM Subject: Re: Adding totals This should be it (if I am understanding you correctly). Adam $strSQL = SELECT SUM(columnName)

[PHP-DB] Adding totals

Hi all, Is there a way for me in PHP4 to add all the contens (floating numbers) of a cartain column whithin a row and show up the result? I have several time inputs and need to show the total. Thanx. Cesar Aracena [EMAIL PROTECTED] Neuquen, Argentina

[PHP-DB] Adding totals

Hi all, Is there a way for me in PHP4 to add all the contens (floating numbers) of a cartain column whithin a row and show up the result? I have several time inputs and need to show the total. Thanx. Cesar Aracena [EMAIL PROTECTED] Neuquen, Argentina

[PHP-DB] First Script

Hi again. As I mentioned before, I am trying out my first script. Here it is, so anyone who wants can tell me where my errors are: ?php // Connect to Database $db = mysql_connect(localhost, admin, xxx); mysql_select_db(contime); $query = select * from time where id 0; $result =

[PHP-DB] RE: First Script

Thanx for the help. I have it almos finished. Now, the script throws all the colums for all the rows of the table. My only problem now is how to print the TOTAL for the column named time. Can I use mysql_fetch_array() instead of mysql_fetch_row() to accomplish this? How can I add it? Here's