mysql_fetch_array problem

Matthew Robinson wrote:
> oh ye, just realised i didn't mention that the database has 2 rows, both
> with the 'name' column not null, so the output should be different to what
> it is.

When you do

$sql = 'select col1, col2, col4 from table';
$obj = mysql_query($sql) or die(mysql_error());
$res=mysql_fetch_array($obj);

// $res as as many elements as columns in your select, and their
// index is the name used in the select.

// so, now you can do
echo $res['col1'], $res['col2'], $res['col4'];

// but
echo $res['col3'];
// does not work even if the table has a column named "col3"
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

id is the primary key, so i thought it would be best to use that as the
one to identify the row.

name is what i want to print to the screen.

CODE:

<?php

$dbcnx = @mysql_connect("SERV", "USR", "PWD");


$select = @mysql_select_db("houseproudlancs_co_uk1");





echo ("START<P><HR>");

$command = 'SELECT id, name, description, price FROM stock';
$qresult = mysql_query($command) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
echo ($row ["name"]);
echo ("<br>");
}
echo ("<P><HR><P>END");

?>


OUTPUT:

START


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/houseproudlancs_co_uk/index_to_be.php on line 17


END

sorry about the posting twice about the same thing again, but the line in
question is the one with while on it

Matthew Robinson wrote:
> $qresult = mysql_query($command) or die(mysql_error());

$qresult here

> while ($row = mysql_fetch_array($result)) {

but here you have $result



> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/houseproudlancs_co_uk/index_to_be.php on line 17

$result is *not* an object returned from mysql_query() function :)
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

thanks for the help pedro, im not used to programming properly, as i used
to program vb, which wipes your bum for you. anyway, thanks again. this
has been a problem for days.