[PHP] Re: editor for remote files using ssh

2004-07-24 Thread Harlequin
I use HTML-Kit which highlights syntax for a number of languages, PHP included. I am unsure of its ability to connect using SSL but it's very customisable when creating a new remote folder and I use it to work on remote files all the time. It simply creates a connection if needed and saves the fil

[PHP] Unexpected T_ENCAPSED...

2004-07-24 Thread Harlequin
I've been working on a query to retrieve a user's data based on their UserID that is stored in a variable "$_SESSION['logname']" which underneath I convert using: $UserID = $_SESSION['logname']; But when I execute a SELECT query: $CaptureDetails = "SELECT * FROM RegisteredMembers WHERE UserID

[PHP] Creation of MySQL Database Using PHP

2004-07-24 Thread Harlequin
Hello. I have a friend who knows less than me about PHP and MySQL (which I know is hard to believe) but she needs a login facility for her site. I've passed over some script I use but she doesn't know how to create the database. I can write some commands that create the tables OK - but can I do t

[PHP] Usng Session Vaiable in WHERE Statement

2004-07-26 Thread Harlequin
Could someone please help me with my syntax here...? $MembersDataQry = "SELECT * FROM MembersData WHERE UserID='$_SESSION['logname']'"; I get an error on line 2 but can't seem to figure out what I've missed. The variable echoes fine so I know there's a string in there. -- -

Re: [PHP] Creation of MySQL Database Using PHP

2004-07-26 Thread Harlequin
Marek thanks very much. -- - Michael Mason Arras People www.arraspeople.co.uk - "Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Harlequin wrote: > > Hello. > > > > I

[PHP] Retrieve The Last Record in a Table

2004-07-26 Thread Harlequin
I would like to retrieve the last entry in a login table and present that to a user so they can verify the date we have when they last logged in. Is this possible...? -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP Gen

Re: [PHP] Retrieve The Last Record in a Table

2004-07-27 Thread Harlequin
t; On Mon, 26 Jul 2004 18:27:25 +0100, Harlequin > <[EMAIL PROTECTED]> wrote: > > > > > > I would like to retrieve the last entry in a login table and present that to > > a user so they can verify the date we have when they last logged in. > > > > Is this pos

[PHP] Verifying AUthorised Users through Session Variables not Working...?

2004-07-27 Thread Harlequin
Hi all. I'm using session variables to identify if a user is authorised, if yes - display x and so on. However, I've come across a couple of issues: when users access a page that's 2 folders deep into the root I.e. www.mydomain.com/folder1/folder2 any include references I use have to be absolute

[PHP] Retrieving Stored Values for Dropdown Menu

2004-07-28 Thread Harlequin
Hi all. I'm trying to retrieve values from a previously selected dropdown menu. For text I simply use value="$Whatever" But for dropdowns I can't do this - has anyone else come across this before...? -- - Michael Mason Arras People www.arraspeople.co.uk --

[PHP] Re: Retrieving Stored Values for Dropdown Menu

2004-07-28 Thread Harlequin
co.uk - "David Robley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Wed, 28 Jul 2004 20:49, Harlequin wrote: > > > Hi all. > > > > I'm trying to retrieve values from a previously selected dropdown menu. >

[PHP] Re: Retrieving Stored Values for Dropdown Menu

2004-07-28 Thread Harlequin
I ended up with this: Can you see any obvious problems I might miss.? -- - Michael Mason Arras People www.arraspeople.co.uk - "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all

[PHP] Conversion of Field Value to Hyperlink

2004-07-29 Thread Harlequin
Afternoon... I have a table generated by some code that returns certain field values and drops them into a table. On of these values is ID and I'd like to convert it to a hyperlink that people can use to go to another page to view further information about a record. However: The fields are not in

Re: [PHP] Conversion of Field Value to Hyperlink

2004-07-29 Thread Harlequin
RTFM...? -- - Michael Mason Arras People www.arraspeople.co.uk - "Jay Blanchard" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] [snip] I have a table generated by some code that returns certain field values and drops them int

Re: [PHP] Conversion of Field Value to Hyperlink

2004-07-29 Thread Harlequin
I know. Just wondered if Jay had the courage of his convictions. -- - Michael Mason Arras People www.arraspeople.co.uk - "John Nichel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Harleq

Re: [PHP] Conversion of Field Value to Hyperlink OT

