Show only results that start with "A"

Here's what I am trying to do, I am trying to display the $query but I only want to display the $query's that begin with the letter "A"

Can someone tell me if this is possible and if so how can I do this? Thank you very much in advance.

 

Change the SQL to

SELECT * FROM `searchtable` [B]WHERE query like 'a%'[/B] ORDER BY `query` ASC

Code (markup):

 

SWEEEEEEEEEEEEEEET Thank so much man, I love this forum, i think you guys are the best, (shouldn't mean much but o'well) but still thanks so much man can't tell you how greatful I am thanks again WOW !

 

Yooooouuuuuuuur welcome

 

Sorry, one more question, what if I wanted to do, lets say... XYZ like 3 letters instead of one, thanks in advance

 

Change the SQL to

Change the SQL to

SELECT * FROM `searchtable` 
[B]WHERE query like 'x%' OR query like 'y%' OR query like 'z%'[/B] 
ORDER BY `query` ASC

Code (markup):

 

Thanks so much, I am still having a problem, theres to many results per page, is there anyway to split them into like 100 per page, I am kind of new to php.

 

You will need to use the limit clause
e.g.

SELECT * FROM `searchtable` 
WHERE query like 'x%' OR query like 'y%' OR query like 'z%' 
ORDER BY `query` ASC
[B]LIMIT 10, 5[/B]

Code (markup):

This would return 5 rows starting from position 10.

 

Ok thanks so much, what I was trying to do was like this site here: h**p://www.edcomp.com/sitemap.aspx did but I am guessing that's more complicated then I think since there like different pages and stuff, thanks for all your help.

 

You can do that with what I've posted, it's fairly simple to do you will just need to pass the letter and page number on the URL and then build the SQL from those parameters. If you experiment a bit I'm sure you'll get there and if yet get stuck feel free to post more questions here.

 

Ok, I did this right now:

<?php

$dbase['host'] = 'localhost';
$dbase['user'] = 'pgn_SEARCH';
$dbase['pass'] = '***';
$dbase['name'] = 'pgn_SEARCH';

$dblink = mysql_connect($dbase['host'], $dbase['user'],$dbase['pass']);
mysql_select_db($dbase['name'], $dblink);

//Now for the displaying stuff
$getit = mysql_query("SELECT * FROM `searchtable` ORDER BY `time` desc LIMIT 2, 10") or die(mysql_error());
while($get = mysql_fetch_array($getit))
{
$query = $get['query'];
$query = str_replace(" ", "-", $query);
$query = str_replace("?", "-", $query);
$query = str_replace("#", "-", $query);
$query = str_replace("}", "-", $query);
$query = str_replace("{", "-", $query);
$query = str_replace("%", "-", $query);
$query2 = $get['query'];
$time = $get['time'];
$ftime = $get['ftime'];
echo("<p><font size=-1><A href='/e-$query.htm'>$query2</a></font></P>");
}
?>

now what do I do, whats pass the letter and page number on the url then build the sql to those perameters means, I really want to do this I hope you'll help me I know I am dumb I am just 16 and starting but I am really learning quick (Thanks to you and other helpful members here )

 

On the URL you need to pass the letter and page no, so the URL would look like

links.php?letter=a&page=4

Code (markup):

Which would mean you want to look at page 4 of the letter As. Then in the code do something like

$Letter = $_GET['letter'];
$Page = $_GET['page'];

$ListingsPerPage = 5;

$lStartRow = ($Page - 1) * $ListingsPerPage;

$lSQL = "SELECT * FROM `searchtable` 
WHERE query like '$Letter%'
ORDER BY `query` ASC
LIMIT $lStartRow, $ListingsPerPage";

PHP:

I've not tested this but it should give you the general idea.

 

I did this:

<?php

$dbase['host'] = 'localhost';
$dbase['user'] = 'pgn_SEARCH';
$dbase['pass'] = '***';
$dbase['name'] = 'pgn_SEARCH';

$dblink = mysql_connect($dbase['host'], $dbase['user'],$dbase['pass']);
mysql_select_db($dbase['name'], $dblink);

//Now for the displaying stuff
$Letter = $_GET['letter'];
$Page = $_GET['page'];

$ListingsPerPage = 5;

$lStartRow = ($Page - 1) * $ListingsPerPage;

$lSQL = "SELECT * FROM `searchtable`
WHERE query like '$Letter%'
ORDER BY `query` ASC
LIMIT $lStartRow, $ListingsPerPage";

{
$query = $get['query'];
$query = str_replace(" ", "-", $query);
$query = str_replace("?", "-", $query);
$query = str_replace("#", "-", $query);
$query = str_replace("}", "-", $query);
$query = str_replace("{", "-", $query);
$query = str_replace("%", "-", $query);
$query2 = $get['query'];
$time = $get['time'];
$ftime = $get['ftime'];
echo("<font size=-1><A href='/e-$query.htm'>$query2</a></font> ");
}


?>

But I am not getting any results when I use links.php?letter=a&page=1 just a white page, I should be getting apple and a couple other words with a as results, did I do something wrong? By the way, thanks so much for taking the time to help me, I really do appreciate it.

 

echo out the SQL that is generated and post it here.

 

It's 5:15 AM my mom just woke up and is yelling at me I got to go I will be back tomarrow morning, thanks so much for all your help, I really do appreciate it, if you find out whats wrong please tell me I would be extremely greatful.

Thank you again.

 

not sure what echo out means

 

hmmm, you already use it in your code. Just do

echo $lSQL;

PHP:

 

Man I am such a dumbass and I feel like I am frustrating you, I still don't know what your asking, I'm sorry if I am a dumbass I know how frustrating it must be for you



I typed

<?php

$dbase['host'] = 'localhost';
$dbase['user'] = 'pgn_SEARCH';
$dbase['pass'] = '***;
$dbase['name'] = 'pgn_SEARCH';

$dblink = mysql_connect($dbase['host'], $dbase['user'],$dbase['pass']);
mysql_select_db($dbase['name'], $dblink);

echo $lSQL;


?>

in there is that what u were asking, i just see blank page

 

You missed the

$lSQL = "SELECT * FROM `searchtable`
WHERE query like '$Letter%'
ORDER BY `query` ASC
LIMIT $lStartRow, $ListingsPerPage"; 

PHP:

Do

<?php

$dbase['host'] = 'localhost';
$dbase['user'] = 'pgn_SEARCH';
$dbase['pass'] = '***';
$dbase['name'] = 'pgn_SEARCH';

$dblink = mysql_connect($dbase['host'], $dbase['user'],$dbase['pass']);
mysql_select_db($dbase['name'], $dblink);

//Now for the displaying stuff
$Letter = $_GET['letter'];
$Page = $_GET['page'];

$ListingsPerPage = 5;

$lStartRow = ($Page - 1) * $ListingsPerPage;

$lSQL = "SELECT * FROM `searchtable`
WHERE query like '$Letter%'
ORDER BY `query` ASC
LIMIT $lStartRow, $ListingsPerPage"; 

echo $lSQL;

PHP:

 

thats all i see on the page

Full code as of now: