Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: unique job page

  1. #1
    New Coder
    Join Date
    Apr 2012
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    unique job page

    Hi

    Sorry to post again

    I have solved all the other issues I think on my admin page but got this one that am stuck on

    What should happen is a user clicks on a job and displays on a page of its own, it is getting the jobs from the database

    What is happening is on the job.php page I get this error

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Designer ORDER BY id desc LIMIT 1' at line 1

    Not sure on how to fix it really, I did look round on Google etc

    In the address bar it comes up with job.php?id=Web%20Designer

    So I think it is sort of working

    I have added a pastebin link below with the coding from the job.php page if it helps

    http://pastebin.com/P7KaD0pG

    Thank you in advance

    Ian

  • #2
    New Coder
    Join Date
    Nov 2011
    Location
    Ratio, Logic
    Posts
    55
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Never name your variables with space in it.

    URL encoded symbol can't be read by MqSQL engine so you have an error.
    Space in MySQL is used for deviding functions/variables.

    Best way naming variables in PHP, MySQL or Linux would be like:
    PHP Code:
    web_designer 


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •