[<?Wille?>]

hi.. im trying to write a forum script just so that i maby would learn something new and so that i would have one ready when some client ask for it..
no problems so far exept that when i take table names they are all with small letters.. i would like to replace the first letter with same but BIG version of it..
i mean the first letter.. not spaces ond/or numbers
anyone have the code snipped ready?


thx 4 all help
Wille

[Worm]

Originally Posted by <?Wille?>

hi.. im trying to write a forum script just so that i maby would learn something new and so that i would have one ready when some client ask for it..
no problems so far exept that when i take table names they are all with small letters.. i would like to replace the first letter with same but BIG version of it..
i mean the first letter.. not spaces ond/or numbers
anyone have the code snipped ready?


thx 4 all help
Wille

Hi !

Either I just dont know the code you are talking about or I think there is no code for changing the first letter BIG, because the MySQL Server will rename the first letter of your tablename even if you create a new table. If you try

CREATE TABLE `Errorhandling` (
`ID` int(11) NOT NULL auto_increment,
`errno` varchar(100) NOT NULL default '0',
`errtext` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

the MySQL Server will save it as `errorhandling`...

:?

[<?Wille?>]

Originally Posted by Worm

Hi !

Either I just dont know the code you are talking about or I think there is no code for changing the first letter BIG, because the MySQL Server will rename the first letter of your tablename even if you create a new table. If you try

CREATE TABLE `Errorhandling` (
`ID` int(11) NOT NULL auto_increment,
`errno` varchar(100) NOT NULL default '0',
`errtext` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

the MySQL Server will save it as `errorhandling`...

:?

actually.. i want a php code that changes the strings first letter.. the function i think should be used is "eregi_replace" but i didnt understand anything about their examples when trying to figure out the rigth arguments from php manual

[Worm]

Originally Posted by <?Wille?>

actually.. i want a php code that changes the strings first letter.. the function i think should be used is "eregi_replace" but i didnt understand anything about their examples when trying to figure out the rigth arguments from php manual

You want to change the first letter of which string ? Pls make an example...

Some code that might help you:

PHP Code:

function change_first($c_string)

{

  if(ord($c_string[0]) >= 97 || ord($c_string[0]) <= 122)

  {

    $temp = ord($c_string[0]) - 32;

    $c_string[0] = chr($temp);



    return $c_string;

  }

} 

How about this ?

[<?Wille?>]

Originally Posted by Worm

You want to change the first letter of which string ? Pls make an example...

well.. i said i was doing a forum.. so basicly a table is a thread.. or well thats my easyest logic solution.. so when im trying to list the threads i logicly use mysql_list_tables and put them in a table.. but becourse mysql renames and makes all letters small i want to replace 1st letter with the Big version.

PHP Code:

// inside a loop

// alot before

$tablename = "general discussion or something"; // not this easy in my code

// some more

// here the change before i echo it

echo("<td>$tablename</td>"); 

[Worm]

Originally Posted by <?Wille?>

well.. i said i was doing a forum.. so basicly a table is a thread.. or well thats my easyest logic solution.. so when im trying to list the threads i logicly use mysql_list_tables and put them in a table.. but becourse mysql renames and makes all letters small i want to replace 1st letter with the Big version.

PHP Code:

// inside a loop

// alot before

$tablename = "general discussion or something"; // not this easy in my code

// some more

// here the change before i echo it

echo("<td>$tablename</td>"); 

Did you have a look at the function above ?

[<?Wille?>]

Originally Posted by Worm

Did you have a look at the function above ?

no actually.. didnt notice it..

[Worm]

Originally Posted by <?Wille?>

no actually.. didnt notice it..

did it help you ?

[<?Wille?>]

so now i tryed that code.. unfortunally it didt work.. it didt change the string in any way.. then ofcourse just so that it would not be too easy for you who try to help me the code im looking for should also be able to change scandinavian letters å ä ö (&aring; &auml; &ouml; in html if someone would need them)

[<?Wille?>]

stupid me.. ofcourse it doesint do anything when i dont call the function..
we are doing some progress..
so this is the code right now:

PHP Code:

if(ord($tab) >= 97 && ord($tab) <= 122) { // must be && not ||.. its always one of them

    $temp = ord($tab) - 32; 

    $tab = chr($temp); 

} 

but... problem is.. table name is "general talk" but now i get only "G"..
suggestions?