[PHP-DB] Euro symbol

2001-12-19 Thread Rubanowicz, Lisa
Hi All, The Euro symbol that works in the browser IE5 is € however it doesn't work in Netscape. Anyone got any ideas ?? and when will they be updating. All the Best Lisa Lisa Rubanowicz Case ITC, Navan, Ireland Tel: #353 (0)46 77663 [EMAIL PROTECTED]

RE: [PHP-DB] get last field from a table

2001-01-10 Thread Rubanowicz, Lisa
This came from a previous listing hope it helps: SELECT MAX(id) FROM permission_table I am a beginner though so you may want to check for others. Lisa -Original Message- From: Cahyo S. Aji [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 10:24 AM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] DELETE FROM.... Question

2001-01-16 Thread Rubanowicz, Lisa
http://hotwired.lycos.com/webmonkey/99/21/index3a_page6.html?tw=programming If you go to this page it has all "Add", "Edit" and "Delete" all in one script. I got it working last night. Up to this I had been able to do the Add and Delete but not the Edit, so this has it all . Great for beginners

RE: [PHP-DB] SQL coloring in BBEdit 6.0?

2001-01-16 Thread Rubanowicz, Lisa
Hi All, I am new to PHP and am using TextPad 4.0 at the moment but it doesn't colour code PHP. Can anyone recommend a Text Editor that does this. The BBEdit is only for Mac. Thanks for your help All the Best Lisa -Original Message- From: Michael Zornek [mailto:[EMAIL PROTECTED]] Sent: T

[PHP-DB] Newbie - 2 tables one insert

2001-01-23 Thread Rubanowicz, Lisa
Hi all, Could you please help me out on this one. I want to create a web site using two tables. 1. page_creation - Stores page_id and page_name to be shown on all navigation bars. 2. pages - Contains pg_id, page_id, etc etc. I want to do an insert into page_creation to create a new page and then p

RE: [PHP-DB] Newbie - 2 tables one insert

2001-01-23 Thread Rubanowicz, Lisa
I realised I just sent my password out needless to say I am just about to change it. All the Best Lisa -Original Message- From: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 1:54 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Newbie - 2 tables one insert Hi

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

2001-01-26 Thread Rubanowicz, Lisa
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","", $message) . "

RE: [PHP-DB] Displaying Graphics dynamically

2001-03-12 Thread Rubanowicz, Lisa
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 this

[PHP-DB] Apache Question

2001-03-12 Thread Rubanowicz, Lisa
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 th

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

2001-03-26 Thread Rubanowicz, Lisa
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 form

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

2001-03-26 Thread Rubanowicz, Lisa
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 mysql_fetch_object..

RE: [PHP-DB] PHP/MySQL Program

2001-03-26 Thread Rubanowicz, Lisa
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 P

RE: [PHP-DB] MySQL manager

2001-03-27 Thread Rubanowicz, Lisa
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: [PHP-DB

[PHP-DB] SELECT MAX(ID) PLUS 1

2001-03-28 Thread Rubanowicz, Lisa
Hi All, I have been driven maad with this now for about a week and have looked all around for the answer but seem to get sent off in a tangent any time I get close. My SELECT statement seems to be right when I run it in MySQLFront but to add 1 in PHP .. Here is the story. I have a

FW: [PHP-DB] SELECT MAX(ID) PLUS 1

2001-03-28 Thread Rubanowicz, Lisa
Can anyone help me on this one Lisa -Original Message- From: Walter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 10:55 AM To: Rubanowicz, Lisa Subject: Re: [PHP-DB] SELECT MAX(ID) PLUS 1 Are tables are to differnet, so you don't have anything on my code

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

2001-03-28 Thread Rubanowicz, Lisa
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] CSS versus Includes

2001-04-02 Thread Rubanowicz, Lisa
Hi there, you can also do it this way using Javascript if (navigator.appName == "Netscape") { StyleSheet = "netstyle.css" } else { StyleSheet = "iestyle.css" } document.write('

RE: [PHP-DB] Keeping Variables

2001-04-02 Thread Rubanowicz, Lisa
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: [EMAIL PROTECTED] Subject: [PHP-DB] Keeping Variables

RE: [PHP-DB] duplicate a table

2001-04-03 Thread Rubanowicz, Lisa
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] dupli

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

2001-04-10 Thread Rubanowicz, Lisa
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] Uploading file into database

2001-04-11 Thread Rubanowicz, Lisa
Hope this helps. Lisa http://someurl.com/pics"; if (isset($fupload )) { if ($fupload_type == "image/gif") { copy ($fupload, "$file_dir/$fupload_name") or die ("Couldn't copy"); } } } ?> Home page -Original Message- From: Xsarus

RE: [PHP-DB] Convertin Asp to Php

2001-04-18 Thread Rubanowicz, Lisa
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

[PHP-DB] Odd - Even Results in a Table - Newbie question

2001-05-11 Thread Rubanowicz, Lisa
HI all, I am just a beginner at this stuff but I can't get my head around the logic of getting Row 1 in the left hand side of a two column table and Row 2 data in the right hand side. Something like this ___ | Data from Row 1 in MySQL| Dat

RE: [PHP-DB] Odd - Even Results in a Table - Newbie question

2001-05-11 Thread Rubanowicz, Lisa
Thank you both for your replies All the Best Lisa -Original Message- From: Samuel Torton [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 12:34 PM To: Samuel Torton Cc: Rubanowicz, Lisa; '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Odd - Even Results in a Table - Newbi

RE: [PHP-DB] MySQL Connect Problem

2001-05-17 Thread Rubanowicz, Lisa
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: and here is db_details.php By using the include it means if I go LIVE with a site I only have to change one file db_details.php The reason I don't do it all in one

RE: [PHP-DB] Data errors in entering

2001-05-21 Thread Rubanowicz, Lisa
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')";

[PHP-DB] Password Protect page

2001-06-22 Thread Rubanowicz, Lisa
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 passwo

[PHP-DB] Password Protect page

2001-06-22 Thread Rubanowicz, Lisa
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 passwo

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

2001-07-12 Thread Rubanowicz, Lisa
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 1

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

2001-11-09 Thread Rubanowicz, Lisa
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 yet

[PHP-DB] Date format in MySQL

2003-02-03 Thread RUBANOWICZ Lisa
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 coul