truegilly Posted May 19, 2007 Share Posted May 19, 2007 Hi everybody, just been having a play with the MYSQLI function set and i seem to only be able to generate the first row of my table, even though the query i am using is a SELECT * FROM type query. ??? Ive only just started playing with this so obviously i am at fault but i would really appreciate any tips Heres my code:- <?php[color=brown][color=blue][/color][/color] $link = mysqli_connect(HOST, USER, PASSWORD, DATABASE, PORT); /* check connection */ if (!$link) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $query = "SELECT * FROM employee"; $result = mysqli_query($link, $query); $row = mysqli_fetch_array($result, MYSQLI_NUM); ?> <HTML> <HEAD> <TITLE>DB CONNECTIONS</TITLE> </HEAD> <BODY> <TABLE border="2"> <?php $i = 0; foreach($row as $value) { printf ("<TD>" . $value . "</TD>"); $i++; if($i == 6) { echo "<TR>"; $i = 0; } } echo $i; ?> </TR> </TABLE> There are actually 8 employees but its only retuning the first one. e1 pw1 BLOGGS Fred 50000000 8545 528 Thanks guys Quote Link to comment https://forums.phpfreaks.com/topic/52125-mysqli-not-getting-full-result-set/ Share on other sites More sharing options...
truegilly Posted May 19, 2007 Author Share Posted May 19, 2007 BUMP Quote Link to comment https://forums.phpfreaks.com/topic/52125-mysqli-not-getting-full-result-set/#findComment-257132 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.