PHP - Database Driven Php Menu System

I'm looking to open a custom giftcard shop in which I'll be selling giftcards at 75%-95% of the face value. (I usually buy them off ebay cheap and resell them).

I've already got the login system complete by using one I found online. What I'm looking to do now is make the shop section now where I can import a text document with the giftcard #, and Pin number to have them all show up in a list (but have only the first 6 numbers show up and the rest stared out with "***" until purchased, with the option to add each individual one to the cart (checkboxes beside each one).

But I want them to be able to buy them with "credits". Credits being a site currency I'd like to be created. I want users to be able to buy these "credits" with the LibertyReserve API. These credits are to be attached to their login until used up. 1 credit = 1$ LR

I notice Libertyreserve has a sample shop script: http://www.libertyreserve.com/en/home/downloads , but it doesnt exactly have the credit features and cart features I stated above, however I'm sure can be somewhat useful in coding what I need.

Any help would be greatly appreciated, since I have no idea where to start. I'm sure this is basic to some, and well I'm looking to hire someone if they are confident they can complete this quick, otherwise any free feedback would help so much.

Here is the site so far... http://www.eliteids.com/lrstore

I have a database table of plants, one of chemicals, one of products, one of illnesses. Each table is connected, for example lets say opium poppies. They contain the chemical morphine. Morphine is used in painkiller products. Its used to treat pain and other illnesses. On the opium poppy page, I want to list all the chemicals found in the poppy. All the products (i.e. opium, laudanum) made from the poppy. All the illnesses which are treated with the poppy. Users need to be able to edit this page, and enter chemicals, products or illnesses that are related to this plant. They also need to be able to edit the info on the page.   Making database relations is a pain in the ass with CakePHP. I don't want to waste any more time so I'm thinking maybe making it as a wordpress plugin is the way to go.  How would you go about this? Is there an easier way than wordpress, like a better CMS, or framework? If I use wordpress, should I do all the DB interactions with AJAX to avoid having to interact with the DB through wordpress (this gave me massive trouble in the past since I had my data in an external db)?

I've played around with CakePHP, then XCrud (a decent CRUD application) but I gave up on both of them, XCrud was great for everything up until it came to managing complicated relational database tables. Anyhow, I'm using wordpress a lot now cuz it lets me stop reinventing the wheel so much and although I was able to integrate XCrud into WordPress as a plugin, I think the best way to go is just transfer my database tables to WordPress tables and display them as custom post types. My time is really limited right now though, is there a plugin/set of plugins I can use to automate the process? To show you what I mean, heres the XCrud list display of one of the tables:   thats great because it automatically sets up the CRUD thing and lets you add and edit fields to the table, and doesn't heavily box you into their system but I have a table of plants, one for products, one for pharmacology, one for categories which are all related to each other, and some of them are structured in a tree/nested hierarchy structure so long story short, I need to do advanced searches based on these relations and handle these tree structured tables and CakePHP didn't work out, and XCrud has crappy documentation and isn't popular enough to find good info.   So how would you go about transfering this system to WordPress? I'm guessing I need to make custom post types for each table but what I don't yet know is how to transfer the DB tables to WordPress format, how to handle the relationships between each table and how to handle the hierarchical tree structures.

Ok, first off, I tested my own coded reg system and when I make an error test, the error shows but the user info gets added to the database. How can I stop letting the code add the user to the database when an error occurs.
<?php include "lang.php"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PokePals - Registering</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js" />
<link rel="stylesheet" type="text/css" href="style.css" /></head>
<body>
<?php include "navbar.php"; ?>
<?php 
// Important stuff goes here
include "sql_local.php";
include "ban.php";
// Now for the registration page
  echo "<div class='panel'>";
