Hello and welcome to our community! Is this your first visit?
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
    Thanked 0 Times in 0 Posts

    unique job page


    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


    Thank you in advance


  • #2
    New Coder
    Join Date
    Nov 2011
    Ratio, Logic
    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:


    Posting Permissions

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