Driving me maaaaadddd!

[wudz]

Hi,
I am a Newbie to PHP and SQL so all help and explaination would be greatfully received.

Please could anyone please tell and show me what I have done wrong with the script below...I have tried all combinations, I get no errors, but neither do I

get any result.

I have hard written the email query address to match one of the many email addresses in the Table to cut down on problems. The mySQL table (AUCTION_invitedbuyerslist) contains list_name (email address),user_id (intro id number).

The list_name column is set as PRIMARY ...should it be INDEX?

Anyway, it will not retrive the user_id...arrrrgghhh

//get intro users id

        $query = "SELECT user_id from AUCTION_invitedbuyerslist where list_name = '[e-mail]'";
         $res = mysql_query($query);
             if(!$res) {
	         MySQLError($query);
	         exit;
          }

        $intro_id = $res;[/B]

Many thanks in anticipation

John 🙂

[devinemke]

mysql_connect('host', 'username', 'password') or exit(mysql_error());
mysql_select_db('dbname') or exit(mysql_error());

$result = mysql_query("SELECT user_id from AUCTION_invitedbuyerslist WHERE list_name = '[e-mail]'") or exit(mysql_error());
$intro_id = mysql_result($result, 0);

[wudz]

Hi,

Cheers for the script, ran it and same problem...knowing you would be right my thinking cap went on again and relised that when testing I did not drop the site, logged in as intro user then registered in as new user pre cookie, so the script picked up the wrong id from the header....Re-tested, but dropped the site after recomending new user.....worked great...left your script in, much neater.. 😉

Thanks for the prompt reply, very much appreciated..

Cheers

John 🙂