Forum Moderators: coopster

Message Too Old, No Replies

how to get starting from words

how to get starting from words

         

siddiq ijiff

8:33 pm on Nov 5, 2007 (gmt 0)

10+ Year Member



how to get starting from words using php
i want to show all the words which are in mysql and starting from a how i can show?

PHP_Chimp

9:38 pm on Nov 5, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Check out the mysql [uk3.php.net] functions.
There is an example on that page that shows you linking to and getting a query back from the database.

siddiq ijiff

11:15 am on Nov 6, 2007 (gmt 0)

10+ Year Member



i am unable to understand... :(

Habtom

11:19 am on Nov 6, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If I understand you correctly, you want to find out the words starting with a certain character.

If that is the case, your query should look like the following:

mysql_query("SELECT * FROM table1 WHERE field1 LIKE 'A%'");

Habtom

[edited by: Habtom at 11:19 am (utc) on Nov. 6, 2007]

PHP_Chimp

12:18 pm on Nov 6, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Have a look at <snip> as it has an easy to follow example for using the LIKE keyword.

I didnt include it as a link as im not sure if they actually fit within the charter.

Or there is [dev.mysql.com...] as it has some examples

[edited by: PHP_Chimp at 12:36 pm (utc) on Nov. 6, 2007]

[edited by: dreamcatcher at 4:21 pm (utc) on Nov. 6, 2007]
[edit reason] no urls as per T.O.S [webmasterworld.com].Thanks [/edit]

siddiq ijiff

4:06 pm on Nov 6, 2007 (gmt 0)

10+ Year Member



Habtom you are rite i want this, let me check code :D

siddiq ijiff

4:10 pm on Nov 6, 2007 (gmt 0)

10+ Year Member



thanks Habtom :)