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

2002-03-11 Thread John Hughes, Jomari Works
I am working on the creation of Web-based database where parents log the hours they spend participating in school activities. (The school requires that parents spend two hours each week.) I have a prototype demonstration site at http://fuzzheads.org/demo As currently constructed, the parent log

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

2002-03-11 Thread John Hughes, Jomari Works
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

2002-03-15 Thread John Hughes, Jomari Works
SQL QUERY question I have three tables: students has student_id and student_name parents has parent_id and parent_name parentlog has student_id and parent_id I want to search the parentlog WHERE student_id = some_id GROUP BY parent_id (This will bring back two rows when there are two parents)

[PHP-DB] passing array through $PHP_SELF

2002-03-18 Thread John Hughes, Jomari Works
I have a page that selects students from a mysql table who meet a certain requirement. Those who meet the requirement have a check box variable that is "checked." (The other students have the check box, but it is unchecked.) The "checked" student id numbers are sent to the next PHP page. That pa