Unsupported operand type

ehmer

Any ideas about this error regarding the code below

Fatal error: Unsupported operand types in C:\Program Files\Apache Group\Apache2\htdocs\galleryone\includes\photo.php on line 12.

I've assumed it relates to the value of $row or $numrowsperpage. But as far as I can tell both variables would be integers.

Appreciate any suggestions
David

<?php
class navbar {
var $numrowsperpage = 1;
var $str_previous = "<<";
var $str_next = ">>";
var $file;
var $total_records;
function execute($sql, $type = "mysql") {
global $total_records, $row, $numtoshow;
$numtoshow = $this->numrowsperpage;
if (!isset($row)) $row = 0;
$start = $row * $numtoshow;
$result = mysql_query($sql);

leatherback

Hi,

Not sure but ehh.. shouldn't:

$numtoshow = $this->numrowsperpage;

be:
$numtoshow = $this->$numrowsperpage;

ahundiak

What version of php are you using? And can you post the code that shows the nav object being created and execute being called?

I copied your code into a file, commented out the sql query and was able to create and excute an object with no errors.

So the problem might be elsewhere.

ehmer

I'm using version 4.1.2 win32

Nav object being created and executed is:
<?php
$nav = new navbar;
$nav->numrowsperpage = 1;
$sql = "SELECT url, caption FROM photos ORDER BY date ";
$result = $nav->execute($sql, $db, "mysql");
$rows = mysql_num_rows($result);
for ($y = 0; $y < $rows; $y++) {
$data = mysql_fetch_object($result);
echo $data->url . "<br>\n";
}
echo "<hr>\n";
$links = $nav->getlinks("all", "on");
for ($y = 0; $y < count($links); $y++) {
echo $links[$y] . "  ";
}
?>

Regarding the previous reply, I think the dollar sign is omitted from the variable, so it should read as I had it. ie
$numtoshow = this->numrowsperpage;

"Not sure but ehh.. shouldn't: $numtoshow = $this->numrowsperpage; "

Appreciate any further help
David

tdomega

you declared navbar::execute with 2 arguments but you are calling it with 3. that alone should throw a fatal error or am i missing something?

and which line exactly is #12 of photo.php?

ehmer

Line 12 is:
$start = $row * $numtoshow;

I picked up on the 2 versus 3 arguments in navbar execute and fixed that. Didn't change anything.

The latest issue I'm having are the errors:
Warning: Supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\galleryone\includes\photo.php on line 18

Warning: Supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\galleryone\includes\photo.php on line 85

Line 18 & 85 respectively are;
$total_records = mysql_num_rows($result);
$rows = mysql_num_rows($result);

Any ideas, what does this error normally refer to?
David

tdomega

$row and $numtoshow dont happen to be CONST?
are you sure both are integer/float and not arrays or something else
try echo both to see if they contain the values you expect and that they are really set...
if that dont help...i dont know...

for the warnings:
it means the result past to mysql_num_rows() is not valid, means your query returned no rows or your query has an error!
if you definitly know that your query is ok and you dont want the warning to be displayed make it $rows=@mysql_num_rows($result);

ehmer

$row is an array.

Not sure what to do with this to resolve the problem though.

David

ahundiak

You are trying to do too much without understanding php. Is this someone else's script?

If $row is an array then what do you expect to happen when it get's multiplied?
Why do have all those globals in execute?
The posts about invalid mysql resources show a lack of understanding on how to do queries and an inability to search this forum for answers.

Slow down a bit. Read up and understand queries. Take a look at arrays and variables in general. Then maybe try a navbar object taking it a few lines at a time.

tdomega

you can only multiply an element of an array at a time look which element of $row you need and usethis