Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: MYSQL pagalba

Parašė PnQ· 2011 Rugs. 19 23:09:20
#1
Sveiki, taigi noreciau padaryti toki scriptuka kad rodytu VIP lista. Va pagal si scripta darau ir man reikia kad tik rodytu kas turi pvz Vip=1 rodytu Vardas ir vipiki. Gal kas galite padeti?

<td>

';$result = mysql_query('SELECT Vardas,vipiki,Vip FROM users ORDER BY vipiki DESC LIMIT 150');
echo '<table border="1" cellpadding="3" cellspacing="0" rules="rows" frame="below" width="100%">
<th>#</th><th>Slapyvardis</th><th>Galioja Iki</th>';
$nr = '1';
while ($row = mysql_fetch_array($result))
{
echo '<tr>
<td><center>' .$nr++. '.</center></td>
<td><center>' .$row['Vardas']. '</center></td>
<td><center>' .$row['Vip']. '</center></td>
<td><center>' .$row['vipiki']. '</center></td>
</tr>';
}
echo '</table>

</td>
Redagavo PnQ· 2011 Rugs. 19 23:09:29

Parašė Ponas24· 2011 Rugs. 19 23:09:06
#2

<td>
 
';$result = mysql_query("SELECT Vardas,vipiki,Vip FROM users WHERE Vip = '1' ORDER BY vipiki DESC LIMIT 150");
echo '<table border="1" cellpadding="3" cellspacing="0" rules="rows" frame="below" width="100%">
<th>#</th><th>Slapyvardis</th><th>Galioja Iki</th>';
$nr = '1';
while ($row = mysql_fetch_array($result))
{
echo '<tr>
<td><center>' .$nr++. '.</center></td>
<td><center>' .$row['Vardas']. '</center></td>
<td><center>' .$row['Vip']. '</center></td>
<td><center>' .$row['vipiki']. '</center></td>
</tr>';
}
echo '</table>
 
</td>


Jei teisingai supratau ;/