displaying database table with php

[cdennste]

Using the below code to try and get this database table to display using PHP..

Where am i going wrong....

Thanks Craig

//connect to the database
$mysql_access = mysql_connect("localhost", "root", "") or die( "Could not connect!" );

//select the database name
mysql_select_db("extranet1", $mysql_access) or die( "Could not select DB!");

$results = mysql_query( "select * from assets", $mysql_access);

while($row = mysql_fetch_array( $result ) ){//walk through the results array
unset( $selected_rows );
$selected_rows = "";
$selected_rows .= $row["filename"];//name is the column which correlates to the array index
$selected_rows .= ", ";
$selected_rows .= $row["color"];
$selected_rows .= ", ";
$selected_rows .= $row["time"];
$selected_rows .= ", ";
$selected_rows .= $row["annotation"];
$selected_rows .= ", ";
$selected_rows .= $row["timegen"];
$selected_rows .= ", ";
$selected_rows .= $row["node"];//name is the column which correlates to the array index
$selected_rows .= ", ";
$selected_rows .= $row["text"];
$selected_rows .= ", ";
$selected_rows .= $row["text"];
echo( $selected_rows );
}
//close the connection
mysql_close($mysql_access);

[stolzyboy]

are you getting errors or no display

use this while loop instead

while ($row = mysql_fetch_array($result))
{
echo $row['filename'] . ", " . $row['color'] . ", " . $row['time'] . ", " . $row['annotation'] . ", " . $row['timegen'] . ", " . $row['node'] . ", " . $row['text'] . "<br><br>";
}

[cdennste]

I was getting errors.

this works
Notice: Undefined variable: result in C:\ISERVICE\test.php on line 14

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\ISERVICE\test.php on line 14

I'll give that a try though thanks...

[cdennste]

Thanks for the advice just a had a simple spelling error.

Here is what the code looks like.

But now i am trying to get any blank cell in the database to show up in a <td></td> cell. Cannot get it to work properly.

//connect to the database
$mysql_access = mysql_connect("localhost", "root", "") or die( "Could not connect!" );

//select the database name
mysql_select_db("extranet1", $mysql_access) or die( "Could not select DB!");

$results = mysql_query( "select * from assets", $mysql_access);

while($row = mysql_fetch_array( $results ) ){//walk through the results array
unset( $selected_rows );
$selected_rows = "<tr><td>";
$selected_rows .= $row["Team"];//name is the column which correlates to the array index
$selected_rows .= "</td><td>";
$selected_rows .= $row["Name"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Service"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Device"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Grid"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Cabinet"];//name is the column which correlates to the array index
$selected_rows .= "</td><td>";
$selected_rows .= $row["Serial"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Make"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Model"];
$selected_rows .= "</td><td>";
$selected_rows .= $row["Comments"];
$selected_rows .= "</td></tr>";
echo( $selected_rows );
}
//close the connection
mysql_close($mysql_access);

[stolzyboy]

you are making this way to hard on yourself, you should get rid of your .= theory, very hard to read and work through and my way is much easier to do html formatting around your results sets, here is how i would do it:

<?
//select the database name 
mysql_select_db("extranet1", $mysql_access) or die( "Could not select DB!"); 

$results = mysql_query( "select * from assets", $mysql_access); 

while($row = mysql_fetch_array($results))
{//walk through the results array
?>
<tr>
<td><? echo $row["Team"]; ?></td>
<td><? echo $row["Name"]; ?></td>
<td><? echo $row["Service"]; ?></td>
<td><? echo $row["Device"]; ?></td>
<td><? echo $row["Grid"]; ?></td>
<td><? echo $row["Cabinet"];?></td>
<td><? echo $row["Serial"]; ?></td>
<td><? echo $row["Make"]; ?></td>
<td><? echo $row["Model"]; ?></td>
<td><? echo $row["Comments"]; ?></td>
</tr>
<?
} 
//close the connection 
mysql_close($mysql_access);
?>

[cdennste]

OK I do agree on that your way is the way to go about displaying the data. Comes out looking exactly the same but allot easier to understand.

How do i go about make a null statement that will but a tab or blank image in for every empty <td></td> set. because it makes the table hard to follow with all these blank spaces all over...

[stolzyboy]

something like this for each entry

<td><? if ($row['Name'] == ""){ echo "<img src=graphic.gif width=10 height=1>"} else { echo $row["Name"];} ?></td>

[cdennste]

Parse error: parse error, unexpected T_STRING, expecting ',' or ';'

is the error i keep getting. Do i need to put / or \ infront of my " ?

[stolzyboy]

sorry i was missing the semicolon after the

echo "<img src=graphic.gif width=10 height=1>";} //need semi