[SOLVED] Help me with php sql..

[plznty]

<?php
include("include/data.php");
if ($_COOKIE[user] == ($username) && $_COOKIE[pass] == md5($password)) {
include("include/config.php");
$query="SELECT * FROM logs";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
echo "<center><font color='#FFFFFF'><b>Logs</b><p>";

$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$username=mysql_result($result,$i,"username");
$password=mysql_result($result,$i,"password");
$logger=mysql_result($result,$i,"logger");

echo "Username: $username<br>Password: $password<br>Logged by: $logger<br>";

$i++;
}

}else{
echo '<META HTTP-EQUIV="Refresh" CONTENT="0; URL=index.php">';
}
?>

 

I want it so that if $logger is equal to the login username then display.

If not do not display anything.

[MadTechie]

HUmmmmmm

you want

IF $logger is equal to (==) the $username then display(echo)!

So

if($logger==$username)
{
echo "something!";
}

[plznty]

I fort that would work but now it only posts "something!" if the logger is not the username.

Could someone add me on msn or something so i can discuss this, ill pay a small fee

[MadTechie]

This code is cleaner

 

no point finding a all records if you only want to display some

<?php
include("include/data.php");
if ($_COOKIE['user'] == ($username) && $_COOKIE['pass'] == md5($password))
{
include("include/config.php");
$query="SELECT * FROM logs WHERE username=logger";
$result=mysql_query($query);
$num=mysql_num_rows($result);
echo "<center><font color='#FFFFFF'><b>Logs</b><p>";
$i=0;
while ($i < $num)
{
	$id=mysql_result($result,$i,"id");
	$username=mysql_result($result,$i,"username");
	$password=mysql_result($result,$i,"password");
	$logger=mysql_result($result,$i,"logger");
	echo "Username: $username<br>Password: $password<br>Logged by: $logger<br>";
	$i++;
}
mysql_close();
}else{
echo '<META HTTP-EQUIV="Refresh" CONTENT="0; URL=index.php">';
}
?>

[plznty]

<?php
include("include/data.php");
if ($_COOKIE['user'] == ($username) && $_COOKIE['pass'] == md5($password))
{
   include("include/config.php");
   $query="SELECT * FROM logs WHERE username=logger";
   $result=mysql_query($query);
   $num=mysql_num_rows($result);
   echo "<center><font color='#FFFFFF'><b>Logs</b><p>";
   $i=0;
   while ($i < $num)
   {
      $id=mysql_result($result,$i,"id");
      $username=mysql_result($result,$i,"username");
      $password=mysql_result($result,$i,"password");
      $logger=mysql_result($result,$i,"logger");
      echo "Username: $username<br>Password: $password<br>Logged by: $logger<br>";
      $i++;
   }
   mysql_close();
}else{
   echo '<META HTTP-EQUIV="Refresh" CONTENT="0; URL=index.php">';
}
?>

I need it to display the logs on the database where $logger is equal to the login username.

[MadTechie]

change

$query="SELECT * FROM logs WHERE username=logger";

to

$query="SELECT * FROM logs WHERE logger='$username' ";

[plznty]

change

$query="SELECT * FROM logs WHERE username=logger";

to

$query="SELECT * FROM logs WHERE logger='$username' ";

That looks about right, but i get an error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\web\PHISHER-V2\phisher\admin\logs.php on line 8

Help?

[JasonLewis]

Make this:

$result=mysql_query($query);

 

This:

$result=mysql_query($query) or die(mysql_error());

[plznty]

Okay it works now!

Thanks everybody.