Calling A Function inside A Function-Buzzle!

saidbakr

Hi,
Look at this code:

 <? 
 function mydo(){
$sql2 = "select * from img ORDER BY img_id";
$re = mycon($sql2);//calling for another function.
return $re;
}


  ?>
<?
$host = "localhost";
$user = "said";
$psw = "fox";
$db = "lam";
 ?>
<? 
function mycon($sql){
global $host;
global $user;
global $psw;
global $db;

mysql_connect($host,$user,$psw);
mysql_select_db($db)|| die(mysql_error());
$res = mysql_query($sql) || die(mysql_error());
$t = "hiii";
//return (mysql_num_rows($res));
return $res;
}

echo mydo()."hhh";
 ?>

The value returned for $re from mydo() function is incorrect, it must be a resource id.
If I modified mycon() function and placing the SQL ststement directly in it, it returns the correct value.!😕
?
What's the problem? The rule of mydo() is only to supply mycon() with the SQL statment during its calling inside mydo() function.

What's Wrong I did?🙁

tekky

err I was wrong... gimmi a minute :rolleyes:

.... can you supply us with the 2 different outputs you get?

saidbakr

I noticed that the presence of ,|| die(..., on the right of
$res = mysql_query($sql), leads to $res to handle a strange value it's namely equls to 1, instead of handling a resource id of the resulting query. Now I think the problem base is located inside || die.

Hence, I'd like to ask what's (or die, || die) do ? or what's its effect on the previouse function execution?

I think the value of 1 which is handled in $res during the presence of || die means true. So Why The $res carried The returned value by || die and it scaped or does not regard the value returned by mysql_query()?

tekky

I've never seen || die always "mysql_query() OR die("blah");

it ends the execution delivering the "STRING" in die() as the error

try replacing || with OR?

rohithmr

OK saidbakr, you kno mysql_query returns a query handle not the actual data. So modify ur code so dat:

<?php
function mydo($sql){ 
$re = mycon($sql); //calling for another function. 
return $re; 
}

function mycon($sql){ 
global $host; 
global $user; 
global $psw; 
global $db; 

mysql_connect($host,$user,$psw); 
mysql_select_db($db) or die(mysql_error()); 
$res = mysql_query($sql) or die(mysql_error()); 

//return (mysql_num_rows($res)); 
return mysql_fetch_assoc($res); 
} 

echo '<pre>';
print_r(mydo('select * from img ORDER BY img_id'));
echo '</pre>';
?>