Jump to content

Archived

This topic is now archived and is closed to further replies.

CanMan2004

php sql count error

Recommended Posts

Hi everyone

I have a php query that counts the rows in a table, when I put an if statement in the middle of the query, I get the error

Parse error: syntax error, unexpected T_IF

The code that im using is

[code]if ($search == "679")
{
$sqlresult = mysql_query("SELECT * FROM information WHERE".

if ($nameid != "")
{
" nameid = $nameid AND".
}
" hireit='$hire'", $connection);
$num_rows = mysql_num_rows($sqlresult);
$results = $num_rows;[/code]

The error shows on line

if ($nameid != "")

Can anyone help?

Thanks

Dave

Share this post


Link to post
Share on other sites
You can't use operators where strings are expected.

Build a string first, then do the query.

Share this post


Link to post
Share on other sites
You are using an if statement after a line which isn't finished and so PHP is returning the T_IF error message. To solve this do something like this in stead:
[code]if ($search == "679")
{
    $sql = SELECT * FROM information WHERE";

    if (!empty($nameid))
    {
        $sql .= " nameid = $nameid AND";
    }

    $sql .= " hireit='$hire'";

    $sqlresult = mysql_query($sql, $connection) or die("Query error : " . mysql_error() . "<br />" . $sql);

    $num_rows = mysql_num_rows($sqlresult);
    $results = $num_rows;[/code]

Also I wuld recommend you to indent your code too (like above).

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.