jigen7
Nov 9th 2007, 5:02 pm
im getting the errors unable to jump to row........
not working:
$sql2 ="Select LinkCategoryID from LinkCategories where LinkCategoryName ='$arr[5]'";
$result3=mysql_query($sql2,$conn_id);
$y = 0;
$count3 = mysql_num_fields($result3);
while ($y < $count3) {
$res_linkuserid=mysql_result($result3,$y,"LinkCategoryID"); ;
$y++;
}
is there sumthing wrong with my code i need to get the LinkCategoryID depending on the given LinkCategoryName which is in $arr[5] from table LinkCategories??anyone can help me throughout here because this code is perfectly running but the one i have posted in the upper part is not weird
working:
$sql ="Select UserID from Users where UserName = '$user[1]'";
$result2=mysql_query($sql,$conn_id);
$x = 0;
$count2 = mysql_num_fields($result2);
while ($x < $count2) {
$res_userid=mysql_result($result2,$x,"UserID");
$x++;
}
?? thx
not working:
$sql2 ="Select LinkCategoryID from LinkCategories where LinkCategoryName ='$arr[5]'";
$result3=mysql_query($sql2,$conn_id);
$y = 0;
$count3 = mysql_num_fields($result3);
while ($y < $count3) {
$res_linkuserid=mysql_result($result3,$y,"LinkCategoryID"); ;
$y++;
}
is there sumthing wrong with my code i need to get the LinkCategoryID depending on the given LinkCategoryName which is in $arr[5] from table LinkCategories??anyone can help me throughout here because this code is perfectly running but the one i have posted in the upper part is not weird
working:
$sql ="Select UserID from Users where UserName = '$user[1]'";
$result2=mysql_query($sql,$conn_id);
$x = 0;
$count2 = mysql_num_fields($result2);
while ($x < $count2) {
$res_userid=mysql_result($result2,$x,"UserID");
$x++;
}
?? thx