Rob (SA) Posted June 6, 2010 Share Posted June 6, 2010 Hi folks,For those that know they can sure help.I have a script that places text form MySQL into a table, however I would like to view the table in capital letters.I am also led to believe the choice would be to incorporate "strtoupper" somehwere in my script.My script looks like this currently echo '<tr><td bgcolor="#FFFFFF"><font style="font-size:10px" color="#00008B" face="Arial">';echo '<option value="'.$row['surname'].', '.$row['name'].'">'.$row['surname'].', '.$row['name'].'</option>'; Your advise here would be most welcome Link to comment Share on other sites More sharing options...
jeffman Posted June 6, 2010 Share Posted June 6, 2010 That would work. Read about it here. It would look something like this: strtoupper($row['surname'])You can also change the case as part of your SQL query. Look here. Link to comment Share on other sites More sharing options...
dsonesuk Posted June 6, 2010 Share Posted June 6, 2010 echo '<option value="'.strtoupper($row['surname']).', '.strtoupper($row['name']).'">'.strtoupper($row['surname']).', '.strtoupper($row['name']).'</option>';hi rob, question: you wouldn't happen to live near "Elspark, Germiston" area? Link to comment Share on other sites More sharing options...
Rob (SA) Posted June 6, 2010 Author Share Posted June 6, 2010 Hi,Elspark is South from where I stay.Approximatly 50kmDriving distance echo '<option value="'.strtoupper($row['surname']).', '.strtoupper($row['name']).'">'.strtoupper($row['surname']).', '.strtoupper($row['name']).'</option>';hi rob, question: you wouldn't happen to live near "Elspark, Germiston" area? Link to comment Share on other sites More sharing options...
Rob (SA) Posted June 6, 2010 Author Share Posted June 6, 2010 Thanks guys for the prompt replies.It works for me. Hi,Elspark is South from where I stay.Approximatly 50kmDriving distance Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.