[PHP-DB] PHP: Good for articles?

2001-03-08 Thread Dan Eskildsen
Hi everyone. I am a freelance html web designer - and I am new at it. I have also learnt Javascript. I have a customer - a local newspaper - who wants me to update their site weekly with newspaper articles. I have been doing this in html. I recently changed ISP - and my new ISP allows me to r

[PHP-DB] Where do I get started?

2001-03-08 Thread Dan Eskildsen
ta, adding field data, and even creating a new database > from a web front end. > > Chad > > -Original Message- > From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 08, 2001 5:35 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP: Good for articl

[PHP-DB] SSI and PHP?

2001-03-10 Thread Dan Eskildsen
Hi there, Can anyone tell me if it is possible to combine Server Side Includes with PHP? If not, is there a work around? Please cc your comments to [EMAIL PROTECTED] I would like everyone who commented on my queries the last couple of days. I went from not knowing a single thing about PHP and

Re: [PHP-DB] SSI and PHP?

2001-03-10 Thread Dan Eskildsen
I meant: I would like to THANK everyone who commented on my queries the last couple of days. ""Dan Eskildsen"" <[EMAIL PROTECTED]> skrev i en meddelelse 98cvq8$7dr$[EMAIL PROTECTED]">news:98cvq8$7dr$[EMAIL PROTECTED]... > Hi there, > > Can anyone

[PHP-DB] Storing character returns

2001-03-12 Thread Dan Eskildsen
I store newspaper articles into a MySQL database. The text that I insert (via phpwizard.net) contains a little formatting: line returns to separate paragraph, but when I suck the data out again to display it all the character returns vanish. Any ideas? Please cc comments to [EMAIL PROTECTED]

[PHP-DB] document.referrer in php?

2001-03-12 Thread Dan Eskildsen
Are the following javascript variables avaliable in php? I searched for this on www.php.net but could not find any references. document.referrer window.location I would appreciate your help. Please cc comments to [EMAIL PROTECTED] Regards, Dan -- PHP Database Mailing List (http://www.php.

[PHP-DB] No. of Users online right now?

2001-03-20 Thread Dan Eskildsen
Hi there, This is a NewBie Question: While out surfing I have often seen a message like: "There are 17 users on this site at the moment." Can I do this with php? Just to show how many people are on (browsing) the site at that moment? I run a community website. Thanks ===

[PHP-DB] file name extentions

2001-03-24 Thread Dan Eskildsen
Hi there, Currently my ISP has PHP 3 installed and to run php scripts I have to save the file as name.php3 I expect to install my own server and php4 in the foreseeable future - how can I save the files as .php so that they are upwardly compatible? I have tired using the filenmae file.php but t

[PHP-DB] mysql/php select using date in where clause

2001-05-03 Thread Dan Eskildsen
***NEWBIE ALERT*** (I am only very new at this) PHP and MySQL OK - I have a table with data and one of the fields is a Date field. Now I would like to SELECT all records where the date is less that 45 days old. Eh, How do I do that? I have tried this: #Declaring variables $today=date("Y-m-d

Re: [PHP-DB] mysql/php select using date in where clause

2001-05-03 Thread Dan Eskildsen
AND > > TO_DAYS(NOW()) - TO_DAYS(date_column) <= '45' > > where date_column contains record dates... > > Martin > > > > ""Dan Eskildsen"" <[EMAIL PROTECTED]> wrote in message > 9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAI

[PHP-DB] Newbie: IF statement

2001-05-14 Thread Dan Eskildsen
MAJOR NEWBIE ALERT! I can't believe this! I can't even work out an IF statement! My page contains a search string (eg: page.php3?Page=products ) If the URL does not contain a search string (ie page.php3) then I want to assign the Page variable to 'homepage". I have tried these if statements,

[PHP-DB] Pick a row, any row.

2001-05-17 Thread Dan Eskildsen
Newbie alert! Hi. Just a qucik question: Does anyone know of a random function that I can use. I want to query my database. Then random pick one of the rows in the result, and then display the contents of the randomly picked row. How can I pick a random row? Thank you in advance. --

[PHP-DB] Random - not that random

2001-05-17 Thread Dan Eskildsen
Newbie alert Hi! Here is a piece of coding. It randomly choose between four options to display on my homepage. The problem is that it doesn't seem to be that random - rather biased. The last option $message[3] is displayed 9 out of 10 times. Any suggestions? $message[0] = '[PHP-DB] How do I backup my MySQL database? asks a Newbie.
*** NEWBIE ALERT! *** I am only new at this, but I have discovered one thing: I love php and mysql! I now have a couple of tables of information in a MySQL database. The site is run by my ISP so I don't have control of the server. My question is: how do I via php/mysql