RE: [PHP] Password encyption
So host your own server. That way nobody but you has access to it. Then you could store the password wherever you want, unecrypted, and it wouldn't matter. If you're running an application that's that security conscious, you shouldn't be using a shared server anyway. -Original Message- From: Anzak Wolf [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 1:24 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Password encyption Yes I have looked though since I'm not 100% sure what I'm looking for it is hard to come up with a solid answer. I'm just looking for a more secure way to connect to my database through PHP and was hoping to find some suggestions here, not get the run around. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Password encyption
Well that's a whole different thing, then. -Original Message- From: Anzak Wolf [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 1:40 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Password encyption I do run my own server but I know for a fact that even if I harden the server as much as I can there is a chance that someone could gain access to that server. While once they have root on the box they pretty much can do as they like, and my app really does not have a huge security requirement, this is a learning processes for me and I'm always looking for a better/more secure way to do things. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: hellllppp my php kills the browser
However, those newbies who stick around will learn how to research and
find most of the answers themselves. Not a bad result, if you ask me.
Education often sounds Holier than Thou, but there's usually a good
reason for it.
Bob
-Original Message-
From: Michael Lauzon [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 19, 2004 8:20 PM
To: Aidan Lister
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: heppp my php kills the browser
I see enough of this Holier Than Thou attitude on the OCLUG list, I
don't need to see it here as well, and if you keep it up people like
me...the newbies will shy away from PHP!
On Sun, 20 Jun 2004 12:39:26 +1000, Aidan Lister [EMAIL PROTECTED] wrote:
Please read:
http://www.catb.org/~esr/faqs/smart-questions.html
Water_foul [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
i fixed it i had an endless loop oops :)
Water_foul [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
i dont know why but the following code kills the browser: ?php
//the function for adding new addresses
function loop_new_address($loopnum,$url,$name){
//the ${'link' . $loopnum} says put $link and add $loopnum to the
end
if(isset($_COOKIE['link' . $loopnum . ''])){
loop_new_address_help($loopnum+1,$url,$name);
}
else{
setcookie('link' . $loopnum . '',$url,time()+3600,'/');
setcookie('name' . $loopnum . '',$name,time()+3600,'/');
setcookie('link' . $loopnum . '',$url,time()+3600);
setcookie('name' . $loopnum . '',$name,time()+3600);
print('a href=$url' . $name . '/a was added');
};
};
//A function to let loop_new_address loop
function loop_new_address_help($loopnum,$url,$name){
loop_new_address($loopnum,$url,$name);
};
if(isset($_GET['new'])) {
loop_new_address(1,$_GET['url'],$_GET['name']);
};
print('table');
print('trtdform Method=GET
action=module/personal/delete.phpdelete/td/tr');
//write code
$writenum=1;
while(isset($_COOKIE['link' . $writenum . ''])==true){
print('a href=' . $_COOKIE['link' . $writenum . ''] . '' .
$_COOKIE['name'
. $writenum . ''] . '/a');
};
include('links.htm')
?
trtdinput type=submit value=Delete
Checked/form/td/tr /table table
trtdform METHOD=GET
ACTION=module/personal/links.phpinput
type=hidden name=new value=1/tdtd/td/tr
trtdSite name/tdtdINPUT TYPE=text NAME=name
VALUE=/td/tr
trtdsite url (if it is not on this site it MUST contain
http://;)/tdtdINPUT TYPE=text NAME=url VALUE=/td/tr
trtd/tdtdINPUT TYPE=SUBMIT
VALUE=Continue/form/td/tr
/table
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Michael Lauzon, Founder
The Quill Society
http://www.quillsociety.org/
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Parse Error
- Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: Rolf van de Krol [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 9:06 AM Subject: RE: [PHP] Parse Error The error is: Parse error: parse error, unexpected T_VARIABLE in /www/htdocs/rolfvand/thinkquest/browsercheck.php on line 46 [/snip] All of your values are not enclosed with single quotes - the first four are, last four aren't That's almost definitely not the issue. Worst case scenario with the non-existent quotes is that MySQL will put bad information into the database if it's expecting numbers there and gets a string, or the query will fail if it's a string with whitespace. It ought to parse just fine. Personally, I bet there's something not too far above the posted lines that's bad. Although the soon-to-follow query will look odd. $result=mysql_query($mysql_query); Bob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fw: [PHP] Parse Error
Since I replied only to Edwin. - Original Message - From: Bob Eldred [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 10:40 PM Subject: Re: [PHP] Parse Error Yes. Of course not. That wasn't the point. The point was that the parse error isn't caused by the lack of single quotes. Were everything else right in the script, that query would be just fine. - Original Message - From: - Edwin - [EMAIL PROTECTED] To: Bob Eldred [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 10:04 PM Subject: Re: [PHP] Parse Error On Wed, 18 Feb 2004 21:35:15 -0800 Bob Eldred [EMAIL PROTECTED] wrote: The error is: Parse error: parse error, unexpected T_VARIABLE in /www/htdocs/rolfvand/thinkquest/browsercheck.php on line 46 [/snip] All of your values are not enclosed with single quotes - the first four are, last four aren't That's almost definitely not the issue. Worst case scenario with the non-existent quotes is that MySQL will put bad information into the database if it's expecting numbers there and gets a string, or the query will fail if it's a string with whitespace. It ought to parse just fine. ?? Your query wouldn't even be executed if you have a parse error on your script. (So, it's not even possible for MySQL to put bad information into the database...) Single quotes, double quotes, semi-colon ought to be checked if one has Parse error: parse error, unexpected T_VARIABLE in blah blah blah... ...[snip]... -- - E - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Algorithm....
I'm working on a calendaring script right now, and am stuck on a programmatic way to figure something out. Basically, the work day is broken down into 15-minute intervals, where the value of a given interval can be figured as $hour=floor($i/4) and the minutes can be figured as $minutes=($i%4)*15. So 32 = 8:00, 33=8:15, etc. Currently, it's relatively easy to pull up a day, and block out those times that are already taken up with appointments. I'm throwing them all into an array ($available_times). So, that array would look like: 32=yes 33=yes 34=yes 35=yes 36=no 37=no 38=yes 39=yes etc, for someone who has a meeting from 9:00 to 9:30. Now, what I'm trying to do is check when they schedule a new meeting so that they don't overlap their times with something that's already taken up. So, in the array given above, if they select 8:30 as the start time, I'd like them to be able to select 8:45 or 9:00 as the end time, but nothing later than that, as the time from 9:00 to 9:30 is already taken up. And I'm stuck trying to figure out an approach to this. Preferably one that I can throw into javascript so they can fix their errors before it ever hits the server. Any help appreciated. Bob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Algorithm....
Clearly, I'm going to have to get on the PHP short bus. I was never any
good at bitmasking.
In the meantime, I've got it working. Not elegant, mind you, but working
nonetheless. Thanks.
Bob
- Original Message -
From: Manuel Vázquez Acosta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 16, 2004 9:47 PM
Subject: [PHP] Re: Algorithm
I suggest a bit's mask technique; since max(i)=96, you can represent a day
by 96/8 = 12 bytes = 3 (32-bits integers).
TimeFrameA is an integer representing the first 32 15-minutes
chunks(0-31),
TimeFrameB represents 32-63, and TimeFrameC 64-95.
If a bit is 1 the you that 15-minutes chunk is marked as busy, 0
otherwise. It is easy to find which is the first 'busy'bit in each
TimeFrame:
// at least one bit is marked as busy
if (TimeFrame 0)
{
mask = 0x8000;
while (mask TimeFrame == 0)
mask = mask 1;
}
Hope this helps (I think it saves both memory and time)
Manu.
Bob Eldred [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm working on a calendaring script right now, and am stuck on a
programmatic way to figure something out.
Basically, the work day is broken down into 15-minute intervals, where
the
value of a given interval can be figured as $hour=floor($i/4) and the
minutes can be figured as $minutes=($i%4)*15. So 32 = 8:00, 33=8:15,
etc.
Currently, it's relatively easy to pull up a day, and block out those
times
that are already taken up with appointments. I'm throwing them all into
an
array ($available_times). So, that array would look like:
32=yes
33=yes
34=yes
35=yes
36=no
37=no
38=yes
39=yes
etc, for someone who has a meeting from 9:00 to 9:30.
Now, what I'm trying to do is check when they schedule a new meeting so
that
they don't overlap their times with something that's already taken up.
So,
in the array given above, if they select 8:30 as the start time, I'd
like
them to be able to select 8:45 or 9:00 as the end time, but nothing
later
than that, as the time from 9:00 to 9:30 is already taken up.
And I'm stuck trying to figure out an approach to this. Preferably one
that
I can throw into javascript so they can fix their errors before it ever
hits
the server.
Any help appreciated.
Bob
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Image Header Issues - solved
For the archives, for when someone else runs into this. The following headers solved the issue where IE would only save an image as a BMP, when the image was, in fact, a JPG: header(Pragma: public); header(Expires: 0); header(Cache-Control: must-revalidate, post-check=0, pre-check=0); header(Content-Type: image/jpeg); header(Content-length: .(string)filesize($fullpicturename)); header(Content-Disposition: inline; filename=\.$row[name].\); header(Content-Transfer-Encoding: binary); My thanks to Larry Brown for his assistance. It seems that Justin French isn't the only freaking genius on this list! Bob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Header Issues
Again, it is *not* that known issue. That's the very first thing I checked. If that were the issue, jpgs from other sources would also not save properly. But they do, as I've stated several times. Thanks, though. Bob - Original Message - From: Brian V Bonini [EMAIL PROTECTED] To: Bob Eldred [EMAIL PROTECTED] Cc: PHP Lists [EMAIL PROTECTED] Sent: Saturday, January 17, 2004 7:28 AM Subject: Re: [PHP] Image Header Issues This is a known issue with IE. And it is in their knowledge base. If I recall the fix is to clear the cache, cookies, and broken/corrupt objects. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Header Issues
OK, that's it. The session_start() is the issue. Unfortunately, the img=x.jpg didn't help. Now I've got to figure out some sorta security without using sessions. Thanks, for at least pointing me in the right direction. Now if we could figure out why this would be happening, that would be great. Bob - Original Message - From: Toby Irmer [EMAIL PROTECTED] To: Larry Brown [EMAIL PROTECTED]; Bob Eldred [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Saturday, January 17, 2004 2:11 PM Subject: Re: [PHP] Image Header Issues I have the same problem. Strange: I have a session_start(); before the header... if I take that out, the image will download as a JPG... so maybe if you find a way to do things in this script without starting the session first... toby - Original Message - From: Larry Brown [EMAIL PROTECTED] To: Bob Eldred [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Saturday, January 17, 2004 6:32 PM Subject: RE: [PHP] Image Header Issues try adding showpicture.php?pid=111384img=x.jpg to the end even though you aren't using that variable, IE may see that the type is jpg here. I have this same problem/workaround in place right now for a script that wouldn't work with IE without it for downloading pdf. (pdf was generated on the fly) -Original Message- From: Bob Eldred [mailto:[EMAIL PROTECTED] Sent: Saturday, January 17, 2004 12:00 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Image Header Issues Again, it is *not* that known issue. That's the very first thing I checked. If that were the issue, jpgs from other sources would also not save properly. But they do, as I've stated several times. Thanks, though. Bob - Original Message - From: Brian V Bonini [EMAIL PROTECTED] To: Bob Eldred [EMAIL PROTECTED] Cc: PHP Lists [EMAIL PROTECTED] Sent: Saturday, January 17, 2004 7:28 AM Subject: Re: [PHP] Image Header Issues This is a known issue with IE. And it is in their knowledge base. If I recall the fix is to clear the cache, cookies, and broken/corrupt objects. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Header Issues
Grr.that's *not* the problem. IE saves JPGs just fine, so long as they are not passed through this particular script. Which is why I think it has something to do with the headers. Bob - Original Message - From: Arthur Pelkey [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 16, 2004 6:29 AM Subject: RE: [PHP] Image Header Issues I've had this same problem, and it was not related to any script I wrote, ie just stopped saving in any other format(for images), besides bmp, I am sure there would be something on ms's knowledge base, but it escapes me what I did to fix it, or updated. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Image Header Issues
Well, I've done a lot of web searching, and a lot of experimentation, but
haven't hit upon a fix for my issue yet.
Currently, images are served on a site I'm working on in two ways:
1) Free Images are served normally (img src=freepic.jpg).
2) Non-Free Images are served through a PHP wrapper with authentication
functionality in it (img src=showpicture.php?pid=111384).
The issues I'm having *only* occur in Internet Explorer, but it's not the
full-cache issue that Microsoft acknowledges, and I don't honestly believe
it to be a total bug in IE, since the free images, served up through a
normal img tag work fine.
The issue is that, if the user right-clicks the image, and chooses Save
As, it will only save as a BMP. Interestingly, if the user right-clicks on
a link to a picture, and chooses save target as, it works just fine.
So far, I've tried the following, with no success:
1) Mod-Rewrite, rewriting a request of /secure/111384.img to
/showpicture.php?pid=111384. I did this because it was suggested that IE
might be looking at the file name in the link, not seeing an image type, and
therefore defaulting to bmp. The rewrite works successfully, and the
picture is shown, but the save as function still doesn't work. Getting
the image properties from within IE gives a Type of Not Available.
2) Adding, rewriting, subtracting, etc, many many header combinations.
3) All Microsoft-suggested full-cache problem fixes, just in case.
So, the scripts involved are these:
in functions.php:
function showpix($picture_id)
{
$sql=SELECT ug.group_name, p.name from usenet_groups as ug,
ipictures as
p WHERE p.id='$picture_id' AND ug.id=p.group_id;
$result=mysql_query($sql) or die(mysql_error());
$row=mysql_fetch_array($result);
$dirhash=get_storage_dir($row[name]);
$picturedirectory=STORAGEDIR./.$row[group_name];
$fullpicturename=$picturedirectory./.$dirhash./.$row[name];
header(Content-Type: image/jpeg);
header(Content-Length: .(string)filesize($fullpicturename));
header(Content-Disposition: inline;
filename=\.$row[name].\);
readfile($fullpicturename);
return(true);
}
The page serving the image:
trtda href=/secure/?=$row[id]?.jpg target=_BLANK
img src=showpicture.php?type=thumbpid=?=$row[id]?br
?=$row[name].br.$row[date_added]?/a
?php if($_SESSION[sec_level]==4)
{
echo brimg onClick=\rethumbnail({$row[id]});\
src=\/graphics/rethumbnail.png\.SPACER.
img onClick=\del_picture({$row[id]});\
src=\/graphics/trashcan.png\;
}
?
/td
showpicture.php:
?php
include('dbconnect.php');
include('defines.php');
include('functions.php');
if($_GET[type]==temp||$_GET[type]==thumbtemp)
{
$sec_level=4;
}
else
{
$sec_level=2;
}
include('validate_user.php');
switch($_GET[type])
{
case thumb:
{
showthumb($_GET[pid]);
break;
}
case temp:
{
showpixtemp($_GET[pname], $_GET[gid]);
break;
}
case thumbtemp:
{
showthumbtemp($_GET[pname], $_GET[gid]);
break;
}
default:
{
showpix($_GET[pid]);
}
}
?
Because of the fact that IE can properly determine the image type when
statically served, I have to believe that something is not being sent
properly to the browser from within one of these functions.
I apologize for asking this question twice, but having done more research,
and having unsuccesfully implemented the suggestions given to me last time,
I'm hoping that someone can point me in the right direction, before I'm
simply forced to do Apache redirection, which isn't as good as actually
checking in the session for logged-in status.
Thanks in advance for anything you can throw my way.
Bob
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Header Problems
- Original Message -
function showpix($picture_id)
{
$sql=SELECT ug.group_name, p.name from usenet_groups as ug,
pictures as p WHERE p.id='$picture_id' AND ug.id=p.group_id;
$result=mysql_query($sql) or die(mysql_error());
$row=mysql_fetch_array($result);
$dirhash=get_storage_dir($row[name]);
$picturedirectory=STORAGEDIR./.$row[group_name];
$fullpicturename=$picturedirectory./.$dirhash./.$row[name];
header(Content-Type: image/jpeg);
header(Content-Length: .filesize($fullpicturename));
header(Content-Disposition: inline; filename=.$row[name]);
readfile($fullpicturename);
exit;
}
OK, an update. The pictures are saveable as .jpg's in Opera, so it seems to
be localized to IE. Is there maybe a different set of headers that should
be sent for Internet Explorer, or do I just have a bug in my browser to deal
with?
Bob
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Image Header Problems
Hi there,
I'm wanting to serve images outside the docroot of apache, so that the
images can't be so easily hijacked. However, I appear to be running into a
problem with (I think) the headers not being sent properly. IE (v6) will
only save the images as BMPs, not as JPGs, even though they are JPG images.
It's not the full-cache bug, as I've cleared that out while trying to solve
this problem.
Images are called like this:
img src=/showpicture.php?pid=xx
Where pid is the database ID of the image.
showpicture.php is basically a wrapper with some security functions to make
sure that the person is logged into my site, which then calls the following
function to display the picture. Nothing else is output to the browser, and
the image shows just fine:
function showpix($picture_id)
{
$sql=SELECT ug.group_name, p.name from usenet_groups as ug,
pictures as p WHERE p.id='$picture_id' AND ug.id=p.group_id;
$result=mysql_query($sql) or die(mysql_error());
$row=mysql_fetch_array($result);
$dirhash=get_storage_dir($row[name]);
$picturedirectory=STORAGEDIR./.$row[group_name];
$fullpicturename=$picturedirectory./.$dirhash./.$row[name];
header(Content-Type: image/jpeg);
header(Content-Length: .filesize($fullpicturename));
header(Content-Disposition: inline; filename=.$row[name]);
readfile($fullpicturename);
exit;
}
Something in here has me stumped. Any ideas?
Bob
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] OpenBSD 3.2 PHP 4.2.3 packages
I'm hopeful that someone here has been in my situation and found a fix for it. I recently installed a clean OpenBSD 3.2 system, and added the php4-core-4.2.3 and php4-gd-4.2.3 packages, along with a few other packages from the php4 collection. Most everything seems to be working fine. However, php4-gd-4.2.3 doesn't appear to be working at all. At least the createimagefromjpeg function isn't returning the picture it's supposed to return. It's similar to what I had before the upgrade to 3.2 when I didn't have PHP compiled with the --with-gd and --with-jpeg-dir config options. A phpinfo() page shows that the gd module is activated, and that JPG Support is enabled, but the function does not work at all. Any ideas where I can look to solve this? Bob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] plus sign has changed to space after POST
I don't believe it has anything to do with PHP, to be honest. I've got
scripts that are several versions of PHP old that do that. However, it
makes no difference in execution of the script.
case show roster:
{
...
}
catches submit=show+roster quite nicely.
Bob
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 3:42 PM
Subject: [PHP] plus sign has changed to space after POST
After upgrade to 4.2.3, plus + sign has changed to space after POST. I
have checked the mailing list but can't find any help to turn this off
forever! is this a bug in PHP?
thanks
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Need MENTOR for Fantasy football project
So experiment. That's exactly how I made my fantasy league stuff work. Along with a few questions here when I had *specific* issues with code. Bob - Original Message - From: Karl James [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 12:33 PM Subject: RE: [PHP] Need MENTOR for Fantasy football project I have the php bible 4 book but it Doesnt tell you how to do things all the way And still leaves with lots of questions. -Original Message- From: Charles Wiltgen [mailto:lists;wiltgen.net] Sent: Friday, November 08, 2002 9:03 PM To: List PHP General Subject: Re: [PHP] Need MENTOR for Fantasy football project Karl James wrote... Would any want to help me with this please get with me asap I need to be able to talk to you thru the end and make sure I do shit right. I want to do all the work, just need a teacher. As they say, Just Do It. Ask specific, PHP-related questions as you have them. If you don't know anything about using PHP and MySQL, buy one of the many fine books available on the subject. Or, you could just pay someone to do it for you. -- Charles Wiltgen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Newbie question
Hi there,
I'm really really new to both PHP and MySQL, so this is probably going to
turn out to be an easy fix.
The basis is this: I have a MySQL database with two tables in it. I'm
trying to update 1 of the fields (aqfl_team) in the first table
(nfl_players) with a value from a field (aqfl_team) from the second table
(temp_aqfl_rosters).
The PHP document looks like this:
html
body
?php
$db = mysql_connect(localhost,root,password);
mysql_select_db(aqfl,$db);
$aqfl_result = mysql_query(SELECT * FROM temp_aqfl_rosters);
echo Updating rosters.;
$myrow = mysql_fetch_array($aqfl_result);
do {
$aqfl_player_first = $myrow[first_name];
$aqfl_player_last = $myrow[last_name];
$aqfl_player_position = $myrow[position];
$aqfl_player_nfl_team = $myrow[nfl_team];
$aqfl_player_aqfl_team = $myrow[aqfl_team];
$nfl_player_id = mysql_query(SELECT player_id FROM nfl_players WHERE
first_name='$aqfl_player_first' AND last_name='$aqfl_player_last' AND
position='$aqfl_player_position' AND nfl_team='$aqfl_player_nfl_team');
$result = mysql_query(UPDATE nfl_players SET
aqfl_team='$aqfl_player_aqfl_team' WHERE player_id='$nfl_player_id');
echo $aqfl_player_first $aqfl_player_last updated ($aqfl_player_position,
$aqfl_player_nfl_team, $aqfl_player_aqfl_team);
} while ($myrow = mysql_fetch_array($aqfl_result));
?
/body
/html
The end result is that I get a screenful of data (every player, NFL team,
and AQFL team is correct) stating that the various players are updated, but
but the field update in nfl_players is not actually done.
I'm sure it's a syntax issue, but I don't know what's the actual problem.
Any help?
Thanks,
Bob
--
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]
