Table To Html

[redrock]

Hello

I have just started realy using php .. I have learned how to create forms in php an connect to a database..In the form i have made i have 4 items that need to be filled out... what i am wanting to do is make one of the ids show on a webpage after it is submitted... Is this possible an if so how do i do it😕 😕

[bastien]

since you can query the db (ie conect and insert) the select is no problem

<?//connection code

//query

$result=mysql_query("select * from table_name");

while $rows=mysql_fetch_array($result)){

$item1 = $rows['column_name1'];
$item2 = $orws['column_name2'];
//etc 

echo " this is $item1, and this is $item2";

}//end while loop

?>

[redrock]

Remember im real new to all this is this what this is suppose to look like?

<?php
$db = mysql_connect($db_Database,$db_Password, $db_UserName, $db_Hostname);

//connection code

//query

$result=mysql_query("SELECT em_spades_wins.em_player_name FROM em_spades_wins;");

while $rows=mysql_fetch_array($result){

$item1 = $rows[em_player_name'];
$item2 = $orws['column_name2'];
//etc

echo " this is $item1, and this is $item2";

}//end while loop

?>

[stolzyboy]

this

while $rows=mysql_fetch_array($result){

should be

while ($rows=mysql_fetch_array($result)){

[redrock]

I am sorry to be so much trouble.. but here is my exact script..but once i learn all this i hope i can be as much help as you all have been...

<?php
$db = mysql_connect($db_Database,$db_Password, $db_UserName, $db_Hostname);

$result=mysql_query("SELECT em_spades_wins.em_player_name FROM em_spades_wins;");

while ($rows=mysql_fetch_array($result))

{$item1 = $rows em_player_name';

echo " this is $item1, and this is $item2";

}//end while loop

?>

This is the error i am getting

Parse error: parse error, unexpected T_STRING in /home/xxx/xxx/xxx/xxx/spades.php on line 9

[bastien]

so close

$item1 = $rows['em_player_name'];

echo " this is $item1";

[redrock]

I think its time i give up on this Idea... O have been working on it for a week..have wrote many scripts of my own trying to get it done an still no luck

<?php
$db = mysql_connect($db_Database,$db_Password, $db_UserName, $db_Hostname);

$result=mysql_query("SELECT em_spades_wins.em_player_name FROM em_spades_wins;");

while ($rows=mysql_fetch_array($result)){

$item1 = $rows['em_player_name'];

echo " this is $item1";

}//end while loop

?>

An Error is
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /xxx/xxx/xxx/xxx/xxx/spades.php on line 7

🙁 🙁 🙁

[stolzyboy]

that just means you aren't getting any results from your query string, echo out $result to see where the problem may lie

[bastien]

try adding this to see what the error is

$result=mysql_query("SELECT em_spades_wins.em_player_name FROM em_spades_wins;") or die ("error is ".mysql_error());

[redrock]

Thanks for all your help but after doing everything you have told me as well as using what i know still keep getting every error in the book.I dont know if this simple script just doesnt like me or what but this is what i have came up with an still to no success

<?php

$db = mysql_connect($db_Database,$db_Password, $db_UserName, $db_Hostname);

$result=mysql_query("SELECT em_spades_wins.em_player_name FROM em_spades_wins;");

while $rows=mysql_fetch_array($result){

$item1 = $rows['em_player_name'];

echo " this is $item1";

}

?>

[bastien]

try using this db connections tring to see if you really connect to the db

<?php
//page is called [b]dbconn.php       [/b]
 //check the password from the DB


    $vusername = "username";                   //your username for you local system
    $pwd ="password";                                          //password to accecss mySQL
    $host = "localhost";                   //host is localhost - even for most web hosts
    $dbname = "db_name";                //db name to be accessed



    //connect to db
    //$conn=mysql_connect($host, $username, $pwd) or die ("Unable to connect to database");

    if (!($conn=mysql_connect($host, $vusername, $pwd)))  {
        printf("error connecting to DB by user = $vusername and pwd=$pwd");
        exit;
    }
   $db=mysql_select_db($dbname,$conn) or die("Unable to connect to database");

?>

then

<?
//page is [b]test.php[/b]

//inlcude the db connection page
require("dbconn.php");

$sql="SELECT em_spades_wins.em_player_name FROM em_spades_wins";


$result=mysql_query($sql, $conn) or die ("Can't connect because ".mysql_error()); 

while $rows=mysql_fetch_array($result){ 

$item1 = $rows['em_player_name']; 

echo " this is $item1"; 

} 

?>

hth

[redrock]

ok ty ty I had to make one change in te script you sent me i had to add ( ) around an arguement an weee it worked..Now here is my next item here is the page the script calls http://www.heavenshideaway.org/spades.php what i would like to do is make it come out in a table with three columns wide how would i do this ... an if i where a rich man id pay ya tons

[bastien]

echo "<table>"

$x=1; //set counter for moving through data to create rows

while ($rows=(mysql_query($result)){

  $item=$rows['item'];

  if ($x==1){
      echo "<tr><td>$item</td>";
      $x++;

 }elseif($x==2){
      echo "<td>$item></td>";
      $x++;
 }else{
      echo "<td>$item</td></tr>";
      $x=1;
 }

}//end while loop

[redrock]

great ty i finally got all this work lol...I have somewhat of a table going on now i just gotta figure out to make borders around the names on the tables put background color an all that good stuff on the pages...

[redrock]

For all who have been helping me with this is what i took from everyone help an came up with a working script!!!

<?

require("dbconn.php");
require("spadesty.htm");

$sql=("SELECT em_spades_wins.em_player_name FROM em_spades_wins");

$result=mysql_query($sql, $conn) or die ("Can't connect because ".mysql_error()); 

echo '<table border="4" cellspacing="0" width="50%" bordercolor="#800080" cellpadding="5"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
    echo '<td>'.$rows['em_player_name'].'</td>';
    if ($i++%3 == 0) {
        echo '</tr><tr>';

} 
}
echo '</tr></table>';
?>

This made 8 different scripts i needed work an I owe it all to yall for you great help

[redrock]

ok i thought i had all this figured out but guess i was wrong.I am try to do a 4 column wide table this is what i have came up with any help?

 <?
//page is test.php

//inlcude the db connection page
require("dbconn.php");


$sql=("SELECT em_members.em_member_name,em_members.em_icq,em_members.em_homepage,em_members.em_aim FROM em_members");

$result=mysql_query($sql, $conn) or die ("Can't connect because ".mysql_error()); 

echo '<table border="4" cellspacing="0" width="50%" bordercolor="#800080" cellpadding="5"><tr>';
$i = 0;
$em_member_name = $row["name"];

$icq = $row["icq"];
if ($icq == "n/a") {
$icqlink = "n/a";
}
else {
$icqlink = "<a href='http://wwp.icq.com/scripts/Search.dll?to=$icq'>$icq</a>";
}
$aim = $row["aim"];
if ($aim == "n/a") {
$aimlink = "n/a";
}
else {
$aimlink = "<a href='aim:addbuddy?screenname=$aim'>$aim</a>";
}
$homepage = $row["HomePage"];
if ($homepage == "n/a") {
$homepage = "n/a";
}
else {
$homepage = "<'em_homepage'>$homepage</a>";
}

while ($rows=mysql_fetch_array($result)){
    echo '<td>'.$rows['em_player_name'].'</td>';
    if ($i++%4 == 0) {
        echo '</tr><tr>';

} 
}
echo '</tr></table>';
?>