Ok so this has me a little stumped. I have a WHERE clause that produces results in phpmyadmin but not on the web page. Here is what I have
$sqlCur = mysql_query("SELECT * FROM currency WHERE airframe = '$acft'");
This produces a blank result on the webpage. $acft has been echo and has data. When I run the same query in phpmyadmin the row is produced as it should.
Now here is the kicker this code
$sqlCur = mysql_query("SELECT * FROM currency WHERE username = '$user'");
Works fine on the website. When I search with this and echo the table colum it will show a value of 0 or what ever is in there.
So even if I use this
$sqlCur = mysql_query("SELECT * FROM currency WHERE username = '$user' && airframe = '$acft'");
there is a blank return. I echo all varibles and it has data, i.e. $user = John SMith and $acft = C32 and when I plug those varibles in phpmyadmin i get a result. Now to really throw a wrench in it, this only effects 1 user. Checking others user everything produces just fine. Am I missing something obvious or just being a derp