RE: [PHP-DB] how can I delete a record from txt file

2004-01-23 Thread Angelo Zanetti
well you gotta make sure that the record that you are deleting is not being used by another program, you will have to look at the other program and determine when they run, it will be difficult to automate that. to physically delete a record you have to find the id of the record ( i presume that

Re: [PHP-DB] Drop down box NOT populated

2004-01-23 Thread Tristan . Pretty
Jsut a guess... Your row has a capital 'A' in the SQL statement, and a lower case 'a' in teh $row[] call.. does that matter? Larry Sandwick [EMAIL PROTECTED] 22/01/2004 15:46 Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject [PHP-DB] Drop down box NOT populated

Re: [PHP-DB] Drop down box NOT populated

2004-01-23 Thread John W. Holmes
From: [EMAIL PROTECTED] Jsut a guess... Your row has a capital 'A' in the SQL statement, and a lower case 'a' in teh $row[] call.. does that matter? Yep, that would matter, but not the exact problem. I don't know if this thread has already been answered or not, so... The real problem is

RE: [PHP-DB] Drop down box NOT populated

2004-01-23 Thread Humberto Silva
Instead of: $row = mysql_fetch_array($sql) Use: $row = mysql_fetch_assoc($sql) Humberto Silva World Editing Portugal -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: sexta-feira, 23 de Janeiro de 2004 15:42 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc:

Re: [PHP-DB] Drop down box NOT populated

2004-01-23 Thread John W. Holmes
From: Humberto Silva [EMAIL PROTECTED] Instead of: $row = mysql_fetch_array($sql) Use: $row = mysql_fetch_assoc($sql) While I'm in the habit of doing that, using fetch_array() isn't going to cause any problems with regard to the original post. Which one you use is really a matter of

RE: [PHP-DB] Drop down box NOT populated

2004-01-23 Thread Humberto Silva
I confess i didn't read the original post ... You're absolutely right ... Humberto Silva World Editing Portugal -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: sexta-feira, 23 de Janeiro de 2004 16:03 To: Humberto Silva Cc: [EMAIL PROTECTED] Subject: Re:

[PHP-DB] Help with a COUNT / SELECT query

2004-01-23 Thread Shaun
Hi, I have a Bookings application. When a Booking is made it is entered in to the Bookings table. Bookings take place at Areas, held in the Areas table. Each Area has a unique Area_ID held in the Bookings table for each Booking. Each Booking needs to be completed and when done so the

RE: [PHP-DB] editing, deleting records

2004-01-23 Thread mayo
Add a table cell with a link to the page processing the edit/del example print (tda href=\edit.php?id= . $row['id'] . \EDIT/a/td); print(td . $lname . /tdtd . $fname . /tdtd . $dob . /tdtd . $phone . /tdtd . $address . /tdtd . $email . /tdtd . $sex . /td);

[PHP-DB] Array sorting question...

2004-01-23 Thread NIPP, SCOTT V (SBCSI)
I am trying to populate an array from a MySQL database. I think I have the code correct to populate the array, but I need to somehow sort the array eliminating duplicate values. I think I can loop through the array doing a comparison and building a new array by discarding the value if it

Re: [PHP-DB] Database Abstraction Layer?

2004-01-23 Thread Muhammed Mamedov
I don't think that DB_DataObject will create a nicce SQL. I think it's better to write it yourself (you know when you have large data sets its better to handle the work youurself)... But your comments on that PEAR::DB is a good package and that many others depend on it makes it the favorite one, I

RE: [PHP-DB] Array sorting question...

2004-01-23 Thread Katie Evans-Young
NIPP, SCOTT V (SBCSI) wrote: I am trying to populate an array from a MySQL database. I think I have the code correct to populate the array, but I need to somehow sort the array eliminating duplicate values. I think I can loop through the array doing a comparison and building a new

Re: [PHP-DB] Help with a COUNT / SELECT query

2004-01-23 Thread Shaun
Thanks for your reply, but that only tells me how many complete Bookings there are. I need to know how many Areas are complete i.e. for each Area where Bookings take place, all of those Bookings have been completed. Any ideas? Oòvn?Oòsis [EMAIL PROTECTED] wrote in message news:[EMAIL

Re: [PHP-DB] Help with a COUNT / SELECT query

2004-01-23 Thread Micah Stevens
SELECT COUNT(WMS_Area.Area_ID) AS complete_areas FROM WMS_Area, WMS_Bookings WHERE WMS_Area.Area_ID = WMS_Bookings.Area_ID AND MIN(WMS_Bookings.Booking_Status) = 2 GROUP BY WMS_Area.Area_ID Or something like that.. there's probably a better way to do it.. On Fri January 23 2004 1:05 pm,

RE: [PHP-DB] CREATE TABLE problem

2004-01-23 Thread Diane Gonzales
Actually, it's more of an order problem: I fixed the SQL already. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 4:47 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] CREATE TABLE problem I have had similar

RE: [PHP-DB] CREATE TABLE problem

2004-01-23 Thread Diane Gonzales
If you're using MySQL, change to this: staffid int(3) unsigned not null auto_increment, The order of the attribute description is important in MySQL. -Original Message- From: js [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 6:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB]

[PHP-DB] Stroring files as BLOBs in MySQL?

2004-01-23 Thread John
Whats the problems with it?? I now have an 150MB table with MIDI files and title and authors. could i run into problems bu doing this?? -- ** Free Nokia Ringtones US http://www.ring-tones.us ** -- PHP Database Mailing List

Re: [PHP-DB] Stroring files as BLOBs in MySQL?

2004-01-23 Thread John W. Holmes
John wrote: Whats the problems with it?? I now have an 150MB table with MIDI files and title and authors. could i run into problems bu doing this?? This is like asking if you should use Windows or Linux. Everyone has their own opinion and no one is going to change it. It's also been discussed