[PHP-DB] PHP mysql_connect Access Denied

2001-03-19 Thread Matt Coyne
table (the password column being encrypted). I am thinking that there are some potential configuration problems as the php page works in my online server environment (pair networks) Has anyone got an idea where I am going wrong and/or can point me in the right direction? Any help appreciated.

[PHP-DB] Getting ages from dates

2001-03-25 Thread Matt Coyne
ks for PHP and MySQL. I have run through Julie Meloni's PHP Fast and Easy (thanks Julie) and want to get in deeper. Any help/pointers appreciated TIA Matt Coyne t h r e e z e r o : : : the mill, millstone lane, leicester, le1 5jn e : [EMAIL PROTECTED] ::

[PHP-DB] newbie help

2001-03-25 Thread Matt Coyne
Hi all Having created a form that sends values to a php file that searches a table and returned results in the format specified I was on a high (little things I know!). However, this only works if I enter values into all fields on the form. How can I create an SQL query (mySQL) that will use on

Re: [PHP-DB] newbie help

2001-03-25 Thread Matt Coyne
co.uk : : :t h r e e z e r o > From: CC Zona <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Sun, 25 Mar 2001 10:39:23 -0800 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] newbie help > > In article <[EMAIL PROTECTED]>, > [EMA

[PHP-DB] Another newbie question

2001-03-26 Thread Matt Coyne
Hi guys/gals Having had my head sorted out by this list already today, I am in need of some more help...!! I have an input form that, through php queries a MySQL db and passes results back and the browser displays them (at this stage just as a list). I have been looking into the LIMIT command t

Re: [PHP-DB] Another newbie question

2001-03-26 Thread Matt Coyne
> Date: Mon, 26 Mar 2001 14:48:20 +0200 > To: "'Matt Coyne'" <[EMAIL PROTECTED]>, "'PHP DB'" <[EMAIL PROTECTED]> > Subject: RE: [PHP-DB] Another newbie question > > OK, Matt, so you've got the basics =8). > > Your beginn

[PHP-DB] Newbie : URGENT : SELECT ... AS

2001-04-14 Thread Matt Coyne
Hi all I am trying to make searches based on the age of a person. The db contains only the Date of Birth. So... My first attempt was to try the following : (this is all done in the command line on Win2000) SELECT firstname, surname, dob, floor((to_days(curdate())-to_days(DOB))/365) AS age FROM

[PHP-DB] ERROR

2001-04-14 Thread Matt Coyne
Hi all I am getting an error which I don't understand. It is: Warning: 0 is not a MySQL result index in /usr/www/users/three0/_host/castingcollective/_dev/php/flashtest/flashsearch .php3 on line 302 Any ideas? thanks Matt //t h r e e z e r o : : : the mill, millstone

Re: [PHP-DB] Newbie : URGENT : SELECT ... AS [solution]

2001-04-16 Thread Matt Coyne
#x27;25'; > > Francois Legare > [EMAIL PROTECTED] > Vancouver BC Canada > 604.261.1320 > >> -Original Message- >> From: Matt Coyne [mailto:[EMAIL PROTECTED]] >> Sent: April 14, 2001 5:07 AM >> To: PHP DB >> Subject: [PHP-DB] Newbie : URGENT : SELECT ...