/    Sign up×
Community /Pin to ProfileBookmark

MySQL check if record exists problems

Can someone tell me if I’m missing anything, i always get a “yes” even when it gets an ID thats not in the database..?

[code=php]
//INCLUDE DATABASE CONNECTION SETTINGS
include(“../includes/mysql/connection.php”);

//INCLUDE DATABASE NAME
$dbname = csecc_contactus;

//CONNECT TO DATABASE
$dbconn = mysql_connect ( $dbhost, $dbuser, $dbpass );
mysql_select_db( $dbname, $dbconn );

$msg_id = $_GET[‘msg_id’];

$valid_id = mysql_query(“SELECT * FROM `message_queue` WHERE `msg_id` = ‘$msg_id'”, $dbconn);

if($row = mysql_fetch_array( $valid_id )) {

echo “yes”;

} else {

echo “no”;

}
[/code]

to post a comment
PHP

1 Comments(s)

Copy linkTweet thisAlerts:
@The_Little_GuyJun 15.2006 — [code=php]//INCLUDE DATABASE CONNECTION SETTINGS
include("../includes/mysql/connection.php");
//INCLUDE DATABASE NAME
$dbname = csecc_contactus;
//CONNECT TO DATABASE
$dbconn = mysql_connect ( $dbhost, $dbuser, $dbpass );
mysql_select_db( $dbname, $dbconn );
$msg_id = $_GET['msg_id'];
$valid_id = mysql_query("SELECT * FROM message_queue WHERE msg_id = '$msg_id'", $dbconn);
$row = mysql_fetch_array($valid_id);
$rownum = mysql_num_rows($valid_id);
if(!$rownum) {
echo "No";
} else {
echo "Yes";
} [/code]
×

Success!

Help @phpnstuff spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.16,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...