Click to See Complete Forum and Search --> : display a certain record only from mysql database


TAV3RN
03-12-2009, 07:03 AM
Hi

I would like to know how to display a certain record from my sql result.

Say i have SELECT * FROM tbl

which brings back

title:

title 1
title_2
title_3
title_4

i would like to be able to display at the top of the page title_1 and then further on in the page title_3 and then ignore the other 2 records.

I was thinking about putting these results into an array but i cant seem to get it to work.

Any help is much appreciated.

Thanks

TAV3RN

Kuriyama
03-13-2009, 11:01 AM
Fix this with a better SQL statement.

What is different between title_1 and 3 and title_2 and 4?

TAV3RN
03-13-2009, 11:06 AM
Thanks for your response,

~I have solved the problem though by flagging records with a new column allowing for me to select them and display them wherever i want on a page.

Not sure if this explains what i done but the problem was pretty much just a client being picky where they want content placed.

Thanks anyway.

TAV3RN