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

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

Preg_match unknown modifyer
Hello,

Im trying to write a little script for my forums i need to get the reply from my forum

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t

GIS appliction help
I found some tutorials in the internet to develop a map application I don't want to use google maps

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

Get content from table into a list, without repeating.
Alright this is kinda an odd thing, so I need some help.

I have a table "quote" wit