[RESOLVED] Escaping Quotation marks from DB? and displaying by date

MarkBad311

say I am populating a text field in my database and I want to have a hyperlink in the text do I:

A) write it out as follows: this great bar <a href="domain">Sherlock's</a> is in erie

😎 <a href=\"domain\">Sherlock\'s</a>

Do I need to escape all my slashes in side of the DB too?

All I want to do is display the text,

Also I would like to display only the fields from that current week

db table is: Events
and it has 4 fields

bar_name | updated | details | for_week |

name | 2006-01-01 | event details | 1
name | 2006-01-08 | event details | 2

I would like to display anything updated within one week of the actual date it is. how can I do this?

Thanks from your neighborhood Noobie!

devinemke

i assume that you are using mySQL

1) any data that you want to enter into the db should be run thru [man]addslashes[/man] before it is fed to an INSERT query. be advised that PHP can be configured to do this automatically using the magic_quotes_gpc directive in your php.ini.

SELECT * FROM Events WHERE updated BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 WEEK) AND CURDATE()

MarkBad311

Outstanding Help!!! Thank you very much I will be back later tonight I am sure! Only one thing is I am adding all of my data to the DB through a program called TurboDBAdmin. its pretty nice I ad the table, fields and their type and I go in to the TurboDBadmin and I can type it all up directly in to the DB. When it comes out of the DB I will probally have problems. What would be the proper syntax to get this data out of the DB without having the URL's Mess anything up?