2004-07-29 Thread Harlequin
Jay I am new. we all are at something at some point or other in our lives. If you don't like me fine - just ignore me. If you want to help, that's fine also. Just be polite. You don't need to swear to get your point across and don't need to be aggressive as either method implies a lack of contr

Re: [PHP] Conversion of Field Value to Hyperlink

2004-07-29 Thread Harlequin
Mmmm... Interesting Jay. Maybe I'll just WTFM mate :) -- - Michael Mason Arras People www.arraspeople.co.uk - "Jay Blanchard" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] [snip] I have a table generated by some code that

[PHP] Re: Replace a button by an image

2004-07-30 Thread Harlequin
Henri. I prefer to use CSS for things like this but I'm sure PHP has it's own idiosyncrasies. I checked out the site posted in response to your post and personally thought the graphics were a bit ropey. typically CSS is used for replacing images or backgrounds on hover but is very flexible and q

[PHP] Re: php coding software

2004-08-02 Thread Harlequin
Brad I use HTML-Kit for HTML, ASP, Java, CSS, PHP and MySQL. Free too :) -- - Michael Mason Arras People www.arraspeople.co.uk - "Brad Ciszewski" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does anyone know any good so

[PHP] Unable to Destroy Session

2004-08-03 Thread Harlequin
Morning guys. I'm trying to destroy a session using "session_destroy();" and I get the following error: "Trying to destroy initialised session" I simply want a user to click a logout button that destroys the session cookie. Am I doing this the right way...? -- - Mi

[PHP] Re: Unable to Destroy Session

2004-08-03 Thread Harlequin
Sorted it. for some reason it was holding the session because I had two browser windows open which is the environment it will be used in by the users. strange though... -- - Michael Mason Arras People www.arraspeople.co.uk - "Harl

[PHP] Query Results Question

2004-08-03 Thread Harlequin
I have the following query which should return just two rows: SELECT 'ID', 'Vacancy Role', 'Vacancy Salary', 'Vacancy Location', 'Vacancy Type' FROM vacancy_details WHERE Publish = 'Yes' As only two rows have Publish set to "Yes". yet even if I execute the query through phpMyAdmin I get two

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
Richard Thanks firstly for your help. I renamed the fields so the spaces are underscores and amended your query but still receive an error: "not a valid MySQL result resource " Still tinkering though... -- - Michael Mason Arras People www.arraspeople.co.uk --

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
Richard. Public. I changed it to "Publish". But if I use a query window to interrogate the database I still get just two rows using the following query with field names not values for the row cell contents: SELECT 'ID','Vacancy_Role','Vacancy_Salary','Vacancy_Location','Vacancy_Type' FROM vaca

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
I'm only selecting a few fields Richard as I want to try and drop them into an array and display in a table. I know I'm probably going the long way around doing this but I need to learn from scratch exactly how to do it. I appreciate your help and patience very much. I've managed to get the quer

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
Mason Arras People www.arraspeople.co.uk - "Curt Zirzow" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > * Thus wrote Harlequin: > > Richard > > > > Thanks firstly for your help. I renamed the fields so the spaces are

Re: [PHP] Query Results Question - Solved

2004-08-03 Thread Harlequin
Many thanks Richard. I have the table presenting neatly now, thanks for all your help with this one...! -- - Michael Mason Arras People www.arraspeople.co.uk - "Richard Bewley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]

Re: [PHP] Query Results Question - Solved

2004-08-03 Thread Harlequin
I know what's going to happen though Richard. I'll dump it in their site and it'll look terrible because they don't know how to use CSS effectively. But hey - that's part of the fun. Hyperlinks tomorrow though :| -- - Michael Mason Arras People www.arraspeople.co.u

Re: [PHP] Outputting Data

2004-08-05 Thread Harlequin
Jay. Strange behaviour. My ISP seems to allow me to download messages intermittently but can reply to all anytime I like. However, If I can't download I can bloody well reply. Guess who the ISP is...? NTL...! I'm talking to my ISP about directory access, seems the problem with outputting that f

[PHP] Outputting Data

2004-08-05 Thread Harlequin
It appears that I am unable to output the data to a directory because although my user has sufficient privileges on the database to execute the query the user in question does not have file privileges. As I am reliant on my host I'm looking for other ways to achieve this. Could I possibly set a p

