Displaying certain things from database

bsmaff

I am currently designing a web site and need help.

I need to get information out of a certain field of a database to show on a page.

As I need to get on a webpage the events in date order and only events within the next 2 weeks to be shown.

Fox1337

This is easy enough, but without information on your database layout, it's a guess in the dark.

To display a certain field of a database, you just need an SQL query like this:

$sql = "SELECT `field` FROM `table`";

If you wanted to sort it by date, assuming the column for storing the date is called something like 'timestamp', you would just use the ORDER BY parameter:

$sql = "SELECT `field` FROM `table` ORDER BY `timestamp` DESC";

That would sort it descending (DESC), as opposed to ascending (ASC). This generally means the newest one will be shown first, and the oldest one last.

As for your last question, grabbing events within the next two weeks, it's just a matter of math.

Assuming you're storing the time of the even with a timestamp, it makes everything easy.

You can get the timestamp of the current time using the following:

$now = time();

That's the basis for your calculation. From there, you need to figure out how many seconds (Since the timestamps go by seconds) are in two weeks.

Simple enough: 60602414. SecondsMinutesHoursDays. That leaves you with an end result of 1209600.

Knowing this, it's just a factor of combining those two numbers to grab the threshold, then using the SQL queries to grab anything under that threshold:

<?
$now = time();
$then = ($now+1209600);
$sql = "SELECT `field` FROM `table` WHERE `timestamp`<'$then' ORDER BY `timestamp` DESC";
?>

Something like that should work.

jkurrle

Fox1337 provided the select string, now you have to use it in your database.

Basically, you do the following:
1) Create a connection to the database server
2) Select the database
3) Run Fox's query, filling in your information where necessary
4) Close the database
5) Take the array of results, run it through a loop, (like a while loop) and process the rows one at a time.
6) When processing each row, you will probably extract the data of the row, then display it.

That's the code basics. Good luck.

Roger_Ramjet

jkurrle wrote:
Fox1337 provided the select string, now you have to use it in your database.

Basically, you do the following:
1) Create a connection to the database server
2) Select the database
3) Run Fox's query, filling in your information where necessary
4) Close the database
5) Take the array of results, run it through a loop, (like a while loop) and process the rows one at a time.
6) When processing each row, you will probably extract the data of the row, then display it.

That's the code basics. Good luck.

Slight problem there mate, if you close the connection before you process the results you loose them.