Break Apart Text 2

[dagger2002]

ok i have a question.

How do i break apart text.

I have a 4 digit code (YYMM) and want to be able to display it as

0601 = January 2006
0602 = February 2006

and so on.

What do i use to do this?

Thanks alot in advanced

 

[jpadie]

would you not get the result you are looking for by changing your query?

$queryRt ="		
			SELECT DISTINCT 
				sto_date 
			FROM `stories` 
			WHERE 
				`sto_artType` = '3' 
			AND 
				`newsIss` != " . $rowMain['newsIss'] . " 
			AND `
				sto_include` = '1' 
			LIMIT 0 , 30";

 

[dagger2002]

Im trying to sort by iss, which stands for issues, its just not playing nice. and i need more then just the date unfortunately.

 

[jpadie]

why? why not just add the order by clause?

anyway the reason why distinct is not working for you is that you are including the primary key (and perhaps other row-unique data) and so there will never be two rows that are equal.

so you may be able to achieve the DISTINCT(ion) [sorry] you want by limiting the columns that you ask for in the Select clause (which is best practice anyway)

 

[sleipnir214]

dagger2002:

so im not sure y they put the global statement in there.

Take it out. It doesn't do anything.

Read the PHP online manual section on Variable Scope:

http://www.php.net/manual/en/language.variables.scope.php

Want the best answers? Ask the best questions! TANSTAAFL!

 

[dagger2002]

Tahnk you jpadie and sleipnir for all of the help. I now have the distinct working correctly. This also fixes another problem that i had posted a month ago in the mysql forum.

Thank you both.

I have given u both a star for the help.

Thanks again