two problems regarding My SQL

[SirOliver]

hi,
can someone help me with theese:

1. if i execute the following query:

select count(*) from t_table where row_1=10 and row_2=132

i get the result "1"

but, if i execute it thorugh php,

i get: "Resource id #2"

I have tried to change values for row_1 and row_2 and i always got the same result.

2. i have noticed that if i write wrong name of the field and try to insert data in db, nothing happens - php continues to work, but no data is inserted. How can i force it to return the error ?

[cahva]

You have to use mysql_fetch_array, mysql_fetch_row etc. to print the results.

In your case:

$query="select count(*) from t_table where row_1=10 and row_2=132";
$result=mysql_query($query);
$row=mysql_fetch_row($result);
echo $row['0'];

If you want to see the latest error, use echo mysql_error();

[SirOliver]

thank you very much.

now, when this works, i have another problem 🙂

is it possible to use IF two times for 2 different!! conditions before using first ELSE ?
something like :

IF (something)

//sentences make connection to db

IF ($row=o)
// do something

ELSE
ELSE

[tiziano]

Hi,
yes, it's possible, but the first ELSE will refer itself to the second IF statement, and the second ELSE will refer to the first IF.
You can nest IF - ELSEIF - ELSE statements, not cross them.
Didn't you think to use ELSEIF? Is it possible for you?
Bye.
Tiziano

[Pig]

You can nest if statements within others, make multiple conditions with AND, and can use elseif and else statements.

I'm not sure what you are getting at, but it sounds like you want a nested if statement.

if( blah)
     {
     eh
     if(blah2)
          {
          eh2
          {
     }
else
     {
     eh3
     }

can you be more specific, if that isn't it?

[SirOliver]

tiziano: i can't use elseif because it is totally different values i am comparing.

pig: yes, it is a nested if, but i managed to get it work..
but the strange thing happens

this is the script:

IF (sth) {

// sth ...

IF ($row>0)
{
echo "i already have you in db";
}

else
{
// insert into db ... echo "inserted in db";
}

} else {
// something
}

Now, when $row is >0 script inserts data into db, and when it is 0 it says "i already have you in db" ?

Doesn't seems logic to me... but it works
😕

[Pig]

I don't know your query exactly, but I'd wager that the >0 means that there was a match already in there (so you wouldn't want to put it in.)

Glad it worked out.