Retrieving data from MySQL Database

Anon

I have a database (techsolutions) and a table within that db (hosting).

The table has 8 fields (say fields 1-8 for now), and 9 rows fo data within the fields.

I need to gather all the information from the table and present it into a table using $field1[$i}, $field2[$i] etc.. (for example).

How can I do this? Everything I try just brings back #resource_id2???

leatherback

You may have to adjust it a bit, but this is, from the top of my head, the idea :

$sql_query = "select * from hosting" ;

//Set the query

$ResultArray = mysql_query($sql_query) ;

//Perform the query

$Content = "<table><tr>";

// initiate var with content and add table commands

while ($row =@ mysql_fetch_array($ResultArray))
{
$Content .= "<td>$row[field1]</td><td>$row[field2]</td>";
}

// As long as the resultarray has info, parse it into row. Then get each field from the array row, and paste it into a new variable

$Content .= "</tr></table>";

// finalize the table

echo $Content ;

// print the table

Jelle.

Anon

I was looking along the lines of doing...

<form method="post" target="main" action="<?php echo $PHP_SELF ?>">
<input type="hidden" name="action" value="set_var">
<table border="0" width="100%">
<tr>
<th bgcolor="#3399CC">Package</th>
<th bgcolor="#3399CC">Web Space</th>
<th bgcolor="#3399CC">Email Accounts</th>
<th bgcolor="#3399CC">Email Aliases</th>
<th bgcolor="#3399CC">Monthly</th>
<th bgcolor="#3399CC">Yearly</th>
<th bgcolor="#3399CC">Purchase</th>
</tr>

<?php

db_connect();

$list = @mysql_db_query("SELECT * FROM hosting");
if ($row = @mysql_fetch_array($list)) {
	do {
		$id = $row["id"];
		$package = $row["package"];
		$web_space = $row["web_space"];
		$email_accts = $row["email_accts"];
		$email_alias = $row["email_alias"];
		$month = $row["month"];
		$year = $row["year"];

		print ("<tr>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>$package</font></p></td>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>$web_space</font></p></td>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>$email_accts</font></p></td>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>$email_alias</font></p></td>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>&pound$month</font></p></td>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>&pound$year</font></p></td>\n");
		print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'><input name='package' type='radio' value='$host_id'></font></p></td>\n");
		print ("<tr>\n");
	}
	while($row = @mysql_fetch_array($list));
}

?>
</table></div></form>

Any ideas as to why that didn't work?
I will try your method anyway

leatherback

Hi,

I am not very experienced in PhP yet, so maybe this is not the problem, but you might want to try:
instead of:
if ($row = @mysql_fetch_array($list)) {

put
while ($row = @mysql_fetch_array($list)) {

Guess you can lose the
do {
part

Leave the quotes away in
$id = $row["id"];

As far as I know, you don't need them (??)
I think you can leave the last part

while($row = @mysql_fetch_array($list));
}

away if you make the first replacement I suggested in this post

Hope this helps & works!..