Getting data from MySql

Need to display data using php

[mvaz]

I have a database setup with some files in it; ie, html, text and graphics. I fail to understand how to create a link so these files are displayed on the browser; or could someone explain how to create a <a href> type link to display database contents. - Thanks in advance

[eelixduppy]

Welcome to WebmasterWorld!

There is a great tutorial here in our Library [webmasterworld.com] on The Basics of extracting data from MySQL using PHP [webmasterworld.com].

If you have any further questions do not hesitate to ask them here!

Good luck!

[mvaz]

Thnx eelixduppy!

Tried the suggested pages, but wasn't much help available there. If I rephrase my problem, perhaps someone might help. This is what I want PHP & MySql to achieve for me.

I am running a site which has a page for messages and wishes that our community members want me to post in there. I have a database called wishes, where the fields are msgID, sender, email, publishdate, msgFor and finally the message field.

Say someone posts a message today, and the publishdate is 20 Nov 2006, I want this particular msg to be automatically posted on 20th. I can't for the life of me get this data out of the database.

Can somebody experienced help me out with this please? Thnx a bunch!

[dreamcatcher]

SELECT * FROM table WHERE publishdate = '2006-11-20';

Assuming you are using a DATE field for the data.

dc