On Sat, Mar 24, 2012 at 8:47 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2012-03-23 16:54, Chanaka Dharmarathna a écrit :
> Hi,
>
> I am trying to do some improvements on feature request [1]. A field (let's
> call it as 'picture') with mime type "mime/jpeg" is not showing th image,
> if the query (execute in query window) retrieve the 'picture' field from
> the table (SELECT `picture` FROM `table_name` WHERE 1) as mentioned in [1].
>
> To display data, $where_clause is generated by the function
> PMA_getUniqueCondition (in root/libraries/common.lib.php) row wisely. For a
> long data like blob type, it returns $where_clause as empty string ("").
> (There is conditions to check the length of the data in that function)
>
> What I'm trying to do is, for that kind of scenarios, make the
> $where_clause as "`table`.`primary_key_feild_name` =
> 'primary_key_value_for_corresponding_row'" (tried with hard coding & works
> for me). To do this I'm going to add a new argument to
> PMA_getUniqueCondition function with those two parameters (primary field
> name & relevant value). And call this inside PMA_displayTableBody function
> (in display_tbl.lib.php) with those values.
>
> If the way I'm going is correct,
> Is there any way to fetching out primary key field value of each row while
> inside the PMA_displayTableBody function ?
> Or is there global parameter which holds table meta data ?

Look at $fields_meta which is available in this function.

--
Marc Delisle
http://infomarc.info

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Hi Marc,

Thanks for your quick reply. I'll look in to that.

Regards !

--
____________________________________

Chanaka Indrajith
Bsc.Computer Engineering Undergraduate
Faculty of Engineering
University of Peradeniya
____________________________________