substr

[Destramic]

what im trying to d is substr a table name just to get the fisrt character so i can use it as an AS...example

 

FROM news AS n

 

$table = "news";
$as      = substr($table, 0, 1);

 

sigular named tables are fine...but if the table is named something like this news_comments and have many underscores i want it to return nc...what is the best way to achieve this please?

[Porl123]

<?php
$table = "news";
$chars = str_split($table);
echo $chars[0];

[Destramic]

it doesnt work if you do this

 

		$table = "news_comments";
$chars = str_split($table);
echo $chars[0];

 

i want it to return NC...the code i written above does the same as yours really

[Porl123]

$table = "news_comments";
$split = explode('_',$table);
$c = '';
foreach($split as $word)
{
$s = str_split($word);
$c .= $s[0];
}
echo $c;

[Destramic]

that works great thank you