Em Andamento

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(users.id=users_theme.user_id)

WHERE users.id=[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

Ver 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

Premiar a:

bendriss

Hi, See pm

$30 USD em 0 dias
(14 Avaliações)
4.3

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

bewhite

Five minute work for me.

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

here i'm! carlo italy

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

Hi, Please check you PM, Thanks

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