[Bonzo]

I will try to keep this post short and to the point.

A freind of mine has started up in PC repair.

I sugested when he was out and needed some info he could go to his website and look at a database.

He WAS happy with this before but now :He wants his customers to have some access to the information.

Before I just had a database with one table and a form to search the datbase.

Question is what to do now - I do not want to input all the data into two different tables.

Choices : Two tables and when the data is uploaded only a certain amount goes into one. One table and add a variable so only a certain amout of the data can be seen.

Any sugestions either on a way to do this or a link to a code would be helpful.

Anthony

[the_mole001]

Hey,

It might not be the best way, but i'd suggest you add a column to the table for something like "access" and have a number/word system. Say a user can onli have a low access have low, then medium or high, or 1, 2 and 3. Then when printing results catorgrize what you want each level to see. Just an idea

-Peter

[Bonzo]

I had not thought this through.

All I need is two different query's :

Select col1, col2 FROM database - for user

Select * FROM database - for Admin

Use a "login" for Admin which would let him have the " * " search.

Thanks for making me think Peter.

Anthony

[cbunting]

Hello,
You are correct. You don't need any additional tables. Just put togeather another script or page and only pull out the info that you want the users to see.

If you run into any problems, Let me know and i'll do what I can to help.

Regards,
Chris

[Bonzo]

Thanks for the offer Chris; I am trying to be clever and its not working !

PHP Code:

// Query by make



  $query = "SELECT DISTINCT make FROM support ORDER BY make";

  $result = mysql_query($query) or die ("Couldn't execute query.");



  echo "<form action = ",$PHP_SELF," method='post_self'><select name='make'>\n";



  while ($row = mysql_fetch_array($result))

  {

    extract($row);

    echo "<option value='$make'>$make\n";

  }

  echo "</select>\n";

  echo "<input type='submit' value='Select by make'></form>\n";

        

if (isset($make)) {print "no";}



else {print "yes";} 

I thought I would try and be clever :

Instead of the user inputting something to search for I thought I would give them a list of the options - other wise the could take ages finding an answer.

I then thought instead of passing the variable to another page I would save pages by sending to itself.

The first form works OK and the dropdown list is populated OK; when I select an option that is added to the URL e.g. ?make=dell

From there it goes wrong as the "isset" check I put in always comes up "no".

Can someone help me out please Anthony

[nd2]

try empty() instead of isset() i also spoted this line
echo "<option value='$make'>$make\n";

you may want to make it like

echo "<option value='".$make."'>".$make."</option>\n";

or even

echo '<option value="'.$make.'">".$make."</option>';

[Bonzo]

Thanks for the ideas nd2 but my code looks about right echo "<option value='$make'>$make\n"; if I change it to echo "<option value='".$make."'>".$make."</option>\n"; all my options in the list are $make !
This was my first attempt at php and I will check it again later - Have to go soon wifie is on about geting some DIY done. I have a feeling the problem may be here though.

The empty bit did not work properly either so I tried both :

PHP Code:

if (empty($make)) {print "empty = no";}

else {print $make;}



if (isset($make)) {print "<br>isset = no";}

else {print $make;} 

When first navigating to page :

Hewlet packard
isset = no

When sellecting Compac and pressing submit ( with ?make=Compac in the address bar )

Hewlet packard
isset = no

Note: Hewlet packard is the last option on my list.

Anthony

[NeverMind]

I don't know why people depend on registered globals!!

try this one intstead:

PHP Code:

if (isset($_GET['make']))

  echo $_GET['make'].': Yes';

else

  echo 'no'; 

also I noticed that your form method is 'post_self' not POST !!
what is this post_self anyway ?

[Bonzo]

WAHOO that works now ; thanks NeverMind. All I have to do i intigrate it into my next form.

I was desperate last night and was trying anything hence " what is this post_self anyway ? " I thought I had seen it somewhere : )

If I leave the method on the form will not work - dose nothing not even add the make to the URL.

I now have - the isset still a test.

PHP Code:

echo "<form action = ",$PHP_SELF,"><select name='make'>\n";



  while ($row = mysql_fetch_array($result))

  {

    extract($row);

    echo "<option value='$make'>$make\n";

   }

echo "</select>\n";

echo "<input type='submit' value='Select by make'></form>\n";



if (isset($_GET['make']))

  echo $_GET['make'].': Yes';

else

  echo 'no' 

This adds the make to the URL OK and output of the "isset" is Dell: Yes

Thanks for the help guy's

Anthony

[Bonzo]

I think you were trying to catch me out NeverMind and it worked !!

PHP Code:

if (isset($_GET['make'])) 

  echo $_GET['make'].': Yes'; 

else 

  echo 'no' // where is the ; 

Anthony