Set mysql value to a php variable

[nimonogi]

Hello,

I want to set php variable "$vatnumber" with the value "IT123456789" from the following mysql database.

Table: invoicedata
Column: customfields / Value:

a:1:{i:0;a:3:{s:2:"id";s:1:"7";s:9:"fieldname";s:3:"VAT";s:5:"value";s:13:"IT123456789";}}

Value "IT123456789" doesn't have always the same letters and numbers nor the same number of digits.

$vatnumber = $data["VAT"];

It's not working..

How can i do that?

Thanks!

[swa66]

Seeing more and more of this kind of what I consider abuse of databases: storing arrays in serialized form instead of using the the database to allow it to work with the data.

Did you unserialize the string back into an array ?
[php.net...]

[nimonogi]

No. I'm not sure if i can do that since my script is encoded with ioncube.