To get the $admin_name in the categories.php

[juniorphp]

I want to get the admin name after they log in,
and use this variable in the categories.php

is it a session variable?

I tried to echo $admin_name; in categories, but it didn't work

[DrByte]

I want to get the admin name after they log in,
and use this variable in the categories.php

Why?

is it a session variable?

I tried to echo $admin_name; in categories, but it didn't work

You'd have to look it up from the database by referencing $_SESSION['admin_id']

[juniorphp]

I got it, thank you.

Also, i want to know the location of code for categories listing in categories.php

thank a lot~

[DrByte]

I got it, thank you.

Also, i want to know the location of code for categories listing in categories.php

thank a lot~

You're changing topics now, but I think what you're looking for is /admin/includes/modules/category_product_listing.php

[juniorphp]

I can get the admin_id

echo $_SESSION['admin_id'];

but I still can't extract the admin name from the SQL by the code


{

$result = $db->Execute("select admin_name from " . TABLE_ADMIN . " where admin_id = '" .$_SESSION['admin_id'] . "'");

$row = mysql_fetch_assoc($result);

echo $row['Variable_name'];

}


it give Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\~...

how can i fix it ?

[juniorphp]

as I can get the admin_id after login in

echo $_SESSION['admin_id'];

but I still can't extract the admin name from the SQL by the code


{

$result = $db->Execute("select admin_name from " . TABLE_ADMIN . " where admin_id = '" .$_SESSION['admin_id'] . "'");

$row = mysql_fetch_assoc($result);

echo $row['Variable_name'];

}


it give Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\~...

how can i fix it ?

[DrByte]

Repeating the same post again isn't very helpful to anybody.
Posting more information about things you've tried will usually get you faster (and definitely friendlier) answers.

but I still can't extract the admin name from the SQL by the code


{

$result = $db->Execute("select admin_name from " . TABLE_ADMIN . " where admin_id = '" .$_SESSION['admin_id'] . "'");

$row = mysql_fetch_assoc($result);

echo $row['Variable_name'];

}

1. Why would you expect $row['Variable_name"] to match anything in the original query?

2. If you're going to use the Zen Cart functions to query the database, you need to be consistent in doing so.
You'll find it much easier to use this:

$result = $db->Execute("select admin_name from " . TABLE_ADMIN . " where admin_id = '" . $_SESSION['admin_id'] . "'");

echo $result->fields['admin_name'];