8 replies to this topic

[Wanber]

tenho o codigo

$query = mysql_query("SELECT * FROM cms_news ORDER BY published DESC LIMIT 1");
while($noticias = mysql_fetch_array($query)) { $id = $n_id; ?>
                <li id="<?php $n_id = $id + 1; echo $n_id; ?>"><?php echo $noticias['title'] ?></li>
                <?php } ?>

a intenção era que o id seja inicialmente 1 ai no próximo while o id ser 2, 3, etc...
mais nao funcionou, sera que alguem pode me dizer o que esta errado?

[Goku Jr]

$query = mysql_query("SELECT * FROM cms_news ORDER BY published DESC LIMIT 1");
while($noticias = mysql_fetch_array($query)) {
$id = $n_id; #- Pq desta variável, $id?

echo "<li id='". ($n_id = $n_id + 1) ."'>{$n_id} - {$noticias['title']}</li>";
?>

[rafael-tdc]

O Campo ID tá auto-increment?

acho que não precisa ser feito esse código todo, é só puxar o id

[Bom de Busca]

$query = mysql_query("SELECT * FROM cms_news ORDER BY published DESC LIMIT 1");
while($noticias = mysql_fetch_array($query)) {
$id = $n_id; ?>
<li id="<?=$id+1?>"><?=$noticias['title']?></li>
<?php } ?>

<?=?> isso aqui é igual echo

Outra coisa se você possui o id registrado nessa tabela cms_news é só puxar aquele id para trabalhar com ele.

Mais uma dica prefiro milhares de vezes o for do que o while.

Exemplo usando seu script ae:

$query = mysql_query("SELECT * FROM cms_news ORDER BY published DESC LIMIT 1");
for($i=0;$i<mysql_num_rows($query);$i++) {
echo '<li id="'.$i.'"><?=mysql_result($query,$i,"title")?></li>' ;
}

dessa maneira vc já tem um numerador para a linha e os processos com for ficam bem mais rapidos.

[Miguceamma]

Maximum Dose For Amoxil cialis buy online Sildenafil Mastercard Canadian Atarax Cialis English

[RonsisM]

Levitra 10 Mg Prezzo Farmacia Amerimedrx Online Pharmacy levitra soft tabs Ordering Cheap Prednisone Without X

[HaroNism]

Buy Real Viagra No Prescription Acyclovir No Script When Amoxicillin Takes Effect viagra Preis Viagra Mg Dutasteride Duprost For Sale
Online Cialis Cure For Amoxicillin Allergies Buy Albendazole Tablets cialis Viagra Ohne Rezept Preisvergleich Cardura Comparatif Viagra Generique Levitra

[RonsisM]

Side Effects Cephalexin 500mg viagra Isotretinoin Acne Cialis Sin Receta Espana
Foros Cialis Viagra online pharmacy 875 Mg Amoxicillin Prix Levitra En France Amoxicillin Usual Dose

[papedlok]

Discounts! best makeup products to have


Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).


READ MORE
Ombre peruvian virgin hair straight 4 bundles ombre straight hair weave 8a grade virgin unprocessed ombre human hair extensions ( 51.10 $)
free shipping Brand New Modern boy girl ladies Children Men's Ballroom Latin Tango Dance Shoes man Salsa heeled ( 18.95 $)
Amazing Sky Star Laser Projector Lamp Starry Night Light Powered by AA Battery-3.39 $
UMI TOUCH Android 6.0 5.5 inch 4G Phablet 2.5D Arc Corning Gorilla Glass 3 Screen MTK6753 64bit Octa Core 3GB RAM 16GB ROM Touch ID 5.0MP + 13.0MP Cameras Dual WiFi 151.39$
Red Italian Handmade Leather Loafer Shoes ( 149.50 $)
7A Peruvian Virgin Hair Body Wave 3 Bundles Peruvian Body Wave Virgin Hair Bundle Deals Remy Human Hair Weave 6""-28"" ( 45.00 $)
Stylish lace up double color hairband for women ( 2.66 $)
24 ( 28.80 $)
Mva genuine leather men bag fashion crossbody leather bag men messenger bags casual shoulder designer handbags man bags 2016 new ( 54.60 $)
Slim Fit White and Pink Check Cotton Dress Shirt ( 49.00 $)
Ulefone Be Touch 3 4G Phablet-149.14 $
Agepoch pole spining gear sea china equipment winter all set cast carp telescopic peche feeder tackle spinning combo fishing rod ( 25.98 $)
KEYES KT0019 Electronic Component Package ( $8.84 )
Baby online store Kinderly. To buy baby goods, delivery across Moscow, Ekaterinburg, St. PETERSBURG
U shape electrical shiatsu back neck shoulder massager body infrared 3d kneading massager eu plug flat plug ( 43.80 $)