query display

[Anon]

hello!
I just started to use php, so I have some problems... surprise! The code above retrieve just the first argument on the first row. what`s wrong with it?

<?

$connection=mysql_connect('localhost','username','password') or die("cant establish connection");
mysql_select_db('database') or die("cant establish connection with database");
$table="table";
$database="database";

$resultID=mysql_query("select * from table ");
$column_count= mysql_num_fields($resultID);
$row = mysql_fetch_row($resultID);
echo "Result: " . $row[0];

?>

[Anon]

Nothing is wrong with your script.

I assume you want to traverse your result array. This would be something like:

I have a little tool function using mysql_result($r,m,n), where

$r:Result array
$m: Column
$n: Row

Make a double loop, and display the output as HTML.

Make yourself a little toolbox for displaying sql statements etc, and you will prosper as a programmer.

Nice and simple.

[suren]

Try this
$hostname = "ur host";
$username = "ur user name";
$password = "pwd";
$dbName = "db name";
mssql_connect($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");
$query = "select * from table";
$result = mssql_query($query);
$number = mssql_num_rows($result);
$i=0;
if ($number == 0) :
print "No data?";
elseif ($number > 0) :
while ($i < $number) :
echo mssql_result($result,$i,"[column1 to be retrieved]");
echo mssql_result($result,$i,"[column2 to be retrieved]");
$i++;
endwhile;
endif;

[Anon]

thank you very much...but:
when I tried it it said:
Warning: [column1 to be retrieved] not found in MySQL result index 2 in c:\inetpub\wwwroot\koe2.php on line 17

Warning: [column2 to be retrieved] not found in MySQL result index 2 in c:\inetpub\wwwroot\koe2.php on line 18

(yeah I changed the text inside those [])
Is it wrong with my database or what?

thanks,

M