Hmm....
Hmm.. I wonder...could this have something to do with it all?
What I did change yesterday, was to make sure the spaces gets sent, BUT, these are changed %20
Could it by any chance be that the null results I am getting, is simply because when it is written to the database, it gets written as "Foxy%20Hollow".
If so, do you have any suggestions on how to get arount this?
Because as far as I know, it will either gets sent as "FoxyHollow" or "Foxy%20Hollow".
(I course make it so that it will be "Foxy<any char>Hollow" aswell, could I in the register.php change the <any char> before sending it to the database? And in that case, how?)
When I look in the phpMyAdmin interface, I see them as it should be, with blanks, not %20.. I havn't actually checked in the console yet.
---------- Post updated at 12:00 PM ---------- Previous update was at 11:40 AM ----------
I have to apologize again to anyone that have tried to helo me so far.. to see exactly what was going in to the database, I checked the logs of http-access....
All entries have (up untill now) gotten entered as "%20Venue%20Name" so all of them had a blank space in front of them.. no wonder I never found them when trying WHERE venue = 'Foxy Hollow".. it didn't exist.
Problem solved, thank you!
---------- Post updated at 12:35 PM ---------- Previous update was at 12:34 PM ----------
Ok, one more problem.. (hope you guys arn't fed up with me yet)
I have managed to strip it all diwn, as I said earlier, from "%20Venue%20Name" to "Venue%20Name". But, I just detected something else...
If the registered venue name is for example "Foxy Hollow" (Foxy%20%20%20Hollow) I get the same kind of error, it can't be found as I only get "Foxy%20Hollow" outputed in my dropdown menu.
Is there a way to already at the point of inserting the values in the database, reduce the blanks. So that if I get a value like "This%20Venue%20%20Name%20Is%20%20%20Long" in the $_POST[venue] variable in register.php, it can get reduced to "This%20Venue%20Name%20Is%20Long". I guess the answer is str_replace. If I knew how many blanks there were, I wouldn't have any problems with this. But I have no way of knowing the exact amount of blanks will be used in the name, so I have no clue of how to use str_replace for this.
I mean, str_replace(' ', ' '); would only convert two blanks into one, right?