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
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
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
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:
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
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:
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
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);
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
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
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
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òvn?Oòsis [EMAIL PROTECTED] wrote in message
news:[EMAIL
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,
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
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]
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
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
17 matches
Mail list logo