[Resolved] echo() table.....ehh

[Dynoserv]

Well what i am doing here is..
I am a very newbie to php.

Okay
i have information in a database that i want to pull out with a echo table

EXAMPLE::

---

| Client ID : | Name : | Address | City: | State : | Zip : |

---

| $client | $name |$address|$city | $state | $zip |

It echos the last roll and pulls from the database...

see how new i am...

HELP ME PLEASEEEEE
Michael

[LordShryku]

Something like this should get you started

<?php
$conn = mysql_connect("","","");
mysql_select_db("blah", $conn);
$sql = "SELECT clientId, 
               name, 
               address, 
               city,
               state, 
               zipCode
        FROM   table";
$res = mysql_query($sql);
if(mysql_num_row($res)>0) {
   /* If we have rows, build the table header */
   echo "<table border=\"1\">
           <tr>
             <th align=\"center\">Client ID</th>
             <th align=\"center\">Name</th>
             <th align=\"center\">Address</th>
             <th align=\"center\">City</th>
             <th align=\"center\">State</th>
             <th align=\"center\">Zip</th>
           </tr>";
   while($row=mysql_fetch_array($res)) {
      echo "<tr>
              <td>".$row['clientId']."</td>
              <td>".$row['name']."</td>
              <td>".$row['address']."</td>
              <td>".$row['city']."</td>
              <td>".$row['state']."</td>
              <td>".$row['zipCode']."</td>
            </tr>";
   }
   echo "</table>";
}
else {
   echo "No rows found";
}
?>

[Dynoserv]

Hello Lordshryku,

Thats the idea that i have, and thank you very much, But im getting a error and i have tried to work it out.

here is the error:
Fatal error: Call to undefined function: mysql_num_row() in /home/httpd/vhosts/xxxxxx.xxxxxxx.xxx/httpdocs/tables.php on line 16

my code:

<?php 
$conn = mysql_connect("localhost", "xxxxx", "xxxxx"); 
mysql_select_db("cdorder", $conn); 
$sql = "SELECT * FROM cd_order (Client_ID,First_Name,Last_Name,Address,Apartment,City,State,Zip_code)";

$res = mysql_query($sql); 
if(mysql_num_row($res)>0) { 
   /* If we have rows, build the table header */ 
   echo "<table border=\"1\"> 
           <tr> 
             <th align=\"center\">Client ID</th> 
             <th align=\"center\">Name</th> 
             <th align=\"center\">Address</th> 
             <th align=\"center\">City</th> 
             <th align=\"center\">State</th> 
             <th align=\"center\">Zip</th> 
           </tr>"; 
   while($row=mysql_fetch_array($res)) { 
      echo "<tr> 
              <td>".$row['Client_ID']."</td> 
              <td>".$row['First_Name']." </td> 
              <td>".$row['Address']."</td> 
              <td>".$row['City']."</td> 
              <td>".$row['State']."</td> 
              <td>".$row['Zip_Code']."</td> 
            </tr>"; 
   } 
   echo "</table>"; 
} 
else { 
   echo "No rows found"; 
} 
?> 

[LordShryku]

should be mysql_num_rows

[Dynoserv]

Thanks again for the reply,
Still getting a error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/xxx.xxxx.xxx/httpdocs/tables.php on line 16
No rows found

<?php 
$conn = mysql_connect("localhost", "xxx", "xxxxx"); 
mysql_select_db("cdorder", $conn); 
$sql = "SELECT * FROM cd_order (Client_ID,First_Name,Address,City,State,Zip_Code)";

$res = mysql_query($sql); 
if(mysql_num_rows($res)>0) { 
   /* If we have rows, build the table header */ 
   echo "<table border=\"1\"> 
           <tr> 
             <th align=\"center\">Client ID</th> 
             <th align=\"center\">Name</th> 
             <th align=\"center\">Address</th> 
             <th align=\"center\">City</th> 
             <th align=\"center\">State</th> 
             <th align=\"center\">Zip</th> 
           </tr>"; 
   while($row=mysql_fetch_array($res)) { 
      echo "<tr> 
              <td>".$row['Client_ID']."</td> 
              <td>".$row['First_Name']." </td> 
              <td>".$row['Address']."</td> 
              <td>".$row['City']."</td> 
              <td>".$row['State']."</td> 
              <td>".$row['Zip_Code']."</td> 
            </tr>"; 
   } 
   echo "</table>"; 
} 
else { 
   echo "No rows found"; 
} 
?>

[LordShryku]

Your SQL statement is invalid. If You are going to pull everything, just use

$sql = "SELECT * FROM cd_order ";

[Dynoserv]

OH thank you very very much.

That worked.

Thanks again

Cheers Michael