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

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

$variable = $variable
Hello

Sorry if this is a really simple question but I have run out of ideas. Is there a reall

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

From Header Showing 'Unkown' In Hotmail? Why?
Code: $to = $row_GetID['email_addr'].',sales@mywebaddress.co.uk';
$subject = 'Thank you for you

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f