Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: unique job page
11-25-2013, 01:16 PM #1
- 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
11-25-2013, 05:37 PM #2
- 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: