jak pokazac wynik funkcji mysql w php ?

Article View: pl.comp.lang.php

Article #220389

#220389

From: dziobacz
Date: Sat, 29 Aug 2009 08:56

19 lines
1561 bytes

W php my adminie zrobilem funkcje:

DROP FUNCTION IF EXISTS fun;
DELIMITER $$

CREATE FUNCTION fun(zmienna INT) RETURNS INT
BEGIN
DECLARE x INT;
SET x = zmienna;
SET x = x+1;
RETURN x;
END


Jak ja teraz w php wywolac - robilem cos takiego:
$query = mysql_query("select fun(5)") or die ("cos jest zle");
echo $query;

ale dostaje: Resource id #3

Technical Details

Message-ID: <49fe46a5-98c4-41e4-a802-6a167c87be94@r34g2000vba.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r34g2000vba.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r34g2000vba.googlegroups.com!not-for-mail
From: dziobacz <aaabbbcccdaabb@gmail.com>
Newsgroups: pl.comp.lang.php
Subject: jak pokazac wynik funkcji mysql w php ?
Date: Sat, 29 Aug 2009 01:56:46 -0700 (PDT)
Organization: http://groups.google.com
Lines: 20
Message-ID: <49fe46a5-98c4-41e4-a802-6a167c87be94@r34g2000vba.googlegroups.com>
NNTP-Posting-Host: 89.77.157.71
Mime-Version: 1.0
X-Trace: posting.google.com 1251536206 15142 127.0.0.1 (29 Aug 2009 08:56:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 29 Aug 2009 08:56:46 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r34g2000vba.googlegroups.com; posting-host=89.77.157.71;  posting-account=FTpwKgoAAABWuTKca1o8YbX_ip78wnH2
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.1.2)  Gecko/20090729 Firefox/3.5.2 (.NET CLR 4.0.20506) FirePHP/0.3,gzip(gfe),gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit