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 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 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
Archived
This topic is now archived and is closed to further replies.