You were right. That worked perfectly, thanks so much my head was killing me trying to figure the blasted thing out.
Cheers
Search found 12 matches
- Fri Aug 01, 2008 9:51 am
- Forum: Databases
- Topic: Display data by date
- Replies: 5
- Views: 676
- 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>"; ...
- 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...
- 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!
Thanks everyone and thanks jayshields I was looking for just that!
- 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.
What im essentially looking for is something like a blog. I write a story, then I upload it.
- 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...
- 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!
- 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],...
- 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 ...
- 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!
- 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...
- 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...