Re: [PHP] mysql functions

2004-02-10 Thread John W. Holmes
From: "Angelo Zanetti" <[EMAIL PROTECTED]> > I have a query which returns only 1 row, which of the following would be the > best to get the value from the resultset: > > mysql_result() > mysql_fetch_field() > mysql_fetch_row() > > the resultset only returns 1 column, so basically its only 1 field

RE: [PHP] mysql functions

2004-02-10 Thread Hamid Hossain
Use mysql_result and u can use mysql_fetch_object, mysql_fetch_array also. The following example will show u how to do it with mysql_result which will retrive one row only. From PHP Manual: $result = mysql_query("SELECT name FROM work.employee") or die("Could not query: . mysql_er

RE: [PHP] MySQL Functions Setup

2003-01-23 Thread Steven Balthazor
I am guessing that you installed the php from a redhat rpm; if so then you just need to install the php-mysql rpm. You can download from: http://rpmfind.net//linux/RPM/redhat/8.0/i386/php-mysql-4.2.2-8.0.5.i386.htm l (or any of a number of other places). Cheers, Steven Balthazor -Original