RE: [PHP-DB] Can't use field names in print

2002-01-13 Thread Beau Lebens 

you should be able to just change the mysql_fetch_row to a mysql_fetch_array
and then use the names rather than the numbers in your print (modified
below, not tested :)

// ");
//   }
// ?>

/beau

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Can't use field names in print

2002-01-13 Thread planomax 

Thanks for the quick response.  I left out the part you mention, here is the
whole code (the one that works);
");
  }
?>


I just can't seem to be able to access the array using the column names from
the table.
Pete


"Beau Lebens" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> you need to use the *_fetch_array() functions
>
> i.e. if you are using MySQL
>
> $SQL = "something"; // build SQL query
> $result = mysql_query($SQL); // execute query, save all results in $result
> $firstResult = mysql_fetch_array($result); // create an array containing
> each returned record
>
> // subsequent calls to mysql_fetch_array($result) will get each record
>
> HTH
>
> Beau
> PS please excuse email butchering my single-line comments :)
>
>
> // -Original Message-
> // From: planomax [mailto:[EMAIL PROTECTED]]
> // Sent: Monday, 14 January 2002 10:13 AM
> // To: [EMAIL PROTECTED]
> // Subject: [PHP-DB] Can't use field names in print
> //
> //
> // To output each row, this works:
> //
> // print("$row[0] - $row[1] - $row[2]");
> //
> // But using the table's field names, I don't see anything:
> //
> //   $ID=$row["ID"];
> //   $test1=$row["test1"];
> //   $test2=$row["test2"];
> //   print ("$ID - $test1 - $test2");
> //
> // I'm used to using Cold Fusion and want to learn PHP.  Any
> // help would be
> // appreciated.  Thanks.
> // Pete
> //
> //
> //
> // --
> // PHP Database Mailing List (http://www.php.net/)
> // To unsubscribe, e-mail: [EMAIL PROTECTED]
> // For additional commands, e-mail: [EMAIL PROTECTED]
> // To contact the list administrators, e-mail:
> // [EMAIL PROTECTED]
> //



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Can't use field names in print

2002-01-13 Thread Beau Lebens 

you need to use the *_fetch_array() functions

i.e. if you are using MySQL

$SQL = "something"; // build SQL query
$result = mysql_query($SQL); // execute query, save all results in $result
$firstResult = mysql_fetch_array($result); // create an array containing
each returned record

// subsequent calls to mysql_fetch_array($result) will get each record

HTH

Beau
PS please excuse email butchering my single-line comments :)


// -Original Message-
// From: planomax [mailto:[EMAIL PROTECTED]]
// Sent: Monday, 14 January 2002 10:13 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Can't use field names in print
// 
// 
// To output each row, this works:
// 
// print("$row[0] - $row[1] - $row[2]");
// 
// But using the table's field names, I don't see anything:
// 
//   $ID=$row["ID"];
//   $test1=$row["test1"];
//   $test2=$row["test2"];
//   print ("$ID - $test1 - $test2");
// 
// I'm used to using Cold Fusion and want to learn PHP.  Any 
// help would be
// appreciated.  Thanks.
// Pete
// 
// 
// 
// -- 
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail: 
// [EMAIL PROTECTED]
// 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]