Re: [PHP] OT mysql pivot table problem

Matt Giddings wrote: > Ummm yeah, its going to take me a while to wrap my head around that one. > thanks though! > Matt -- Matt Giddings Web Programmer Information Technology Services Saginaw Valley State University Phone: 989.964.7247 http://www.svsu.edu I was born in Saginaw, Michigan. I gre

Re: [PHP] OT mysql pivot table problem

Ummm yeah, its going to take me a while to wrap my head around that one. thanks though! Matt On Thu, Jun 25, 2009 at 5:07 PM, Andrew Ballard wrote: > On Thu, Jun 25, 2009 at 4:21 PM, Andrew Ballard wrote: > > On Thu, Jun 25, 2009 at 3:20 PM, Matt Giddings wrote: > >> I know this is the off topi

Re: [PHP] OT mysql pivot table problem

On Thu, Jun 25, 2009 at 4:21 PM, Andrew Ballard wrote: > On Thu, Jun 25, 2009 at 3:20 PM, Matt Giddings wrote: >> I know this is the off topic (sorry), but it is a php project that I'm >> working on!  I need some pointers on how to pivot a mysql column (containing >> comma delimited data) into an e

Re: [PHP] OT mysql pivot table problem

On Thu, 2009-06-25 at 16:17 -0400, Eddie Drapkin wrote: > You'd be much, much better off creating a query by concatenating ", > ($uid, $groups[$i])" into one huge insert query. > > YOU SHOULD NEVER, EVER EVER EVER EVER RUN QUERIES IN A LOOP! > > > On Thu, Jun 25, 2009 at 4:11 PM, Matt Giddings w

Re: [PHP] OT mysql pivot table problem

On Thu, Jun 25, 2009 at 3:20 PM, Matt Giddings wrote: > I know this is the off topic (sorry), but it is a php project that I'm > working on!  I need some pointers on how to pivot a mysql column (containing > comma delimited data) into an equal number of rows (see example).  Any > direction (pointer

Re: [PHP] OT mysql pivot table problem

You'd be much, much better off creating a query by concatenating ", ($uid, $groups[$i])" into one huge insert query. YOU SHOULD NEVER, EVER EVER EVER EVER RUN QUERIES IN A LOOP! On Thu, Jun 25, 2009 at 4:11 PM, Matt Giddings wrote: > Thanks for taking the time to provide an example.  I'm going t

Re: [PHP] OT mysql pivot table problem

Thanks for taking the time to provide an example. I'm going to take the advice given by you and others and simply do this in php instead of looking for a fancy mysql solution. ; ) Dang, and I was really wanting to wow myself today... Thanks again! Matt On Thu, Jun 25, 2009 at 3:51 PM, Ashley Sh

Re: [PHP] OT mysql pivot table problem

On Thu, 2009-06-25 at 15:20 -0400, Matt Giddings wrote: > I know this is the off topic (sorry), but it is a php project that I'm > working on! I need some pointers on how to pivot a mysql column (containing > comma delimited data) into an equal number of rows (see example). Any > direction (point

[PHP] OT mysql pivot table problem

I know this is the off topic (sorry), but it is a php project that I'm working on! I need some pointers on how to pivot a mysql column (containing comma delimited data) into an equal number of rows (see example). Any direction (pointers to links, etc. would be appreciated). >From this: user.tab