[MikeNL]

Hi,

Does anyone know how to create HTML tables (3 rows, 4 colums) from a MySQL query in PHP?

I have a script that works, but the first row only has 3 colums, all the other rows have 4.

THX!!!!!

[digioz]

Here is an example:

PHP Code:

<?php
    $location = "localhost";
    $username = "username";
    $password = "password";
    $database = "database";
    $conn = mysql_connect("$location","$username","$password");
 
    if (!$conn) die ("Could not connect MySQL");
    mysql_select_db($database,$conn) or die ("Could not open database");
 
mysql_query("CREATE TABLE tablename (
column1 VARCHAR(20),
column2 VARCHAR(20),
column3 VARCHAR(20),
column4 VARCHAR(20))");
 
Repeat this set of code 3 times to insert 3 rows:
 
$insert = "INSERT INTO users (column1,column2,column3, column4)
    VALUES ('Value1','Value2','Value3','Value4')";
    mysql_query($insert) or die ("Could not add data to the table");
 ?>

Let me know if you have any other questions.

Originally Posted by MikeNL

Hi,

Does anyone know how to create HTML tables (3 rows, 4 colums) from a MySQL query in PHP?

I have a script that works, but the first row only has 3 colums, all the other rows have 4.

THX!!!!!

[Volte]

Dude, Create HTML tables FROM MySQL Querys, Not Create Tables in MySQL.

PHP Code:

$Query = mysql_query("SELECT * FROM table WHERE (field='value')");



echo "<table><tr><td>Column 1</td><td>Column 2</td><td>Column 3</td></tr>";

while ($Row = mysql_fetch_array($Query)) {



echo "<tr><td>Column 1 Value</td><td>Column 2 Value</td><td>Column 3 Value</td></tr>";



}



echo "</table>"; 

I think that's what you were trying to do.

[MikeNL]

THX Volte, I will try it, Mike