|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I am running the following code, getting limited results, and am hoping someone can shed some light on this. The following query result does return five records but only records 2,3 and 4 are shown. Not sure why record 1 and 5 do not. Is there a way to insure that record 1 is the first record "pointed" to or is there another way to accomplish this?
<?php $q = "Select * from Products_tbl where VendorId = 3"; $db_product->query( $q ); while( $db_product->next_record() ) { ?> <area shape="rect" coords="<?php echo $db_product->f('product_menu_coord')?>" /> <br /> <?php } ?> Thanks. |
|
#2
|
|||
|
|||
|
What Database are you using? MySQL?
__________________
Sir, a desire of knowledge is the natural feeling of mankind; and every human being, whose mind is not debauched, will be willing to give all that he has to get knowledge. |
|
#3
|
|||
|
|||
|
Quote:
Yes, MySQL. tHX. |
|
#4
|
|||
|
|||
|
What class are you using for the database? I would guess the mysqli class, but I don't know if it is something that you wrote or got from someone else. If I had to guess from the code, I would say that when you run the query it is already on the first record and when you call next_record() in the while loop you advance to the second row and begin from there. However without knowing the class you are using this is all just speculation.
|
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Coding > php5 - Not all Records are showing |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|