how can i set custom message to sql query for this script

Question

got this:

if (mysql_num_rows($ak) == 0) {
    $sonuc = mysql_query($sql) or die(mysql_error());
}
elseif (mysql_num_rows($ak) == 1) {
    $sonuc = "you already added";
}

this script works succesfully. but mysql_query($sql) echos "1" how can let it echo "successfully added." thanks...

(im asking simple questions because im new to php)

Felix Kling · Accepted Answer · 2010-02-04 12:57:32Z

2

$sonuc = mysql_query($sql) or die(mysql_error());
if($sonuc) {
   echo "successfully added.";
}

But as you have or die(mysql_error()) this is also valid (but easier to mess up with when you change code):

$sonuc = mysql_query($sql) or die(mysql_error());
echo "successfully added.";

answered Feb 4, 2010 at 12:57

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ali Demirci Over a year ago

kk fixed added ; to end of echo

Chris Gutierrez Over a year ago

Add a semicolon to the end of the echo line.

Sarfraz · Accepted Answer · 2010-02-04 12:59:18Z

0

Try this:

if (mysql_num_rows($ak) == 0) {
    $ak = mysql_query($sql) or die(mysql_error());
    $sonuc = "successfully added";
}
elseif (mysql_num_rows($ak) == 1) {
    $sonuc = "you already added";
}

echo $sonuc;

answered Feb 4, 2010 at 12:59

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Collectives™ on Stack Overflow

how can i set custom message to sql query for this script

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related