Undefined offset error when running SQL query

Question

Each time I run the the SQL statement:

SELECT * FROM tbl_accident WHERE progress = 'on hire' AND progress = 'vd'

But it returns an error:

Notice: Undefined offset: 2 in C:\xampp\htdocs\newclaim\cases.php on line 139
Notice: Undefined offset: 1 in C:\xampp\htdocs\newclaim\cases.php on line 139

Alternatively when I run:

SELECT * FROM tbl_accident WHERE progress = 'on hire';

or

SELECT * FROM tbl_accident WHERE progress = 'vd';

There is no problem. What am I doing wrong? The code at line 138-140 reads:

<td><?php $caseOpen = explode("/", $row_cases['caseOpen']); 
  $caseOpen = $caseOpen[2].'/'.$caseOpen[1].'/'.$caseOpen[0]; 
  echo $caseOpen;?></td>

juergen d · Accepted Answer · 2012-04-18 11:52:01Z

3

try

SELECT * FROM tbl_accident WHERE progress='on hire' OR progress='vd'

You used AND instead of OR in your query. Using AND will never return any result because progress can't be vd and on hire at the same time.

answered Apr 18, 2012 at 11:52

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

Comments

t-clausen.dk · Accepted Answer · 2012-04-18 12:15:34Z

1

You are currently always getting 0 rows returned from your select.

Try this:

SELECT * FROM tbl_accident WHERE progress in ('on hire', 'vd')

answered Apr 18, 2012 at 12:15

t-clausen.dk

44.5k12 gold badges61 silver badges92 bronze badges

Comments

Rohit Choudhary · Accepted Answer · 2012-04-18 11:52:15Z

1

Please check your sql. You are using progress in where clause more than on time using AND. YOu can use OR instead of AND

answered Apr 18, 2012 at 11:52

Rohit Choudhary

2,2571 gold badge24 silver badges35 bronze badges

Collectives™ on Stack Overflow

Undefined offset error when running SQL query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related