passing parameters

tito

I am unsuccessfully trying to post some parameters into mysql using

http://site.com/log.php?username=thename&status=1

contents of log.php:

<?php
$username= $GET['username'];
$status= $GET['status'];
$ip= $_SERVER['REMOTE_ADDR'];
require ("logconfig.php");

mysql_connect($host,$user,$pass);

@mysql_select_db($database) or die( "Unable to select database");

mysql_query('UPDATE sessions set status="0", username="" WHERE username=$username');
mysql_query('UPDATE sessions set status="1", username=$username WHERE ip=$ip');
?>

but nothing is happening... what is missing please?

goldbug

You're not quoting $username and $ips in the second query, and $username in the first query.

tito

no that's not it...

goldbug

what does mysql_error() say?

tito

there are no errors, it just isn't updating the info

goldbug

Try echoing your sql statements, to look for possible statement issues. Sometimes you'll find missing info there.

tito

The sql statement is fine, it's just not grabbing the info from the http page. When I replace the values with actual value, it works

goldbug

Well, aside from the fact that you aren't quoting the username in your sql statement (you really should), I can't see anything that strikes me as invalid in what you've got. Maybe someone else sees something.

tito

this is really a mystery. The echo shows that the files are being grabbed, but mysql is not inserting them

<?php
$username=$GET['username'];
$status=$GET['status'];
$ip=$_SERVER['REMOTE_ADDR'];
require ("logconfig.php");
mysql_connect($host,$user,$pass);

@mysql_select_db($database) or die( "Unable to select database");
mysql_query('UPDATE sessions set username="", status="0" WHERE username="$username"');
echo "emptying previous session...<br>";
mysql_query('UPDATE sessions set username="$username", status="1" WHERE ip="$ip"');
echo "inserting $username into new session...<br>";
echo "$ip<br>";
echo "$username<br>";
echo "$status";
?>

devinemke

your quotes are scewing up your query, try this

mysql_query ("UPDATE sessions set username='', status='0' WHERE username='" . $username . "'");

mysql_query ("UPDATE sessions set username='" . $username . "', status='1' WHERE ip='" . $ip . "'");

tito

that worked... thanks

tito

after using the above query, I then get the info from table to display on site. I have usernames and numbers_and_alpha__as_usernames. All those numbers_and_as_usernames have one thing in common: they all start with the '-' (minus sign) in front of them. I am trying to tell the query that all those numbers should be viewed as 'a timecode user' instead of:

bleed, yuny, johnn, -7CWLWP6V6X

so I could segregate later one and put 'x members, and x timecode users'

How do I translate that so the below bold justifies itself?

<?php

$c=0;
$username="";
require ("logconfig.php");

mysql_connect($host,$user,$pass) or die(mysql_error());

@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query('SELECT username FROM sessions WHERE status="1"');
$result2 = mysql_query('SELECT username as count FROM sessions WHERE status="1" and username<>"a timecode user "');
$d=mysql_num_rows($result2);
if ($d==0)
echo"";
if ($d==1) .....

devinemke

$result2 = mysql_query ("SELECT username as count FROM sessions WHERE status='1' and username REGEXP BINARY "^[-]");