|
|
Posted by Neal on 08/03/05 02:30
Scott Auge wrote:
> In article <icQHe.687950$Cl1.273185@fe03.news.easynews.com>,
> Neal <pissed@comcast.net> wrote:
>
>
>>JDS wrote:
>>
>>>
>>>You lost me.
>>>
>>>Post the results of
>>>
>>>DESCRIBE <tablename>
>>>
>>>for both tables. (i.e. what do the tables actually look like?)
>>>
>>>Also, what are the problems you are having? All you say is "but am having
>>>problems". Just not enough info, hoss.
>>>
>>
>>Sorry if I'm unclear. Basically, I'm giving unique passwords to schools
>>in our district so they can post jobs. This part works and all the info
>>gets put into a table called 'jobs'. But, I'm trying to make another
>>page where they can login and only their school will show up (so I can
>>later make it so they can delete their own entry if they fill their
>>position).
>>
>> $sql = "SELECT * FROM login WHERE
>> username = '$PHP_AUTH_USER' AND
>> password = '$PHP_AUTH_PW'";
>> $result = mysql_query( $sql )
>> or die ( 'Unable to execute query.' );
>> $X = mysql_fetch_array($result);
>> $num = mysql_numrows( $result );
>> if ( $num != 0 ) {
>> $auth = true;
>> }
>> }
>>
>>if ( ! $auth ) {
>>
>> header( 'WWW-Authenticate: Basic realm="Private"' );
>> header( 'HTTP/1.0 401 Unauthorized' );
>> echo 'Authorization Required.';
>> exit;
>>
>>} else {
>>
>>$school = "$X[school]";
>>echo("$school");
>>$S1 = "SELECT * FROM jobs WHERE school = '$school'";
>>$S2 = mysql_query($S1);
>>while($S3 = mysql_fetch_array($S2))
>>{
>>print("$S3[title] : $S3[school]");
>>}
>>
>>I put that echo part just to test if I get the correct school according
>>to the username and password (this part works). The problem I think is
>>with the WHERE statement because when I take that out, I get ALL the
>>entries from the jobs table printing the title field and the school
>>field like it should. But with the above WHERE statement where I'm
>>trying to limit it to one school only, I get just the school name from
>>the echo.
>
>
> That is how it is suppose to work.
>
>
>>The login table has 3 fields: username, password, and school. The jobs
>>table has a bunch of fields, one of them being schools that I'm trying
>>to match to the login.
>>Sorry, if I'm not more clear.
>
>
> It sounds like that is what it is doing.
>
> Maybe you can describe what you were hoping to get.
>
>
I'm hoping to retrieve and print records currently in the table where
the field 'school' = $school.
There are currently about 10 records in the table, and lets say one of
them has Washington HS in the
school field. When I put WHERE school = 'Washington HS'"; the
corresponding row (title : school)
will print out. But, when I put WHERE school = '$school'"; .... nothing.
Even though the echo("$school'); line prints out 'Washington HS' (if I
entered the username and password associated with this school from the
login table).
Basically, this is an attempt at session management using 2 MySQL tables
so when the user logs (using the login table), they'll only see their
records from another table I'm trying to associate with the login table.
If there is
another way....
Navigation:
[Reply to this message]
|