Why is the logic of this simple code not working?

Posted on 16th Feb 2014 07:03 pm by admin

Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_query, then checking $sql as if it a were TRUE of FALSE. Which I though it would be. My Code always skips to the }else{ statment after the If(). What is wrong, How I do this?
I could of sworn I've wrote other scripts using this and it works.



PHP:

//Check first if it exists
$sql = mysql_query("SELECT var FROM fake WHERE token='{$token}'");


if( ! $sql){
// Does not exist! Create it.
$sql = mysql_query("INSERT INTO fake (var,token) VALUES('$var','$token')") ;


} else {
//It exists, Update it.

$sql = mysql_query("UPDATE fake SET var='{$var}' WHERE token='{$token}'") ;


}


Also

echo $sql; prints out, Resource id #11 or something.. Doesn't seem to say false or true....

Your Answer:

Login to answer

Other forums

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

Help with explandable category tree
I have the below query:

SELECT l1.id as lev1_id,l2.id as lev2_id,l3.id as lev3_id,l1.categ

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri

Batch Related Pricing
Hi, I need some clarity on the batch related pricing

For example the following are the b

help with mysql_error()
Hi,

I am trying to insert data into a table, but I am not able to insert it. I wanted to see

md5 is it unique
I know this is most likely one of many simple questions that can be found semi easily. But I'm press

Character increment
Hi,

I am facing a scenario like above,but in my case i want to show up like Col A,Col B etc..

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an

php sessions,logouts & the bloomin back button!
Hi All,

I've got a cms that members can log into. When they logout, the session is destroyed,