[Resolved] passing varibles in a query

[adi5402]

Ok iv got this query and If i try passing a varible in the way below it fails to come up as the result.

 $query ='SELECT `Email` '
        . ' FROM `user_info` '
        . ' WHERE `Email` = \'.$user_name.\' AND `pass` = \'.$passw.\' LIMIT 0, 30';

where if i check the varibles with an echo the results im gettign is good also if i put the varibles directly into the uquery it works fine with the code below.

 $query ='SELECT `Email` '
        . ' FROM `user_info` '
        . ' WHERE `Email` = \'[e-mail]\' AND `pass` = \'footbal\' LIMIT 0, 30';

can some one see a error in the first one becuse i am really looking for somehting that gives me

mysql_num_rows($result) == 1

N/a I have set my password to have a fulltext property and its size is 7 digits can some one explain to me what fulltext means.

[eoghain]

$query ='SELECT `Email` '
        . ' FROM `user_info` '
        . ' WHERE `Email` = `'.$user_name.'` AND `pass` = `'.$passw.'` LIMIT 0, 30';

If you look at your second example you have surrounded your email address and password with quotes (because they are strings), but in your first example the variables aren't surrounded with quotes, this will cause your query to not work. Above is correct.

[adi5402]

Unknown column '[e-mail]' in 'where clause' where [e-mail] is the e-mail Id in the database

[eoghain]

Sorry I was using your example, which was using back ticks. OOps.

$query ='SELECT `Email` '
        . ' FROM `user_info` '
        . ' WHERE `Email` = "'.$user_name.'" AND `pass` = "'.$passw.'" LIMIT 0, 30';

[adi5402]

that worked thanks alot so basicly u stuck them in small sections of " quotes to make them look like strings but then the '' help single them out i think im getting the hang of this thanks again