[PHP] array

2001-09-24 Thread Jeremy Morano

Hello everyone.

I'm  encountering difficulties using my arrays.

while ($row = mysql_fetch_array($result)) {
$link[$c] = $row['link'];
$c = $c + 1;
}


This is where I try  using it.




while ($row = mysql_fetch_array($result)) {
$date = $row['date'];
$path = $row['path'];
$entry_name = $row['entry_name'];
$company_name = $row['company_name'];

$file = basename ($path);

while ($c = 0) {

echo $link[$c];


if($file == $link[$c])
{
$file = This is new;
}

$c = $c -1;
}

$contact_list2 .= $date   $file   $entry_name   $company_name\n;

}



Comment:  Theecho $link[$c]  works fine. It displays what it should.
However the if statement does not because $file and $link[$c] are equal on
several occasions yet the content of $file doesn't change...  Thank You.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] NT?

2001-09-10 Thread Jeremy Morano

Hello, 
Sorry to bother everyone. I was just wondering if php runs on NT?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] clear contents?

2001-09-07 Thread Jeremy Morano


Hi everone...
I'm having a little problem. The code below pops up a password dialog box
where the user types in a username and a password to be able to proceed.
However, if the user does not close the browser and goes back to the link,
which they pops up the diolog box again and they don't have to type in there
username and password again. They are remembered. I would like it so that
the user has to type in there username and password any and every time that
the diolog box is called on. Doe anyone know how to do this?  I tried to
clear the contents of PHP_AUTH_USER and PHP_AUTH_PW at the top of the page
but that just messed things up. Can someone please help me?



?
session_start();
session_register(PHP_AUTH_USER);



if (isset( $PHP_AUTH_USER )  isset($PHP_AUTH_PW))




// Connect to MySQL

mysql_connect( 'l', 'c', 'c' )
or die ( 'Unable to connect to server.' );

// Select database on MySQL server

mysql_select_db( 'contact' )
or die ( 'Unable to select database.' );

// Formulate the query

$sql = SELECT * FROM users WHERE
username = '$PHP_AUTH_USER' AND
password = '$PHP_AUTH_PW';

// Execute the query and put results in $result

$result = mysql_query( $sql )
or die ( 'Unable to execute query.' );

// Get number of rows in $result.

$num = mysql_numrows( $result );

if ( $num != 0 )


// A matching row was found - the user is authenticated.

$auth = true;

}

}

if ( ! $auth )


header( 'WWW-Authenticate: Basic realm=Private' );
header( 'HTTP/1.0 401 Unauthorized' );
echo 'Authorization Required.';
exit;

} else


session_start();

}

if ($valid != yes) {
header(Location: contact_menu.php);
exit;
}

?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] isset

2001-09-04 Thread Jeremy Morano

Hi ,

Is there anyway of hiding the name of the website in the isset Enter
Network Password window?



if (isset( $PHP_AUTH_USER )  isset($PHP_AUTH_PW))


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] authenticate

2001-09-04 Thread Jeremy Morano

Hi,

Is there anyway that I can hide my website name in the authenticate window?

if ( ! $auth ) { 

header( 'WWW-Authenticate: Basic realm=Private); 
header( 'HTTP/1.0 401 Unauthorized' ); 
echo 'Authorization Required.'; 
exit; 

}

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] option block

2001-09-04 Thread Jeremy Morano

Hello everyone, I'm having a problem with my option block... I'm trying to
pass the value of uid to the next page. I always get the last uid value in
table user. How can I change this so I get to pass the value of the user's
choice?




$sql = SELECT user.uid, user.first_name, user.last_name
FROM user, company
Where company.uid = user.companyUid and company.company = '$PHP_AUTH_USER'
ORDER BY last_name
;



$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);


while ($row = mysql_fetch_array($result)) {
$uid = $row['uid'];
$first_name = $row['first_name'];
$last_name = $row['last_name'];

$option_block .= option value=\$uid\$last_name, $first_name/option;
}

$display_block = 

FORM METHOD=\post\ ACTION=\show_moduser.php\

PstrongUser:/strong
select name=\uid\
$option_block
/select

INPUT TYPE=\SUBMIT\ NAME=\submit\ VALUE=\Select this User\/P
/form

;


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] JOIN

2001-08-30 Thread Jeremy Morano

Sorry everone but I 'm having a hard time with joins


How do I add this clause:

users.uid = selection.user_uid from table selection 

to this query:

$sql = SELECT users.uid, users.username
FROM users LEFT JOIN picks
ON users.uid = picks.user_id 
WHERE picks.user_id IS NULL

Thank You.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] FW: correction to JOIN

2001-08-30 Thread Jeremy Morano



