adrianle

Hey y'all.. need some definite help here. I have two tables, one for Parents, and one for Children. There may be multiple Children for any given Parent, and they're both related in their tables via a unique FamilyID. I need to pull each Parent record, and ALL related Children records into a recordset. Ex. Parent Bill has two kids, Jimmy & Tommy. Parent Dave has one kid, Molly. I need to retrieve a recordset that looks like this: Bill, Jimmy, Tommy Dave, Molly Obviously, one of the challenges is that the different number of Children that will be output - though I'm fine with retrieving multiple children info into a single column. Suggestions?

It says: /etc/php.ini ... which is where I put it.

Hey guys.. I've got a few entries in a php.ini file that don't appear to be taking hold after restarting apache. Here's the scenario: Wrote an info.php to show me my PHP configuration. It says it's looking for php.ini under .../webroot/etc/php.ini I changed that php.ini - restarted Apache Ran the info.php again, and I don't see the new values reflected here. Suggestions?

I've got a stinker of a question and it's driving me crazy. I have a table showing a list of contacts, and in some cases, more than one Contact work for the same Company (a unique ID is held in this table for the relative Company). I need to somehow return a list of rows showing me all instances of A) the Company ID, and B) the number of contacts for that Company Help??

The time value is coming from a TIME column type in the table, so the example mysql> SELECT TIME_TO_SEC('00:05:30'); doesn't help much I'm afraid. I've tried to use this function with the column name plugged into the select statement but without success. To answer Anemic's question.. that would require having to calculate out the time slice into seconds before entering it into the table. The point of this exercise is to have PHP calculate the total number of seconds for us!

I've got a mysql table where I want to enter some amount of time, say 5 minutes (5:00) into a column, which will then be pulled by a page and a calculation done (5 minutes x 60 seconds = 300 seconds). I'm unsure what type of mysql field type I should use to hold this data. Any ideas?

..and I mean that in a literal sense! I have a mySQL table with Parent information in it. I also have a table with Child information in it, each with a unique ID related to one of the records in the Parent table. Some Parents have multiple Children. I need to run a select statement that will return ALL family records, ideally with the parent first, and then their children, and so on. Suggestions? I posted this question on a mysql forum and got no replies.

I'm currently pulling database content into a page that will be printed. This page has a footer div with client logo, etc. I need to figure out how to split the content after X number of lines so it will print onto the next page without running over the footer div. Help??