kasuwa1235

Well-known member
  • Dec 17, 2007
    6,353
    91
    48
    gampaha
    index.php


    <?php

    require 'sql.inc.php';

    $query = "SELECT 'food' , 'calories' FROM 'foods' ORDER BY 'id' DESC";

    if($query_run = mysql_query($query)){

    while($query_row = mysql_fetch_assoc($query_run)){

    $food = $query_row['food'];
    $calories = $query_row['calories'];


    echo $food . ' has' .$calories. 'calories';


    }
    }

    else{

    mysql_error();
    }

    ?>



    ------------------------------------------------------------------------
    sql.inc.php


    <?php

    $conn_error = 'could not connect';
    $mysql_host='localhost';
    $mysql_user = 'root';
    $mysql_pass = '';

    $mysql_db = 'a_database';


    if(!@mysql_connect($mysql_host,$mysql_user,$mysql_pass) || !@mysql_select_db($mysql_db)){

    die($conn_error);
    }


    ?>



    Data base okkoma hariyatama hadala thiyenne . but Display wenne nane Mokuth ?


    Error ekakwath enne na blank page eka display wenne :(
     

    sajith.xp.pk

    Well-known member
  • Nov 12, 2008
    5,979
    3,996
    113
    Sri Lanka
    $query = "SELECT `food` , `calories` FROM `foods` ORDER BY `id` DESC";
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)){

    ' wenuwata ` daanna

    dala ohoma code eka modify karla balanna

    echo $food . ' has' .$calories. 'calories';
    to

    echo $food . " has " .$calories. " calories";

    ekath daanna
     

    kasuwa1235

    Well-known member
  • Dec 17, 2007
    6,353
    91
    48
    gampaha
    $query = "SELECT `food` , `calories` FROM `foods` ORDER BY `id` DESC";
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)){

    ' wenuwata ` daanna

    dala ohoma code eka modify karla balanna

    echo $food . ' has' .$calories. 'calories';
    to

    echo $food . " has " .$calories. " calories";

    ekath daanna



    Hariyan na Machan :(