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
