Re: [PHP-DB] Creating an array of mySQL results with PHP

and then press a single Update button and have all of the values updated. John Hughes - Original Message - From: "Shrock, Court" <[EMAIL PROTECTED]> To: "'John Hughes, Jomari Works'" <[EMAIL PROTECTED]>; "Shrock, Court" <[EMAIL PROTEC

Re: [PHP-DB] Creating an array of mySQL results with PHP

quot;$week_no\" "; # end create sql query The foreach format and figuring out to extract the data in preparation for the UPDATE command caused me the most trouble. The demo site mentioned in the original message has been modified to incorporate the one-button update feature for tho

Re: [PHP-DB] textarea and mysql query

nfo']; $fname = $row['fname']; $lname = $row['lname']; $title = $row['title']; $city = $row['city']; $other = $row['other']; $record_date = $row['record_date']; $status = $row['status']; $batch = $row['ba

Re: [PHP-DB] using multiple checkboxes to delete from db

d]; $studentname = $data[this_studentname]; $send_mail = $data[send_mail]; if ($send_mail == "Yes") { # Your sql statement and processing goes here }# end if }# end for each Hope this helps. John Hughes - Original Message - From: "wesley grubbs:." <

[PHP-DB] figuring out number of months between two dates

I have a table that contains a list of dates. For instance: 2001-08-23 2001-08-27 2001-09-04 (and running through) 2002-06-03 I want to calculate how many months between 2001-08-23 and CURRENT_DATE (which for discussion purposes we'll put at 2002-04-01) and how many months between the first we

Re: [PHP-DB] figuring out number of months between two dates

digits without the intervening hyphen so I can feed the data to PERIOD_DIFF? - Original Message - From: "John Hughes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 01, 2002 11:56 PM Subject: [PHP-DB] figuring out number of months between two dates

[PHP-DB] HTTP authentication script failure display

me and password" when a failure occurs, I get a blank screeen. I've compared the code in the book with mine but I can't see what I've done. Any help would be appreciated. John Hughes \n"); } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] HTTP authentication

Earlier I posted a question about why the failure message in my HTTP authentication script wasn't working. I figured out the answer. There was no place to go if the user entered a username or password that wasn't in the database. Below is the corrected code. John Hughes \n"); }

[PHP-DB] deleting records

It's late and I'm getting groggy. I have a table called mail_list. There are four possible list_names. I want to be able to either delete an email associated with a particular list or all matching email. Deleting WHERE email AND list match works fine. The problem is when I want to delete an a

Re: [PHP-DB] deleting records

This was, of course, an example where the PHP code was introducing an error. The delete sql works as expected and deletes all matching email. Next time I'm going to sleep on a problem before posting. - Original Message - From: "John Hughes" <[EMAIL PROTECTED]>

[PHP-DB] One search or lots of little sqls?

pick the portion to display? We are not talking a high-volume site, perhaps a dozen people at one time. John Hughes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to avoid: Warning: Page has Expired

r you. To resubmit your information and view this Web page, click the Refresh button. What causes this and how can I fix it so this doesn't happen? The URL for this site is http://fuzzheads.org/barcelona TIA John Hughes -- PHP Database Mailing List (http://www.php.net/) To u

[PHP-DB] Limitations on sending text to a database via text area forms

, what alternatives might I use to circumvent this limit? I need to keep the creation of these documents as simple as possible. Anything more than copying and pasting is going to cause trouble more me. John Hughes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

RE: [PHP-DB] redirect a page

If you really want to redirect and not just display a message that no records were found, then this will work: $num = mysql_numrows($result); if ($num == 0) { header("Location: sorry.php"); exit; } ELSE { while ... --- "Rankin, Randy" <[EMAIL PROTECTED]> wrote: > Nato, > > Try somethi

[PHP-DB] translating password($var) back to text

retrieve a decoded value from mySQL? John Hughes __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] DROP tables with prefix match

I need to rebuild a PHP-mySQL site that has an extensive table structure. Is there a way to DROP all tables that start with a certain prefix? __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP Database Mailing L

[PHP-DB] Creating an array of mySQL results with PHP

ast']; $meetings = $row['meetings']; $other = $row['other']; I then create a table row of the result and loop through. A sample table cell looks like this: How would I change the mysql_fetch_array to create an array of weeks and how would I change the table

Re: [PHP-DB] Creating an array of mySQL results with PHP

OK. I can see how that works, assuming that the value would be \"log[$week_no][classroom]\" as well. What would the mysql_fetch_array look like? - Original Message - From: "Shrock, Court" <[EMAIL PROTECTED]> To: "'John Hughes, Jomari Works'"

[PHP-DB] Joining three tables

ables and search all in one pass? TIA John Hughes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] passing array through $PHP_SELF

or `T_NUM_STRING' Right now I have the book open to implode and explode, figuring I can translate the array and then pass it back and forth, but that seems rather inelegant. Is there a "simple" way to pass an array when using $PHP_SELF to reload a page? TIA John Hughes --