Re: help with print value

You're talking about a table in a database, correct? Assuming the database is MySQL, you would: 1. open a connection to the database 2. execute a SQL select statement to fetch the data 3. process the results, formatting them into HTML. There are a number of tutorials on doing this, but it's only a few lines of code: 1. Connect to the database: require( "dbname.inc" ); //stores your hostname, username and password outside the script. $db = mysql_pconnect("$host", "$user", "$pass") or die("Unable to connect to server"); 2. Create your query, usually done by first assigning it to a variable. That way, if you are not getting the results you want it's easy to echo the SQL to the screen: $sql = "SELECT month, day, value from sometable order by month, day"; // use your own field names in place of month, etc. $result = mysql_query($sql); // executes the SQL statement //echo $result . &nbsp;&nbsp; . mysql_num_rows( $result) . "<br>"; 3. test for and process the results. Here we assume a table displayed in the user's browser.

if( $result && mysql_num_rows( $result) ){    //test that you have a result AND that number of rows is > 0. Remember the convention that 0 is false.

while ($myrow = mysql_fetch_array($result)) {

      //assuming you have issued a <table> somewhere above ...
      echo "<tr> <td>" . $myrow['month'] . "</td>";  // the "." (dot) concatenates in PHP
      echo "<td> . $myrow['day'] . "</td>";             // or should we say "joins strings and variables"
      echo "<td> . $myrow['value'] . "</td> </tr>";  // and of course, close the row

} } That's rudimentary. There is no WHERE condition on the SELECT which you would use if you wanted a particular month or year. Hope this has been helpful. Check out the various tutorials; there are probably some written in Spanish. Go to: http://www.php.net/links.php and scroll down to Spanish, there are four links there. Hope this has been helpful - Miles Thompson At 02:38 PM 7/30/2005, Jesús Alain Rodríguez Santos wrote:

Sorry for my english, i'm cuban, it's dificult for me explain that in english but I'll try: I have a table columns: month, day and value ||month||day||value

    7     1    56
    7     3    34
    8     4    50
    9     5    78
    .     .     .
    .     .     .

etc... I need to get the value for every day, for example: for day 1 the value is 56 for day 3 the value is 67 for day 4 the value is 50 did you understain, please helpe me -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php