help with query

[pro_se]

I have a query that is looking up a users comments:
[code]<?php
  $uname = $_GET['name'];
$result = mysql_query("select * from comments where to=$uname");
while($r = mysql_fetch_array($result))
{
  $from=$r["from"];
  $msg=$r["msg"];
  $time=$r["time"];
  $date=$r["date"];
  echo "$msg<br />
      _{$from | $date | $time}
      <hr color=#B0B0B0 noshade=noshade size=1/>";
}
?>[/code]

and I keep getting an error like this: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/user.php on line 45

I have no idea what is wrong... maybe someone can help me?

[redarrow]

try this ok.
[code]
<?php

$uname = $_GET['name'];
$query="select * from comments where to='$uname'";
$result=mysql_query($query);

while($r = mysql_fetch_assoc($result)) {

   $from=$r["from"];
   $msg=$r["msg"];
   $time=$r["time"];
   $date=$r["date"];
   echo "$msg<br />
   _{$from | $date | $time}
   <hr color=#B0B0B0 noshade=noshade size=1/>";
}
?>
[/code]

[pro_se]

nope... same error... Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/user.php on line 53  ???

[redarrow]

post your findings ok.
[code]
<?php

$uname = $_GET['name'];
$query="select * from comments where uname='$uname'";

print_r($query);

$result=mysql_query($query);

while($r = mysql_fetch_assoc($result)) {

   $from=$r["from"];
   $msg=$r["msg"];
   $time=$r["time"];
   $date=$r["date"];
   echo "$msg<br />
   _{$from | $date | $time}
   <hr color=#B0B0B0 noshade=noshade size=1/>";
}
?>
[/code]

[pro_se]

select * from comments where uname='corey'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/user.php on line 56

[pro_se]

that is the right query... this is weird...

[redarrow]

what the table info please as i see no id

[pro_se]

id  to    from          ip                    msg                                  date        time
1 corey Nil Thacker 10.160.43.200 Testing the comment system... July 28, 2006 1:03

in a table called comments...

my address bar looks like: http://localhost/users.php?name=corey

[redarrow]

also show me the link to get to this page ok.

[redarrow]

are you using sessions

[pro_se]

no sessions... my address bar looks like: http://localhost/users.php?name=corey

its a comment system where anyone can comment

[redarrow]

add ip=ip in the link ok

post the findings

[code]
<?php
$ip = $_GET['ip'];
$uname = $_GET['name'];
$query="select * from comments where uname='$uname' and ip='$ip'";

print_r($query);

$result=mysql_query($query);

while($r = mysql_fetch_assoc($result)) {

   $from=$r["from"];
   $msg=$r["msg"];
   $time=$r["time"];
   $date=$r["date"];
   echo "$msg<br />
   _{$from | $date | $time}
   <hr color=#B0B0B0 noshade=noshade size=1/>";
}
?>
[/code]

[pro_se]

select * from comments where uname='corey' and ip='10.160.43.200'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/user.php on line 56

address bar: user.php?name=corey&ip=10.160.43.200

[redarrow]

add all the table in link and get ok

madness but might work some reason not working strange got me lol..................

[pro_se]

ahhh!!!!! it still does not work!!!!!!!! same error... wow...

link: user.php?name=corey&ip=10.160.43.200&time=1:03&date=July%2028,%202006

[redarrow]

try this for a min ok see if we can get somthink out lol ...........
[code]
<?php

$uname = $_GET['name'];
$query="select * from comments where uname='$uname''";

print_r($query);

$result=mysql_query($query);

while(list($key,$val)=each($result)) {

echo "$key  : $val ";

}
?>
[/code]

[redarrow]

ive got it haaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

your date is wrong should be 01-01-06

the format i mean ok.

hahaha


$date=date("d-m-y");
$time=date("h:i:s");

[pro_se]

dude... it was not that... i got it.... it was the name thing... for the $_GET.... i had it named wrong.... wow... im am a dummy...

[pro_se]

thanks for all ur help! :P

[redarrow]

ok mate good luck all the best