-Original Message-
From: Jeremy Morano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:05 PM
To: [EMAIL PROTECTED]
Subject: JOIN 


Sorry everone but I 'm having a hard time with joins


How do I add this clause:

users.uid  selection.user_uid from table selection 

to this query:

$sql = SELECT users.uid, users.username
FROM users LEFT JOIN picks
ON users.uid = picks.user_id 
WHERE picks.user_id IS NULL

Thank You.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] im puzzled

2001-08-29 Thread Jeremy Morano

Hi ,

this is my query

SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;

this works correctly. The results are what they are supposed to be:
However, when I change the = sign to a  or !=, The results are completely
incorrect.

--

picks.user_id contains: 5, 1, 7, 8, 9, 12, 13, 15

users.uid contains: 1, 8, 9, 5, 7, 10, 11, 12, 13, 14, 15


the result for SELECT users.uid FROM users, picks WHERE users.uid =
picks.user_id; is:

5, 1, 7, 8, 9, 12, 13, 15

and the result for SELECT users.uid FROM users, picks WHERE users.uid 
picks.user_id; is:

1, 7, 8, 9, 10, 11, 12, 13, 14, 15, 5, 7, 8, 9, 10, 11,12, 13, 14, 15, 1, 5,
8, 9, 10 ,11...etc

it goes on for 80 rows with no particular pattern..H.E.L.P.!.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] concatenate?

2001-08-28 Thread Jeremy Morano


Hello,

I was just wondering if there was a simple function like str_con or
something like that to concatenate strings?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] fix my query please

2001-08-28 Thread Jeremy Morano

an somebody please fix up my query.




$connection = @mysql_connect(l, c, c) or die(Couldn't connect.);

$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);



$sql = SELECT distinct users.uid , users.username
FROM users LEFT OUTER JOIN picks using(id)
Where  users.uid  picks.user_id
;



$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);


while ($row = mysql_fetch_array($result)) {
$usersleft = $row['username'];
$uid = $row['uid'];

$my_string=$usersleftbr;

echo $my_string;
}


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] clause

2001-08-27 Thread Jeremy Morano

Hi,

Can somebody help me out?
My where clause is completely being ignored.
More specifically the . I tried to use != and that didn't work either.
However, when I substitute it with an = , It fuctions correctly.

Right now, the output is all the users.uid and all the users.username from
the table users.
H E L P !



$connection = @mysql_connect(l, c, c) or die(Couldn't connect.);

$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);

$sql = SELECT distinct users.uid , users.username
FROM users, picks
WHERE picks.users_uid  users.uid
;

$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);


while ($row = mysql_fetch_array($result)) {
$uid = $row['uid'];
$username = $row['username'];

$option_block .= option value=\$uid\$username/option;
}


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] \n

2001-08-24 Thread Jeremy Morano


Sorry to bother you with what probably seems like a useless question but why
is this not skipping a line?


echo  $team \n ;



Its in a while loop and the output is:

  Bears Giants Jets etc


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] limit 1

2001-08-24 Thread Jeremy Morano


Hi,


I wondering if it was possible to use limit on part of a query and not all.




this is my query which works the way it should.

$sql = SELECT users.names
FROM  users, selection
Where  users.name = selection.name   and   setting = 'on' limit 1
;




What I would like to do is put a limit of 1 to only this part - setting
= 'on' limit 1 --- and not on the rest.

You see, there are many users.name that have a setting = 'on'I
want, ALL those names , ONLY once..

How do I do this?



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] always last

2001-08-23 Thread Jeremy Morano

Hi,  I need a little bit of help.
My variable $team in the option block is always set to the last variable
that is readI would like it to contain the option that the user
clicks.Please help me!



My Select works properly

...


$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);


while ($row = mysql_fetch_array($result)) {
$uid = $row['uid']
$team = $row['team'];


$option_block .= option value=\$uid\$team/option;
}

$display_block = 

FORM METHOD=\post\ ACTION=\show_makeapick.php\

PstrongTeam:/strong
select name=\uid\
$option_block
/select

INPUT TYPE=\SUBMIT\ NAME=\submit\ VALUE=\Select this Team\/P
/form

;

?

HTML
HEAD
TITLEUser Management: Modify a User/TITLE
/HEAD
BODY
h1User Management/h1
h2emModify a User/em/h2
PSelect a contact from the list below, to modify the user's record./p

? echo $display_block; ?

pa href=contact_menu3.phpReturn to Main Menu/a/p

/BODY
/HTML



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] column_name

2001-08-22 Thread Jeremy Morano

Hi ,

I was wondering if there was a way to retreive a column_name instead of a
value in a query?

For example if my table has the fieldfirstname,  lastname, telephone,
movie1, movie2, movie3..


