Search found 12 matches

by Darragh3277
Fri Aug 01, 2008 9:51 am
Forum: Databases
Topic: Display data by date
Replies: 5
Views: 676

Re: Display data by date

You were right. That worked perfectly, thanks so much my head was killing me trying to figure the blasted thing out.

Cheers
by Darragh3277
Fri Aug 01, 2008 9:28 am
Forum: Databases
Topic: Display data by date
Replies: 5
Views: 676

Re: Display data by date

Hey thanks for the quick reply. It's almost right. This is the code I put in while($row = mysql_fetch_array($result)){     $dateTime = new DateTime($row['Date']);     $NewDate = date_format($dateTime, "d-m-Y");     if($row['Date'] != $last_date)         echo $NewDate."<br>";     ...
by Darragh3277
Fri Aug 01, 2008 8:29 am
Forum: Databases
Topic: Display data by date
Replies: 5
Views: 676

Display data by date

Hi all! Not sure this belongs here but I think it does. Ok so I have a database to store the results and dates of matches. The database is like this: HTeam HScore ATeam AScore Date I can display my data by date like this so far: 07-08-2008 Team A 12 - 3 Team B 07-07-2008 Team C 12 - 3 Team D 07-06-2...
by Darragh3277
Tue Jul 08, 2008 5:39 am
Forum: Databases
Topic: Uploading .txt or .doc files to a database.
Replies: 7
Views: 1003

Re: Uploading .txt or .doc files to a database.

Wow thanks for all the great replies! Just what I needed!

Thanks everyone and thanks jayshields I was looking for just that!
by Darragh3277
Tue Jul 01, 2008 6:19 am
Forum: Databases
Topic: Uploading .txt or .doc files to a database.
Replies: 7
Views: 1003

Re: Uploading .txt or .doc files to a database.

I'm not sure if that would work the way I want it? Could you explain how you would use it this case? Sorry i'm pretty new to php/mysql

What im essentially looking for is something like a blog. I write a story, then I upload it.
by Darragh3277
Fri Jun 27, 2008 5:46 am
Forum: Databases
Topic: Uploading .txt or .doc files to a database.
Replies: 7
Views: 1003

Uploading .txt or .doc files to a database.

Hey all, I've another question to put to ye. I'm making a website for my local sports team. Each week I will recive a match report as a .txt or .doc file. I would like to use a form to upload this data and then be able to display the contents of the file on a page. How do I do this? Is there a way t...
by Darragh3277
Fri Jun 27, 2008 5:10 am
Forum: Databases
Topic: Inserting date
Replies: 4
Views: 551

Re: Inserting date

Ah you legend!! Thanks for the help! Exactly what I was looking for! Cheers!
by Darragh3277
Thu Jun 26, 2008 5:49 am
Forum: Databases
Topic: Inserting date
Replies: 4
Views: 551

Re: Inserting date

Thanks for the reply. I am however after changing it slighty. Now instead of a plain text box for date I have 3 boxes. A drop down menu for day & month, and also a plain text field for year (YYYY). I was wondering if it were possible to do something like this: $Timestamp = strtotime($_POST[day],...
by Darragh3277
Wed Jun 25, 2008 10:57 am
Forum: Databases
Topic: Inserting date
Replies: 4
Views: 551

Inserting date

Hi all, I'm pretty sure this is a simple problem but i'm pretty new and my head is nothing but addled so any help at all is greatly appreciated. I have a database with a column date. I want to manually insert dates into it using a form and then be able to SORT BY date DESC. In my form I just have a ...
by Darragh3277
Tue Jun 24, 2008 10:35 am
Forum: Databases
Topic: Display contents of database by date.
Replies: 4
Views: 1063

Re: Display contents of database by date.

Cheers! Thats perfect thanks!
by Darragh3277
Tue Jun 24, 2008 10:17 am
Forum: Databases
Topic: Display contents of database by date.
Replies: 4
Views: 1063

Re: Display contents of database by date.

Ack! just store the date of the results in the results table, you can query and order based on that very easily: id    |    team_1    |    team_2    |    score_1    |    score_2    |    date Thanks for the quick reply! Thats how I have my table set up. It's just i'm unsure on how to dynamically upd...
by Darragh3277
Tue Jun 24, 2008 9:30 am
Forum: Databases
Topic: Display contents of database by date.
Replies: 4
Views: 1063

Display contents of database by date.

Hi all, i'm new to devnet. I've been browsing it for a while now and its helped me out with a lot of stuff in the past so i'd like to say a general thank you to everyone first. Now on to my question, i'm sorry if I can't explain it perfectly, as i'm not too sure how to describe it. I'm making websit...