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)..

[How to create HTML tables from MySQL?](http://stackoverflow.com/questions/2690668/how-to-create-html-tables-from-mysql) — fiskolin, Dec 16 '13 at 10:17
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 .= " \n" ; } } — Prakash N, Dec 16 '13 at 10:44

score 1 · Accepted Answer · edited Dec 16 '13 at 13:45

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 '13 at 13:45

Funk Forty Niner

74,450
15
68
141

answered Dec 16 '13 at 11:17

Humphrey

2,659
3
28
38

1

Thank u ...Itz working .. but i made use of for loop. – Prakash N Dec 16 '13 at 12:20
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 Dec 16 '13 at 12:51
1

@Fred-ii- okay but I really get motivated from people like you who comes up and corect our mistakes thanks once again – Humphrey Dec 22 '13 at 08:01

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

1 Answers1