Member Avatar for waveydaveywaves

i've successfully developed a page where i can echo a $_SESSION['SESS_MEMBER_ID'] and display the member id of a person who is logged in. however i need to display all the data of two mysql databases that are relational.

$sql = "SELECT * FROM `members`.`players` WHERE `member_id` = 3 LIMIT 0, 30 "this is the code i currently have;

I need to replace the "member_id" and the "3" to work with the $SESSIOn_Member_id by binding it to a variable and querying with it. can someone prepare this statement and revise my sql query and demonstrate the session binding to a varible?

Edited by mike_2000_17 because: Fixed formatting
  • 2 Contributors
  • 4 Replies
  • 152 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by waveydaveywaves
Member Avatar for hicman

would you rewrite your code without tags (only the sql command) I may help you :)

Member Avatar for waveydaveywaves

sorry didnt realize it would do that

query("SELECT * FROM `members`.`players` WHERE `member_id` = 3 LIMIT 0, 30 ";)

Member Avatar for hicman

once time the user is logged in, he has his own IDsession so you've just to replace member_id by $_SESSION then you got :

$reponse = $bdd->query("SELECT * FROM members,players WHERE ".$_SESSION['member_id']." = 3 LIMIT 0, 30 ";
$donnees = $reponse->fetch( );
echo $donnees['field1']; // display out your data
echo $donnees['field2'];
//....................
//....................
//....................
echo $donnees['field3'];
Member Avatar for waveydaveywaves

no theres no 3 in this coding, i need to have 3 replaced with a varible binded with session member_id. the member id is a one-one realational row in two separate tables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.