problem looping through records
| From: | Huzz | Date: | Sun, 10 Aug 2003 21:11:09 +0000 |
| Subject: | problem looping through records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-159057@lists.php.net to get a copy of this message | ||
I have a sql statement which brings about 15 records... inside the while
loop i am trying to get data from another table by passing an id, the
problem is i am only getting the first record .. not the whole 15 records..
any suggestion??
function list_ss_cats(){
global $db;
$sql = "SELECT DISTINCT(new_cat) FROM logos WHERE format =3";
$result = $db->sql_query($sql);
$num = $db->sql_numrows();
while($row = $db->sql_fetchrow()){
$sql2 = "SELECT * FROM cats WHERE id='$row[new_cat]'";
$result1 = $db->sql_query($sql2);
$row1 = $db->sql_fetchrow($result1);
echo $row1[en]; // this should show all 15 records but only shows the first
record
}
}
Many thanks in advance
huzz