Extraction of the data from MySQL using PHP

Question

$query = "SELECT * FROM `status_info_private` WHERE `id`=$id ORDER BY `Status_Date` DESC LIMIT 100";
if ($query_run = mysql_query($query)) {
    while ($rows = mysql_fetch_array($query_run)) {
        echo '<a href="view_profile.php?id=' . $id . '"><font color="#009900" > ' . $rows['Name'] . ' ' . ' Says :' . '</font></a><br/>';
        echo '<p align="justify> ' . $rows['Private_status'] . '<br/>';
        echo '<p align="right">' . $rows['Status_Date'] . '<br/>';
        $like   = $rows['Like'];
        $unlike = $rows['Unlike'];
    }
}

I think everything is correct in the piece of code. But still I am unable to get the output under the column titled as "Private_status". The above code is producing everything correctly except the message under cols "Private_status". I have already checked the spelling of the col name & there is no error in that part. So, Please tell me what exactly is missing ?

 is deprecated. As well as align= attribute on the  element. Please learn about CSS. — Madara's Ghost
– Madara's Ghost, Commented Nov 3, 2012 at 10:30
can you place print_r($rows) in while loop and get us the result? — Mohit Mehta
– Mohit Mehta, Commented Nov 3, 2012 at 10:31
Also, what is the output you're getting, and what are you expecting? — Madara's Ghost
– Madara's Ghost, Commented Nov 3, 2012 at 10:31
@ Madara Uchiha I am not an expert in CSS but i am sure we can use align attribute in element. By the way problem is not styling... — Hare Kumar
– Hare Kumar, Commented Nov 3, 2012 at 10:34
we understand that the problem is not styling but there is no harm in getting good things.. — 000
– 000, Commented Nov 3, 2012 at 10:37

000 · Accepted Answer · 2012-11-03 10:32:52Z

1

first close your  tags and then do a print_r to check what is in $rows .. Also, start using PDO or mysqli

answered Nov 3, 2012 at 10:32

000

3,9404 gold badges27 silver badges40 bronze badges

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

1 Comment

Hare Kumar Over a year ago

closing of the tags is not a problem. Since is a singular tag.

Eugen · Accepted Answer · 2012-11-03 10:37:23Z

0

$query = "SELECT * FROM `status_info_private` WHERE `id`=$id ORDER BY `Status_Date` DESC LIMIT 100";
if ($query_run = mysql_query($query)) {
    while ($rows = mysql_fetch_array($query_run)) {
        echo '<a href="view_profile.php?id=' . $id . '" color="#009900" > ' . $rows['Name'] . ' ' . ' Says :' . '</a><br/>';
        echo '<p align="justify"> ' . $rows['Private_status'] . '</p>';
        echo '<p align="right">' . $rows['Status_Date'] . '</p>';
        $like   = $rows['Like'];
        $unlike = $rows['Unlike'];
    }
}

answered Nov 3, 2012 at 10:37

Eugen

1,38612 silver badges16 bronze badges

1 Comment

Hare Kumar Over a year ago

:- Still not working. As i have already mentioned styling is not a problem in extraction of data from the database. By the way thanx for your help...

Collectives™ on Stack Overflow

Extraction of the data from MySQL using PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related