Search found 92 matches

by phpPete
Fri Aug 23, 2002 1:43 pm
Forum: Databases
Topic: BETWEEN question
Replies: 5
Views: 1968

Interesting behavior. In testing, one of the groupings had nothing to return, so it "appears" MySQL grabbed the next result, which was out of the grouping. So I asked for everything between 'H' AND 'P' and there is nothing in the DB to satisfy that query, so MySQL returns the first possibl...
by phpPete
Fri Aug 23, 2002 1:23 pm
Forum: Databases
Topic: BETWEEN question
Replies: 5
Views: 1968

Muchas gracias
by phpPete
Fri Aug 23, 2002 1:16 pm
Forum: Databases
Topic: BETWEEN question
Replies: 5
Views: 1968

BETWEEN question

Example "SELECT item_name, rec_code FROM menu_item WHERE item_name BETWEEN 'A' AND 'G' "; Am I mistaken, but does this query exclude A and G in the results? And if so, how do I get 'A" values? Also should I overlap the subseguent groupings? ie BETWEEN A and G BETWEEN G and P BEWTEEN P...
by phpPete
Fri Aug 23, 2002 7:17 am
Forum: General Discussion
Topic: On application design
Replies: 19
Views: 9901

:oops: ...ummm....errrr...what's a "shoutbox"...?
by phpPete
Fri Aug 23, 2002 1:13 am
Forum: General Discussion
Topic: On application design
Replies: 19
Views: 9901

Keeping with the theme of this thread I happened accross these articles:

http://www.phpfreaks.com/tutorials/1/0.php
http://www.phpbuilder.com/columns/tim20001010.php3
by phpPete
Thu Aug 22, 2002 12:31 pm
Forum: PHP - Code
Topic: SWITCH-CASE block fails to execute
Replies: 4
Views: 668

Now that I LIKE!!!

Thanks!
by phpPete
Thu Aug 22, 2002 12:12 pm
Forum: PHP - Code
Topic: SWITCH-CASE block fails to execute
Replies: 4
Views: 668

Making this change I get the behavior I'm looking for:

Code: Select all

switch (( $_POSTї'submit']ї'showItem']ї0] ) || ( $_POSTї'submit']ї'showItem']ї1])||( $_POSTї'submit']ї'showItem']ї2]))
by phpPete
Thu Aug 22, 2002 11:58 am
Forum: PHPDN Suggestions
Topic: Peer Review
Replies: 4
Views: 6982

I would be enthusiastic about seeing this. I suppose we could submit our code for dissection by the more expereinced, and those with a mind to could point out the strengths and weakness. When submitting any code I think as a requirement a rubrik of sorts ought to be attached. Compelling the submitte...
by phpPete
Thu Aug 22, 2002 11:53 am
Forum: General Discussion
Topic: On application design
Replies: 19
Views: 9901

This is right up my alley as for what I'm looking to learn. It's the next logical step in developing as a developer.

I would be totally psyched to see somthing like that!
by phpPete
Thu Aug 22, 2002 11:43 am
Forum: PHP - Code
Topic: SWITCH-CASE block fails to execute
Replies: 4
Views: 668

SWITCH-CASE block fails to execute

First...sorry to post all the code here, but I think it will help, normally I wouldn't do it.. And any suggestions as to doing this better are greatly appreciated...!!! The user is presented with a form containing 3 select lists. Each list has associated with it a submit button. The user selects fro...
by phpPete
Wed Aug 21, 2002 10:07 pm
Forum: PHP - Code
Topic: Converting this to a function
Replies: 6
Views: 1201

One of those days! I HAD to get away from the computer for a few hours.

Go Sox ! ( wait til next year! )

Pats going for 2!

Celts and Bruins on the rise!

Mass native...can you tell? :)
by phpPete
Wed Aug 21, 2002 6:20 pm
Forum: PHP - Code
Topic: Converting this to a function
Replies: 6
Views: 1201

Hey Nielsene;

That's pretty neat! Works like a charm. ( fixed a typo or 2 )

It is SO depressing that I struggle with something like this and you whip it up in 10 minutes...oh well...

Greatly appreciate it!
by phpPete
Wed Aug 21, 2002 1:15 pm
Forum: PHP - Code
Topic: Converting this to a function
Replies: 6
Views: 1201

Thanks for your efforts. I've taken a break on that code for a few...working on something else...and in serious need of coffee!!

At least it's a worthwhile function....i hope..:)
by phpPete
Wed Aug 21, 2002 12:33 pm
Forum: PHP - Code
Topic: Converting this to a function
Replies: 6
Views: 1201

Converting this to a function

I'd like to convert the following to a generic function which will return a an array of links which pass variables in the url I'm having some trouble abstracting it to the most basic components, thus they are the hard coded items...:( This is the code as it is in procedural form $lenRows =0; $fieldN...
by phpPete
Wed Aug 21, 2002 7:14 am
Forum: General Discussion
Topic: Introducing myself turned Battle rapping w/ comp. terms
Replies: 49
Views: 20548

ShoNuff!!!