Retrieving text from a mysql database

Question

I am sure this is a stupid question but I can't figure out how to do it. I need to retrieve a large block of text that is stored in a database. I know how to connect to the database and submit the sql query. What I can't figure out how to do is have it store that text in a string so I can have it echo later on the page.

What I have so far

$db_name = "j_db";
$table_name = "contacts";
$connection = @mysql_connect("localhost", "*****", "****") or die(mysql_error());
$db = @mysql_select_db($db_name, $connection) or die(mysql_error());

$sql = "SELECT meaning 
          FROM $table_name 
         WHERE card = (php variable here)";

$result = @mysql_query($sql, $connection) or die(mysql_error());

Be careful not need show id and password on your posts. :D

dz1984
– dz1984

2010-11-01 03:36:43 +00:00
Commented Nov 1, 2010 at 3:36 — dz1984
– dz1984, Commented Nov 1, 2010 at 3:36

superUntitled · Accepted Answer · 2010-11-01 03:39:04Z

3

Using mysql_fetch_array()

  while( $row = mysql_fetch_array($result) ){
    $meaning = $row["meaning"];
    echo $meaning;
    }

edited Nov 1, 2010 at 3:39

answered Nov 1, 2010 at 3:33

superUntitled

22.6k30 gold badges86 silver badges113 bronze badges

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

1 Comment

user1694691 Over a year ago

I suggest that, for posterity, this answer be updated to reference php.net/manual/en/book.mysqli.php rather than the mySQL extension

Brad Mace · Accepted Answer · 2010-11-01 03:28:44Z

0

Look at the mysql_fetch_* functions. mysql_fetch_assoc is a popular choice.

answered Nov 1, 2010 at 3:28

Brad Mace

28k19 gold badges110 silver badges152 bronze badges

Comments

Sumudu Sahan Weerasuriya · Accepted Answer · 2015-08-15 15:18:29Z

0

<?php
    $url= '' ;
    $username = '' ;
    $password = '' ;
    $dbname = '' ;

    $connection = mysql_connect('$url' , '$username', '$password');
                  mysql_select_db('$dbname' , $connection);
    $result = mysql_query("SELECT textColumnName FROM tableName", $connection);

    while($row = mysql_fetch_array($result)){
         echo $row['textColumnName'];
    }
?>

answered Aug 15, 2015 at 15:18

Sumudu Sahan Weerasuriya

212 bronze badges

Collectives™ on Stack Overflow

Retrieving text from a mysql database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related