Jump to content

jnmunsey

New Members
  • Posts

    5
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

jnmunsey's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I posted this in the freelance forum not realizing replies weren't allowed. Not sure where else to put it though. Hi I haven't participated much around here I know but I thought I'd seek help anyway. We have a site that is in dire need of redesign nearly from the ground up. It is more or less an e-commerce site but one I feel needs to be a custom job and not use an off the shelf ecommerce or even CMS package. It basically is an event tickets site which sells concert, sports and theater tickets. There is also another project slightly related that is more of a traditional website though it will need to be database driven. Both projects will require LAMP + more... Before we proceed to fix things we'd like to consult with someone about what to do and how to do it. Are there any recommendations of any individuals or companies that can help us and do it right? I imagine I will get a ton of spam form people offering their services. That's nice but I am hoping I can get some feedback from as many people as possibly about getting help. Last thing any one wants to do is get bad advice or direction and then spend thousands to implement it. I have done most of the work previously but would like someone else to step in and do the work and do it better than I can. So in a nutshell I'd like some guidance to find help in getting these projects done. Should I look at the users and sort by reputation and inquire with them? anything else? Any help is appreciated, and thank you!
  2. Thanks got it to work. Looks like this: SELECT unixtime2, pagenum, count( DISTINCT ipaddress ) AS pagenumtotal FROM ( ( SELECT `unixtime2` , `pagenum` , `ipaddress` FROM `orders1` WHERE unixtime2 > $numweeks AND pagenum != '' ) UNION ALL ( SELECT `unixtime2` , `pagenum` , `ipaddress` FROM `ordersbp` WHERE unixtime2 > $numweeks AND pagenum != '' ) ) AS ABC GROUP BY `unixtime2` , `pagenum` ORDER BY `unixtime2` , pagenum ASC
  3. This is my query: ( SELECT `unixtime2` , `pagenum` , count( DISTINCT `ipaddress` ) AS pagenumtotal FROM `orders1` WHERE unixtime2 >20081031 AND pagenum != '' GROUP BY `unixtime2` , `pagenum` ORDER BY `unixtime2` , pagenum ASC ) UNION ( SELECT `unixtime2` , `pagenum` , count( DISTINCT `ipaddress` ) AS pagenumtotal FROM `ordersbp` WHERE unixtime2 >20081031 AND pagenum != '' GROUP BY `unixtime2` , `pagenum` ORDER BY `unixtime2` , pagenum ASC ) This query yields two separate values for each date and doesn't merge them, a result of the "Count" function. If I were doing a query for just the count alone could use "+" instead of "union" but I need to return values based on the date, pagenum and the unique count of ip addresses for each. Advice? Thanks so much!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.