[PHP-DB] Date format in MySQL

Hi All, I have a date format of -MM-DD in MySQL and am showing it on a PHP page. However I want to show it as 2 February, 2003 or 2 February Can someone please help me. The date will not necessarily be todays date (I looked at the datetime() function and the getdate() function but

RE: [PHP-DB] COPY files = Warning permission denyed

Hi , I had this problem too so... Say it is your pics directory that you want to upload to, I use Leech FTP for my uploads, right click on the pics directory goto Set Attributes and set it to 777. This is not very good practice, but since I don't have the sites live it does'nt matter too much

RE: [PHP-DB] I need a User Authentication solution

http://www.phpsecurepages.f2s.com/ I have tried this and it works great. I am very much a beginner so you shouldn't have any problems, just read the README file thoroughly. All the Best Lisa -Original Message- From: David Coleman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001

[PHP-DB] Password Protect page

Hi All, I have an Admin section for my site (where users fill in web forms and it changes the site and upload facility for images) and would like a script that does a User Logon page. Password is enough. I have created a TABLE in my mySQL database called bw_password with two fields id and

[PHP-DB] Password Protect page

Hi All, I have an Admin section for my site (where users fill in web forms and it changes the site and upload facility for images) and would like a script that does a User Logon page. Password is enough. I have created a TABLE in my mySQL database called bw_password with two fields id and

RE: [PHP-DB] Data errors in entering

I am only a beginner but I always use single quotes, I am using mySQL. Such as: $sql = INSERT INTO $table_name (day, daydate, month, year, time, place, numbers, details, reportby) VALUES ('$day', '$daydate', 'month', 'year', '$time', '$place','$numbers','$details', '$reportby');

RE: [PHP-DB] MySQL Connect Problem

Hi Jeff, I am using Windows, but am a beginner. Here is some code I use maybe it will help I use this in my navigation pages: ? include (db_details.php); ? ? mysql_pconnect($host,$user,$password) or die(Unable to connect to SQL server); mysql_select_db($dbasename) or die(Unable to select

RE: [PHP-DB] Convertin Asp to Php

Hi Tobbe, I haven't used it and I am only a beginner at this stuff, but there is a product called Code Charge www.codecharge.com. It is available for download for a trial period. It may be useful. I don't know of any other possibility, other than re-writing the logic. Although from using PHP and

RE: RE: [PHP-DB] Robust OO Shopping Cart 4 sale -ohmygod

My sentiments exactly - go find a PHP chat room to argue in!! Lisa -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 1:00 PM To: Steve Brett Cc: [EMAIL PROTECTED]; Rick St Jean Subject: Re: RE: [PHP-DB] Robust OO Shopping Cart 4 sale -ohmygod

RE: [PHP-DB] duplicate a table

I installed mySQLFront and it can do the same thing too through a GUI. You save a *.sql file with or without data. All the Best Lisa -Original Message- From: Johannes Janson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB]

RE: [PHP-DB] CSS versus Includes

Hi there, you can also do it this way using Javascript script if (navigator.appName == "Netscape") { StyleSheet = "netstyle.css" } else { StyleSheet = "iestyle.css" } /script

RE: [PHP-DB] Keeping Variables

form method="post" action="?php echo $PHP_SELF?" I use this in forms to submit something to the same page and then do something like if($submit){ do this } Hope it helps Lisa -Original Message- From: Chris Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 9:13 AM To:

RE: [PHP-DB] Re: Record Numbering - was SELECT MAX(ID) PLUS 1

Thanks Steve, I will go back to using separate tables - Thanks Lisa -Original Message- From: Steve Farmer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 12:12 PM To: Rubanowicz, Lisa; [EMAIL PROTECTED] Subject: [PHP-DB] Re: Record Numbering - was SELECT MAX(ID) PLUS 1 Hi

RE: [PHP-DB] MySQL manager

www.mysqlfront.de I have used it and found it to be great. However I am a beginner and if there is a better product please let me know. All the best Lisa -Original Message- From: Rosen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 3:26 PM To: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] continuously view database updates.

HI Kevin, you are the first Irish person I have seen on this list!! Anyhow, When you submit the form insure that the form submits to itself so you don't have to worry about a refresh. On the top of the page have the form and below do the select statement to show what is in the table. When the

RE: [PHP-DB] reading a URL...

Which I think I must have been!! Lisa -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 4:07 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] reading a URL... Hello Try to use this one with

RE: [PHP-DB] PHP/MySQL Program

I haven't used it yet but had it book marked. Try out www.codecharge.com It is not free but only $149 All the Best Lisa PS Let me know how you get on. -Original Message- From: Jason Stechschulte [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:13 PM To: Angela Curtis Cc: [EMAIL

RE: [PHP-DB] Displaying Graphics dynamically

I would recommend this too. Also to make it easier, instead of giving the updating person FTP access to upload tha images, I used an Upload page using PHP to a certain images directory on the web server and all PHP links then are pointed to this directory so all img links look something like

[PHP-DB] Apache Question

I apologise in advance but it may be a quick one. I have set up Apache, PHP and MySQL on my Home PC on Windows 98 believe it or not, on an old machine. Don't ask why!!! Anyhow to my surprise, as I am a beginner, it all installed quite smoothly and I am delighted with my efforts and of course

RE: [PHP-DB] MySQL/PHP Form Addslashes() command

I am a beginner but did it like this, with a little help from my friends!! $query = "INSERT INTO guests "; $query .= "(guest_id, guest_name, "; $query .= "guest_email, guest_time, guest_message) "; $query .= "values(, '$name', '$email', NULL, '" . str_replace("\n","br", $message)