Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
 
20.9.2014 - We have just updated our course layouts and descriptions and added our 2015 schedule.

Pulling data from a mySql table

Posted by Chris_Isaac (Chris Isaac), 5 August 2003
Hi  

I want to be able to pull off and print the colum names and values from a mysql table.  The program below gets the data out, but I have no way of being able to tell from the output what the colums was called.  The other problem is I have to tell it the number of colums to grab.  

Is there a way of grabing the entire row of values /column names straight into an array?  I did try substituting mysql_fetch_array for mysql_fetch_row, but it made no difference.

Thanks

Chris

Code:
<?php
$data=array();
$hot=$_GET[hid];
include ("/usr/home/limited.org.uk/data/standard.inc");

     sql_connect();
     $q = "Select * from hotel,locations where hotel.location = locations.id      and hid = $_GET[hid]";
     $res = mysql_query($q);
           while ($row=mysql_fetch_array($res)){
                 array_push($data,$row[0],$row[1],$row[2],$row[3]);
           }

foreach ($data as $current){
           print "data is $current<br>";
}

?>



Posted by admin (Graham Ellis), 5 August 2003
Mysql_fetch_assoc will return you an array of values for a row, with the elements keyed by the name of the field.  You can then use array_keys, array_walk, each, or something similar to step through each element.



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho