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

in any week 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 PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 11, 2002 11

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

Hughes - Original Message - From: John Hughes, Jomari Works [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 11, 2002 10:42 PM Subject: [PHP-DB] Creating an array of mySQL results with PHP I am working on the creation of Web-based database where parents log the hours

Re: [PHP-DB] textarea and mysql query

the HTML section I have areas such as this: td textarea cols=60 rows=20 name=body wrap=soft ? echo $body; ?/textarea /td This creates an editable TEXTAREA that can then be UPDATEd in the database. John Hughes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www

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

]; $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:. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 30

[PHP-DB] HTTP authentication script failure display

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 ? session_start(); /* ** Check password */ if($PHP_AUTH_USER != '') { require (**/connect_***.***'); $sql = SELECT

[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 ? session_start

[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

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] To: [EMAIL PROTECTED] Sent

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

. 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 unsubscribe

[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 something like

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

() and 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

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

. A sample table cell looks like this: td align=\center\ input type=\text\ name=\classroom\ value=\$classroom\ size=\2\ maxlength=\4\ /td How would I change the mysql_fetch_array to create an array of weeks and how would I change the table output coding to accommodate such an array? TIA John

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' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday