results view

[ctcp]

<?php
$results = mysql_query("select * from crackz where `option` = 'Yes' and type = 'games' and  name like '".chr($numbs)."%' ORDER BY date DESC LIMIT $page, $limit");
while ($data = mysql_fetch_array($results))
{
?>
<li>[<?=$data["type"]?>] [<?=$data["date"]?>] <a href="?section=view&id=<?=$data["id"]?>&type=<?=$type?>" title="<?=$data["name"]?>"><?=$data["name"]?></a> </li>

this work fine but if my record start from space not work..

i mean  (mplampla) work

          ( mplampla) not work

how to fix this ?

 

[ctcp]

im view results by   

    * A

    * B

    * C

    * D

    * E

    * F

    * G

    * H

    * I

if you not understant

 

[ctcp]

help

[MatthewJ]

trim the spaces from the names... data should not start with a space

[MatthewJ]

You could do that with

$results = mysql_query("select * from crackz where `option` = 'Yes' and type = 'games' and  LTRIM(name) like '".chr($numbs)."%' ORDER BY date DESC LIMIT $page, $limit");

[ctcp]

thank you mate :-)

 

[MatthewJ]

No problem at all.