create table in html as per the condition given for a table to mysql database table

Question

I want to create a table(in HTML) which will display rows and columns where i am calling from my query statement i.e.,

select id,name,city from contacts where enquiry_id=125

which will display 3 to 4 rows of data having enquiry_id=125.

The result will be displayed in HTML format for PHP.(or HTML)..

for($i=0;$i<$total;$i++) { $condition="id=".$id.""; $q1 = db_query('select *from '.PRE.$table.' where '.$condition); $id++; if($row = @db_fetch_array($q1)) { $content .= "<tr> <td valign=\"center\"> <input type=\"checkbox\" id=\"contact_id[]\" name=\"contact_id[]\" value=\"".$row['id']."\"/></td> </tr>\n" ; } } — Prakash N
– Prakash N, Commented Dec 16, 2013 at 10:44

Funk Forty Niner · Accepted Answer · 2013-12-16 13:45:25Z

1

You can try this and do not forget to connect to the database:

while ($record = mysql_fetch_array($result, MYSQL_ASSOC)) {
    ?>

<tr>
    <td><?=$record['id']; ?></td>
    <td><?=$record['name']; ?></td>
      <td><?=$record['city']; ?></td>
</tr>    
<?
}

mysql_free_result($result);
?>
</table>

edited Dec 16, 2013 at 13:45

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Dec 16, 2013 at 11:17

Humphrey

2,8273 gold badges30 silver badges39 bronze badges

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

3 Comments

Prakash N Over a year ago

Thank u ...Itz working .. but i made use of for loop.

Humphrey Over a year ago

Okay good its working then try to use the same codes with a for loop , another thing when the code works for you you upvote it

Humphrey Over a year ago

@Fred-ii- okay but I really get motivated from people like you who comes up and corect our mistakes thanks once again

Collectives™ on Stack Overflow

create table in html as per the condition given for a table to mysql database table

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related