How to query search numbers in php mysql

Question

I need a search query. Age value 10 - 15 , 20 - 25 , 17 - 19 , 12 - 59 , 2 - 19 , 18 - 40 , 10 - 20

I send 10 - 25 and I want to get results by matching the numbers

<?php 
  $Age1 = 10;
  $Age2 = 25;

  $Age = $Age1." - ".$Age2;

  $stmt = mysqli_query($con,"SELECT * FROM job_post_p1 where Age LIKE '%" . $Age .  "%'");

?>

Thanks to All

You want to grab rows that have an age in between those two ages? tutorialspoint.com/mysql/mysql-between-clause.htm — Matt
– Matt, Commented Jun 6, 2017 at 19:59
We cannot provide the correct answer unless you provide the sample record in table for age — Agam Banga
– Agam Banga, Commented Jun 6, 2017 at 20:03

Randy · Accepted Answer · 2017-06-06 19:59:40Z

2

You should use the BETWEEN operator, it selects values within a given range.

Example:

$stmt = mysqli_query($con,"SELECT * FROM job_post_p1 where Age BETWEEN 10 AND 25");

answered Jun 6, 2017 at 19:59

Randy

5631 gold badge5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Randy Over a year ago

Yes, it selects the values where the age is between 10 - 25

sensorario · Accepted Answer · 2017-06-06 20:08:40Z

2

I guess what you need is between operator. The between operator aims to select values within a given range. In your scenario, an age range. This operator is inclusive. This means that begin and end values are included.

<?php

$Age1 = 10;
$Age2 = 25;

$stmt = mysqli_query(
    $con,
    "SELECT * " .
    "FROM job_post_p1 " .
    "WHERE Age BETWEEN $Age1 AND $Age2"
);

edited Jun 6, 2017 at 20:08

answered Jun 6, 2017 at 20:01

sensorario

21.9k31 gold badges105 silver badges177 bronze badges

Comments

vivek gupta · Accepted Answer · 2017-06-06 20:05:01Z

-1

$stmt = mysqli_query($con,"SELECT * FROM job_post_p1 where Age BETWEEN 10 AND 25");

answered Jun 6, 2017 at 20:05

vivek gupta

1132 silver badges13 bronze badges

2 Comments

GrumpyCrouton Over a year ago

You should explain why your answer is the correct one, why it should be used. You just posting the code saying "this is it" doesn't answer the question of why that's right, how can anyone else learn from it?

vivek gupta Over a year ago

Thanks for advice

Collectives™ on Stack Overflow

How to query search numbers in php mysql

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related