[SOLVED] Select something if the first character is X

[papaface]

Hello,

How can I select a record or records from a database by the first letter of the "title" field?

e.g

I want to find all titles that begin with the letter L

regards

[redarrow]

try this ok

 

SELECT * FROM table ORDER BY FIELD( field_name, 'L' )

[saf]

Try this:

 

SELECT * FROM `database` WHERE `title` LIKE `L%`;

[papaface]

I tried:

mysql_query("SELECT * FROM videos WHERE title LIKE `".mysql_real_escape_string($_GET['l'])."%` ORDER BY title ASC");

$_GET['l'] is M

 

But it doesnt work...

[papaface]

oops it did. But I got this error when I changed it slightly to:

mysql_query("SELECT * FROM videos WHERE category='".$category."' AND title LIKE `".mysql_real_escape_string($_GET['l'])."%` ORDER BY title ASC");

error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[dough boy]

Not sure but it doesn't appear the ' around the mysql_real_escape_string function are the correct 's;

 

You should also echo the sql and try running it manually in the database to see what the error is.

[papaface]

I tried:

mysql_query("SELECT * FROM videos WHERE category='".$category."' `title` LIKE '".mysql_real_escape_string($_GET['l'])."%' ORDER BY title ASC");

 

still doesnt work

[redarrow]

$x=mysql_real_escape_string($_GET['l']);
mysql_query("SELECT * FROM videos WHERE category='".$category."' `title` LIKE '".$x."%' ORDER BY title ASC");

 

 

 

[papaface]

Got it working.

Thanks

[redarrow]

post ur  result for us all and press solved lol