MYSQL fetch array cannot catch row's name in php

Question

Here is my code

$sql = "SELECT distinct s.doc_id, s.pat_id, s.approved, p.pat_fullname, p.pat_id from patient p, subscribe s WHERE s.doc_id = '$doc_id' AND s.approved = '1' AND s.pat_id = p.pat_id;";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result))
{
    $patname = $row['p.pat_fullname'];      
    echo "<label>Patient:</label>";
    echo "<option value='$patname'>$patname</option>";

}

Notice: Undefined index: p.pat_fullname in C:\Program Files (x86)\EasyPHP-5.3.9\www\PHR system\doc_patdoc.php on line 60

Above is the notice from browser. The sql query is definitely worked as I have tried it in my database. So what row's name should I put instead of p.pat_fullname?

MrCode · Accepted Answer · 2012-11-20 17:16:53Z

5

The result does not contain the p. prefix, so remove that:

 $patname = $row['pat_fullname'];

answered Nov 20, 2012 at 17:16

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

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

3 Comments

Manse Over a year ago

+1 this is a correct answer - but what if there are columns with the same name ? (I know there isnt in the OPs case, which is why I voted up)

Theodore R. Smith Over a year ago

If they are the same name, you need to alias them so that they have unique names.

Manse Over a year ago

@TheodoreR.Smith you mean just like my answer ;-)

Manse · Accepted Answer · 2012-11-20 17:17:02Z

1

Use an alias in your query :

p.pat_fullname as fullname

then access it like this :

$row['fullname']

You can access it without the p. table alias but if you have multiple columns with the same name this is the safest way to go

answered Nov 20, 2012 at 17:17

Manse

38.1k11 gold badges88 silver badges112 bronze badges

1 Comment

user1802939 Over a year ago

Thanks, this is the answer I want.

Collectives™ on Stack Overflow

MYSQL fetch array cannot catch row's name in php

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related