quick problem

[Rakim]

hey i have a problem and it is....

<?php 
include "config.php"; 

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
/* We have now connected, unless you got an error message */ 
/* Lets extract the data (news) from the database */ 
$query = "SELECT id, yname, ad1, ad2, tc, sp, cty, zip, pno, eml, emlv, payment, dmn, userid, pw, pwv, pack, nts FROM hostunit ORDER BY id"; 
$result = mysql_query($query); 
/* Here we fetch the result as an array */ 
while($r=mysql_fetch_array($result)) 
{    

/* This bit sets our data from each row as variables, to make it easier to display */ 
    $id=$r["id"];
    $yname=$r["yname"]; 
    $ad1=$r["ad1"]; 
    $ad2=$r["ad2"]; 
    $tc=$r["tc"];     

    $sp=$r["sp"];
    $cty=$r["cty"];
    $zip=$r["zip"];
    $pno=$r["pno"];
    $eml=$r["eml"];
    $emlv=$r["emlv"];
    $payment=$r["payment"];
    $dmn=$r["dmn"];
    $userid=$r["userid"];
    $pw=$r["pw"];
    $pwv=$r["pwv"];
    $pack=$r["pack"];
    $nts=$r["nts"];
/* Now lets display the news */ 
    echo "<table border='1' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='100%' id='AutoNumber1'>
  <tr>
    <td width='100%'>
    <p align='center'><b><font size='2' face='Verdana'>Customer ID : $id</font></b></td>
  </tr>
  <tr>
    <td width='100%'>
    <table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='100%' id='AutoNumber2'>
      <tr>
        <td width='50%' align='right'>
        <p align='right'><b><font size='2' face='Verdana'>Customer Name :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$yname</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Address 
        Line 1 :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$ad1</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Address 
        Line 2 :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$ad2</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Town / 
        City :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$tc</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>State / 
        Province :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$sp</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Country :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$cty</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Post / 
        Zip Code : </font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$zip</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Telephone 
        Number :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$pno</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>E-Mail 
        Address :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$eml</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>E-Mail 
        Address (Verified) :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$emlv</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'>&nbsp;</td>
        <td width='50%'>&nbsp;</td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Payment 
        Method :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$payment</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'>&nbsp;</td>
        <td width='50%'>&nbsp;</td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Domain 
        Name :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$dmn</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Username 
        :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$userid</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Password 
        :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$pw</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Password 
        (Verified) :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$pwv</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'>&nbsp;</td>
        <td width='50%'>&nbsp;</td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Hosting 
        Package :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$pack</font></td>
      </tr>
      <tr>
        <td width='50%' align='right'><b><font size='2' face='Verdana'>Any Extra 
        Notes :</font></b></td>
        <td width='50%'><font size='2' face='Verdana'>$nts</font></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
"; 
} 
mysql_close($db); 

?>

when i goto the page it says...

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/game-unit.com/httpdocs/signup/show/index.php on line 11

please help i need it to display my customers information back to me.

[tekky]

try using

$result=mysql_query($query) or die("Query failed - " .mysql_error());

your code looks right... I'm guessing maybe the query is failing for some reason or another... typo'd fieldname maybe?

consequently you could also eliminate a good chunk of code by using:

while(list($key, $val) = each($r)) { $$key = $val; }

[Rakim]

hey i added the top load of code and didnt know what u mean by the 2nd one but now i get

Query failed - Table 'hostunit.hostunit' doesn't exist

[tekky]

sounds like your db isnt setup....

and to explain the while() I posted

while(list($key, $val) = each($r)) //loop through $r assigning arraykey to $key and the value to $val
{
     $$key = $val; //same as ${$key} = $val; which is basically recreating $r['somevar'] as $somevar = $val; so you can use it as a variable with the key as its name later in the code
}

I'd paste you a link to the link() function help but I cant get php.net to work.... :rolleyes:

[Rakim]

db checked everything is right !

[tekky]

can you dump the table structure out into a CREATE statement so we can see that then?