Code: Select all
<?php
$uname = "random";
$pword = "random";
$db = "random";
mysql_connect("localhost", $uname, $pword);
mysql_select_db($db);
$result = mysql_query("SELECT gold FROM user_info");
mysql_fetch_array($result);
echo($result);
?>Moderator: General Moderators
Code: Select all
<?php
$uname = "random";
$pword = "random";
$db = "random";
mysql_connect("localhost", $uname, $pword);
mysql_select_db($db);
$result = mysql_query("SELECT gold FROM user_info");
mysql_fetch_array($result);
echo($result);
?>Code: Select all
<?php
$uname = "random";
$pword = "random";
$db = "random";
$connection = mysql_connect("localhost", $uname, $pword);
$db = mysql_select_db($db, $connection);
$result = mysql_query("SELECT gold FROM user_info", $connection) or die(mysql_error);
$row = mysql_fetch_array($result);
echo $row['column_name'];
?>Code: Select all
$result = mysql_query("SELECT gold FROM user_info", $connection) or die(mysql_error);
echo mysql_result($result,0); // first row
echo mysql_result($result,3); // 2nd row