ginerjm

Why not simply test for dates > one date and less than the other (including equals as well)?

Echo out your query statements after building them and check them visually.

Fixing the function on #1 is key. Fixing the call on #2 is the other problem.

To quote you: 'testing purposes'. The real point is - don't use urgent on forum posts. Do you really think we are all going to drop everything to help you out? The use of urgent just shows us who's new to the whole idea of forums.

Urgent? Really? And this code is just for testing purposes and it's urgent? Really? Urgent?

What is 'maxforumtopics.subject'. that is your problem.

So you got one problem working? The other you have an undefined var in your function call (the typo).

Also your error reporting put the 1 in quotes. Remove them.

Discard cycpher86's code and just study the original code. Re-read your second set of code until you see the typo you made. I already told you what had to change in the first problem.

So much for letting the student learn how to debug his own errors! And the EASY correction was to simply move the return outside of the while loop! No need for code bloat.

Can we see your new code in its entirety?

My point was what happens when you turned on error checking? And did you find the glitch in your while loop that I pointed out?

And?

Searches and stuff? As in 'do your own research'? Asking for help on a forum is not what I would call research. Hints - a flaw in your logic in your while loop for one problem. A mis-type of something is your second problem which, if you had turned on error checking, would have been pointed out. Did your instructor not tell you about enabling error checking when developing? See my signature.

Another day of learning for me! Thank you for the info.

Not that I am going to help you do your homework, regardless of how you feel about the instructor, but what doesn't work here?

Are you just being a wiseguy or do you want help? In your first sentence you stated that the 'registration is successful'.

You should also work on using proper array notation..A reference to $array[index] causes unnecessary work for the php interpreter as it searches for the correct element in the array. It usually works but can fail if your index name matches some other declared constant value. Proper array syntax if $array['index'].

So what error are getting? Or is it just not the data you expect? (Note the proper usage of punctuation and capitalization in my sentences. Makes it easy to read, no?)

1 - do you have error checking turned properly so that errors can be shown to you? 2 - "this one doesn't". Just what does that mean? white screen? no json returned? something else? 3 - and what if $_GET['what'] is not equal to 'legale'? What query are you going to be preparing then?

Your code is out of context as posted (BESIDES being posted here incorrectly to boot) so it makes it hard to tell you what to change. Show us some more code before this so we may see what mode you are in and what this line should therefore look like. You don't tell us what is making you think it is wrong in the first place. We don't know if you have error checking turned on and are seeing a message or if you don't and are seeing a blank screen or if you are simply 'seeing' the php code on the screen because you are outside of php mode. At first glance the problem here is that you are burying php code inside your html code (bad practice - verrry bad) which is causing it to be not recognized as php.

Besides what mac_gyver has given you try adding some echo statements to your code to show you exactly what is being done with what values. echo out the parms of your connection statement and let's see if you are actually running that code.

iarp gave you some good examples of how to do this but did include a small error in his code. The form he coded up for you uses the POST method. Notice? Then in the ensuing PHP code he showed you how to capture the contents of the dropdown (from the name attribute of the select tag) by grabbing the element from the GET superglobal. Problem is the data will not be in GET since your form is doing a POST. Swap out his use of $_GET for $_POST.

You have declared these vars as global, yes. But you are trying to echo one of them out without having actually assigned anything to it, since you don't show us where you actually executed that function.

I frankly don't see that you did a lot of changing. Don't know what you mean about adding apostrophes either. Get rid of the used of both $_POST and $_GET. Get your act straight and decide how you want to pass parms.