mysql_query( "CALL... multiple results

Posted by bradenkeith on Stack Overflow See other posts from Stack Overflow or by bradenkeith
Published on 2010-03-24T14:50:40Z Indexed on 2010/03/24 14:53 UTC
Read the original article Hit count: 151

Filed under:
|
|

I am tapping into a service that provides zip codes tax information - there service is a bit shakey, so I want to copy their database over and run the results off my own server while using their service to just update my table. However I'm not sure I'm able to loop through multiple results with this query:

mysql_query( "CALL zip2tax.z2t_lookup('" . $strZipCode . "','" . $strUserName . "', '" . $strUserPassword . "')" )

I've tried setting $strZipCode to *. However I get an error from the database.

I read on MySQL that mysql_next_result should be the solution, however I'm unsure how to properly implement that.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql