[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] 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 >

[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] 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 Apach

[PHP-DB] Echo with extra characters

2003-01-08 Thread Alex Francis
I have the following code in my page as a header. 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 ' and \ so that I am left with my variable?. -- PHP Database Mailing List (http://www.php.net/) To

[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 > t

[PHP-DB] Passing variables through a page

2003-01-05 Thread Alex Francis
I have a page (dept_select) with two drop down lists populated from a table in a MySQL Database. If one item is selected in either of the lists I need to go to one page (5-14_select_area.php). If any other item is selected I need to go to another page (add_new_resources.php) but I need to pass the

[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 som

[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 so

[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? "; echo "Select Department"; While ($row = mysql_fetch_assoc($result)) { echo " "; echo stripslashes($row["department"]); echo ""; } echo ""; mysql_free

Re: [PHP-DB] Now not selecting enough

2002-12-18 Thread Alex Francis
opping out the last 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 scrip

[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 MySQL)

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

2002-12-16 Thread Alex Francis
it_id<>'' or something like this, > depending on your type of variable. > > If this isn't solving your problem, show us more source-code and the > table-columns definition. > > greets > ag > > - Original Message - > From: "Alex Francis

[PHP-DB] Selecting more than asked for

2002-12-14 Thread Alex Francis
When using the statement below, as well as getting the data corresponding to $unit_id, I also get any data where unit_id field is blank. I have tried various permutations of unit_id IS NOT NULL, but get syntax errors. Can someone help to get the syntax correct. $SQL = " SELECT * FROM resources whe

[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. -- PH

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
d gets public IP assigned by your ISP. Your WS is also connected to a hub shared with your web server. > > > > does it mean you have two network cards, one connected to cable modem, and the other to the hub? > > > > > > > > > > > > -Original Message

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
.. > can you ping your 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 netwo

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
rkstation can see each other. 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

[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 find

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]> wr

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 w

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 se

[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 phpin

[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 t

[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] Re: Inserting current date(MySQL)?

2002-10-30 Thread Alex Francis
I'm no expert, but here's what I did in the same situation. $enterdate = date('Ymd'); --- this gives me the current date. then when entering the information from the form into my database I just entered the variable into a field called evdt When using the date I wanted it in a more user friendly

[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 me

[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: Course ID : other\n"); echo("Select Course\n"); while ($crs = mysql_fetch_array($results)) { $course= $crs["course_id"]; echo("$course \

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 are

[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

[PHP-DB] Mail Again

2002-04-22 Thread Alex Francis
mail($email, $title, $comments, $emailaddress); mysql_close($link); ?> $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 mai

RE: [PHP-DB] Mail

2002-04-22 Thread Alex Francis
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

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.

Re: [PHP-DB] Mail

2002-04-22 Thread Alex Francis
il account. 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 reci

[PHP-DB] Mail

2002-04-22 Thread Alex Francis
) function. // 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

Re: [PHP-DB] Passing on an "ID"

2002-04-22 Thread Alex Francis
error() . "\n$SQL\n"); } echo (" Link Updated\n");?> 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 to preserve this confidentiality and to ad

[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 This

[PHP-DB] Re: Date of Birth From Form

2002-04-22 Thread Alex Francis
field $eventdatestring = "$eventyear". "$eventmonth". "$eventday"; -- 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 con

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.camer

Re: [PHP-DB] Dates in MYSQL

2002-04-17 Thread Alex Francis
ername text NOT NULL enterdate text NOT NULL 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.camerondes

[PHP-DB] dates in MYSQL

2002-04-17 Thread Alex Francis
his 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 privile

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 are

[PHP-DB] Arrays

2002-04-15 Thread Alex Francis
"eventday"); when I insert it into the database like: $query = "INSERT INTO $tablename4 VALUES ('0', '$entername', '$date', '$eventdate', '$eventheading', '$eventbody' )"; for the $eventdate variable the word "arr

Re: [PHP-DB] Using include file

2002-04-12 Thread Alex Francis
I get a parse error on line 2. The code is as follows: As I said, when I paste the code into each file I don't have a problem. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is se

[PHP-DB] Using include file

2002-04-12 Thread Alex Francis
my test server to my hosting server. Any help would be appreciated. -- 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 infor

[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

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

2002-01-31 Thread Alex Francis
r]."\" 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 Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.c

[PHP-DB] Adding to an empty field

2002-01-31 Thread Alex Francis
ery seems to work alright, no errors showing up and "The answer was successfully inserted!" 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