"Adam Alkins" <[EMAIL PROTECTED]> wrote on 07/13/2002 07:56:46 PM:
> > I have a database, all the data is numbers. I want to make a query that > > will extract the data and then make it available in an array, so the > > array is populated 'real-time'. I could just enter the number into an > > array manually, but I want to automate the job. I don't know what to > > start looking for, the 3 books I have either don't talk about this or I > > just am missing it. > > Could someone point me in the right direction? > Well after you SELECT the data and run the query, you can use a few > functions, it depends on your database type? > For example, for MySQL, you can use mysql_fetch_array() which will take your > data and store it in an array, both numeric and associative. > i.e. $data = mysql_fetch_array($result) can be accessed like > $data['column_name'] > $data[column_number] > You can also fetch an array only as an associative (mysql_fetch_assoc) or > numeric (mysql_fetch_row). And simply if selecting multiple rows, use a loop > while($data = mysql_fetch_array())... > -------------- > Adam Alkins I guess I wasn't very clear on exactly what results I expect. I can get the data and print all the numbers, that's no problem. What I want is to have all the numbers inserted into an array that would look like this: $datax = (50,50,50,60,60,60,70,70,70,65,65,70,75,75,80); Each number in the array is from a single row in the table (15 rows in this example). The database is weights, entered after a work-out, along with their reps. I only need the weights, as shown above. This array $datax is then processed by a php script to create a graph showing the progress of the person's wieght lifting over time. I can enter all the numbers into the array manually and the graph is drawn correctly, but prefer the web interface I made. This is okay for me, but not others. So, I made a web form that takes the data and inserts into the database. That works fine also. The table contains columns: squats, squats_reps, legpress, legpress_reps, etc etc. The first is the weight and the second is the number of reps. So after each workout the appropriate numbers would be entered via the form page, the graph would be generated with the updated numbers from another page. Hope this helps to explain it a bit better, -- Chip > http://www.rasadam.com > -------------- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php