MYSQL Fetching rows into page

Question

I am fetching data from mysql to a page, i am not sure if the way im doing it is appropiate. I am having trouble with fetching values into sections of the page.

<?php
    // Connect to database server
    mysql_connect("localhost", "xxx", "xxx") or die (mysql_error ());

    // Select database
    mysql_select_db("xxx") or die(mysql_error());

    // SQL query
    $strSQL = "SELECT * FROM news";

    // Execute the query (the recordset $rs contains the result)
    $rs = mysql_query($strSQL);

    // Loop the recordset $rs
    // Each row will be made into an array ($row) using mysql_fetch_array
    while($row = mysql_fetch_array($rs)) {

       // Write the value of the column FirstName (which is now in the array $row)
      echo $row['editor_name'] . " " . $row['news_desc'];
  echo "<br />";
  }

    // Close the database connection
    mysql_close();
    ?>

</div>  <!-- content #end -->

the database;

the above yields;

news

I want to do the following; BY: Fadi

echo 'BY' $row['editor_name'] . " " . $row['news_desc'];
      echo "<br />";

but it isn't working :( any tips

echo 'BY' $row['editor_name'] . " " . $row['news_desc']; echo "<br />"; should be echo 'BY' . $row['editor_name'] . " " . $row['news_desc']; echo "<br />"; — Jack
– Jack, Commented Apr 1, 2012 at 20:24

PorridgeBear · Accepted Answer · 2012-04-01 20:28:54Z

1

You are missing a concat operator after 'BY'. Should be

echo 'BY' . $row['editor_name'] . " " . $row['news_desc'];
echo "<br />";

OR tidier:

echo "BY {$row['editor_name']} {$row['news_desc']}<br/>";

answered Apr 1, 2012 at 20:28

PorridgeBear

1,1831 gold badge12 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dAm2K · Accepted Answer · 2012-04-01 20:24:59Z

0

If you want to return associative array you can try using this line:

...

while($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
...

answered Apr 1, 2012 at 20:24

dAm2K

10.4k6 gold badges47 silver badges48 bronze badges

Comments

Gabriel Santos · Accepted Answer · 2012-04-01 20:25:06Z

0

You forgot one dot after 'BY'

echo 'BY' . $row['editor_name'] . ' ' . $row['news_desc'] . '<br />';

answered Apr 1, 2012 at 20:25

Gabriel Santos

4,9742 gold badges45 silver badges74 bronze badges

Collectives™ on Stack Overflow

MYSQL Fetching rows into page

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related