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

Problem with "dynamic" index page
Hi. I have one question. In my index.php page I have this kind of code:
Code: // listaa sivut

Is it possible to view php source code??
Hi All

I was just wondering if it's possible to view a websites php source code?
I know

How to replace search button with link?
hi to everbody.
i have a search submit form and button like this :

<form id="f

parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

Accessing element of object array
Hello

My object looks like this:


Array ( [0] => User Object ( [id] =>

Shuffle Array
Hi,

I am writing a script for a game that needs players to randomly be assigned a target (ano

Query output more than expected
$query=mysql_query("SELECT * FROM players, communities, divisions WHERE dob BETWEEN '{$start_da

Sub-domains & calling unique content
Hello,

Is there a way use something similar to the $_GET function for a sub-domain? I to be a

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say