Sorry, but before I begin..

Dolemite50

Here is my situation,
I have a page made in Dreamweaver that already has tables setup. In one cell it would say "Title:" and then to the right is another cell that I want to populate using mysql/php, the next row says "Size:" in a cell and to the right I want to put the file size. So far all the tutes I find tell me how to build the table dynamically, but how can I put the mysql results into predetermined cells without having to put entire php codes within each cell? In other words, I dont want to have to put code to connect to the mysql server and repetitive info in each cell. Should I declare connections and querys in a global variable or something?

Sorry If thats confusing, I'm a major greenhorn. 🙁

lohmk

try using loops to create your table rows

mcrbids

Originally posted by Dolemite50
Here is my situation,
I have a page made in Dreamweaver that already has tables setup. In one cell it would say "Title:" and then to the right is another cell that I want to populate using mysql/php, the next row says "Size:" in a cell and to the right I want to put the file size. So far all the tutes I find tell me how to build the table dynamically, but how can I put the mysql results into predetermined cells without having to put entire php codes within each cell? In other words, I dont want to have to put code to connect to the mysql server and repetitive info in each cell. Should I declare connections and querys in a global variable or something?

Sorry If thats confusing, I'm a major greenhorn. 🙁

Here's an example that gets username, firstname, and lastname, and displays them ijn a 3 col table:

<TABLE><?

$sql='SELECT * FROM USERS ORDER BY LASTNAME ASC';
$res=mysql_query($sql);
while ($row=mysql_fetch_array($res))
{
echo "<TR><TD>".$row['username']."</TD>";
echo "<TD>".$row['lastname']."</TD>";
echo "<TD>".$row['firstname']."</TD></TR>\n";
}
?></TABLE>

I hope this helps.

Dolemite50

I just dont get it. I think I'm lost. I used Dreamweaver to design a table and have the table set up just how I'd like it. In design view I just click in the left column and type "Title:" and on the cell to the right of it I have the php code to access title from mysql. It works dandy for getting title, but if I want to get genre which is the next cell beneath it, do I have to paste the entire mysql connect script?

Here is how it looks now.
<table width="387" border="0" cellspacing="8" cellpadding="0">
<tr>
<td width="130" align="right" class="genre">Title:</td>
<td width="175" align="left" class="genre">
<?php
$conn = mysql_connect("localhost", "root", "rolorolo");
mysql_select_db("mixposure", $conn);
$sql = 'SELECT * from mp3_table';
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($row = mysql_fetch_array($result)){

						echo $row['title']; 
											} 
			?>
            &nbsp;</td>
          <td width="83">&nbsp;</td>
        </tr>
        <tr>
          <td align="right" class="genre">GENRE:</td>
          <td class="genre"><p>&nbsp;</p>
            <p>&nbsp;
			 </p></td>
          <td>&nbsp;</td>

Thanks again for any help.

Dolemite50

Anybody?

Dolemite50

Can somebody please at least tell me why this isnt being answered? Did I word it wrong? Let me try again:

My problem is this;
I have created a table in design view. It has two colums and it is sized perfectly. On the left column in the first cell it says "Title:" and to the right of it is a cell that I populate from a mysql database. The next row left cell says "Genre:" and to the right of it will be the genre per the mysql.
I am able to populate the "title" row just fine. I click on the empty cell in design view and then switch to code view and code the php like this:

<?php
$conn = mysql_connect("localhost", "root", "rolorolo");
mysql_select_db("mixposure", $conn);
$sql = 'SELECT * from mp3_table';
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
echo $row['title'];
}
?>

That works great but the problem is that if I want to move on to the next row and populate the cell to the right of genre, I have to paste the entire code and reselect the database? I am hoping for a way that I can just have the connection code in there once. The tutorials I am going through tell me how to create the table dynamically but I want to use the table I already created in design view. I know this is confusing but I have been stuck on this problem for a long time. Any help would be greatly appreciated.
Thanks