Search For num rows with the same value as a cookie.

JoshHendo

Hello. I have tried to make a mysql query to search a field for the valu in a cookie and to return the result as a number. I have tried this with lots of other cookies, including post cookies, and it worked fine. If anyone would be able to tell me exactly what i should do that would be great! 🙂

(If you need more info just ask, though i have changed the script around a bit to test different things)

nemonoman

Can you please clarify your question? As stated it makes very little sense to me??

JoshHendo

I want to make a sql command to search for any row that contains the value that a cookie that i have made. Then i want that query to return the number of rows that have that value. (Sorry if i am repeating myself again and again 😛)

laserlight

You're probably looking for something like:
SELECT COUNT(*) FROM tablename WHERE colname='value';

JoshHendo

This is what i have so far:

It is for a login script, so it is to check if the value of 2 cookies is the same as in the database, and that there is only 1, so if it is all correct it will return 1, that is if it worked the way i wanted it to. If say i had a form and it was sent to this page, and i put $username (global variable for the form name) where $_cookie['somethinghere'] was, it would work, though with the cookie it doesn't seem to.

$result = mysql_query("SELECT * FROM users WHERE username = '$_cookie["cookiename"]' AND password = '$_cookie["cookiepassword"]'");

$user = mysql_num_rows($result);

if ($user == "1")
{
echo ('You are logged in');
}
else
{
echo ('You are logged out');

laserlight

You should use $COOKIE, not $cookie.

JoshHendo

Guess I will have to get used to php been case sensitive 🙂

nemonoman

JoshHendo wrote:
Guess I will have to get used to php been case sensitive 🙂

You will also need to get used to the fact that this syntax:

" '$_cookie["cookiepassword"]'"

isn't going to work.

Before the query set a variable to the value of $_cookie["cookiepassword"]

$password=$_cookie["cookiepassword"];

THEN use that variable in the query:

("SELECT * FROM users WHERE password= '$password' ");

There are other ways to do this, of course. Just not the approach you are using, which will fail.