Jump to content

Archived

This topic is now archived and is closed to further replies.

Seamless

Case Sensivity

Recommended Posts

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 advance

Seamless

Share this post


Link to post
Share on other sites
I can't see anythig in your PHP or MySql code that would have any effect on case. What about your stylesheet definitions?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.