if (isset($_POST["submit"])) {
// Define the variables here
$user = mysql_real_escape_string ($_POST["user"]);
$pass1 = mysql_real_escape_string ($_POST["pass"]);
$pass2 = mysql_real_escape_string ($_POST["passconf"]);
$email = mysql_real_escape_string ($_POST["email"]);
$email2 = mysql_real_escape_string ($_POST["email2"]);
$dpfc = mysql_real_escape_string ($_POST["dpfc"]);
$platinumfc = mysql_real_escape_string ($_POST["platinumfc"]);
$hgssfc = mysql_real_escape_string ($_POST["hgssfc"]);
$otherfc = mysql_real_escape_string ($_POST["otherfc"]);
$favoritepkmn = mysql_real_escape_string ($_POST["favoritepkmn"]);
$aboutme = mysql_real_escape_string ($_POST["aboutme"]);
$hobbies = mysql_real_escape_string ($_POST["hobbies"]);
$favorites = mysql_real_escape_string ($_POST["favorites"]);
$gender = mysql_real_escape_string ($_POST["gender"]);

// Now check for some errors
// Did he/she fill out the form completely? Lets find out
function errors() {
if (!$_POST["user"] | !$_POST["pass"] | !$_POST["email"] ) { 
  echo "<div class='error'>Please fill in the required fields</div>";
}
// Passwords match
 if ($_POST['pass'] != $_POST['passconf']) {
   echo "<div class='error'>Password does not match with the other one</div>";
}
// Email match
 if ($_POST['email'] != $_POST['email2']) {
 echo "<div class='error'>Email does not match with the other one</div>";
 }
}

// Is the user banned?
foreach($banned_ips as $ip_ban) {
     if($user_ip == $ip_ban) {
  die ("<div class='error'>Your IP address is banned from registering. Contact the site administrator for more info</div>");
}
}
// If there are no errors, start adding the information to the database
if (!errors()) {
// Secure the passwords
$securepass = md5($pass1);
// Submit to the database
$insertuser = "INSERT INTO users (user, password, email, dpfc, platinumfc, hgssfc, otherfc, favoritepkmn, aboutme, hobbies, favorites, gender, regip) values ('$user', '$securepass', '$email', '$dpfc', '$platinumfc', '$hgssfc', '$otherfc', '$favoritepkmn', '$aboutme', '$hobbies', '$favorites', '$gender', '$user_ip')";
$add = mysql_query($insertuser, $con) or die ('Error: ' . mysql_error() . ' Please contact an admin');
if ($add) {
echo ("<h3>Registration Success</h3><p>You may now login using your username and password. Start hatching some eggs now!</p>"); }
}
}
  ?> <div class='registerform'><form action='register.php' method='post'>
      <label>Username *</label>
      <input type='text' name='user' class='form1' value='<?php echo @$_POST['user']; ?>' />
      <fieldset><legend>Password</legend>
      <label>Enter your password *</label>
      <input type='password' name='pass' class='form1' value='<?php echo @$_POST['pass']; ?>' />
      <label>Password again *</label>
      <input type='password' name='passconf' class='form1' value='<?php echo @$_POST['passconf']; ?>' />
      </fieldset>
      <fieldset><legend>Email</legend>
      <label>Enter your email *</label>
      <input type="text" name="email" class="form1" value="<?php echo @$_POST['email']; ?>" />
      <label>Enter email again *</label>
      <input type="text" name="email2" class="form1" value="<?php echo @$_POST['email2']; ?>" />
      </fieldset>
      <input type="submit" name="submit" class="submitbutton" value="Register!" />
      </form>

So I have to add data into my database for Olympic records for a school project. I have the sql statements and everything, but it will only enter the athlete's name and country into the table. My code is Code: [Select]
<html>
<head>
<title> CSS </title>
 <style type="text/css">
p {font-family:arial; font-size:10pt;}
body {margin: 0; padding: 0; text-align: center;}
a:link {text-decoration: none}
a:visited {text-decoration: overline; color:purple;}
a:active {text-decoration: underline;}
a:hover {text-decoration: line-through ; color:pink}
input:hover {background: aqua; color:black}
input:active { background: lime ; color: black; }
input:focus { background: yellow; color: black; }
.button {border: 1px dotted ; background:red; padding: 2px;}
.button:hover {border: 2px dotted;background: url('submitbackground.jpg') no-repeat top left; }

#main {margin: 0 auto; text-align: left; width: 800px;}
#nav  {clear: both; border: 1px solid; background-color:lightgreen; padding: 10px; width:auto; height: 8%;}
#div1 {border: 1px solid; background-color:lightblue; padding: 10px; float: left; width:20%; height:92%;}
#div2 {border: 1px solid; background-image: url('monkey.jpg'); background-repeat:no-repeat;
background-position:center bottom ; padding: 10px; float:left; width:74.5%; height:92%;}

