[SOLVED] MySQL/PHP query issue.

[iPixel]

Ok i've got a table with a field called "terminated".

0 = employed, 1 = byebye

 

Here's the query

<?php
$emp_list_query = "SELECT firstname, lastname FROM table_ad WHERE manager = '$wholename' AND terminated = '0' ORDER BY firstname ASC LIMIT 0, 11";
?>

 

This causes a syntax error near 'terminated. My assumption is because of the work which is probably a predefined MySQL function or something.

 

I've tried placing the fieldname 'terminated' into single quotes but that just doesnt return anything at all. No error, but no data either.

 

 

What's the deal here?

[mikesta707]

try it without the quotes around 0.  its probably an integer column, and single quotes means a string

[ashton321]

Not sure if this is the error, but I believ that you don't need ' ' numbers, in your case the 0.

[iPixel]

'terminated' = 0 ORDER BY...

 

This causes no errors, but still retreives data where terminated = 1.

 

what's really weird is that on other pages i use WHERE terminated = '0' and that work. It's just this page that's giving me syntax errors.

[ashton321]

Try no quotes around terminated

[iPixel]

LOL forgive me i'm an idiot. I was looking at the wrong database. Grrr... too much crap going on haha!

I'm losing it.

[mikesta707]

let me get this straight. when you put WHERE teminated=0 it retrieves the rows that have terminated with a value of 1. that doesn't make any sense. are you sure the fields in your database are how you expect them to me

 

EDIT: ok i was about to say

[ashton321]

Ha done that and similiar things many times!