Stored functions, (how to check num_rows())

[neller]

Hi,

 

Say I had the following stored function (just a quick demo it does nothing)

 

BEGIN
  SELECT `name` FROM `customers` WHERE `name` = var_name
END

 

How would I check within a procedure how many rows where returned? so if > 0 I can run another query within the function, for example (and this obviously wont work)

 

BEGIN
  SELECT `name` FROM `customers` WHERE `name` = var_name
  IF > 0  another query here
END

 

thanks in advance

 

ps... alternatively if anybody knows a good tutorial / book on things like the above #i'm more than happy to find it myself.

[ram4nd]

http://php.net/manual/en/function.mysql-num-rows.php and use the same query.

[Mchl]

http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows

[neller]

Thanks guys, I will check out both those links to see if they solve my problems.

[Mchl]

If you want to do it in stored routine, I suggest you start with MySQL's docs