PHP list issue ( Undefined offset: )

Question

Original SQL query is this; SELECT id,post_title,post_date FROM wp_posts where id='1'

When I retrieve the record, I am finding it but when it comes to returning the results, I am puzzled. Here is the where I got stuck.

   while ($row = mysql_fetch_assoc($RS)) :
      print_r ($row); 
      list($id,$post_title,$post_date) = $row;
   endwhile;

print_r ($row) outputs this; Array ( [ID] => 1 [post_title] => Hello world! [post_date] => 2012-03-27 03:28:27 )

And when I run the list function in there ( for debug purposes obviously ), I get this;

Notice: Undefined offset: 2 in F:\inetpub\wwwroot\whatever\sql.php on line 147
Notice: Undefined offset: 1 in F:\inetpub\wwwroot\whatever\sql.php on line 147
Notice: Undefined offset: 0 in F:\inetpub\wwwroot\whatever\sql.php on line 147

What's causing this?

stewe · Accepted Answer · 2012-03-28 01:40:12Z

6

Replace:

mysql_fetch_assoc($RS)

with:

mysql_fetch_array($RS, MYSQL_NUM)

then it should work, because the list function trys to access the array using numeric keys.

answered Mar 28, 2012 at 1:40

stewe

42.8k13 gold badges82 silver badges77 bronze badges

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

Comments

Average Joe · Accepted Answer · 2012-03-28 01:39:12Z

6

I guess the answer lies somewhere within this;

list() only works on numerical arrays and assumes the numerical indices start at 0.

:(

answered Mar 28, 2012 at 1:39

Average Joe

4,64111 gold badges58 silver badges84 bronze badges

Comments

summea · Accepted Answer · 2012-03-28 01:40:59Z

2

You might be able to use extract() here instead, as well; (documentation here.)

answered Mar 28, 2012 at 1:40

summea

7,6534 gold badges35 silver badges49 bronze badges

Comments

webjprgm · Accepted Answer · 2012-03-28 01:40:12Z

1

You used mysql_fetch_assoc, so the resulting array per row has data under a key by column name, whereas "list" tries to match variables to values using numerical array indexes. You can use mysql_fetch_array instead.

answered Mar 28, 2012 at 1:40

webjprgm

4,6712 gold badges20 silver badges14 bronze badges

Comments

Ravi · Accepted Answer · 2013-01-29 07:07:36Z

0

$categ = val1 | val2

list($one,$two,$three)=@split('[|]',$categ);

If you try to list the value which is not available it will return the error Undefined Offset.

Here the error will be Undefined Offset 2.

Because while spliting $categ, it will have only two values, if you try to access third value then it will return error.

answered Jan 29, 2013 at 7:07

Ravi

173 bronze badges

Collectives™ on Stack Overflow

PHP list issue ( Undefined offset: )

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related