</style>

</head>


<body>
<?php

session_start () ;
print_r ($_REQUEST) ;

if ($_SESSION['admin'] == 2) {
echo " sorry" ;
} else {

echo $_SESSION['admin']; 
if(isset($_POST['athname'])){
$athname= $_POST['athname'] ;
}

if(isset($_POST['country'])){
$country = $_POST['country'];
}

if(isset($_POST['medal'])){
$medal= $_POST ['medal'];
}

if(isset($_POST['venueyear'])){
$venueyear= $_POST ['venueyear'];
}
 if(isset($_POST['venuecity'])){
$venuecity= $_POST ['venuecity'];
}  
if(isset($_POST['venuecountry'])){
$venuecountry= $_POST ['venuecountry'];
}
if(isset($_POST['event'])){
$event= $_POST ['event'];
}
if(isset($_POST['gender'])){
$gender= $_POST ['gender'];
}



echo "<div id='main'> " ;

echo"<div id='nav'>";

echo"</div>" ;



echo "<div id='div1'>" ;
echo "<a href='index.php'>home</a><br/>" ;
echo "<a href='search.php'>Search</a><br/>" ;
echo "<a href='add-data.php'>Add Data</a><br/>" ;
echo "<a href='DeleteData.php'>Delete Data</a>" ;
echo "</div>" ;

echo"<div id='div2'>" ;


if (isset($_POST['search'])) {

$connection = odbc_connect('Olympics', '', '');
 
 
 if (!$connection)
{exit("Conection Failed: " . $connection);}

$enrID = null ;


if ( $event == '100 meters' and $gender == 'M') {
$enrID = 1 ;
echo "$enrID" ;
}elseif ($event == '200 meters' and $gender == 'M') {
$enrID = 2 ;
echo "$enrID" ;
}elseif ($event == '400 meters'and $gender == 'M') {
$enrID = 3 ;
}elseif ($event == '800 meters' and $gender == 'M') {
$enrID = 4 ;
}elseif ($event == '1500 meters' and $gender == 'M') {
$enrID = 5 ;
}elseif ($event == 'Long Jump' and $gender == 'M') {
$enrID = 6 ;
}elseif ($event == 'High Jump' and $gender == 'M') {
$enrID = 7 ;
}elseif ($event == 'Shot put' and $gender == 'M') {
$enrID = 8 ;
}elseif ($event == 'basketball' and $gender == 'M') {
$enrID = 13 ;
}elseif ($event == 'rowing' and $gender == 'M') {
$enrID = 14 ;
}elseif ($event == 'volleyball(indoor)' and $gender == 'M') {
$enrID = 15 ;
}elseif ($event == 'volleyball(beach)' and $gender == 'M') {
$enrID = 16 ;
}elseif ($event == '100 meters' and $gender == 'F') {
$enrID = 17 ;
}elseif ($event == '200 meters' and $gender == 'F') {
$enrID = 18 ;
}elseif ($event == '400 meters'and $gender == 'F') {
$enrID = 19 ;
}elseif ($event == '800 meters' and $gender == 'F') {
$enrID = 20 ;
}elseif ($event == '1500 meters' and $gender == 'F') {
$enrID = 21 ;
}elseif ($event == 'Long Jump' and $gender == 'F') {
$enrID = 22 ;
}elseif ($event == 'High Jump' and $gender == 'F') {
$enrID = 23 ;
}elseif ($event == 'Shot put' and $gender == 'F') {
$enrID = 24 ;
}elseif ($event == 'basketball' and $gender == 'F') {
$enrID = 25 ;
}elseif ($event == 'rowing' and $gender == 'F') {
$enrID =26 ;
}elseif ($event == 'volleyball(indoor)' and $gender == 'F') {
$enrID = 27 ;
}elseif ($event == 'volleyball(beach)' and $gender == 'F') {
$enrID = 28 ;
}

$EnrVenID = null ;


if ($venueyear == '1984') {
$EnrVenID = 1 ;
echo "$EnrVenID" ;
}elseif ($venueyear == '1988') {
$EnrVenID = 2 ;
}elseif ($venueyear == '1992') {
$EnrVenID = 3 ;
}elseif ($venueyear == '1996') {
$EnrVenID = 4 ;
}elseif ($venueyear == '2000') {
$EnrVenID = 5 ;
}elseif ($venueyear == '2004') {
$EnrVenID = 6 ;
}elseif ($venueyear == '2008') {
$EnrVenID = 7 ;
echo "$EnrVenID" ;
}elseif ($venueyear == '2012') {
$EnrVenID = 8 ;
echo "$EnrVenID" ;
}

$sql="INSERT INTO Athletes (Athname, Athcountry) values ( '$athname', '$country') " ;
$rs=odbc_exec($connection,$sql); 


$sql4="INSERT INTO Enrollments (EnrMedal, EnrYear, EnrEventID, EnrVenID) values ( '$medal', '$venueyear', '$enrID', '$EnrVenID') " ;
$rs4=odbc_exec($connection,$sql4); 
}
echo "<form method='post' action=''>\n";

echo"Please fill out all the fields with the data that you wish to be added: <br/>";

echo"Athelete Name:<input type ='text' Name='athname' > <br/> \n"  ; 

echo"Athelete Country:<input type ='text' Name='country' > <br/> \n"  ; 

echo "Medal: <select name='medal' value='medal'>\n";
echo "<option > </option>\n";
echo "<option $Gold> Gold </option>\n";
echo "<option $Silver> Silver </option>\n";
echo "<option $Bronze'> Bronze</option>\n";
echo "</select>\n" ;

echo "Venue Year: <select name='venueyear' value= 'venueyear'>\n";
echo "<option ></option>\n";
echo "<option $1984> 1984 </option>\n";
echo "<option $1988> 1988 </option>\n";
echo "<option $1992>1992 </option>\n";
echo "<option $1996> 1996 </option>\n";
echo "<option $2000> 2000 </option>\n";
echo "<option $2004> 2004 </option>\n";
echo "<option $2008> 2008 </option>\n";
echo "<option $2012> 2012</option>\n";
echo "</select>\n" ;

echo "Venue City: <select name='venuecity' value= 'venuecity'>\n";
echo "<option > </option>\n";
echo "<option $LA> Los Angeles </option>\n";
echo "<option $Seoul> Seoul </option>\n";
echo "<option $Barca> Barcelona </option>\n";
echo "<option $ATL> Atlanta</option>\n";
echo "<option $Syd> Sydney </option>\n";
echo "<option $Ath> Athens</option>\n";
echo "<option $Beij> Beijing </option>\n";
echo "<option $Lon> London</option>\n";
echo "</select>\n" ;

echo "Venue City: <select name='venuecountry' value= 'venuecountry'>\n";
echo "<option > </option>\n";
echo "<option $USA> U.S.A. </option>\n";
echo "<option $SK> South Korea </option>\n";
echo "<option $Spain> Spain </option>\n";
echo "<option $Aus> Australia </option>\n";
echo "<option $Greece> Greece</option>\n";
echo "<option $Chin> China </option>\n";
echo "<option $UK> United Kingdom</option>\n";
echo "</select>\n" ;

echo "Event: <select name='event' value='event>\n";
echo  "<option value=''> </option>\n";
echo "<option > </option>\n";
echo "<option $100m> 100 meters</option>\n";
echo "<option $200m> 200 meters </option>\n";
echo "<option $400m>400 meters </option>\n";
echo "<option $800m> 800 meters </option>\n";
echo "<option $1500m> 1500 meters </option>\n";
echo "<option $LongJump> Long Jump</option>\n";
echo "<option $HighJump> High Jumo </option>\n";
echo "<option $Shotput> Shot put </option>\n";
echo "<option $Basketball> Basketball </option>\n";
echo "<option $Rowing> Rowing </option>\n";
echo "<option $Volleyball> Indoor Volleyball </option>\n";
echo "<option $Volley> Beach Volleyball</option>\n";
echo "</select>\n" ;

echo "Gender: <select name='gender'>\n";
echo  "<option value=''> </option>\n";
echo "<option $Male>M</option>\n";
echo "<option $Female>F</option>\n";
echo "</select>\n" ;


echo "<input type='submit' name='search' value='Search'  />\n";
echo "</form>\n"; 

echo "</div>" ;


}
?>
</body>

