database query script

[imsoldiers]

im in need of some help coding a script for my needs.

so say i have some software that a user needs to enter there details (email address) are there email is checked against a database to see if they are a valid member.

when the user enters there email and click ok the software will go to a php script on my server to check if the user is active.

the url the software will go to looks like this

www.someurl.com/checkscript.php?email=[e-mail]

the php scripts needs to do this

get the value of email=

connect to the database

go to a table called members

check a column called email

see if the value of email= is there

if not echo "some error text"

if found check

check a column called member_group_id

if a value of 8 is found

echo or print "correct response software is looking for"

if another value is found

echo or print "some user not found text"

Im really hoping someone can help as im lost and kinda new to php

any help much appreciated

[imsoldiers]

This is what i have so far

<?php
$dbhost = 'XXXXXXXX';
$dbuser = 'XXXXXXXX';
$dbpass = 'XXXXXXXX';
$dbname = 'XXXXXXXX';

// Open Database Connection
mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);

if (!empty($_GET['action']) && !empty($_GET['email']))
{

$sql="SELECT * FROM members WHERE email='$email';

$result=mysql_query($sql);
$count=mysql_num_rows($result);

if($count==8) //if the user is found
{
	//username and password match
	$row = mysql_fetch_assoc($result);
	if($row['member_group_id'] == 3)
	{
		echo "No User Found";
}else{
		        echo "USER FOUND";
		}

} else {
	echo "NO USER FOUND";

}

}

?>

[NogDog]

You need a closing double quote on the line where you define $sql.

[imsoldiers]

Can you show me what you mean, I'm new to php and just trying to get to grips with it, thanks for your reply

[bradgrafelman]

You begin a string but never close it, hence why the color-coding is all wrong.

This string is never closed:

"Hello world!

yet this one is:

"Hello world!"

[NogDog]

I.e.:

$sql="SELECT * FROM members WHERE email='$email'[color=red][b]"[/b][/color];
                                                ^
                                                |