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 Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/5913-case-sensivity/#findComment-21155 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.