[prasanth]

Hi ,

i am using php based one helpdesk tool i need to modify that tool in that
i am using two tables users,incident

when all user information will be in users table, but i need fetch inceident table details indexed by the users table login name
this is the php and query sample

PHP Code:

if (!@mysql_select_db("helpcore", $link)) {

     echo "<p>There has been an error. This is the error message:</p>";

     echo "<p><strong>" . mysql_error() . "</strong></p>";

     echo "Please Contact Your Systems Administrator with the details";

}



/* Passes a Query to the Active Database */

$sql1 = mysql_query("SELECT users.id FROM users WHERE (users.loginname='$myusename')");



$result = mysql_query("SELECT incidents.id, incidents.description, users.firstname, users.surname, users.loginname FROM incidents,users WHERE (incidents.owner_id = users.id) OR  (incidents.contact_id = '$sql1')"), $link);



if (!$result) {

  echo("<p>Error performing query: " . mysql_error() . "</p>"); 

my requerement is when user login that information will store $myusername variable , as per that login name i need to fetch other information from incedints table

[blinn_shade]

Try writting your query like this:

PHP Code:

$sql1 = mysql_query("SELECT users.id FROM users WHERE loginname='".$myusename."'");
$row = mysql_fetch_array($sql1);
$result = mysql_query("SELECT in.id, in.description, u.firstname, u.surname, u.loginname FROM incidents AS in,users AS u WHERE (in.owner_id = u.id OR in.contact_id = '".$row['column_name']."')"), $link); 

Replace $row['column_name'] with the actual column name but keep it in the $row array variable.

[End User]

I'm always curious about this....

Why not just write:

Code:

$sql1 = mysql_query("SELECT users.id FROM users WHERE loginname='$myusename'");

instead of:

Code:

$sql1 = mysql_query("SELECT users.id FROM users WHERE loginname='".$myusename."'");

[blinn_shade]

Because in the program I use It makes the variable stand out and I can spot it quicker. See in the code above it stands out?