Notice: Undefined offset: 1 in E:\xampp\htdocs\WPTC-PMS5-5-14\edit_column.php on line 12

Question

when the below code works I get the above mentioned error , what should i do ? please help me ...

<?php
 //session_start();
 include("dbconnect_database.php");
 $tname=$_GET['tn'];
 $cname=$_GET['cn'];
 $des=mysql_query("desc `$tname` `$cname`");
 $row=mysql_fetch_array($des);
 list($type, $b) = explode('[(]',$row[1]);
 list($size) = explode('[)]',$b);
 ?>

Your error message refers to line 12 but there are only *ten* lines of code. — , May 08 '14 at 03:36

Mark Miller · Answer 1 · 2014-05-08T05:02:02.210

0

Try changing this:

list($type, $b) = explode('[(]',$row[1]);

to this:

list($type, $b) = explode('[(]',$row[0]);

UPDATE

The error is telling you that 1 is not a valid index for $row, so that is the problem. Just before that line, try var_dump($row). This will tell what the valid indexes for $row are, and you should be able to use that to fix your code.

edited May 08 '14 at 05:02

answered May 08 '14 at 03:39

Mark Miller

7,442
2
16
22

Thanks for your suggestion , but iam still getting the error message "Notice: Undefined offset: 1 in E:\xampp\htdocs\WPTC-PMS5-5-14\edit_column.php on line 12" – user3614697 May 08 '14 at 04:54

score -1 · Answer 2 · edited May 18 '14 at 21:21

-1

there is no ' around table and column name

$des=mysql_query("desc $tname $cname");

sidenote: use mysqli_query instead of mysql because use of mysql is been deprecated

edited May 18 '14 at 21:21

BenMorel

34,448
50
182
322

answered May 08 '14 at 03:43

ashishmaurya

1,196
10
18

If you recommend *mysqli* over *mysql*, why does your answer contain *mysql* extension functions? Also, OP uses backticks, not single-quotes – Phil May 08 '14 at 04:19
@Phil question was asked using MYSQL – ashishmaurya May 08 '14 at 04:29
So what? What is your motivation for providing answers on SO if it's not to educate? – Phil May 08 '14 at 04:35

Notice: Undefined offset: 1 in E:\xampp\htdocs\WPTC-PMS5-5-14\edit_column.php on line 12

2 Answers2