Query using like

[ehmer]

I am using the following details to search my MySQL database

    query string:  ...index.php?keywords=ashley&submit=%3E%3E

    using the following code to retrieve the passed variables:    $var =

$_GET['keywords'];

    Then structuring my query as follows

    $sql = "SELECT url, caption, date FROM photos WHERE keywords LIKE

'%$var%' ORDER BY date ASC ";

printing the query gives the following:

    SELECT url, caption, date FROM photos WHERE keywords LIKE '%ashley%'

ORDER BY date ASC

If I execute the following 2 lines of code the result I get from this query
is: Resource id #3 followed by the fatel error below
$result = mysql_query($sql);
echo $result;

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

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

This error is not returned if the function uses other queries I have sent to
it.

Appreciate any suggestions
David

[LordShryku]

What lines are between

$result = mysql_query($sql);
echo $result;

and

$start = $row * $numtoshow;

?

[ehmer]

The query gets called here in photo.php, the query is passed from queries.php:

<div id="center_container">
<?php
$nav = new navbar;
$nav->numrowsperpage = 1;
include('queries.php');
$result = $nav->execute($sql, $connection, "mysql");
$rows = mysql_num_rows($result);
?>

The problem appears to be in one of the functions of the navbar class.
Below is the class up to the point where the error occurs.

class navbar {
var $numrowsperpage = 1;
var $str_previous = "&lt;&lt;";
var $str_next = "&gt;&gt;";
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;

Is this more clear?

David