Mysql with while

[artiemus]

well i have tried many things running the below script on a sperate file taking th if statement out of course, tried splitting the to section the cards func, and db part into seperate files and include them and nothing gets displayed from the db

               if( $links == "Cards" )
                   	{
                        function cards($userslist){
global $userslist;
return <<<EOF
<table  style='border:1px dotted blue;width:30%;font-family:Verdana;font-size:10px'>
   <tr>
    <td width="10%" style='border:1px dotted blue;'><img src="$userslist[name].jpg"></td>
    <td width="90%" align="left" valign="top">
        <br>
        <strong>Card:</strong>$userslist[name]
        <br>
        <strong>Type:</strong>$userslist[type]
        <br>
        <strong>Inscription:</strong>$userslist[inscription]
        <br>
        <strong>Attribute:</strong>$userslist[atributes]
    </td>
    </tr>
      </table>
      <br>
EOF;
}
                        require "include.lib.php";
                        $sql = "SELECT * FROM ro_cards";
                        $results = mysql_query($sql,$db);
                        do {

                       echo cards($userslist);
                   }while($userslist = mysql_fetch_array($results));}
}
?>

test.php this link is the seperate file that inlcudes both db sect and card func have info from DB

this is the include part with no info

take a look i am in loose ends any help would be nice oh... almost forget i have also tried include/require _once........:rolleyes:

[cgraz]

you have a while loop, but nothing within it. You're not actually outputting anything. You gotta do something like this

while($row = mysql_fetch_array($query)) {
  echo "Field 1" . $row["field1"] . "<br>\n";
  echo "Field 2" . $row["field2"] . "<br>\n";
  echo "Field 3" . $row["field3"] . "<br>\n";
}

And so on. I'm not sure why you're ending the while loop with a semi-colon either.

Cgraz

[artiemus]

the while loop is calling for function cards($userslist)

the sing test page works..link above
but the include one..........

[cgraz]

gotcha.

Well if the function is in the file you're including, and it works when it's not included, then the only thing I can think of is the file isn't getting included (but most servers would give you an ugly error message if that happened.)

The links you gave arne't working, but I'm wondering about the <table> You ahve both PHP and html mixed int here but there are no echo statements or weaving in and out of PHP. Does that work? I'm not familiar with the >> EOF; stuff, so I might just be crazy 😉

Cgraz

[artiemus]

try copy paste url then it should work just remember don't allow external links

http://cgi-bin.spaceports.com/~roempire/cards.php
look here is info

http://cgi-bin.spaceports.com/~roempire/
then click card DB and nop info

[cgraz]

Ok, that makes more sense now. The function is working just fine, it's just not getting any variables from the db. I'd try two things.

Under global $userlists make another global variable. Something like $one = "1";

Then, inside of each table, echo the following

One equals $one

That should echo (since you made it global). If it does, then you may want to try for testing purposes making each specific key in the array global

global $userslist["name"];
global $userlists["type"];

and see if that works. I've never ran into this problem before, but playing around with things like that is how I would go about solving it. The query is obviously working because it created as many tables as there were results, the problem is the values just aren't getting passed. Try the above and let me know if that gets you anywhere or solves the problem.

Cgraz

[artiemus]

haha i took the global vars out and it works tried what u said and it would have it so i decided to take the globals out tkae a look

http://cgi-bin.spaceports.com/~roempire/?links=Cards
(remember to paste and copy url)

thanx for ur debug help

[cgraz]

lol. Playing around always seems to work when I'm trying to figure out what the hell is going on with my code.

Glad you got it working.

Cgraz