[SOLVED] problem with query

[dadamssg]

i just made a table to store attendance of people for an event

the table only is empty now and has three fields...

 

'eventid' int(11),

'username' varchar(20),

'choice' tinyint(1)

 

so now that ive created the table im trying to write a query that checks to see if  user has inputted a choice(yes or no) for an event.

 

heres my code

$cxn = mysqli_connect($host,$user,$passwd,$dbname)
          or die ("Couldn't connect");

$postid = $_GET["id"];

$username = $_SESSION['logname'];


$comquery = "SELECT * FROM test WHERE eventid = $postid AND username = $username";
$together = mysqli_query ($cxn,$comquery)
             or die (mysqli_error($together));

 

i get this error

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/inaggie1/public_html/showevent.php on line 42

 

i can NOT see what im doing wrong

 

[lonewolf217]

not sure if its the root of the problem or not, but I do not think you need $together in the error statement.  just use mysqli_error() and do you get the same error ?

[dadamssg]

hmmm im not real sure what i did...i just retyped and renamed the variables and eventually it worked  :-\

[corbin]

mysqli_error takes a link as an argument, not a query resource.  (When ever a query fails, FALSE is returned.)

 

 

So, $cxn should be used.