[PHP-DB] Unable MySQL db connect Remotely

2005-03-07 Thread Tsegaye Woldegebriel
I wanted to connect to mysql on a remote server, but I have error message: denied for [EMAIL PROTECTED] even if I have the right password and username. the xxx.xxx.xxx.xxx part is our Windows 2003 Small Business Server ip address, and I am on a client computer for this network.(I am locally

Re: [PHP-DB] Unable MySQL db connect Remotely

2005-03-07 Thread Tatang Widyanto
check host on privilege table is mysql allowed to connect from your host ??? Tsegaye Woldegebriel wrote: I wanted to connect to mysql on a remote server, but I have error message: denied for [EMAIL PROTECTED] even if I have the right password and username. the xxx.xxx.xxx.xxx part is our Windows

[PHP-DB] authentication problem (php and popups)

2005-03-07 Thread mel list_php
Hi! I have an authentication problem... My users are authenticated through a mysql table. This set up a session variable to true and allow them to browse different pages (in each page I test that session variable). To deny direct access to the directory, I put an htaccess which simply denies

Re: [PHP-DB] Shopping Cart

2005-03-07 Thread Martin Norland
Wendell Frohwein wrote: Hello everyone. Just want to thank you for all the help you have provided me in the past. I have a new task that I am trying to tackle, but have come into a snag. I am building a customized shopping cart for auto accessories. I have gotten about 90% of the cart worked out

[PHP-DB] data grabbing and mathematics!

2005-03-07 Thread JeRRy
Hi, I have 23 tables, well I have more but these 23 tables are the main agenda regarding this question. In each of the table is a column titled score and a column titled nickname ... These are the two columns we need for this. Now lets throw a few names so you understand my needs. Lets say

[PHP-DB] data grabbing and mathematics!

2005-03-07 Thread JeRRy
Hi, I have 23 tables, well I have more but these 23 tables are the main agenda regarding this question. In each of the table is a column titled score and a column titled nickname ... These are the two columns we need for this. Now lets throw a few names so you understand my needs. Lets say

Re: [PHP-DB] data grabbing and mathematics!

2005-03-07 Thread Martin Norland
JeRRy wrote: Hi, I have 23 tables, well I have more but these 23 tables are the main agenda regarding this question. In each of the table is a column titled score and a column titled nickname ... These are the two columns we need for this. [snip] Now I want the scores added up. So using the + not

[PHP-DB] regex question

2005-03-07 Thread Chip Wiegand
I am writing some regex on a php form to validate input and have come up with this, for example - if (empty($first) || !eregi(^[A-Za-z]+[- ]?[A-Za-z]+$, $first)) for checking a persons name. This allows a single name, or a hyphenated double name, or a non-hyphenated double name, and it works.

Re: [PHP-DB] regex question

2005-03-07 Thread Martin Norland
Chip Wiegand wrote: I am writing some regex on a php form to validate input and have come up with this, for example - if (empty($first) || !eregi(^[A-Za-z]+[- ]?[A-Za-z]+$, $first)) for checking a persons name. This allows a single name, or a hyphenated double name, or a non-hyphenated double

RE: [PHP-DB] Shopping Cart

2005-03-07 Thread Wendell Frohwein
Hi martin, thanks for the email. I'm sorting it out slowly but surely. I was just a little over worked the night I wrote that novel of an email. I don't know if you saw my latest email titled Mysql Result. That's the last step I am at. I used a select statement across multiple tables to get all

Re: [PHP-DB] regex question

2005-03-07 Thread W. D.
At 11:04 3/7/2005, Chip Wiegand wrote: I am writing some regex on a php form to validate input and have come up with this, for example - if (empty($first) || !eregi(^[A-Za-z]+[- ]?[A-Za-z]+$, $first)) for checking a persons name. This allows a single name, or a hyphenated double name, or a

Re: [PHP-DB] Re:data grabbing and mathematics!

2005-03-07 Thread Martin Norland
Neil Smith [MVP, Digital media] wrote: At 17:15 07/03/2005 +, you wrote: well - two options spring to mind... 1) use a single table, with 23 columns instead of 2. Then sum the columns in your query. - 1 query, no loops required. 2) have your script pull everything and add it all up. - 22

Re: [PHP-DB] Shopping Cart

2005-03-07 Thread Martin Norland
Wendell Frohwein wrote: Hi martin, thanks for the email. I'm sorting it out slowly but surely. I was just a little over worked the night I wrote that novel of an email. I don't know if you saw my latest email titled Mysql Result. That's the last step I am at. I used a select statement across

[PHP-DB] mysql, php error

2005-03-07 Thread James
I'm pretty new to this...I've set this book example up on my PC and it's fine. I've attempted this on two Macs... Here's the error I get when I try to run the application. What does the error mean? UNHANDLED ERROR on line 84 in /Library/WebServer/Documents/wda2-winestore/index.php. [PHP

Re: [PHP-DB] mysql, php error

2005-03-07 Thread Martin Norland
James wrote: I'm pretty new to this...I've set this book example up on my PC and it's fine. I've attempted this on two Macs... Here's the error I get when I try to run the application. What does the error mean? UNHANDLED ERROR on line 84 in

[PHP-DB] GD with IIS and MS SQL Server

2005-03-07 Thread Perry, Matthew (Fire Marshal's Office)
I work with a county office in Houston, Texas and have been forced to use Windows IIS (on Windows 2000 Server) with MS SQL Server. They have permitted me to use PHP (instead of ASP) when I showed them problems on every county ASP site. Most applications on IIS are running well including