Hmm, no, thats not essential. There are three possibilities to access
data:
If I use mysql_fetch_object i refer to the fields in this way:
$query->field
If I use mysql_fetch_array I would use $query["field"]
If I use mysql_fetch_row I would use $query[1]
So this couldn´t the problem.
Andreas
On Thursday, February 28, 2002, at 11:48 AM, John Dean wrote:
> Hi
> Should mysql_fetch_object be mysql_fetch_row?
>
> At 11:30 28/02/2002 +0100, you wrote:
>> Regularily, but not in certain tables, I don´t get the excepted result
>> back from a query which in all other cases works perfect.
>> My opinion is that there could be a problem with the index of the
>> table.
>>
>> Probably there could also a bug in the wrapper script which I use to
>> access the database and sometimes tables are not closed correctly
>> (when I use ANALYSE/REPAIR)
>>
>> I use the following fragment, perhaps its not the best script to
>> access the database:
>>
>> <? $av_qid = db_query("
>> SELECT *
>> FROM attributeValue
>> WHERE attribute_type_id = 1
>> ");
>>
>> while ($rr = db_fetch_object($av_qid))
>> {
>> ...
>> }
>> ?>
>>
>>
>> -----------------------
>> script library to access db:
>>
>> <?
>> if (!isset($DB_DIE_ON_FAIL)) { $DB_DIE_ON_FAIL = true; }
>> if (!isset($DB_DEBUG)) { $DB_DEBUG = false; }
>>
>> function db_connect($dbhost, $dbname, $dbuser, $dbpass) {
>> /* connect to the database $dbname on $dbhost with the user/password
>> pair
>> * $dbuser and $dbpass. */
>>
>> global $DB_DIE_ON_FAIL, $DB_DEBUG;
>>
>> if (! $dbh = mysql_pconnect($dbhost, $dbuser, $dbpass)) {
>> if ($DB_DEBUG) {
>> echo "<h2>Can't connect to $dbhost as
>> $dbuser</h2>";
>> echo "<p><b>MySQL Error</b>: ", mysql_error();
>> } else {
>> echo "<h2>Database error encountered</h2>";
>> }
>>
>> if ($DB_DIE_ON_FAIL) {
>> echo "<p>This script cannot continue,
>> terminating.";
>> die();
>> }
>> }
>>
>> if (! mysql_select_db($dbname)) {
>> if ($DB_DEBUG) {
>> echo "<h2>Can't select database $dbname</h2>";
>> echo "<p><b>MySQL Error</b>: ", mysql_error();
>> } else {
>> echo "<h2>Database error encountered</h2>";
>> }
>>
>> if ($DB_DIE_ON_FAIL) {
>> echo "<p>This script cannot continue,
>> terminating.";
>> die();
>> }
>> }
>>
>> return $dbh;
>> }
>>
>> function db_disconnect() {
>> /* disconnect from the database, we normally don't have to call this
>> function
>> * because PHP will handle it */
>>
>> mysql_close();
>> }
>>
>> function db_query($query, $debug=false, $die_on_debug=true,
>> $silent=false) {
>> /* run the query $query against the current database. if $debug is
>> true, then
>> * we will just display the query on screen. if $die_on_debug is
>> true, and
>> * $debug is true, then we will stop the script after printing he
>> debug message,
>> * otherwise we will run the query. if $silent is true then we will
>> surpress
>> * all error messages, otherwise we will print out that a database
>> error has
>> * occurred */
>>
>> global $DB_DIE_ON_FAIL, $DB_DEBUG;
>>
>> if ($debug) {
>> echo "<pre>" . htmlspecialchars($query) . "</pre>";
>>
>> if ($die_on_debug) die;
>> }
>>
>> $qid = mysql_query($query);
>>
>> if (! $qid && ! $silent) {
>> if ($DB_DEBUG) {
>> echo "<h2>Can't execute query</h2>";
>> echo "<pre>" . htmlspecialchars($query) .
>> "</pre>";
>> echo "<p><b>MySQL Error</b>: ", mysql_error();
>> } else {
>> echo "<h2>Database error encountered</h2>";
>> }
>>
>> if ($DB_DIE_ON_FAIL) {
>> echo "<p>This script cannot continue,
>> terminating.";
>> die();
>> }
>> }
>>
>> return $qid;
>> }
>>
>> function db_fetch_array($qid) {
>> /* grab the next row from the query result identifier $qid, and return
>> it
>> * as an associative array. if there are no more results, return
>> FALSE */
>>
>> return mysql_fetch_array($qid);
>> }
>>
>> function db_fetch_row($qid) {
>> /* grab the next row from the query result identifier $qid, and return
>> it
>> * as an array. if there are no more results, return FALSE */
>>
>> return mysql_fetch_row($qid);
>> }
>>
>> function db_fetch_object($qid) {
>> /* grab the next row from the query result identifier $qid, and return
>> it
>> * as an object. if there are no more results, return FALSE */
>>
>> return mysql_fetch_object($qid);
>> }
>>
>> function db_num_rows($qid) {
>> /* return the number of records (rows) returned from the SELECT query
>> with
>> * the query result identifier $qid. */
>>
>> return mysql_num_rows($qid);
>> }
>>
>> function db_affected_rows() {
>> /* return the number of rows affected by the last INSERT, UPDATE, or
>> DELETE
>> * query */
>>
>> return mysql_affected_rows();
>> }
>>
>> function db_insert_id() {
>> /* if you just INSERTed a new row into a table with an autonumber,
>> call this
>> * function to give you the ID of the new autonumber value */
>>
>> return mysql_insert_id();
>> }
>>
>> function db_free_result($qid) {
>> /* free up the resources used by the query result identifier $qid */
>>
>> mysql_free_result($qid);
>> }
>>
>> function db_num_fields($qid) {
>> /* return the number of fields returned from the SELECT query with the
>> * identifier $qid */
>>
>> return mysql_num_fields($qid);
>> }
>>
>> function db_field_name($qid, $fieldno) {
>> /* return the name of the field number $fieldno returned from the
>> SELECT query
>> * with the identifier $qid */
>>
>> return mysql_field_name($qid, $fieldno);
>> }
>>
>> function db_data_seek($qid, $row) {
>> /* move the database cursor to row $row on the SELECT query with the
>> identifier
>> * $qid */
>>
>> if (db_num_rows($qid)) { return mysql_data_seek($qid, $row); }
>> }
>> ?>
>>
>>
>>
>> -----------------------------------------
>> Andreas Habereder
>> Kirchenstr. 17e
>> 81675 München
>> private: [EMAIL PROTECTED]
>> fax: +49 1212 5 107 37 317
>> mobile: +49 172 838 7771
>> -----------------------------------------
>>
>> This message is for the designated recipient only and may contain
>> privileged, proprietary, or otherwise private information. If you have
>> received it in error, please notify the sender immediately and delete
>> the
>> original. Any other use of the email by you is prohibited.
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail <mysql-unsubscribe-
>> [EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
> Regards
> John
>
> -----
> [EMAIL PROTECTED]
> http://www.rygannon.com
>
>
>
>
>
>
>
>
>
>
>
>
-----------------------------------------
Andreas Habereder
Kirchenstr. 17e
81675 München
private: [EMAIL PROTECTED]
fax: +49 1212 5 107 37 317
mobile: +49 172 838 7771
-----------------------------------------
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete the
original. Any other use of the email by you is prohibited.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
