Re: [PHP] Help With Inventory

2007-01-23 Thread Jim Lucas
Brandon Bearden wrote: What I WANT to see is something like this DVD ID | TITLE | GENRE 1 | GENRE 2 | GENRE 3 | ACT | QTY BCK |HLD | INC | OG USR | OUT DATE | OUT USR | IN DATE | IN USR CY GENRE: ACTION - 1 TITLES 20860023 | Movie name | ACTION | | | 1

Re: [PHP] Help With Inventory

2007-01-22 Thread Jim Lucas
Here is my rendition of your script. Give it a shot... Let me know if you have any question about what is going on. I was curious, what is the point of having the alternating column colors? Was that your intention? ?php function invlistONE(){ dbconnect('connect'); $invlist

Re: [PHP] Help With Inventory

2007-01-22 Thread Brandon Bearden
Thank you for your help. I see what you are doing different. I don't understand how the quotient works there. I will sometime. I also don't understand the HEREDOC concept. I wanted colors alternating to allow for a better read. I still have not solved the problem with listing the genre in its

Re: [PHP] Help With Inventory

2007-01-22 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2007-01-22 22:55:50 -0800: Jim Lucas [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] $count = 0; while ( $row = mysql_fetch_array( $invlist ) ) { if ( $count % 1 ) { $rowColor = '#c1c1c1'; } else { $rowColor = ''; } echo HEREDOC tr

Re: [PHP] Help With Inventory

2007-01-22 Thread Brandon Bearden
What I WANT to see is something like this DVD ID | TITLE | GENRE 1 | GENRE 2 | GENRE 3 | ACT | QTY BCK |HLD | INC | OG USR | OUT DATE | OUT USR | IN DATE | IN USR CY GENRE: ACTION - 1 TITLES 20860023 | Movie name | ACTION | | | 1 | 1 | 0 |

[PHP] Help With Inventory

2007-01-20 Thread Brandon Bearden
Can anyone help me figure out how to solve my inventory listing problem? I am using php_5 and mysql_5.0 w/apache on fbsd. I need to figure out a way to make a subtitle for every category (genre) in the inventory so when I list the entire inventory on a sheet (at client's request), it is