[PHP-DB] mail() function

2003-05-29 Thread Alex Francis
I have set up my pc as a test server Windows 98 running Apache as a service, PHP and MySQL but cannot get the mail() function to work. After a long wait, I get an error Warning: Failed to Receive in c:\phpdev\www\assets\submit_users.php on line 17. Is there something I should be changing in the

[PHP-DB] Where have my errors gone?

2003-03-13 Thread Alex Francis
If I had a syntax error, I used to get a message back telling me. Now I just get a blank page. I have tried adding error_reporting=E_ALL; to the page, but still no errors. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Where have my errors gone?

2003-03-13 Thread Alex Francis
Got it . My ISP had upgraded PHP and left error reporting off. They have now fixed it for me. Alex Francis [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] If I had a syntax error, I used to get a message back telling me. Now I just get a blank page. I have tried adding

[PHP-DB] Apache Problem

2003-03-12 Thread Alex Francis
Please bear with me, I am a complete newbie. I am trying to use an in house server for test purposes and am having some problems. I get an Internal Server error and when I look at the error log the error is as follows: Premature end of script headers: /apache/php/php.exe. I have tried the Apache

[PHP-DB] Echo with extra characters

2003-01-08 Thread Alex Francis
I have the following code in my page as a header. ? if ($mainarea==Language) { header(Location:add_5-14_material.php?mainarea=$mainarea); } else { } ? When I echo $mainarea I get \'Language\'. I think it is something to do with my quotation marks but need some help. How do I get rid of the '

[PHP-DB] Re: blob

2003-01-07 Thread Alex Francis
Why not upload the PDF file to a files directory and just put the path and filename in your database. Natividad Castro [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi to all, I want to be able to load PDFs into mysql DB, but I'm not very familiar with the

[PHP-DB] Using ifelse to go to another page

2003-01-04 Thread Alex Francis
I have dropdown lists on one page which were working fine. However I need to make a slight alteration and add another 2 ifelse statements to go to another page instead of carrying out the $SQL statement. I have added the last 2 ifelse statements but I still get the SELECT statement working. Can

[PHP-DB] Using ifelse to redirect to another page

2003-01-04 Thread Alex Francis
I have dropdown lists on one page which were working fine. However I need to make a slight alteration and add another 2 ifelse statements to go to another page instead of carrying out the $SQL statement. I have added the last 2 ifelse statements but I still get the SELECT statement working. Can

[PHP-DB] Passing selection to next page

2002-12-19 Thread Alex Francis
I have a drop down list created using the following code and am having trouble passing my selection to the next page. Can anyone help? ? $query = select distinct department from courses order by department; $result = mysql_query($query); echo SELECT ID='Category Combo Box' NAME='department';

[PHP-DB] Now not selecting enough

2002-12-18 Thread Alex Francis
I am using the following script which I have used with minor variations, several times before without any trouble. I have 3 items in my database but the script only returns 1. I can change which one by leaving off the order by filter, but can't get all three. Where am I going wrong. (PHP and

Re: [PHP-DB] Now not selecting enough

2002-12-18 Thread Alex Francis
t record. Cheers Jason -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Now not selecting enough I am using the following script which I have used with minor variations, several time

Re: [PHP-DB] Selecting more than asked for

2002-12-16 Thread Alex Francis
is isn't solving your problem, show us more source-code and the table-columns definition. greets ag - Original Message - From: Alex Francis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 8:37 PM Subject: [PHP-DB] Selecting more than asked for Wh

[PHP-DB] Selecting more than asked for

2002-12-13 Thread Alex Francis
I am using PHP and MySQL and in one section I am trying to SELECT for a table where unit_id = $variable. In that column I have several blank items. When I select a particular variable I get that plus all the blanks. I presume there is some way of getting just those which meet my criteria. --

Re: [PHP-DB] Apache, PHP and MySQL

2002-12-09 Thread Alex Francis
DN Sorry, I cant find this Action line. If you mean the DLLs being copied to the Windows\System directory, I have done that. Is there a better tutorial for installing Apache and PHP, and if so should I try to uninstall and start again. I could even reformat if necessary - all my backups on the

Re: [PHP-DB] Apache, PHP and MySQL

2002-12-09 Thread Alex Francis
DN, Thank you, I found the line you were referring to, however I still have a problem. My browser comes back with page cannot be found. I created a small test html file, put it in the same directory and it worked alright. When I first add the action it couldn't find the extension dlls, but this

Re: [PHP-DB] Form TextArea Formatting

2002-12-09 Thread Alex Francis
You would be easier reformatting when you take it out of the database. After getting your variable representing the text in the text box do this: $variable = nl2br($variable); Then when you display your variable the all your original new lines are retrieved. John W. Holmes [EMAIL PROTECTED] wrote

[PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
At last I have Apache and PHP running on my server. My server IP is 192.168.1.1 and I have set ServerName 192.168.1.1 in my httpd.conf file. I can access my test files from the server using either http://localhost or http://192.168.1.1, however if I try the same on my main workstation I can't

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
er. try pinging the server: ping 192.168.1.1 -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] More Apache Installation problems At last I have Apache and PHP running on my server. My s

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
r router? is it filtering ICMP? can you ping anything? is your cat 5 cable crimped properly and you have link lights on your switch/hub/router and network card? Adam On Mon, 9 Dec 2002, Alex Francis wrote: It seems like a network problem. I can access the network through windows network neig

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
have two network cards, one connected to cable modem, and the other to the hub? -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:20 PM To: Gene Dymarskiy Subject: RE: [PHP-DB] More Apache Installation problems I need

[PHP-DB] Apache, PHP and MySQL

2002-12-08 Thread Alex Francis
I am trying to set up a test server to test updates before changing my uploaded pages. I have running Windows 98. I have Apache installed and running, and thought I have PHP installed properly. (Installed it as Welling and Thomson). However when I try to run my test.php file which should give

[PHP-DB] Single occurance of data

2002-11-26 Thread Alex Francis
I have two tables in my database with a department name. One table (department), the name only appears once and it includes all departments in the school. In the other table, (courses) department can appear several times, but not all departments will be in the table. I used the following code to

[PHP-DB] Pausing a script

2002-11-05 Thread Alex Francis
Instead of exiting the following script after Use your Browser Back Button to choose another I would like to simply pause it until some clicks a link to allow them to upload the file even if it already on the server. I have been playing about with break but I can't seem to get that to do what I

[PHP-DB] File Download - Complete Newbie

2002-10-26 Thread Alex Francis
I am trying to download file stored in a directory on my server. The information and the path to the file are stored in a MySQL database. This information is then displayed in a table. I now need to link to the correct file to download it and hav'nt a clue how to do it. Can someone help or point

[PHP-DB] Value from drop down list not being passed to database

2002-10-04 Thread Alex Francis
I have a table with a combi box drawing values from one table in a database and this should be inserted into another table along with other information: FORM NAME=Table1FORM ACTION=submit_new_unit.php METHOD=POST TABLE ID=Table1 BORDER=1 BGCOLOR=#CC CELLSPACING=3 CELLPADDING=1 WIDTH=100% TR

[PHP-DB] Re: Mail Again

2002-04-23 Thread Alex Francis
Problem is!!! PHP.INI is at my ISP. Is there a way to make it think it has been changed. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may

Re: [PHP-DB] Re: Mail Again

2002-04-23 Thread Alex Francis
Got it at Last Thank you -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients

[PHP-DB] Passing on an ID

2002-04-22 Thread Alex Francis
tthe opportunity to email the comments back to the writer. I am having difficulty passing on the ID of the story to the feedback page. Can someone help please. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk

Re: [PHP-DB] Passing on an ID

2002-04-22 Thread Alex Francis
= mysql_fetch_array($ret); -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients are requested

[PHP-DB] Mail

2002-04-22 Thread Alex Francis
. // retrieve values $row = mysql_fetch_array($ret); $email = $row[email]; $title = $row[title]; $comments = $row[comments]; $title = $row[title]; mail($email, $title, $comments); -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http

Re: [PHP-DB] Mail

2002-04-22 Thread Alex Francis
. That is at my ISP. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients

RE: [PHP-DB] Mail

2002-04-22 Thread Alex Francis
Can I set this to use the SMTP Server at my ISP but still use the database and PHP files in house. I don't want to make any changes to either the php pages or the database at the ISP until I have got it all working. Although I suppose I could set up another site and database at my ISP. Alex

RE: [PHP-DB] Mail

2002-04-22 Thread Alex Francis
and at the moment I am reluctant to spend the time changing over the modem and I can't seem to get the Windows 2000 PC to connect through the Modem on the Windows 98 mc. I may just get as far as I can and take a chance on working on the ISP. Thank you for your help Alex Francis Cameron Design 35, Drumillan Hill

[PHP-DB] Mail Again

2002-04-22 Thread Alex Francis
); ? $emailaddress is set in the config.inc.php file and comes in alright as a header in the note. However, the mail is sent from the following: nobody [[EMAIL PROTECTED]] Is there a way to tell the PHP Server where the mail is coming from. -- Alex Francis Cameron Design 35, Drumillan Hill

