Simple Mysql statement

I have the following code :

$userp = mysql_query("SELECT users.*, users_profile.*, users_theme.* FROM users, users_profile LEFT JOIN users_theme ON(

WHERE[url removed, login to view] AND [url removed, login to view] = '".$member."'");

$userp = mysql_fetch_assoc($userp);

$smarty->assign('userp', $userp);

This code works fine , however there is a field in the users table I want to include in this statememnt. The field is user_group and has a single digit numerical value .

I want to be able to use the following code with the above corrected statement :

{if $userp.user_group != '2'} do something {/if}

If needed a new variable can be assigned as long as it is capturing the value of table user , field user_group .

I need this literally in an hour , for a good mysql guy this should take less than 5 min .

Habilidades: PHP

Veja mais: mysql smarty, mid, php mysql join table, mysql join table, mysql select statement, mysql table join, php hour min, capturing, mysql users, mysql user, mysql member, works join, variable mysql, simple use, php guy needed, php simple works, mysql join, code variable, php mysql statement, mysql statement, single use code php, smarty php code, php mysql table join, code simple, username following

Acerca do Empregador:
( 17 comentários ) shelby township, United States

ID do Projeto: #165662

Concedido a:


Hi, See pm

$30 USD em 0 dias
(14 Comentários)

4 freelancers estão ofertando em média $50 para esse trabalho


Five minute work for me.

$50 USD in 0 dias
(5 Comentários)

here i'm! carlo italy

$80 USD in 0 dias
(2 Comentários)

Hi, Please check you PM, Thanks

$40 USD in 0 dias
(6 Comentários)