PHP - Why Does This Happen

Hi everyone,

Bit of a random question and im sure there is good reason so if someone could in lighten me that would be great !

With regards to the below code, it seems to just create an infinite loop when you put mysql_fetch_array. Just want to know what wrong with doing this? and why it act in this way ?

Code: [Select]
$sql = mysql_query("SELECT * FROM cities");
$results = mysql_fetch_array($sql);



while($row = $results)
{
echo $row['City']."<br />";
}


thanks Guys

am a new bie for PHP.Hi i have uploaded review code to my webserver www.clickcity.in, the problem is after entering email and  password -> click " sign in ", blank page is displayed.
however url shows as "http://www.clickcity.in/my/login.php?f=login&referer=".please help me to resove the same.
now when i again go to www.clickcity.in in the same browser window , user is logged in.

hi,

i am having issues with sorting within a conditional statement. please see the code below. right now, i ve commented out the sorting below. basically i want to sort by: $venue1->hereNow->count. I am managing to pull the data correctly. see: http://marineboudeau.com/lab/4sq/
<?php if (is_object($venue->response)) { //sort($venue->response->groups[0]->items->hereNow->count); foreach ($venue->response->groups[0]->items as $venue1) { if ($venue1->hereNow->count != '0'){ //var_dump ($venue1); echo "<div style='font-weight:bold;'>".$venue1->name."</div>"; echo "<div>".$venue1->location->address." ".$venue1->location->city."</div>"; echo "<div>".$venue1->hereNow->count."</div>"; echo "</br>"; } } }?>()

any idea what i need to do to make it happen?

thank you.
marine