WordPress.org

1. mattskills
   Member
   Posted 6 months ago #

   Hi,

   I am trying to query a table using the post title of the current post. the dj username will be the same as the post title, Can anybody help me with the right query to make $username = the current post title.

   <?php
   	$username = !!!!!!!!!!!!!!!
   $data = mysql_query("SELECT * FROM users WHERE username='$username'")
   or die(mysql_error());
    while($info = mysql_fetch_array( $data ))
   
    print "".$info['djbio'] . "";
   
   ?>

   Thanks,
   Matt

2. vtxyzzy
   Member
   Posted 6 months ago #

   If the code you showed is inside the Loop, this should work:

   $username = $post->post_title;

3. mattskills
   Member
   Posted 6 months ago #

   That worked , Thanks :)

Reply

You must log in to post.