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

Not connecting to DB using ruby, error:env.c:257:in oci8lib.so: ORA-12154:
Hi All,

I am trying to connect to the database server from the client server using ruby and f

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

For example the following are the b

Show message after entering data
Hello Colleagues

I would like to display messages after entering the data example: "
dat

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to

New to PHP and just trying to understand a little code.
I hope I'm not annoying anyone or breaking the rules but I was wondering about this bit of code righ

rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this

Page not Loading After Test
Hey All

It seemed that an inlcude statement wasn't working for some reason, so I tried a more

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co