You may want to revisit your db design, but if it is like that for reason
then it is simple enough to associate these items with each other in an
array.
Just put together a query then get the row and split it by the commas then
put it into an array as follows.
$ar = Array('small' => '1.99', 'medium' => '2.99', 'large' => '3,99');
Then you can access these values by the following.
$smvalue = $ar['small']
This example is a simple array, if you had a lot of products you could use a
multi dimensional array like this.
$ar = Array( 'hotdogs' => Array('small' => '1.99', 'medium' => '2.99',
'large' => '3,99'),
'burgers' => Array('small' => '2.99', 'medium' => '4.99',
'large' => '6,99'))
Then access them like this
$smallburger = $ar['burger']['small']
Hope this helps.
Simon
-----Original Message-----
From: David Robley [mailto:robleyd@paradise.net.nz]
Sent: 8 October 2002 06:49
To: php-db@lists.php.net
Subject: Re: Array help needed :-(
In article <000801c26e10$a2128510$f7fea8c0@chris>, chris@planetoxygene.com
says...
> Hi there everyone,
>
> I have a problem i'm trying to figure out but i'm not too good with
> arrays, just know the basics, if anyone could help me out on this it
> would be wonderful :-)
>
> I have two sets of data in columns of a MySQL DB, these items are size
> and price.
>
> Size is seperate by comma's in the first column, and I have it split
> into a dropdown box no problem to read (For example):
>
> small
> medium
> large
>
> but then I have a price field, which contains 1.99,2.99,3.99 etc .....
> what I need to do is when someone selects an item from the dropdown -
> say small as an example, it would know how to get 1.99 from the price
> entry in the DB. I guess what I need to do is somehow associate each
> entry in the price field with those in the size, but I have no idea
> how to do it :-(
>
> Any help would be really appreciated as this stumps the hell out of
> me.
>
> Thanks
>
> Chris
I think you may have a problem with your database design? Can you explain
a little more exactly what it is you are trying to do and perhaps someone
can advise on how your data might best be structured.
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
