How can I select multiple mysql colombs with LEFT command.

[DiscoTrio]

I need to make a preview of items in a table so that I have a row called 'title' a row call 'content' limited to 100 characters and only show 3.  Here is what I have:

 

sql_query("SELECT LEFT (content, 100) FROM snews WHERE id = 1 LIMIT 0, 3");

 

My problem is (as you can see) I am only selecting 'content' I just want to select the whole table(or 3 field, whatever is easier).

[kickstart]

Hi

 

Just specify the column name(s)

 

sql_query("SELECT title, LEFT (content, 100) FROM snews WHERE id = 1 LIMIT 0, 3");

 

You can use a * instead of specifying the column names but this isn't really recommended for maintenance reasons.

 

All the best

 

Keith

[fenway]

So? Use * or specify the fields you want... what doesn't work?

[DiscoTrio]

Easier then I thought.... thanx.