Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End Dynamic Dropdown tutorial does not work if the select box has a space inside it.

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • #35067
    phish3rz
    Member

    I am currently using the tutorial from Chris Coyier regarding the Dynamic PHP Dropdown’s – See Tutorial Here.

    My problem is, everything works fantastic with the MYSQL and PHP, but when a drop down option has a space within e.g. ‘Beef Burgers’, it does not return anything. By manually typing it into my browser and submitting, I get presented with – getter.php?choice=Beef%20Burger.

    If i ‘Echo’ the mysql statement after contact with the variable, it’s printed as such:

    SELECT * FROM locations WHERE county_name='West Yorkshire'

    Which is identical to what the town is called in the database!

    I originally thought it was the escape_mysql_real_string, but removing that still presented me with this problem.

    Any help would be hugely appreciated!

Viewing 1 post (of 1 total)
  • The forum ‘Back End’ is closed to new topics and replies.