Trying to select a username but..

Oni

Hello,

A little problem I've run into...

$result = mysql_query($query);
if (mysql_fetch_row($result))
{
$search= "SELECT User FROM users where ip = '$ip'";
$resultt = mysql_query($search);
Print $resultt;

}
else
....

I get this as output:

Resource id #4

Thanks 😉

jami3

Can you post your whole script or atleast most of it as you call vars there that are not in your snippet. Thanks
Jamie

Oni

Yup,

<?php
/* establish a connection with the database */
$server = mysql_connect("localhost", "anonsurf",
          "psw");
if (!$server) die(mysql_error());
mysql_select_db("anonsurf_login");

$ip = getenv('REMOTE_ADDR');

/* SQL statement to query the database */
$query = "SELECT * FROM ip WHERE ip = '$ip'";

/* query the database */
$result = mysql_query($query);


if (mysql_fetch_row($result))
{
$search= "SELECT User FROM users where ip = '$ip'";
$resultt = mysql_query($search);
Print $resultt;

}
else
  Header("Location: --");

mysql_close($server);  

?>

bpat1434

Because, mysql_query() will always return a Resource ID. If you want to get the "User" field out of it, then you need to do this one little line:

list($user) = mysql_fetch_array($resultt);

Then, that variable will hold whatever value "User" has in the database.

You could also do: [man]mysql_result/man

~Brett

Weedpacket

I don't see what the point of this is:

$query = "SELECT * FROM ip WHERE ip = '$ip'";

/* query the database */
$result = mysql_query($query);


if (mysql_fetch_row($result))
{
$search= "SELECT User FROM users where ip = '$ip'";

You do a query, and if it succeeds, you do another query that asks for less information. The second query literally tells you nothing you don't already know.

$query = "SELECT user FROM ip WHERE ip = '$ip'";
/* query the database */
$result = mysql_query($query);
if ($row=mysql_fetch_array($result))
{
	list($user) = $row;
	print $user;
}
else
{
	header('Location: --');
}

Oni

It works, Thanks 😉

The code is actually so that it checks if the IP number is already in the database which means that the user is logged in. So, if the IP is in the database then it doesn't show the login form, rather, a "$user Logged In" Form...

Weedpacket

But if the IP is not in the database, then you'll find that out when you select the IP number from the database: you'll get an empty result set. Trying to select a record and then if you succeed trying to select the same record again just sounds like a waste of time and effort.