Seamless Posted March 27, 2006 Share Posted March 27, 2006 I do apologise if this has been covered before...I'm retrieving some results from a mysql database and i'm using mysql_fetch_array() everything works fine..Apart from the results are not case sensitive, i've checked the database using phpMyAdmin and the values stored ARE case sensitive what am i doing wrong?here's a peice of code as an example[code]<?$sql = "SELECT * FROM table ORDER BY signup_date DESC LIMIT 5";$result = mysql_query($sql) or die ("ERROR: ".mysql_error()." with query: $sql"); while($row = mysql_fetch_array($result)){ echo "<tr> <td class='profile_name'> <p><a href='user-profile.php?username=$row[username]'>$row[username]</a></p> </td>";// Format date $signup_date = date('d-m-y', strtotime($row[signup_date])); echo "<td class='signup_date'> <p>$signup_date</p> </td> </tr>"; }?>[/code]Thanks in advanceSeamless Link to comment https://forums.phpfreaks.com/topic/5913-case-sensivity/ Share on other sites More sharing options...
Barand Posted March 27, 2006 Share Posted March 27, 2006 I can't see anythig in your PHP or MySql code that would have any effect on case. What about your stylesheet definitions? Link to comment https://forums.phpfreaks.com/topic/5913-case-sensivity/#findComment-21155 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.