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

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

How to change Time Zone
HI
I want to change the time zone of the server to another country.How can do that?

Thanks

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

CHECK A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

Dynamically allocating the number of rows in a table based on a variable value
Hi,
I have situation here which i cannot resolve, I have a variable temp which stores the num