|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Problem retrieving data from MySQL
Can anyone tell me what I am doing wrong here???
<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"><p align="center"><font class="bodyfont" size="2"><b>Package</b></font></p></th> <th bgcolor="#3399CC"><p align="center"><font class="bodyfont" size="2"><b>Web Space</b></font></p></th> <th bgcolor="#3399CC"><p align="center"><font class="bodyfont" size="2"><b>Email Accounts</b></font></p></th> <th bgcolor="#3399CC"><p align="center"><font class="bodyfont" size="2"><b>Email Aliases</b></font></p></th> <th bgcolor="#3399CC"><p align="center"><font class="bodyfont" size="2"><b>Monthly</b></font></p></th> <th bgcolor="#3399CC"><p align="center"><font class="bodyfont" size="2"><b>Yearly</b></font></p></th> <th bgcolor="#3399CC"><p align="center"><font class="bodyfont" size="2"><b>Purchase</b></font></p></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'>£$month</font></p></td>n"); print ("<td bgcolor='#3399CC'><p align='center'><font face='verdana' size='2' color='#FFFFFF'>£$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> |
|
#2
|
|||
|
|||
|
RE: Problem retrieving data from MySQL
Could you elaborate on what kind of problem you are having?
|
|
#3
|
|||
|
|||
|
RE: Problem retrieving data from MySQL
Not to worry...
I changed if ($row = @mysql_fetch_array($list)) { do { to while ($row = @mysql_fetch_array($list) { ... and all worked fine. Thanks anyway |
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Coding > Problem retrieving data from MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|