mysqli problem

[sarahA]

I'm a bit behind when it comes to mysqli, and so just starting to convert over to using it. I've got a script however that just doesn't want to work and either throws up a 500 error or gives the wrong result.

Code:

$sql = $mysqli->query("SELECT dateid FROM thedates WHERE bdate = '".$thedate."' AND userid = ".$userid." LIMIT 1");
if ($sql->num_rows()) :
$sql2 = $mysqli->query("UPDATE thedates SET value = '".$status."', cvalue = '' WHERE bdate = '".$thedate."' AND userid = ".$userid." LIMIT 1");
else :
$sql2 = $mysqli->query("INSERT INTO thedates (userid, bdate, daytime, value) VALUES (".$userid.", '".$thedate."', 1, '".$status."')");
endif;

I simply want to say, does a record for this date and userid exist, if so, update it, else insert it. I'm trying to get the insert part to work. Using $sql->num_rows() says it's undefined. I've also tried:

Code:

if ($mysqli->query("SELECT dateid FROM thedates WHERE bdate = '".$thedate."' AND userid = ".$userid." LIMIT 1")) :

which always gives true, so only tries to update.

Anyone know what I'm doing wrong?

[sarahA]

Altered the code a bit and it seems to work, although still not sure why num_rows() just gave an error all of the time

Code:

$sql = $mysqli->query("SELECT COUNT(dateid) FROM thedates WHERE bdate = '".$thedate."' AND userid = ".$userid." LIMIT 1");
$count = $sql->fetch_row();
if ($count[0]) :

[JasonD]

num_rows is a property, not a method.

[sarahA]

Ahhh d'oh   am used to mysql_num_rows() I just didn't pay attention enough, despite reading and re-reading the PHP manual page on num_rows over and over.

Thanks Jason