At 12:22 AM 9/30/2005, Ng Hwee Hwee wrote:
Hi guys,
this looks like a very simple problem but i really have no idea how to do
it.. please help me! thanks!
my MySQL database has a table of which 2 fields are as follow
T100FieldNmT100Value
== =
vehMdlCd[0]
Are you sure you even want to be storing it that way? What happens when
you delete the following row? Do you have to re-index each column?
There's no (trivially) easy way to do that with an update statement as
it stands.
vehMdlCd[1] LEX
You're likely better off storing it simply as
Is it possible for you to store the vehMdlCd array as a serialized field in
your database?
I'm not sure how your data is structured, but you would serialize() your
data on the way into the db then unserialize() it when you select it. When
it's unserialized, you'll get it back in the original array