And my first record is JohnDoe  555-
good   bad bad
My second record isJane  Doe  555- good
goodbad

I would like to know which movies Jane Doe rated good'...Is
this possible and if so how?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] strange error

2001-08-22 Thread Jeremy Morano

Hi,

I get an error message which I can't figure out.

Its a Parse error: on line 142 which is the last line of the page containing
absolutly no code. The last line of code is simply /HTML..Did
anyone have a similar experience? Can anyone help me out please?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] sessions

2001-08-21 Thread Jeremy Morano

Hi ,

I'm having problems with my session_unregister(). Maybe what i'm trying to
do can't be done but I would like someones opinion. This is what I am doing
and why i'm doing it.

session_start();
session_unregister(val_1);
session_register(val_1);

I am doing this to clear the contents of val_1 before I use it again.
Needless to say its not working. val_1 always contains the same value until
I close the browser. How should I go about it?


P.S. Sorry if you've seen a similar post yesterday, I just never got a
reply.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] crop string?

2001-08-20 Thread Jeremy Morano

Hi,
 
I would like to know how to crop this string from this,

$string = \home\folder1\folder2\page1.php 

to this


$string = page1.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] basename()

2001-08-20 Thread Jeremy Morano

Hello,

Can someone please show me how to use basename() correctly?
This is what I am doing:

$file = basename ($path);
$file = basename ($path,.php3);

This is the error I'm gettig:

Warning: Wrong parameter count for basename() in
/home/virtual/ppcu/home/httpd/html/jeremy/stats4.php on line 43


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] session_unregister

2001-08-20 Thread Jeremy Morano

Help me!

I'm working with sessions and having some difficulty. I have my
session_register(variable) at the top of page 1 and page 2.

I use the session_unregister(variable) at the bottom of page 2, everything
seems to work fine at this point. The problem is,

sometimes the user needs to visit page 1 but doesn't nessessaraly have to
visit page 2. I've noticed that my variable

sometimes contains values that are concatenated due to the fact that the
user never reached the session_unregister(variable)

on page 2. What do I do? I can't unregister it at the bottom of page 1 or at
the top of page 2 since I need to pass the value

of that variable to page 2. I tried to use the session_unregister right
before the session_register at the top of page 1 but

that didn't work. The variable was still concatenated. What do I do?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] stuck

2001-08-17 Thread Jeremy Morano

Hi,

Can someone please tell me what is wrong with this page. The problem is that
my option block is always stuck on the last record in the table. No matter
what option I choose, the information, address, city, state...etc, that is
passed is always the one of the last record in the table...Help!





?
session_start();
session_register(address);
session_register(city);
session_register(state);
session_register(zip_code);
session_register(country);
session_register(company);
session_register(occupation);
session_register(telephone);
session_register(fax);

$db_name = contact;
$table_name = company;

$connection = @mysql_connect(l, c, c) or die(Couldn't connect.);

$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);

$sql = SELECT *
FROM $table_name
;

$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);


while ($row = mysql_fetch_array($result)) {
$uid = $row['uid'];
$address = $row['address'];
$city = $row['city'];
$state = $row['state'];
$zip_code = $row['zip_code'];
$country = $row['country'];
$company = $row['company'];
$occupation = $row['occupation'];
$telephone = $row['telephone'];
$fax = $row['fax'];

$option_block .= option value=\$uid\$company/option;
}



$display_block = 

FORM METHOD=post ACTION=show_adduserbycompany.php


PstrongCompany:/strong
select name=\uid\
$option_block
/select

INPUT TYPE=\SUBMIT\ NAME=\submit\ VALUE=\Select this Company\/P
/form

;

?


HTML
HEAD
TITLEUser Information: Add a User/TITLE
/HEAD
BODY
h1 User Information/h1
h2emAdd a User/em/h2
PSelect a company from the list below, to continue to the user
addition./p

? echo $display_block; ?

pa href=contact_menu.phpReturn to Main Menu/a/p

/BODY
/HTML


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] sessions

2001-08-17 Thread Jeremy Morano

Hi there, I was wondering if a function such as session_close() or
session_stop() existed. You see, i've been using session_destroy and/or
session_unregister but the problem is that they unregister and/or destroy
ALL my sessions in my server folder. What I am trying to do is just stop the
session that is going on in that particular page? How can I do this?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] Select

2001-08-14 Thread Jeremy Morano

Hi,

I'm having a problem with my Select statement. This is what i'm doing:



$connection = @mysql_connect(l, c, c) or die(Couldn't connect.);

$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);

$sql = SELECT *
FROM table_1
;

$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);

$data=mysql_fetch_row($result);
$count=$data[0];

echo   $count;