[PHP] MySQL & PHP Examples & Training Providers Required

2004-08-10 Thread Harlequin
Hi all. This might sound like a strange request but here goes. I'm looking for some examples of sites that are purely MySQL and PHP running on Unix and that contain a few thousand records preferably held in relational databases. Rationale: I need to justify PHP as a tool of choice over say vb.n

[PHP] Variable just not Behaving Itself.

2004-08-10 Thread Harlequin
I have the following: [SNIP] ... $Emp_Status_Rqmt=$row["Emp_Status_Rqmt"]; } if( $Emp_Status_Rqmt == 'Permanent' ) { $UserStatus = 'Permanent'; } if( $Emp_Status_Rqmt == 'Contractor' ) { $UserStatus = 'Contractor'; } else { $UserStatus == 'Flexible'; } [SNIP]

[PHP] Changing MySQL Date Format

2004-08-12 Thread Harlequin
I'm using a hell of a lot of dates in my databases and wondered if it was possible to change the date format in my databases from -00-00 to: 00-00-...? Has anyone else managed to do this or use any workarounds I could use perhaps...? I'm just getting a little hacked of having to explode t

[PHP] Re: Creating plotted graphs on the fly

2004-08-12 Thread Harlequin
Ryan I'm looking to do the same thing later down the line. I'd appreciate you keeping in touch by mail and perhaps we can help each other out on this one...? -- - Michael Mason Arras People www.arraspeople.co.uk - "Ryan C . Spaulding" <

Re: [PHP] RE: MySQL & PHP Examples & Training Providers Required

2004-08-12 Thread Harlequin
Jay, guys. Thanks very much for all your responses on this issue. I'm sorry if I don't always reply through the group but if I am working from the office I have a problem connecting to the mailing list. which is just one of the reasons I prefer working from home. I, along with your help, have ins

[PHP] If Else Syntax Incorrect (I Think)

