[PHP-DB] RE: Displaying a single picture...

2002-11-12 Thread Jonathan Narong
not sure i understand why you would need to use a php script for this? why not just use a static html tag, if all you're doing is opening the picture in a new window? -jon -Original Message- From: Brett Lathrope [mailto:brett@;lathrope.com] Sent: Tuesday, November 12, 2002 1:44 PM To: [E

[PHP-DB] RE: date questions in mySql

2002-11-12 Thread Jonathan Narong
yes, you need to insert the date as -mm-dd. you can go around this and still have the user see a form field with mm/dd/ but you need to break each part down, and play with the string functions so the final mysql query is in -mm-dd. -jon -Original Message- From: Paul Ihrig [mai

[PHP-DB] checking for 0 results?

2002-11-15 Thread Jonathan Narong
maybe i'm totally not thinking straight right now, but is there a way in php to check if 0 results are returned in a mysql query? for example, i have a definition database, that has a list of letters the user clicks on (click on the letter, and all the terms for that letter pop up).. but for some

[PHP-DB] creating a new mysql automatically every day?

2002-11-18 Thread Jonathan Narong
i'm currently building a traffic analysis application for a website. it is my first time working on such a project, so i'm not even sure if this would be the best way to do it all, but here it goes. what i would like to do is count the number of hits that go to different sections of the site. i ca

RE: [PHP-DB] creating a new mysql automatically every day?

2002-11-18 Thread Jonathan Narong
John, That is good advice. I wasn't aware of indexes/keys slowing down inserts. Whats the best way to copy a table over to another table though? -jon -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 5:36 PM To: 'Jonathan Naron

[PHP-DB] regarding multiple joins

2002-11-22 Thread Jonathan Narong
this is a problem i've been struggling with for a little while. any attempt to find help online has not produced any useful information. this is regarding joins, which i'm not an expert in, but hopefully one of you can help me out. i have an table 'articles' which has multiple fields, such as auth

[PHP-DB] RE: inserting html into mysql tables

2002-11-22 Thread Jonathan Narong
5k of data is way too much for varchar, so i would use a field of type TEXT. i do this as well (storing html data in mysql) and it works great. some say to use addslashes() although, on my setup (3.23/4.1) it seems to addslashes automatically - not sure exactly why that is though. -Original Me

[PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
ther complex JOIN but i'm not sure how it looks exactly. any help would be appreciated. thank you very much. -jon -Original Message- From: David Elliott [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:18 AM To: Jonathan Narong on PHP-DB Subject: Re: regarding multiple

RE: [PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
that worked perfectly! thank you so much! -jon -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 6:08 PM To: Jonathan Narong; David Elliott; Jonathan Narong on PHP-DB Subject: Re: [PHP-DB] RE: regarding multiple joins At 05:26 PM 11/22/02