Some functions...

[Anon]

Hi, i dont know much in php
- i want to make a random selection from mysql

• i wan to show only the first 100 chars from a mysql row

thanks!! please help me!

[jburfield]

Do you mean the first 100 characters from one of the fields in your database? If so, just to something like this:

query = "SELECT substring(FIELD, 1, 100)"

That will select the first 100 characters from the field FIELD in your database.

If you want to select something as random do something like this:

query = "SELECT FIELD from table order by rand()"

-- Jason