The or operator

mmonaco

I am having a problem with the following code:

    $query = "SELECT * FROM rates";
    $result =& $link->query($query) or
        printf ("There was an error looking up rates: <b>%s</b><br>QUERY: %s<br>",
        $link->error, $query);

No matter what the printf function is executed. I don't think it's because of the =& operator, could it be because of the object?

superwormy

That statement doesn't make a bit of sense... if you want to use an or statement you should have an if statement in there somewhere too... did you mean this:

if ($result =& $link -> query($query))
{
// do something
}
else
print("error message");

mmonaco

It makes pleanty of sense, it follows from the syntax of something like

$link = mysql_connect('localhost', 'user', 'pw', 'db') or die("Connection failed");

drew010

i dont have php5 so i cant try it since its using mysqli, but the query method returns true or false, so you shouldnt need the & operator there.
either way, the same in php4 using mysql_query works fine for me

$result = mysql_query('select * from mytable') or printf("error has occured"); //no error
$result = mysql_query('select fsdafsdfasd') or printf("error has occured: %s", mysql_error()); //shows error

in any case though, the following also work the way you want

$result = &mysql_query('select * from mytable') or printf("error has occured"); //no error
$result = &mysql_query('select fsdafsdfasd') or printf("error has occured: %s", mysql_error()); //shows error

mmonaco

Actually I do need the reference operator there because I get nonclonable objects without it. I think its because I have a class from which actually contains a link and in this instance I am pulling the link out of the class first.

drew010

well have you made sure the link is valid? and tried to make sure the query actually does work if you just run it on a line by itself?
maybe the link is bad.
if query still is returning true or false, and hasnt been extended, then using the & operator there will point $result to the address of wherever the true/false result is, rather than copying it into it.