[landboy]

Hello,
When i use this code to try to get all info from an ib forum member field it doesn't work.
I need it to check to make sure the user has 5 or more posts and exculty has an account

In IB i need to add "s around the name
SELECT * FROM ibf_members WHERE name="MyNameHere"
that works (in the ib toolbox) but It doesn't work in the script.

PHP Code:

$connect = mysql_connect(localhost,forummaste_forum,forum) or die(mysql_error());

$db = mysql_select_db(forummaste_forum,$connect) or die(mysql_error());



$select = "SELECT * FROM ibf_members WHERE name="$ForumUser";

$query = mysql_query($select) or die(mysql_error());

$num = mysql_num_rows($query);



if (!$num = 1) {

    print "Error Forum Username Doesn't Excist";

    exit;

} 

Please Help

[kvnband]

I'm no pro, but shouldn't

PHP Code:

if (!$num = 1) 

be

PHP Code:

if($num != 1) 

?

I'm pretty sure that it should be.

[kvnband]

OH, and when defining the variable in the SQL query, it should be (I think)

PHP Code:

$select = "SELECT * FROM ibf_members WHERE name=$ForumUser"; 

or

PHP Code:

$select = "SELECT * FROM ibf_members WHERE name='ForumUser'"; 

If you want to have " inside of ", you have to escape them with a backslash

PHP Code:

echo "Hello what's up?  \"Get away from me!\""; 

Hope I haven't confused you, because I think I confused myself

Try that and get back to us. OH, and please let us know what errors you are getting (if any)

Kevin

[landboy]

What i need to do is add "s (double quotes) around the variable $ForumUser so the vaule is
"Blah" insted of just Blah is there a function or a way to accomplishing this without having to go deep into coding.
Thanks,

[infinitylimit]

Not that kevin gave you bad information but there is just a quicker more effecient way to do this.

PHP Code:

$select = "SELECT * FROM ibf_members WHERE name=".$ForumUser; 



// should be



$select = 'SELECT name FROM ib_members WHERE name="'.$ForumUser.'"'; 

Unless your going to be using $num later you also don't need to assigned a variable.

Also you might want to take your uid and pwd our of the mysql_connect.