www.webdeveloper.com
Results 1 to 2 of 2

Thread: Problem obtaining resultset from stored procedure

  1. #1
    Join Date
    Feb 2009
    Posts
    26

    Question Problem obtaining resultset from stored procedure

    I have a procedure
    Code:
    CREATE PROCEDURE GET_PAGES()
    				BEGIN
    					select page as page,page_url as url, count(*) as visits from pages_log group by page order by visits desc;
    				END
    on mysql 5.x
    when i call procedure from php
    PHP Code:
    $con=mysql_connect('localhost','root','');
    $result=mysql_query("call GET_PAGES()",$con); 
    i do not get any resultset in $result
    i am new to php please help
    //
    I also want to know what is mysqli
    please help
    Last edited by spsarolkar; 06-13-2009 at 02:51 AM.

  2. #2
    Join Date
    Feb 2009
    Posts
    26

    Exclamation

    is there any other way of doing it,
    when i type from commend prompt as
    Code:
    mysql>call GET_PAGES();
    i get the output why php can't get it???

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles