mysql_query function help.

[iStriide]

I'm not sure on how to do this so I hope one of you can help me. I'm trying to do a mysql_query(); function in PHP to get certain results. I'm trying to get users from my database where their ID's are between 1 and 100. So what would I have to do for that?

[AyKay47]

I would use the mysql BETWEEN() function here...it would be easier to help if you posted your code...

[phpSensei]

Hi There,

 

Maybe I can be some sort of assistance to you here. MySQL offers a variety of tools within its query segments in order to provide you different ways of pulling out a certain set of results, its truly a language of its own once you get down to it.

 

Here's a prime example of what I mean related to your question:

 

mysql_query("SELECT * FROM `users` WHERE `user_id` > 1 AND `user_id` < 100");

 

[iStriide]

Hi There,

 

Maybe I can be some sort of assistance to you here. MySQL offers a variety of tools within its query segments in order to provide you different ways of pulling out a certain set of results, its truly a language of its own once you get down to it.

 

Here's a prime example of what I mean related to your question:

 

mysql_query("SELECT * FROM `users` WHERE `user_id` > 1 AND `user_id` < 100");

 

You help me once again. 

[phpSensei]

My pleasure to help you, it is note worthy to also look into the solution AyKay7 provided, there may be a performance difference here.

 

Mark Topic As Solved.

 

- Sensei