PHP Forum

**melefire** · 04:47 PM

Ok here is the script:

PHP Code:


			
<?
$username="troop439_wiki";
$password="wiki";
$database="troop439_wiki";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM wiki_users";
$result=mysql_query($query);

$num=mysql_num_rows($result);

mysql_close();

echo "<b><center>Users In Database</center></b><br><br>";

$i=0;
while ($i < $num) {

$id=mysql_result($result,$i,"user_id");
$name=mysql_result($result,$i,"user_name");
$qwt=mysql_result($result,$i,"user_real_name");
$xmt=mysql_result($result,$i,"user_password");
$zzz=mysql_result($result,$i,"user_newpassword");
$zmw=mysql_result($result,$i,"user_newpass_time");
$flk=mysql_result($result,$i,"user_email");
$flk1=mysql_result($result,$i,"user_options");
$flk2=mysql_result($result,$i,"user_touched");
$flk3=mysql_result($result,$i,"user_token");
$flk4=mysql_result($result,$i,"user_email_authenticated");
$flk5=mysql_result($result,$i,"user_email_token");
$flk6=mysql_result($result,$i,"user_email_token_expires");
$flk7=mysql_result($result,$i,"user_registration");
$flk8=mysql_result($result,$i,"user_editcount");



echo "<b>$id | $name</b>";

$i++;
}

?>

and when it runs i get:

Code:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/********/public_html/displayusers.php on line 11

**stewart** · 10-31-2007, 05:01 PM

Well that means that your query string is incorrect.

$query="SELECT * FROM wiki_users";

I dont really see much wrong with it unless you simply do not have a table named wiki_users.....

$query="SELECT * FROM `wiki_users`;";

That is about all i can suggest to do ^

**solomongaby** · 10-31-2007, 05:35 PM

try

Code:

 $result=mysql_query($query) or die ('SQL error: '.mysql_error());

**melefire** · 11-01-2007, 02:26 PM

thanks for replies
but now after i made some more changes, when trying to select only certain data from the database it does not work.
New script:

PHP Code:


			
<?

$username="troop439_wiki";

$password="wiki";

$database="troop439_wiki";

$search=$_POST['searchname'];



mysql_connect(localhost,$username,$password);

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

$query="SELECT * FROM `wiki_user` WHERE user_name=$search;";

$result=mysql_query($query) or die ('It apears the user does not exist: '.mysql_error());

$num=mysql_num_rows($result);



mysql_close();



echo "<b><center>Users In Database</center></b><br><br>";



$i=0;

while ($i < $num) {



$id=mysql_result($result,$i,"user_id");

$name=mysql_result($result,$i,"user_name");

$qwt=mysql_result($result,$i,"user_real_name");

$xmt=mysql_result($result,$i,"user_password");

$zzz=mysql_result($result,$i,"user_newpassword");

$zmw=mysql_result($result,$i,"user_newpass_time");

$flk=mysql_result($result,$i,"user_email");

$flk1=mysql_result($result,$i,"user_options");

$flk2=mysql_result($result,$i,"user_touched");

$flk3=mysql_result($result,$i,"user_token");

$flk4=mysql_result($result,$i,"user_email_authenticated");

$flk5=mysql_result($result,$i,"user_email_token");

$flk6=mysql_result($result,$i,"user_email_token_expires");

$flk7=mysql_result($result,$i,"user_registration");

$flk8=mysql_result($result,$i,"user_editcount");







echo "<b>$id | $name</b>";



$i++;

}



?>

Returns error

Code:

It apears the user does not exist: Unknown column 'testuser' in 'where clause'

i am sure that the user exists

**tripy** · 11-01-2007, 02:46 PM

it's because a text value (or string) must be encased between single quotes to let the db distinguish value and column.

PHP Code:


			
$query="SELECT * FROM wiki_user WHERE user_name='$search';";

**solomongaby** · 11-01-2007, 04:37 PM

try this code instead of you're while

Code:

while ($row = mysql_fetch_assoc($result)) {
    echo $row["userid"];
    echo $row["fullname"];
    echo $row["userstatus"];
}