[Quarterbore]

Sorry, you lost me

My issue is that I want to create an AdminCP area that shows somethng like this:

Current Default Credits = 3
Update Default Credits to ____ [Submit]

The problem is, I am struggling to get the "3"

I am pretty sure my solution will be on this page:

http://www.php.net/manual/en/functio...etch-field.php

Here is what I am fighting with at this moment:

PHP Code:

$credits_values = $vbulletin->db->query("
    SELECT vbclassified_credits
    FROM " . TABLE_PREFIX . "user
    ");

$meta = mysql_fetch_field($credits_values);
$default = $meta->def;
echo 'Default Credits = ' . $default;
echo '<br />';
print_r($meta);
exit(); 


This shows me the following:

Default Credits =
stdClass Object ( [name] => vbclassified_credits [table] => dev_user [def] => [max_length] => 4 [not_null] => 1 [primary_key] => 0 [multiple_key] => 0 [unique_key] => 0 [numeric] => 1 [blob] => 0 [type] => int [unsigned] => 0 [zerofill] => 0 )

The values in this database for this field (from PHPMyAdmin) is this:

Field: vbclassified_credits
Type: INT
Length/Values: 5
Collation:
Attributes:
Null: not null
Default: 3
Extra:
Comments:

--------------------------------------------------------------------------------------------------
I changed my code to use the sample from the PHP.net site so it looks like this:

PHP Code:

$credits_values = $vbulletin->db->query("
    SELECT vbclassified_credits
    FROM " . TABLE_PREFIX . "user
    ");

// This checks if field exists!
$meta2 = mysql_field_seek($credits_values, 0);
echo '<br />';
echo 'vBClassified Credits Exists = ' . $meta2;
echo '<br />';



$i = 0;
while ($i < mysql_num_fields($credits_values)) {
    echo "Information for column $i:<br />\n";
    $meta = mysql_fetch_field($credits_values, $i);
    if (!$meta) {
        echo "No information available<br />\n";
    }
    echo "<pre>
blob:         $meta->blob
max_length:   $meta->max_length
multiple_key: $meta->multiple_key
name:         $meta->name
not_null:     $meta->not_null
numeric:      $meta->numeric
primary_key:  $meta->primary_key
table:        $meta->table
type:         $meta->type
default:      $meta->def
unique_key:   $meta->unique_key
unsigned:     $meta->unsigned
zerofill:     $meta->zerofill
</pre>";
    $i++;
}

exit(); 


Now my Output looks like this:

vBClassified Credits Exists = 1
Information for column 0:

blob: 0
max_length: 4
multiple_key: 0
name: vbclassified_credits
not_null: 1
numeric: 1
primary_key: 0
table: dev_user
type: int
default:
unique_key: 0
unsigned: 0
zerofill: 0

So close but so confused...?

Oh yea, I confirmed I have the correct table and it sees the database and field as I edited the null value and refreshed my test script that the non tull value changed from 0 to 1. I tried changing my default value and it still shows as NULL?

Some notes as I try to figure this out:

$max_length is the length of the longest value for that field in the returned dataset, NOT the maximum length of data that column is designed to hold.