</html>
I have the really long IF statements in there so that it enters the correct EnrID and EnrVenID into the database, to make sure it fills out all fields. I am using Microsoft access for my database.

The problem is that it will only fill in the athlete's name and country, and not his/her enrollment information (what medal they got, their enr ID, what year it was taken place, etc.




The problem with my login system is that I want the user to login with a username and password if they wish to be an admin, but the login system doesn't work. the variables aren't passed through the system for some reason, even though it worked a week ago,  but now it doesn't.
The code is Code: [Select]
if(isset($_POST['username'])){
$username= $_POST['username'] ;
}
if(isset($_POST['password'])){
$password= $_POST['password'] ;
}

$username = null ;
$password = null ;
Thanks for any help

I currently have a MyBB forum and I'm going to attempt to create a top list for it, but I'd like users that have already registered on my forum to be able to log into the top list area and either add or edit their website on the top list. How would I go about creating a login script with an already existing MySQL database that contains my MyBB users?

I currently have an HTML form where the options for a certain drop-down menu are hard-coded. Instead, I want to use PHP to...

1. Look up the values in a column (cities) in a MySQL table (locations)
2. Make those values the only options in the dropdown menu.

Any ideas how I would do this? This is what I have so far.

<label for="city">What is your destination city?</label>
<select class="form-control" id="city" name="city">

