Menu
Community /Pin to ProfileBookmark
@NogDogNov 25.2013 — #Find out what the actual query looks like:
Then we can look for why it's generating a SQL syntax error.
PS: You can just post your code here within [noparse]
unique job role 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
[url]http://pastebin.com/P7KaD0pG
Thank you in advance
Ian
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogNov 25.2013 — #Find out what the actual query looks like:[code=php]
$result = mysqli_query($con, $query) or die("Error: ".mysqli_error($con)."n$query");
[/code]Then we can look for why it's generating a SQL syntax error.
PS: You can just post your code here within [noparse]
[code=php] ... [/code][/noparse] tags.