|
|
Posted by Pedro Graca on 06/15/23 11:37
sam.s.kong@gmail.com wrote:
> I've been programming ASP for 5 years and am now learning PHP.
> In ASP, you can use GetRows function which returns 2 by 2 array of
> Recordset.
> Actually, it's a recommended way in ASP when you access DB as it
> disconnects the DB earlier.
> Also, it's handy as you can directly access any data in the array
> without looping.
>
> As far as I know, there's no such function in PHP and I can make one.
> My question is whether it's good in PHP.
>
> pseudo-code:
>
> $data = get_data("select * from table1");
> $var = $data[3][2]; //value at 4th row, 3rd column
You can easily access the returned resource as a kind of array with
$result = mysql_query("select * from table1");
$var = mysql_result($result, 3, 2);
If you choose to put all returned data into a "proper" array, don't
forget to
mysql_free_result($result);
--
If you're posting through Google read <http://cfaj.freeshell.org/google>
Navigation:
[Reply to this message]
|