TalkPHP - View Single Post - [PHP/MySQL] Pulling Multiple Rows *Solved*

Andrew · 10-19-2007, 01:39 AM

Solved. I'm an idiot, I forgot the most basic thing. :)

I haven't touched PHP in a while, and forgot most of the basics, which I'm going over by making small scripts at the moment. However, I'm stuck.

I have a MySQL database with 2 rows, each having 3 fields. What I'm trying to do, is get a resulting array from a query which will hold information from both rows, which are in the same field.

---------------------
| id | name | age |
---------------------
| 1 | Sally | 14 |
---------------------
| 2 | Mark | 13 |
---------------------

What I need, is to get for example, "Sally" and "Mark" in the same array so from there I can pull them apart and manipulate them for my objective.

How can I do this?

10-19-2007, 01:39 AM	#1 (permalink)
Andrew The Acquainted Join Date: Sep 2007 Location: Arizona Posts: 114 Thanks: 10	[PHP/MySQL] Pulling Multiple Rows Solved Solved. I'm an idiot, I forgot the most basic thing. :) I haven't touched PHP in a while, and forgot most of the basics, which I'm going over by making small scripts at the moment. However, I'm stuck. I have a MySQL database with 2 rows, each having 3 fields. What I'm trying to do, is get a resulting array from a query which will hold information from both rows, which are in the same field. --------------------- \| id \| name \| age \| --------------------- \| 1 \| Sally \| 14 \| --------------------- \| 2 \| Mark \| 13 \| --------------------- What I need, is to get for example, "Sally" and "Mark" in the same array so from there I can pull them apart and manipulate them for my objective. How can I do this?