Hi guys,
This has been annoying me for over an hour now to no avail.

Ive got this

PHP Code:

        $chkquery = "SELECT foo from foo WHERE foo = '$conffoo';";
        $chkresult = mysql_query($chkquery) or die(mysql_error());
                while($chkrow = mysql_fetch_array($chkresult)){

                $isit = $chkrow['foo'];

                echo "isit = $isit \n";
                if ($isit == "") {
                echo "Error This FOO $conffoo doesnt seem to be here \n";
                }else{
                echo "$conffoo is here \n";
                }
        }
} 


Anyway,
What im doing is,
Im trying to match rows in a table , If that row is there then great.
If it isnt i need it to echo saying " Its not here!"

I cant seem to get it to work when it doesnt find a matching row.

Ie:
Its happy when it can find a matching row.

If it cant find a matching row it just doesnt seem to do the while..


Any thoughts?


-G

Ok??

What exactly are you trying to do?????

because your code and query makes no logical sense at all.

Either your sql query is going to return rows, or it isn't, and if it returned one row or several rows then the specified column equalled the search value.

Esessentaily im got 2 tables.


I need to check if X exists in Y table.

IE:

Go through every row in table 1
If X from table 1 exists in table 2 then all is good.
If not, Echo error

Then continue through each row in table 1.

It says its fine when it can find a matching row.
However when it doesnt return anything, i cant figure out how to mark that row as bad.

Humm, considering im only expecting one row returned,

Ive tried.
$chkrow = mysql_fetch_array($chkresult);

rathen than using a while, and that seems happy.

There has to be a better way for me to achieve this.

If it doesn't return anything the query failed and there is nothing to "mark as bad"

maybe something like this is what you are after?
$query = "SELECT COUNT(column) AS reccount FROM table WHERE column = 'value';"
// run SQL query

if row['reccount'] = 0{
echo('No records') ;
}

that's pseudocode not working code BTW.

IF reccount is > 0 matching records were found.

Thanks chris,

That works fine,

Ive got it now so if it find more than 1 row it will do the "all is good code"

it its 0 then it runs the "Oh no its gone wrong code"


Thanks again for ya help.

hiiiiiiiiiiiii
i think u need to check the query again.i think some problem in query.
after query u can check query.weather query is empty or not this can be done by using mysql_num_rows

i hope this will help u

thanks