Yet the only result I get is the first value of the first
column.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] newbie

2001-08-08 Thread Jeremy Morano

Hi, I'm a real newbie at this stuff and I have a little problem...  I read
the manual but the answer to my questions were not clear. What I am trying
do do is track down a user when he or she visits my site. I would like to
store some information about them into mySql...Information like, username,
ip, connection and most importantly what page of my site it is that they
visited...I'm not sure if I have to use cookies or sessions or both and I
especially don't know where to start..

Can anyone give me some information or a link other than php.net
PLEASEthank you.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] close browser

2001-08-07 Thread Jeremy Morano

Hi,

Can anybody tell me what the code to close the browser is?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] get value

2001-08-06 Thread Jeremy Morano

hi,,,

can someone tell me how to access the value of count? please?

-
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);

$sql = SELECT count(*)
FROM $table_name, company
Where company.uid = user.companyUid and company.company = '$PHP_AUTH_USER'
;

$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);

--



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] echo

2001-08-03 Thread Jeremy Morano




$sql = SELECT first_name, last_name, address, state, zip_code, country,
company, occupation, telephone, fax, email, entry_name, password, package,
registration_date, valid_until, max_users
FROM $table_name
WHERE uid = \$uid\
;


$result = @mysql_query($sql,$connection) or die(Couldn't execute query.);


---
---When I echo $sql, I get this result
---SELECT first_name, last_name ...
How can I echo the actual values?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] not null

2001-08-01 Thread Jeremy Morano

Hi, 

When a field is declared as an integer, not null and is the primary, 
how would I address it's empty set?

ex: if($value == ???)
{
bla
bla
bla 
}


My condition wants there to be nothing in $value. 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] disable?

2001-07-31 Thread Jeremy Morano

Hi,
I was wondering if there was any way to dissable something from the mouse
right click?
ex: When a user visits my site, I don't want them to be able to use the copy
shortcut on the right mouse click.
How would I do this?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] whats wrong?

2001-07-31 Thread Jeremy Morano

Anythig visibly wrong with this?


FORM METHOD=post ACTION=userinfolistbycompany2.php
INPUT TYPE=hidden name=uid value=? echo $uid; ?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] Limit

2001-07-30 Thread Jeremy Morano

How do I put a limit of records that can be entered in a table?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] Delete

2001-07-27 Thread Jeremy Morano

Hi, im trying to delete a record from a table where the value of a field
must be equal to the value of a field of another table.I know
this is wrong but I need to show you what I mean. I think I'm missing a very
important select statement to join them...can anyone
help me out?


sql=Delete from table1 where table1.value = table2.value


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] copy shortcut

2001-07-26 Thread Jeremy Morano

I would like to know if there is a way to dissable the copy shortcut in my
pages?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] is this right

2001-07-24 Thread Jeremy Morano

this doesn't work,how should it be done?

insert into test (uid, companyUid)
values(1, select uid from companysTable where company = Micrsoft);

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] whats wrong

2001-07-24 Thread Jeremy Morano

Whats wrong with this?


$sql = INSERT INTO $table_name
(uid,companyUid, first_name, last_name, address, state, zip_code, country,
company, occupation, telephone, fax, email, user_name, password)
SELECT
\\, \uid from companyTable WHERE company= Itsolutions\,
\$first_name\,\$last_name\,\$address\,\$state\,\$zip_code\,\$coun
try\,\$company\, \$occupation\, \$telephone\, \$fax\, \$email\,
\$user_name\, \$password\
;


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] screen2

2001-07-19 Thread Jeremy Morano

Can anybody tell me how to refresh or clear a screen in php code and if not,
please tell me,, It cannot be done. 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] bug?

2001-07-19 Thread Jeremy Morano

Does anybody know of a common bug where a variable contains what seems to be
a generated random number
instead of the input data that was given?

I'm inputting all sorts of info and only one variable is acting
strange..hmmm


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] days

2001-07-19 Thread Jeremy Morano


The employees here and I have noticed that we have a variable that works
when it wants to...
But for days at a time. One day it works fine all day. Another day it fills
up with garbage instead of what its supposed toBut whats particular
about this is that it lasts all day. Good or bad, the behavior lasts all
dayCan anyone shed some light on this for us? We  are really
baffled!


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] $PHP_AUTH_USER

2001-07-18 Thread Jeremy Morano

hi
can I use $PHP_AUTH_USER 
as a global variable?
I'm having a hard time with it in my other pages.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] whatever.php

2001-07-18 Thread Jeremy Morano

HI 
I'm using 
require(whatever.php)to access my variables...it works.
The problem is my whatever.php page shows up on top of my current page.
Is there a simple clear screen I can use???
I tried include and the same thing happens.  What do I do?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]