[PHP-DB] dates in MYSQL

2002-04-17 Thread Alex Francis
. Is this possible or do I need to INSERT todays date into the database first. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged

Re: [PHP-DB] Dates in MYSQL

2002-04-17 Thread Alex Francis
eventdate text NOT NULL eventheading text NOT NULL eventbody text NOT NULL -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only

Re: [PHP-DB] Dates in MYSQL

2002-04-17 Thread Alex Francis
Mike, I have just tried it again (that was the first way I tried to do the query) and get the error Unknown column '$todaysdate' in 'where clause' -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk

[PHP-DB] Arrays

2002-04-15 Thread Alex Francis
it into the database like: $query = INSERT INTO $tablename4 VALUES ('0', '$entername', '$date', '$eventdate', '$eventheading', '$eventbody' ); for the $eventdate variable the word array is inserted. Could someone please tell me where I am going wrong. -- Alex Francis Cameron Design 35, Drumillan

Re: [PHP-DB] Arrays

2002-04-15 Thread Alex Francis
Got it now, Thank you -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients

[PHP-DB] Access to Mysql

2002-02-13 Thread Alex Francis
anyone point me to the required information -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised

[PHP-DB] Adding to an empty field

2002-01-31 Thread Alex Francis
! displayed. However, the table is not updated and I cannot see why. The same happens on another page when I try to insert a 'Y'. This script was copied from a third page which works alright. I hope someone can help. I am going mad!!!. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock

Re: [PHP-DB] Adding to an empty field

2002-01-31 Thread Alex Francis
without any luck. Changed the code to: $query = UPDATE submissions SET answers = \.$array[$answer].\ where id = \$id\; and added the following: echo mysql_affected_rows(); affected rows returns 0 although query returns the correct id Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD