Change SQL Selects based on if on desktop or phone/tablet ?

[PatRoy]

Hello folks, 

So, not sure where to start, but I'm wondering if it's at all possible to change a prepared statement / sql based on whether or not we're displaying for desktops, or for smartphone/tablets? I'm not sure what to start looking at since I'm pretty new in PHP and all... 

I've managed to figure out how to change CSS if I'm on phone 

@media only screen and (max-width: 767.98px){
  // PUT CSS FOR PHONES...
}

Any directions on how I would change my SQL, would be awesome! I'd like to narrow down the columns returned if I'm on phone, otherwise breaks my pages looks too much...

Much thanks in advance!

Pat

 

[requinix]

From what you're describing it sounds like the problem is the way those columns are displayed. Right?

Which would make it a job for CSS. Right?

Depending on your CSS framework, you can show and hide things depending on screen sizes...

[PatRoy]

Arghh stupid me ! Of course... you made me realise all I have to do is assign a css class say "hideme" to my columns TD/TH's I want hidden on phones, and have my stylesheet do something like:

 

@media only screen and (max-width: 767.98px){
  .hideme{
    display: none;
  }
}

Something like that should do it. Thanks for your help again :)

Pat