Richard Perry - GreyCube.com: Forums / Live Game Server List / SELECT FROM DATABASE

Richard Perry - GreyCube.com :: Forums :: Live Game Server List

SELECT FROM DATABASE

lexta

Fri Nov 04 2011, 06:56PM

Posts: 14
Joined: Sun Jan 16 2011, 05:02PM
Registered Member #6517

Hi, I want to select data from db with this script:


<?php

$con = mysql_connect("localhost","user","pass");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_select_db("db", $con);



$result = mysql_query("SELECT `ip` FROM `lgsl` WHERE `id`=1");



while($row = mysql_fetch_array($result))

  {

  echo $result;

  }



mysql_close($con);

?>

But in the web page show's me:


Resource id #2

What can i do to show me ip from id 1 ?

Dodgeitorelse

Fri Nov 04 2011, 10:52PM

Posts: 180
Joined: Sun Dec 12 2010, 09:16AM
Registered Member #6457

change while loop to

while($row = mysql_fetch_array($result))
{
echo $row[0];
}