<?php
//connect to the database
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

//grab the city names from the MySQL table 
$query = "SELECT cities FROM locations";

$res = mysqli_query($dbc, $query);

while ($data = mysqli_fetch_assoc($res)) {
echo '<option value="'.$data['cities'].'">'.$data['cities'].'</option>';
}

//close the db connection
mysqli_close($dbc);
?>

</select> 

Hey folks!  a two-part problem he

PART 1:
here's a weird problem i bumped into today.  when i leave OUT the 'varTable' section (see the class designations), it generates a table (allbeit messed up for reasons that i'll get into in part 2).  but when i put 'varTable' back in, it generates the first array output just fine, but nothing shows for the table.  (i need the first to be able to display the array)

why does that happen?

PART 2:
when the table DOES generate, it gives a lot of errors and $i counts up to 7!  whaaaaat!?

thanks in advance for your help.  this has me stumped.  i've tried resetting the array, different variable names...nothing worked.  i also included the array output at the very bottom.  seems like a lot of extra data in there to me...and the [ 0 ] is printing oddly here (spaces prevent odd formatting...).

WR! 



DATABASE TABLE:

| id | item    | cost  | use |
--------------------------------
| 0 | basket             | 35    |  1   |
| 1 | bicycle            | 165   |  1   |
| 2 | glass                | 5      |  1   |
| 3 | running shoe    | 156   |  1   |
| 4 | silver               | 300   |  1   |

PHP CODE:
Code: [Select]
<?php include("constants.php");

<?php
   $connexion = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
   if(!$connexion) { die("Database Connection Failed: ".mysql_error()); }
   
   $selectDB = mysql_select_db("DB_CHOICE", $connexion);
   if(!$selectDB) { die("Database Selection Failed: ".mysql_error()); }
   
   $query = "SELECT * ";
   $query .= "FROM basic_table";
   
   $results = mysql_query($query, $connexion);
   if(!$results) { die("Database Query Failed: ".mysql_error()); }
?>
<div>
<pre class="varTable">
   <?php
      while($checkTable = mysql_fetch_array($results)) {
         print_r($checkTable);
      }
   ?>
</pre>
</div>

<br><br>
<div id='codeBlock'>
<table class='phpTable' width='500' cellpadding="10">
   <?php   //   generate table header row
      while ($tableRow = mysql_fetch_array($results)) {
         echo "<tr>";
         for($i=0; $i<count($tableRow); $i++) {
            echo "<td>" . 
            $tableRow[$i] .
            "</td>";   
         }
         echo "</tr>\n";
      }
   ?>
