two questions in one

viveleroi0

Say I have the following string:

|VI:Metal|CZ:Glass

I do a search using

SELECT * FROM Products WHERE SubCat Like "%VI%

How can I extract everything between each | and :, like get the VI out of |VI:, the CZ out of |CZ: ?

Then, I would need to translate those values into words, like VI=Victorian. If I have something that VI-Victorian, I need a to translate VI into the new value Victorian.

How would I do that?

Option

$split1 = explode('|', '|VI:Metal|CZ:Glass');

//would return...

   $split1[0] -> 'VI:Metal'
   $split1[1] -> 'CZ:Glass'

//then

   $split2 = explode(':', $split1[0]);

//would return...

   $split2[0] -> 'VI'
   $split2[1] -> 'Metal'

Hope this helps you
Jonny

viveleroi0

Thanks, but the string will change for each listing in the database. I won't be able to use the VI letters each time.

batman

Then you could try something like this:

//your sql query
$sql = mysql_query("SELECT * FROM table");
$results = mysql_fetch_array($sql);
foreach($results as $row)
{
$split1 = explode('|', $row); 
$split2 = explode(':', $split1); 
}

Option

sorry viveleroi0, i didnt know how much information you needed. sometimes... if you know that you need almost the full answer for a question.. just tell us... people wont mid if you are learning... it is when people can't be BOTHERED that we get annoyed. 🙂

Thanks
Jonny

Weedpacket

Originally posted by Option
sorry viveleroi0, i didnt know how much information you needed. sometimes... if you know that you need almost the full answer for a question.. just tell us... people wont mid if you are learning... it is when people can't be BOTHERED that we get annoyed. 🙂

Thanks
Jonny

Funny, I don't even see where your code does use "VI"...

batman

Originally posted by Weedpacket

Funny, I don't even see where your code does use "VI"...

It's not in the code. It's one of things he want's to explode out of the results. 🙂