2004-08-13 Thread Harlequin
Can someone help with this please...? if( strlen( $UserID ) != 0 & strlen( $UserPassword ) != 0 & strlen( $SecretPassword ) != 0 & strlen( $UserMail ) != 0 ) { Do something } elseif ( strlen( $UserID ) == 0 or strlen( $UserPassword ) == 0 or strlen( $SecretPassword ) == 0 or strlen( $UserMail ) ==

Re: [PHP] weird error, might be javascript?

2004-08-13 Thread Harlequin
I have had similar problems in the past Angelo and viewing the source of the HTML file usually helps identify and localise the problematic line. -- - Michael Mason Arras People www.arraspeople.co.uk - "John Holmes" <[EMAIL PROTECTED]> wro

[PHP] RIP Programming

2004-08-14 Thread Harlequin
I know, I know. This is a PHP newsgroup. I just wondered if anyone knew of any RIP newsgroups as I can't seem to find any, or any forums... -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP General Mailing List (http://www.

[PHP] System Tray Icon

2004-08-16 Thread Harlequin
Hi all. I just wanted to throw this message in here and get some opinions before I go off developing something So will post in the correct newsgroup later (when I find which newsgroup I need). Before I post a more thorough thread in the correct area I just wanted to find out if this was achievabl

[PHP] Re: back button doesn't work with sessions?

2004-08-17 Thread Harlequin
Frank I use a back button on a couple of sites that use session variables and don't seem to have an issue with them. However, my back buttons are held within IFRAME tags as I am accessing resources externally. -- - Michael Mason Arras People www.arraspeople.co.uk -

[PHP] PHP & MySQL Installation

2004-08-17 Thread Harlequin
Hi all. I'm probably biting off a little more than I can chew here but here goes... I've been asked to move some resources I have developed from our hosting company's server and host them locally. I know I am going to need a licence for MySQL as we are developing commercial applications and not pr

[PHP] Outfile not working

2004-08-20 Thread Harlequin
Morning all. I've been tinkering with the code for the above for some time now and keep getting the same error: "Access Denied..." Can anyone help me find a solution to this as the user in question has full privileges to the database so I assume it's a directory access issue... -- -

[PHP] Exporting Dbase to CSV

2004-08-26 Thread Harlequin
I've seen many different posts on this subject and try as I might I can't get my data to output to CSV for a user to save. I can output to a table, I can output to screen in CSV format but that just means massing about with copy and paste. Has anyone got any suggestions...? -- -

Re: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Harlequin
I'm using MySQL Jay I can present the results in a table easy enough and if I replace the TD TAGs with commas etc. I get a screen output that resembles a CSV file but need to go that one step further and don't know how... -- - Michael Mason Arras People www.arraspe

Re: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Harlequin
I'm using MySQL Dan I can present the results in a table easy enough and if I replace the TD TAGs with commas etc. I get a screen output that resembles a CSV file but need to go that one step further and don't know how... -- - Michael Mason Arras People www.arraspe

[PHP] List of cities

2004-08-29 Thread Harlequin
Morning... Does anyone know of a site that or resource available where I could pull a list of ALL UK cities and towns for an option list...? I started out with 100+, then expanded this list to over 200 but still get complaints that certain towns are not listed. -- -

[PHP] Broken data within an Array

2004-08-31 Thread Harlequin
Hi all. Having a problem echoing a broken date. Here's where I'm at: $DateAdvertisedBroken = explode("-", $DateAdvertised); later, in a table, I use: $result[DateAdvertised] How can I change this so I can call the broken date...? I've tried datebroken [2] etc but no joy. --

[PHP] Re: List of cities

2004-08-31 Thread Harlequin
I scoured the web. begged borrowed and stole and eventually ended up with a list of over 1,600 cities and towns in the UK. -- - Michael Mason Arras People www.arraspeople.co.uk - "Harlequin" <[EMAIL PROTECTED]> wrote

[PHP] Re: Broken data within an Array

2004-08-31 Thread Harlequin
Broken[n] Any ideas...? -- - Michael Mason Arras People www.arraspeople.co.uk - "Jason Barnett" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Harlequin wrote: > > > Hi all. > > > >

Re: [PHP] Re: Broken data within an Array

2004-09-01 Thread Harlequin
while($result = mysql_fetch_array($query)) { $DateAdvertised=$row["DateAdvertised"]; does that help any o would you like all the code...? -- - Michael Mason Arras People www.arraspeople.co.uk - "Comex" <[EMAIL PROTECTED]> wr

[PHP] Re: Broken data within an Array

2004-09-01 Thread Harlequin
Following the query I have this: wrote in message news:[EMAIL PROTECTED] > Hi all. > > Having a problem echoing a broken date. Here's where I'm at: > > $DateAdvertisedBroken = explode("-", $DateAdvertised); > > later, in a table, I use: > > $result[DateAdvertised] > > How can I change this so I c

[PHP] Re: Newbie: Validate Required Form Fields

2004-09-02 Thread Harlequin
Francis I have a new web app that does exactly that. Page one has some mandatory fields. Page 2 checks these fields and tells the user to go back if they aren't complete. If they are complete then they are presented with page 2 and the fields it holds. -- - Michae

[PHP] Load Data Local Infile

2004-09-02 Thread Harlequin
I am using the following command and it appears to execute but does not actually load any data: LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE MembersData FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; Any ideas what I might be missing...? The file exists, and I must ha

[PHP] Re: Load Data Local Infile

2004-09-02 Thread Harlequin
nge. Any ideas guys...? -- - Michael Mason Arras People www.arraspeople.co.uk ----- "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I am using the following command and it appears to execute but does not >actually load any data: >

[PHP] Creating Dropdown Menus From Tables

2004-09-20 Thread Harlequin
Hi all. Hoping this might be relatively easy... I'm wondering if I can create a dropdown menu (ABCDE) by using a select statement and then populating this using PHP...? -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP

[PHP] Parsing a File

2004-09-21 Thread Harlequin
Hi all. I've been through the PHP manual and wonder which file option will best suit my needs. I basically want to take a file that the user uploads and parse it into a variable or string so I can insert it into a field in my database. Do I use: File() file_get_contents Or something else...?

[PHP] Re: Problem with uploaded file

2004-09-26 Thread Harlequin
Sagar This is the code I use to change file permissions on a file that has been uploaded by a user to a predefined area with a predefined filename: // Change File Permissions: chmod("{$uploadfile}", 0644); -- - Michael Mason Arras People www.arraspeople.co.uk

[PHP] Re: php and print

2004-10-10 Thread Harlequin
Bruno I'm still rather new to PHP so I use client side Java: [CODE] Click Here To Print This Page: [/CODE] That may be os use to you... -- - Michael Mason Arras People www.arraspeople.co.uk - "Bruno Santos" <[EMAIL PROTECTED]> wrote

Re: [PHP] Re: php and print

2004-10-12 Thread Harlequin
message news:[EMAIL PROTECTED] > Harlequin wrote: > >>Bruno >> >>I'm still rather new to PHP so I use client side Java: >> > you are not using java you are using javascript. > >>[CODE] >> >>Click Here To Print This Page: >src="../

[PHP] Query Returning Error

2004-10-13 Thread Harlequin
Morning all. this is such a basic question I'm embarrassed to ask but the query worked fine a few minutes ago and now returns an error: I get an error: Parse error: parse error, unexpected '=' in sample.php on line 2 [CODE] // Authenticate User: Query01 = "SELECT * FROM Users WHERE UserI

Re: [PHP] Query Returning Error

2004-10-13 Thread Harlequin
Doh...! thanks mate. -- - Michael Mason Arras People www.arraspeople.co.uk - "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Wednesday 13 October 2004 15:32, Harlequin wrote: > &

[PHP] Match Vs Where - Fulltext Search

2004-09-28 Thread Harlequin
Hi all. It took me some time to discover that you can't use a "MATCH | AGAINST" statement unless you create an fulltext index of the fields to search at the same time. Strange, I know. What's more strange is that as I read more I wonder why people use it because it will only seartch complete w

[PHP] Re: simple date/now() question

2004-09-29 Thread Harlequin
I gave up with the timestamp feature because although it's accurate it's not English and needs to be reworked to make it presentable. Despite finding code to do this I still moved on to using a date\time stamp using the US format of-course and this echoes much easier and will of-course be easie

[PHP] Searching My Database

2004-09-29 Thread Harlequin
Morning everyone. I've read around the subject of searching and although using the FULLTEXT capability of MySQL might be the proper way of doing this I feel it's somewhat limited and have decided to use a simple select procedure. I'm sure there's a better way of doing this, as I'm quite new to

[PHP] TAB Syntax

2004-06-29 Thread Harlequin
I know I'm probably going to get flamed for this but it is only a development site but I am having some trouble getting the syntax right for using the tab when echoing information. My current command is: print_r("Host: $hostUser: $userPassword: $password"); I've tried: print_r("Host: \t$hostUs

[PHP] Re: TAB Syntax

2004-06-30 Thread Harlequin
trol this). Any thoughts...? -- - Michael Mason Arras People www.arraspeople.co.uk - "Lars Torben Wilson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Harlequin wrote: > > > I know I'm probably going to get flamed for this

[PHP] Re: TAB Syntax

2004-06-30 Thread Harlequin
ience Lars. -- - Michael Mason Arras People www.arraspeople.co.uk - "Lars Torben Wilson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Harlequin wrote: > > > Cheers Lars. > > > > So, for example, if I wanted to display som

[PHP] MySQL QUERY Results Not Appearing

2004-06-30 Thread Harlequin
Hi all... Despite being able to make a connection to the server and execute a query I am unable to do this through PHP using the following commands: echo "active members should appear here"; $query = "SELECT * FROM RegisteredMembers"; $result = mysql_query($query) or die ("could not execute qu

[PHP] Re: MySQL QUERY Results Not Appearing

2004-07-02 Thread Harlequin
"could not > execute query"); > while($result = mysql_fetch_array($query)){ > echo $result['YOUR_DB_FIELDNAME']; > } > > change YOUR_DB_FIELDNAME' to whatever the fields are you are querying. > you could also: > > > > > > HTH > > Craig >

Re: [PHP] MySQL QUERY Results Not Appearing[Scanned]

2004-07-02 Thread Harlequin
xample: $sql = "select * from members"; if(!$result = mysql_query($sql)) echo mysql_error(); while($row = mysql_fetch_array($result)) { echo $row['column_name']; } HTH, Michael Egan -Original Message- From: Harlequin [mailto:[EMAIL

[PHP] MySQL Results Not Being Commited To Database

2004-07-03 Thread Harlequin
I've managed with a lot of help to get the PHP pages to echo the results of what a user put into a "User Registration" page. However, I'm still having trouble getting the code right to actually commit the data on the "Registered" page that the "Register" page points to. Can anyone help...? Code a

[PHP] Re: MySQL Results Not Being Commited To Database

2004-07-03 Thread Harlequin
u need any systems advice. -- - Michael Mason Arras People www.arraspeople.co.uk ----- "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've managed with a lot of help to get the PHP pages to e

[PHP] Sending Mail Using PHP & MySQL

2004-07-03 Thread Harlequin
Hi again. New Hour, New Problem. I'm using the following code to user user input from a form on a previous page to send mail confirming registration: $To = "$NewUserMail; $Subject = "Welcome To Arras People's Registered Members Area"; $Message = "$NewUserID, \n\nWelcome to the arras People

Re: [PHP] Sending Mail Using PHP & MySQL

2004-07-03 Thread Harlequin
irst line, so everything > until the next " is part of that variable. Since there's not a ; > after the second ", you are getting the error. > > -- jason everett > -- [EMAIL PROTECTED] > -- http://twocannons.com > > On Sat, 3 Jul 2004 23:03:51 +0100, Har

[PHP] User Logon Procedure Fails

2004-07-04 Thread Harlequin
Another day another problem. This time it appears that users are able to enter their details but I get a query execution error with the following section of code: /* Verify Login */ $sql = "SELECT UserFirstName,UserID,UserPassword FROM RegisteredMembers WHERE UserID='$_POST[TXT_UserID]'"; $r

Re: [PHP] Re: Obtain NT Logon

2004-07-04 Thread Harlequin
Martin John is right. I have used this facility with VB, VBA and VBS but not in PHP. However, the principle is the same. Disable anonymous logins and use the code John is suggesting and it should work a treat. I'd recommend outputting this data to a TXT file or MySQL dbase also. --

[PHP] Unable to retrieve value from database and echo on screen

2004-07-04 Thread Harlequin
I know, I know. Simple stuff to you guys, but I am learning more every day and believe me - I won't be recommending Bill's software for web development from now on :) /* Select User's First Name From Table */ $sql = "SELECT UserFirstName FROM RegisteredMembers WHERE UserID='$_POST[TXT_UserID]'";

[PHP] MySQL Database Connection Question

2004-07-08 Thread Harlequin
I have a user registration form that asks new users to register. However, Do I post the MySQLconnection string in the page they are completing or in the later page that the data is posted to, or both...? -- - Michael Mason Arras People www.arraspeople.co.uk

[PHP] User Redirection if login fails

2004-07-08 Thread Harlequin
Hi again. My code simply asks for a username and password but even if they insert incorrect details the called page is displayed. How can I get them to be redirected to another page if their login information is incorrect...? echo "registerd users login here please..."; echo ""; echo "User

[PHP] PHP Redirection If Login Fails.

2004-07-09 Thread Harlequin
Hi all I've created a page that allows registered users who have previously registered and been entered into the database to login. However, for some reason if a user login fails my code does not display the appropriate error message. Ideally I would like the users to be redirected to another page

[PHP] Retrieving Database Data For Users To Edit

2004-07-09 Thread Harlequin
Hi again. I'm currently trawling through PHP and MySQL forums and web pages trying to find some starting point for the above. In essence what I want to do is once a user is logged in (which I have cracked) display their information for them to edit. Such things as user's password, some text field

[PHP] Re: PHP Redirection If Login Fails.

2004-07-09 Thread Harlequin
="The Login Name, '$_POST[TXT_UserID]' exists, but you have not entered the correct password! Please try again."; } } elseif ($num == 0) // login name not found { unset($do); $message = "The Login Name you entered does not exis

Re: [PHP] Re: PHP Redirection If Login Fails.

2004-07-09 Thread Harlequin
riday 09 July 2004 18:37, Harlequin wrote: > > Here's the code in question: I'd ideally want the user to only be directed > > to this page if login is successful. Directed to another page if > > unsuccessful but even the error messages do not display which I find > >

[PHP] Retrieving Data To Edit

2004-07-09 Thread Harlequin
This is really confusing and I'm sure very simple to achieve. I already have values selected that I want to open and edit: $sql = "SELECT * FROM RegisteredMembers WHERE UserID='$_POST[TXT_UserID]'"; I basically want to recall these values on screen for the user to edit themselves. Once I've achi

[PHP] Re: Retrieving Data To Edit

2004-07-09 Thread Harlequin
ers max"; echo ""; But if is use "value='$UserFurtherComments' nothing appears in the form field, even though the database holds a value in that field. What am I doing wrong...? -- - Michael Mason Arras People www.arraspeople

Re: [PHP] Retrieving Data To Edit

2004-07-09 Thread Harlequin
Yes and thanks very much for the post. I've been trying to use some of the examples on that site but just can't seem to get it to work right. I've posted a reply to my own thread "below" I'd really appreciate any input you can provide. -- - Michael Mason Arras Peopl

[PHP] PHP Include not Working Correctly

2004-07-09 Thread Harlequin
Hi all. in a desperate effort to whittle down my code I decided to use an include statement in my webpage: http://www.arrasresources.co.uk But the include statement: Brings in the correct file but not an images referenced in the CSS file, just the background and formatting. Has anyone come a

[PHP] Login Verification

2004-07-10 Thread Harlequin
Hi everyone. I have a quick question regarding the above. currently I have a form that posts to another page. However, rather than wait until they get to that page to verify their login are there conventions that are recognised for this process currently...? For example, my code for the form's he

Re: [PHP] Login Verification

2004-07-10 Thread Harlequin
ver egging the pudding but I'd like it to be slick that's all. -- - Michael Mason Arras People www.arraspeople.co.uk - "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Sunday 11 Ju

[PHP] Re: Login Verification

2004-07-10 Thread Harlequin
Jason, John, Tim, Eric. Thanks for your patience. Which along with persistence is it's own reward :). I got it working OK and am reasonably happy with the results. -- - Michael Mason Arras People www.arraspeople.co.uk ----- "

[PHP] UPDATE...

2004-07-10 Thread Harlequin
Hi again. I know I should be in bed but if I leave this I'll just go mad...! I have a page that successfully calls data from the database based on userID & Password combo. No Problems there eh... I display the information in a form, the user is supposed to be updating this information and then hit

Re: [PHP] UPDATE...

2004-07-10 Thread Harlequin
ople.co.uk - "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Sunday 11 July 2004 08:20, Harlequin wrote: > > > I have a page that successfully calls data from the database based on > > userID & Password combo. No Problems there eh

Re: [PHP] UPDATE...

2004-07-10 Thread Harlequin
co.uk - "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Sunday 11 July 2004 08:33, Harlequin wrote: > > > I'm hitting the submit button at the bottom of the page and getting > > redirected OK to the next page with no errors but whe

Re: [PHP] UPDATE...

2004-07-10 Thread Harlequin
chael Mason Arras People www.arraspeople.co.uk - "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Sunday 11 July 2004 09:00, Harlequin wrote: > > > I did as you suggest and I get a rather generic response: > > > > Sor

[PHP] Passing Variables

2004-07-11 Thread Harlequin
I'm just working on my syntax for passing a variable "UserID" from one page to the next and it works a little like this so far: On my form I have: " Generates: for example: ['\"JDoe\"'] Which part of my syntax is incorrect...? -- - Michael Mason Arras People ww

[PHP] Re: Passing Variables

2004-07-11 Thread Harlequin
Thanks Tim. Solved the problem. -- - Michael Mason Arras People www.arraspeople.co.uk - "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm just working on my syntax for passing a variabl

[PHP] PHP and HTML Conventions

2004-07-12 Thread Harlequin
Hi all. I just wondered if the general convention was to use entirely PHP and simply encase HTML TAGs within that or use a mix and simply use PHP TAGs when required. -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP Gene

[PHP] Re: PHP and HTML Conventions

2004-07-13 Thread Harlequin
d. Thanks guys. -- - Michael Mason Arras People www.arraspeople.co.uk - "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all. > > I just wondered if the general convention was to use entirely PHP and simply > encase HTML T

[PHP] Re: PHP and HTML Conventions

2004-07-13 Thread Harlequin
is there a HTML equivalent of the PHP include statement then...? -- - Michael Mason Arras People www.arraspeople.co.uk - "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all. > > I jus

[PHP] Session Variables ~ Best Practices

2004-07-13 Thread Harlequin
I'm right in the middle of developing some pages that will require session cookies. Now I have a few questions and hope I don't bore you too much... I presume I am right in assuming that I can declare variables anywhere I like providing I have started a session on the page but I cannot actually us

[PHP] MCAL Function

2004-07-14 Thread Harlequin
It appears that PHP can create on-pine calendars...? I'm looking for tutorials but no joy. Can anyone point me in the right direction...? -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP General Mailing List (http://www.p

  1   2   >