[SOLVED] Not a Valid MySQL result resource???

[refiking]

Heres what the script returns when ran:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/refiking/public_html/scripting/process.php on line 13

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/refiking/public_html/scripting/process.php on line 14

 

Here are line 12-14:

$sl =  mysql_query("SELECT * From tourney WHERE tid = '$tid' AND user = '$user'");
$fetch_em = mysql_fetch_array($sl);
$numrows = mysql_num_rows($sl);

 

[trq]

You failed to check your result before using it. The minimum syntax for a select should be...

 

<?php

$sql = "SELECT * From tourney WHERE tid = '$tid' AND user = '$user'";
if ($result =  mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    $fetch_em = mysql_fetch_array($result);
  }
} else {
  die(mysql_error() . $sql);
}

?>

[refiking]

OK Thanks.  I found the problem.  I don't have a user column in the table.  How can I search all the columns in the table for $user ?

[trq]

Surely you know which field holds your usernames?

[refiking]

Actually, this is a tournament script.  I am searching to see if the name is listed under this tournament id.  There are 32 different players, so I'd like to search to see if their name is listed under one of the 32 columns for players.  Is there a way to accomplish this?

[trq]

Sounds like a pretty poor db design, but yeah, you could execute.

 

SELECT * FROM tbl WHERE '$user' IN(fld1,fld2,fld3,fld4);

 

etc etc.