Query question !!!

iam building web site PHP and  mySQl
i use dream weaver

i want to make a query using dream weaver to catch memebers from data base where "user_level" = "admin" OR "memeber"


but the wezard only give me one option to chose

i have to chose only "admin" or "member"

hot to modify this so i can co=hose both admin and memeber


thanks experts

FLAASHER

LVL 13
FLAASHERAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jason C. LevineConnect With a Mentor No oneCommented:
$query_rsMemeber = "SELECT user_id, user_fullname, user_takhasos, user_khebra FROM users WHERE user_level = 'member' OR user_level = 'admin'";

0
 
Jason C. LevineNo oneCommented:
Hi FLAASHER,

Just modify the SQL in code view to add the OR clause.

If you post the PHP, I can show you exactly what I mean.
0
 
FLAASHERAuthor Commented:
here is th code :


<?php

mysql_select_db($database_flashawy, $flashawy);
$query_rsMemeber = "SELECT user_id, user_fullname, user_takhasos, user_khebra FROM users WHERE user_level = 'member'";
$rsMemeber = mysql_query($query_rsMemeber, $flashawy) or die(mysql_error());
$row_rsMemeber = mysql_fetch_assoc($rsMemeber);
$totalRows_rsMemeber = mysql_num_rows($rsMemeber);
?>



here is the problem :

WHERE user_level = 'member'


i want it member or admin ..... not member only


FLAASHER
0
 
FLAASHERAuthor Commented:
Thanks jason

0
 
Jason C. LevineNo oneCommented:
No problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.