</table>
ARRAY OUPUT:

Code: [Select]
Array
(
    [0] => 1
    [id] => 1
    [1] => basket
    [item] => basket
    [2] => 35
    [cost] => 35
    [3] => 1
    [usable] => 1
)
Array
(
    [0] => 2
    [id] => 2
    [1] => bicycle
    [item] => bicycle
    [2] => 165
    [cost] => 165
    [3] => 1
    [usable] => 1
)
Array
(
    [0] => 3
    [id] => 3
    [1] => glass
    [item] => glass
    [2] => 5
    [cost] => 5
    [3] => 1
    [usable] => 1
)
Array
(
    [0] => 4
    [id] => 4
    [1] => running shoe
    [item] => running shoe
    [2] => 14
    [cost] => 14
    [3] => 1
    [usable] => 1
)
Array
(
    [0] => 5
    [id] => 5
    [1] => silver
    [item] => silver
    [2] => 300
    [cost] => 300
    [3] => 1
    [usable] => 1
)

hello dear PHP-Fans - greetings to you - and a happy new year!!


i set up a WAMP-System on my openSuse 11.4 system.  In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running.  Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want  to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=351877.0

Hello all;
I have a client that has a members area.  He asked me to password protect it, which I did simply by assigning one static password.  Now he wants a full username/login system where the member can set their own password, which I have never done before.  I assume I'd just set up a Table with three fields, (one for name, one for password, one for the type of access they have) then check against it for access, but experience has taught me that whenever something seems simple, it's actually very complex. 

Do any of you know of any good premade templates for this kind of thing?  Ideally it'd be session-based (obviously).  I found one system he http://frozenade.wordpress.com/2007/11/24/how-to-create-login-page-in-php-and-mysql-with-session/  but it's several years old, and the misspellings in the comments tend to scare me away a bit. 

Thanks for any help you might be able to provide.

I'm trying to make it so that someone can add an item to the shop based upon the current items within the database.

How do I go about doing that? I know i have to change <input> to <select>, but beyond that, how do I code it so I can run an array to get all the current items from the table `items` and list them by their `name` field?

Thanks in advance!

Here is what I have so far:


function addshopinv($id) {
error_reporting(E_ALL);
ini_set('display_errors', 1);
   if (isset($_POST["submit"])) {
        extract($_POST);
        $errors = 0;
        $errorlist = "";
        if ($name == "") { $errors++; $errorlist .= "Name is required.<br />"; }
else if ($errors == 0) { 
$dbh=dbconnect() or die ("Userlist read error: " . mysql_error()."<br>");
mysql_select_db("XXX");
$query = mysql_query("SELECT id FROM items WHERE name='$name'");
while ($result = mysql_fetch_array($query)){
$item_id = $result['id'];
$query1 = mysql_query("INSERT INTO sale SET shop_id='$id', item_id='$item_id'");
}
            admindisplay("Inventory Item Added.","Add New Inventory Item");
        } else {
            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Add New Item to Shop");
        }        
   }

   $page = <<<END
<b><u>Add New Inventory Item</u></b><br /><br />
<form action="admin_panel.php?do=addshopinv:$id" method="post">
<table width="90%">
<tr><td width="20%">Name:</td><td><input type="text" name="name" size="30" maxlength="255" value="" />*255 character max</td></tr>
</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>
END;
    $page = parsetemplate($page, $row);
    admindisplay($page, "Add New Inventory Item");
}

Hi all,
i want my list/menu field values to come from my database. how can i accomplish that?
thanks

i did
Code: [Select]
<select name="select">
                  <option value="0">--select below--</option>
  <option value="1">Me</option>
  <?php
  
                  require_once '../konnect/konex.php';

$result = mysql_query("SELECT * FROM is_clients");

while($row = mysql_fetch_array($result))
  {
  echo "<option value ='2'>".$row"['name']</option>";
  echo "<br />";
  }

?>
                  </select>

Where is the best to store the list of categories and menu? Obviously it is better to reduce mysql queries. From a plain list in file, we can create desirable list (menu) from an array. This is quite faster (though SELECT from an indexed table is fast too; but I do know if it is as fast as reading from a php file). Any idea how to code this to create the menu faster ?