[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Bj
Hi Joseph First a dsiclaimer, in view of my closing remark, I apologise in advance for any inadvertent slips in the following code... :-) This:'{$_POST['username']}' ),0); in the SELECT query is the fault with the other problem, but I cannot work out what is wrong with it. So far I

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Sheila Fenelon
Bj wrote: Try rewriting: # Verify if username already exists # 1. Build the query $query = SELECT_COUNT(*) AS ucount . Where did the underscore come from? Should be a space. FROM book_mydb.members . WHERE members.username = . '{$_POST['username']}' ; # [Incidentally I have no idea what

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Joseph, Smile Poet
Bj, You lightened my mood. Yes I have noticed that this tutorial has some errors, and I did wonder how complex he'd made it.I found another tutorial on phpfreaks.com, dealing with a similar project, and substituted some of that. It worked well till that tutorial left me floundering -- I

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Joseph, Smile Poet
Sheila, First let me say thank you for the support and help; I am most gratefulto you and everybody else who contirbutes to my education. I am just not in a position to attend any classes (not that I know of any round here) at present. The 'Look!Isn't php/mysql simple' intros are fine, but

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Bj
I am trying to sort a problem to do with VALUES syntax, and can't find the rules at this moment!!! I used to use an SQL tutorial on the Web, but found it was much easier to keep a copy of Sams Teach Yourself SQL in 10 minutes on the shelf, it was about £8 in PCWorld I think. Not only is it

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread JimMenees
In a message dated 3/9/2004 1:55:33 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I used to use an SQL tutorial on the Web I haven't been following this thread, but caught the above comment. There's a nice sql tutorial with an online testing forum at: http://sqlcourse.com/ or the

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread rudy
I think you really could learn SQL in ten one-minute lessons from it. yes, like you can learn how to play chess in 10 minutes, too ;o) • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Sheila Fenelon
rudy wrote: I think you really could learn SQL in ten one-minute lessons from it. yes, like you can learn how to play chess in 10 minutes, too Which is exactly why I'm having so much trouble writing lessons to teach PHP/MySQL. There is a lot to cover. I didn't learn what I know in six

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread rudy
Which is exactly why I'm having so much trouble writing lessons to teach PHP/MySQL. There is a lot to cover. I didn't learn what I know in six one-hour lessons. The best I could hope to do is provide a good foundation. you're writing lessons to teach php/mysql? where? will they be on the

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Trusz, Andrew
-Original Message- From: Sheila Fenelon] Sent: Tuesday, March 09, 2004 2:26 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] Re: $_POST and access questions rudy wrote: I think you really could learn SQL in ten one-minute lessons from it. yes, like you can learn how to play chess

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Sheila Fenelon
Trusz, Andrew wrote: What's missing in most courses is the foundation. It's usually a quick jump from hello world to forms, email, and a shopping cart without the discussion of the ' { ) ] ; not to mention regular expressions. A good foundation might have saved poor Joe a headache or two.

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread rudy
I teach an Intro to PHP class at EclecticAcademy.com - low cost but not free. They keep asking for a PHP/MySQL class. cool let me know if you need an SQL instructor rudy • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Sheila Fenelon
rudy wrote: I teach an Intro to PHP class at EclecticAcademy.com - low cost but not free. They keep asking for a PHP/MySQL class. cool let me know if you need an SQL instructor I'll pass your name and email on to the people that run it. A separate SQL class would be great. Sheila •

[wdvltalk] Re: $_POST and access questions

2004-03-09 Thread Cheryl D. Wise
I teach the web accessibility class there and will also pass your interest along. Cheryl D. Wise Certified Professional Web Developer MS-MVP-FrontPage www.wiserways.com mailto: [EMAIL PROTECTED] 713.353.0139 Office -Original Message- From: Sheila Fenelon rudy wrote: I teach an Intro

[wdvltalk] Re: $_POST and access questions

2004-03-08 Thread Sheila Fenelon
Hi Joseph, Joseph, Smile-Poet wrote: Why this: Notice: Undefined variable: email_error in c:\easyphp1-7\www\join.php on line 65 if the following two queries define the variable?: if(!$_POST['email_address']){ $errors .= Missing Email address\n; $email_error = true ; }

[wdvltalk] Re: $_POST and access questions

2004-03-08 Thread Robin Hastings
Quoting Joseph, Smile-Poet [EMAIL PROTECTED]: Why this: Notice: Undefined variable: email_error in c:\easyphp1-7\www\join.php on line 65 if the following two queries define the variable?: if(!$_POST['email_address']){ $errors .= Missing Email address\n;

[wdvltalk] Re: $_POST and access questions

2004-03-08 Thread Joseph, Smile Poet
Sheila and Robin, Thanks very much. You were right about the variable *not* having been defined; I'm a bit closer to understanding and being able to watch out for that! This:'{$_POST['username']}' ),0); in the SELECT query is the fault with the other problem, but I cannot work out