[PHP-DB] default-character-set problem
Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list
Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions similar
to the code below? I've tried a few different ways but I keep getting
Resource ID #4. I need to do this to retrieve an email address from one
table and retrieve details from another.
Cheers for any tips - I'm stumped with this one,
Graeme :)
$query = SELECT Name, Address FROM users;
$query2 = SELECT EmailAddress From Members;
$result = mysql_query($query);
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result) and $Email =
mysql_fetch_array($result2))
{
echo Name: $details[Name];
echo Address: $details[Address];
echo Email: $Email[EmailAddress];
}
Unless I've missed something you're going about this the wrong way. For what
you want to do, you should (in general) be able to accomplish it using just a
single query.
What fields do the tables 'users' and 'Members' contain? There should be a
field there (like eg. userid) which links the two together. If there isn't
one then you should seriously restructure your tables so that there is one.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Cats are smarter than dogs. You can't make eight cats pull a sled through
the snow.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question, just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use some
logic to combine the results into an array by a common factor. Just
remember that you can only work with one mysql result per connection at
a time. You *may* (untested!) be able to accomplish what you want to do
with two separate connections, but again, this is seriously overkill. :)
I'd definitely recommend restructuring your talbes as Jason suggested.
-- Josh
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions
similar
to the code below? I've tried a few different ways but I keep getting
Resource ID #4. I need to do this to retrieve an email address from
one
table and retrieve details from another.
Cheers for any tips - I'm stumped with this one,
Graeme :)
$query = SELECT Name, Address FROM users;
$query2 = SELECT EmailAddress From Members;
$result = mysql_query($query);
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result) and $Email =
mysql_fetch_array($result2))
{
echo Name: $details[Name];
echo Address: $details[Address];
echo Email: $Email[EmailAddress];
}
Unless I've missed something you're going about this the wrong way. For
what
you want to do, you should (in general) be able to accomplish it using
just a
single query.
What fields do the tables 'users' and 'Members' contain? There should be
a
field there (like eg. userid) which links the two together. If there
isn't
one then you should seriously restructure your tables so that there is
one.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Cats are smarter than dogs. You can't make eight cats pull a sled
through
the snow.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Abstraction layer or not?
I'm working on a new site, and I'm wondering whether to use an abstraction layer or not. I don't have any plans to switch DB system, but you never know what the future holds. I figure that there's no reason not to, but are there any down sides? Which abstraction layers are good? well, any down side ? may be slower for example. So, if you don't plan to switch db system, the speed of the layer could be your criteria. ADOdb is a good one. PEAR also has an abstraction class. Once you get used to using them, they make things easier over all. I've never actually switched databases with them, so I don't know how much easier it makes that. I find them ideal for error catching and reporting. I agreed. ADOdb (http://php.weblogs.com/ADODB) is quite nice, fast, (the fatest ?) and very helpful even if you don't change db. See benchmark at http://phplens.com/lens/adodb/. Well, it's from adodb, may be you would find an other one written by those using pear_db. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] default-character-set problem
You have to put the same under [server] Nikos wrote: Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] sort by date
I have two tables, one contains event information and the other dates that the event takes place: | id| int(11) | | PRI | 0 | auto_increment | | title | varchar(100) | YES | | NULL|| | location | varchar(100) | YES | | NULL|| | address | varchar(100) | YES | | NULL|| | contact | varchar(100) | YES | | NULL|| | category | varchar(100) | YES | | NULL|| | event_time| varchar(200) | YES | | NULL|| | urllink | varchar(100) | YES | | NULL|| | descript | text | YES | | NULL|| | id | int(11) | | PRI | 0 | auto_increment | | event_key | int(11) | YES | | NULL|| | event_date | date| YES | | NULL|| They are linked via dateTable.event_key=eventTable.id I want to be able to sort by the first date that the event takes place. I tried: $sql=select e.*,d.event_date from eventTable e,dateTable d where e.id=d.event_key order by d.event_date,d.event_key but it still shows each date that the event takes place. I tried doing a min(d.event_date) as event_date and then group by instead of order by but still get too many results. Any help to straighten this out? Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] postgresql and php - my codes running twice?!?!?
Hi,
Can anyone help I'm going mad with this...
I'm using postgresql with php and writing a small login and sign-up system.
Whena user wishes to sign-up Iwant to check there are not any other users
with the same username, so I'm doing a select against the db with the
requested username before allowing the insert to add the user to the db.
For some reason the code I'm using seems to be running through the fucntion
twice sometimes!!! and other times runs as it should!!!
Thanks for any help or ideas.
Zac
The code in the top of the html page calling the function:
?php
// - - - - form processing
if($_REQUEST[Username]){
// - - - - - include login code page
include_once /wrt/fl/htdocs/incs/cde/usr_lg.html;
// - - - - check for redirect
if(isset($_SESSION[Rdr])){
$Rdr = $_SESSION[Rdr];
} else {
$Rdr = $c01_user_login_redirect;
}
$ChckVal = array(Username,Password,Country);
Mmbr_SgnUp($ChckVal, $Rdr);
#Usr_Lgn($Rdr);
}
?
The function it's self :
function Mmbr_SgnUp($ChkVal, $Rdr){
/* Will check that each element in ChkVal array has a $_POST value not null
Will check no duplicates of unique column
Will redirect to success or fail with error message
HTML Form Elements should be called
Username, Password, Preffered, Reminder, Country,
ChkVal array of element names to be checked
Rdr page to redirect to if successful
Standard begining to error message
*/
$GLOBALS[dbgPos] = 'Mmbr_SgnUp function';
if($GLOBALS[c01_debug]) echo 'h2 Debugging from New Member Sign Up
Function /h2blockquote';
// - - - - - - - - define function vars
// - - - - - - - - array for errors that occured
$Err = array();
// - - - - - - - - array for noting missing elements in sign up
$EmtErr = array();
// - - - - - - - - check that each form element has been completed
ForEach($ChkVal as $val){
// - - - - - - - - if element is not set add element to error array
if(!isset($_REQUEST[$val])){
array_push($EmtErr,$val);
$Err[0] = $GLOBALS[c01_Err_21];
}
}
if($GLOBALS[c01_debug]){
// - - - - - - write ChkVal array to screen
wrt_arr_scrn($ChkVal);
echo 'Rdr = '.$Rdr.'brbr';
}
// - - - - - - - - Check for duplicate values in db
// - - - - - - - - create db connecion
$Con = dbc();
$Qry = dbq('SELECT UsrId FROM Usr WHERE UsrId =
'.'.$_REQUEST[Username].'.';');
for($r = 0 ; $r 1; $r++){
echo $r;
}
if($GLOBALS[c01_debug]) echo 'SELECT UsrId FROM Usr WHERE UsrId =
'.'.$_REQUEST[Username].'.';brbr';
if(db_num_rows($Qry) $GLOBALS[c01_0]){
$Row = db_fetch_row($Qry);
echo $Row[0];
$Err[1] = $GLOBALS[c01_Err_20];
if($GLOBALS[c01_debug]) echo ' Check for more than one entry NumRows
returned - '.db_num_rows($Qry).'brbr';
// - - - - - - - - log new member sign-up failure
wrt_log($GLOBALS[c01_log_level_usr],$GLOBALS[c01_t],'New_Member','***
FAILED Sign-up at '.$GLOBALS[c05_DteTme].', Username = '.$_POST[Username].',
Err[0] = '.$Err[0].', Err[1] = '.$Err[1]. \n);
if($GLOBALS[c01_debug]) echo '/blockquoteh2 End Debugging from New
Member Sign Up Function /h2';
// - - - - - - - - return errors
$Err[missing] = $EmtErr;
return $Err;
} else {
// - - - - - - - - Check if signup was successful
if($GLOBALS[c01_debug]) echo'No Errors In passed data Proceding to write
to DBbrbr';
// - - - - - - - - insert record into db
$cols = 'Sts,StsDtm,IniDtm,LgiDtm,Usr_MlcKey,UsrId,Pwd';
$vals =
'1,'.'.$GLOBALS[c05_Dte].'.','.'.$GLOBALS[c05_DteTme].'.','.'.$GLO
BALS[c05_DteTme].'.','.'.$_POST[Country].'.','.'.$_POST[Username].'
.','.'.$_POST[Password].';
if($_POST[Preffered] != ''){
echo 'pp'.$_POST[Preffered].'ppbr';
$cols.= ',PrfNme';
$vals.= ','.'.$_POST[Preffered].';
}
$Qry = dbq('INSERT INTO Usr ('.$cols.') Values ('.$vals.');');
// - - - - - - - - get usrid
$Uid = db_insert_id($Qry);
if($GLOBALS[c01_debug]) echo 'Get DB OID - '.$Uid.'brbr';
if($_POST[Reminder]){
// - - - - - - - - add other details to Udt ~ password reminder
$Qry = dbq('INSERT INTO Udt (Udt_UsrKey, PwdRmd) VALUES ('.$Uid.',
'.'.$_POST[Reminder].'.');');
}
// - - - - - - - - log new member sign-up
wrt_log($GLOBALS[c01_log_level_usr],$GLOBALS[c01_t],'New_Member','SUCCESSFUL
Sign-up at '.$GLOBALS[c05_DteTme].', UserId = '.$Uid. \n );
// - - - - - - - - add freebies for becoming a new member
$frb = add_frb('BNM001', $Uid);
if($GLOBALS[c01_debug]) echo ' Add Freebies for Sign Upbrbr';
// - - - - - - - - login ~ which will result in redirect
if($GLOBALS[c01_debug]) echo 'Now Goto Login Function to Log User in';
if($GLOBALS[c01_debug]) echo '/blockquoteh2 End Debugging from New
Member Sign Up Function /h2';
#Usr_Lgn($Rdr);
}
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
if i get your point: 1 event can have more dates.. and you wanna show for each event just the first date... so you wanna show more from one table as the other one in that case you should try to use the left join !! so check the manual on left join -Original Message- From: Terry Romine [mailto:eatrom;blazing-trails.com] Sent: woensdag 6 november 2002 15:55 To: [EMAIL PROTECTED] Subject: [PHP-DB] sort by date I have two tables, one contains event information and the other dates that the event takes place: | id| int(11) | | PRI | 0 | auto_increment | | title | varchar(100) | YES | | NULL|| | location | varchar(100) | YES | | NULL|| | address | varchar(100) | YES | | NULL|| | contact | varchar(100) | YES | | NULL|| | category | varchar(100) | YES | | NULL|| | event_time| varchar(200) | YES | | NULL|| | urllink | varchar(100) | YES | | NULL|| | descript | text | YES | | NULL|| | id | int(11) | | PRI | 0 | auto_increment | | event_key | int(11) | YES | | NULL|| | event_date | date| YES | | NULL|| They are linked via dateTable.event_key=eventTable.id I want to be able to sort by the first date that the event takes place. I tried: $sql=select e.*,d.event_date from eventTable e,dateTable d where e.id=d.event_key order by d.event_date,d.event_key but it still shows each date that the event takes place. I tried doing a min(d.event_date) as event_date and then group by instead of order by but still get too many results. Any help to straighten this out? Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! ---BeginMessage--- I have two tables, one contains event information and the other dates that the event takes place: | id| int(11) | | PRI | 0 | auto_increment | | title | varchar(100) | YES | | NULL|| | location | varchar(100) | YES | | NULL|| | address | varchar(100) | YES | | NULL|| | contact | varchar(100) | YES | | NULL|| | category | varchar(100) | YES | | NULL|| | event_time| varchar(200) | YES | | NULL|| | urllink | varchar(100) | YES | | NULL|| | descript | text | YES | | NULL|| | id | int(11) | | PRI | 0 | auto_increment | | event_key | int(11) | YES | | NULL|| | event_date | date| YES | | NULL|| They are linked via dateTable.event_key=eventTable.id I want to be able to sort by the first date that the event takes place. I tried: $sql=select e.*,d.event_date from eventTable e,dateTable d where e.id=d.event_key order by d.event_date,d.event_key but it still shows each date that the event takes place. I tried doing a min(d.event_date) as event_date and then group by instead of order by but still get too many results. Any help to straighten this out? Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
My guess? Because we're all professionals at work and trying to solve a specific problem...since we're adults, I guess the learning part should be up to each of us--the information is certainly there even in the answer. :-) Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! ---BeginMessage--- why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Good point. Tell me and I forget, show me and I remember, involve me and I understand Ignatius - Original Message - From: Snijders, Mark [EMAIL PROTECTED] To: 'Marco Tabini' [EMAIL PROTECTED]; Terry Romine [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 4:22 PM Subject: RE: [PHP-DB] sort by date why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. Ignatius Reilly To: Snijders, Mark [EMAIL PROTECTED], 'Marco Tabini' ignatius.reill[EMAIL PROTECTED], Terry Romine [EMAIL PROTECTED] [EMAIL PROTECTED]cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date 11/06/2002 10:29 AM Good point. Tell me and I forget, show me and I remember, involve me and I understand Ignatius - Original Message - From: Snijders, Mark [EMAIL PROTECTED] To: 'Marco Tabini' [EMAIL PROTECTED]; Terry Romine [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 4:22 PM Subject: RE: [PHP-DB] sort by date why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Well, excuse me for being a bit cynical, but it's hard to be philosophical with a deadline hanging over your head. It's true that most of the questions can be answered by looking at the manual, but you also have to assume the possibility that the person who's asking them has a real and immediate need for the answers--at least that's the way I try to think. One thing that would be great, IMHO, would be to start putting together a little FAQ, like many other mailing lists have, that gets updated and posted to the list once a month... it could contain answers to the most frequently asked questions--anybody who's tired of answering that register_globals has been turned off in recent versions raise your hand! :-) Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! ---BeginMessage--- Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. Ignatius Reilly To: Snijders, Mark [EMAIL PROTECTED], 'Marco Tabini' ignatius.reill[EMAIL PROTECTED], Terry Romine [EMAIL PROTECTED] [EMAIL PROTECTED]cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date 11/06/2002 10:29 AM Good point. Tell me and I forget, show me and I remember, involve me and I understand Ignatius - Original Message - From: Snijders, Mark [EMAIL PROTECTED] To: 'Marco Tabini' [EMAIL PROTECTED]; Terry Romine [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 4:22 PM Subject: RE: [PHP-DB] sort by date why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
Just to weigh in on the tail end here, a FAQ of the top N items would be nice. But I have to say, I use the archives a lot before I post to the list. The archives contain the answers to most questions out there. If subscribers to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Thanks. My error seemed to be just in the group declaration. Comparing yours and mine with slight modifications to yours that eventually worked as desired: yours: select e.id, title, min(event_date) as event_date from eventTable e, dateTable d where e.id = d.event_key group by e.id; mine: select e.*,min(d.event_date) as event_date from eventTable e,dateTable d where e.id = d.event_key group by d.event_date,d.event_key; As you see, I was already trying to do a join, but the group by was throwing me. Terry On Wednesday, November 6, 2002, at 09:15 AM, Marco Tabini wrote: My guess? Because we're all professionals at work and trying to solve a specific problem...since we're adults, I guess the learning part should be up to each of us--the information is certainly there even in the answer. :-) Marco -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
I agree, but in regard to your last paragraph, you're assuming that they read your post and respond to it. Everybody's quick to answer simple redundant questions that every programmer *should* know the answer to, but higher level stuff seems to just get ignored. I'd hope in a high-frequency list like this the converse would be true. Where are the seasoned pros when somebody is asking a hard question, or asking for alternative approaches to a problem? -- Josh -Original Message- From: Hutchins, Richard [mailto:Richard.Hutchins;GetingeCastle.com] Sent: Wednesday, November 06, 2002 10:48 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] sort by date Just to weigh in on the tail end here, a FAQ of the top N items would be nice. But I have to say, I use the archives a lot before I post to the list. The archives contain the answers to most questions out there. If subscribers to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Hey, there are a lot of new people who are starting with PHP. We all are here to help people learn how to use PHP because we are all PHP fans and want the world to use PHP. register_globals is an issue that us more advanced folk know about and deal with on a regular basis. There are lazy people who don't know how to use a manual. However, we've got the ability here to help people who don't know about or how to use the manual. And honestly, some questions are more difficult than the manual provides, especially if you aren't sure where to look. How's this? Anytime someone posts a potential answer, post the manual page for the function, SQL reference or something related. That way it's in the newsgroup and the archives. People DO search the archives, while some people don't. We can't all expect everyone to be as smart and as knowledgable about PHP as some of the people on this list are. So give them a chance and help them learn how to learn instead of getting mad. And if you get mad, maybe this isn't the right place for you to be! I mean that in the nicest sense; the world is filled with idiots, and this list is here to help both idiots and geniuses get through their stumbling blocks by being an intelligent, helpful and friendly community. At least that's what I hope this is. Peter On 6 Nov 2002, Marco Tabini wrote: Well, excuse me for being a bit cynical, but it's hard to be philosophical with a deadline hanging over your head. It's true that most of the questions can be answered by looking at the manual, but you also have to assume the possibility that the person who's asking them has a real and immediate need for the answers--at least that's the way I try to think. One thing that would be great, IMHO, would be to start putting together a little FAQ, like many other mailing lists have, that gets updated and posted to the list once a month... it could contain answers to the most frequently asked questions--anybody who's tired of answering that register_globals has been turned off in recent versions raise your hand! :-) Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- ---BeginMessage--- Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. Ignatius Reilly To: Snijders, Mark [EMAIL PROTECTED], 'Marco Tabini' ignatius.reill[EMAIL PROTECTED], Terry Romine [EMAIL PROTECTED] [EMAIL PROTECTED]cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date 11/06/2002 10:29 AM Good point. Tell me and I forget, show me and I remember, involve me and I understand Ignatius - Original Message - From: Snijders, Mark [EMAIL PROTECTED] To: 'Marco Tabini' [EMAIL PROTECTED]; Terry Romine [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 4:22 PM Subject: RE: [PHP-DB] sort by date why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco --
RE: [PHP-DB] sort by date
Besides, if they don't search the archives and newsgroups and Google already, why would we believe they'd read the FAQ? Peter On Wed, 6 Nov 2002, Hutchins, Richard wrote: Just to weigh in on the tail end here, a FAQ of the top N items would be nice. But I have to say, I use the archives a lot before I post to the list. The archives contain the answers to most questions out there. If subscribers to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
I have a manual and use it plus lots of sample code to work through, but there are times when we hit a wall and a simple second set of eyes to spot what should be obvious is helpful. I appreciate having a forum to throw out a question and get a rapid response. I could have rewritten this problem, taking the wrong way around and spending more time than my client would like. This way I not only have the solution, but the reason behind it, as well. Thanks again. Terry On Wednesday, November 6, 2002, at 09:35 AM, [EMAIL PROTECTED] wrote: Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
What archive and how do I access it? -Original Message- From: Hutchins, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, November 06, 2002 10:50 AM Subject: RE: [PHP-DB] sort by date Just to weigh in on the tail end here, a FAQ of the top N items would be nice. But I have to say, I use the archives a lot before I post to the list. The archives contain the answers to most questions out there. If subscribers to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
Go here: http://www.php.net/mailing-lists.php and scroll down to find the archive for your type of question. Just click and search away - no subscription necessary. Lots of good help in there if you're diligent. -Original Message- From: dwalker [mailto:dwalker;healthyproductsplus.com] Sent: Wednesday, November 06, 2002 10:42 AM To: Hutchins, Richard; [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date What archive and how do I access it? -Original Message- From: Hutchins, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, November 06, 2002 10:50 AM Subject: RE: [PHP-DB] sort by date Just to weigh in on the tail end here, a FAQ of the top N items would be nice. But I have to say, I use the archives a lot before I post to the list. The archives contain the answers to most questions out there. If subscribers to this list checked the archives to see if their answer is there, then questions like register_globals might decrease in frequency. The other side effect of researching answers for yourself before posting is that you gain exposure to more of the language faster. How many times do you read about something that doesn't solve your immediate problem, but puts an idea into your head as to how you might handle a future situation? I know I benefit from it. Still, nothing better than being able to get help from some of the seasoned pros on this list right away. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
This is how you'd find it in the future. It's fairly simple. http://php.net/ -- Mailing Lists -- Databases and PHP archive link YES OR -- Databases and PHP Newsgroup link Yes Archives: http://marc.theaimsgroup.com/?l=php-db Newsgroup: news://news.php.net/php.db Peter On Wed, 6 Nov 2002, dwalker wrote: What archive and how do I access it? --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Great! But, many people cannot *understand* the manuals for their own reasons, that is why they ask - they hope to get some sample code. Shall we? -- Maxim Maletsky [EMAIL PROTECTED] Peter Beckman [EMAIL PROTECTED] wrote... : Hey, there are a lot of new people who are starting with PHP. We all are here to help people learn how to use PHP because we are all PHP fans and want the world to use PHP. register_globals is an issue that us more advanced folk know about and deal with on a regular basis. There are lazy people who don't know how to use a manual. However, we've got the ability here to help people who don't know about or how to use the manual. And honestly, some questions are more difficult than the manual provides, especially if you aren't sure where to look. How's this? Anytime someone posts a potential answer, post the manual page for the function, SQL reference or something related. That way it's in the newsgroup and the archives. People DO search the archives, while some people don't. We can't all expect everyone to be as smart and as knowledgable about PHP as some of the people on this list are. So give them a chance and help them learn how to learn instead of getting mad. And if you get mad, maybe this isn't the right place for you to be! I mean that in the nicest sense; the world is filled with idiots, and this list is here to help both idiots and geniuses get through their stumbling blocks by being an intelligent, helpful and friendly community. At least that's what I hope this is. Peter On 6 Nov 2002, Marco Tabini wrote: Well, excuse me for being a bit cynical, but it's hard to be philosophical with a deadline hanging over your head. It's true that most of the questions can be answered by looking at the manual, but you also have to assume the possibility that the person who's asking them has a real and immediate need for the answers--at least that's the way I try to think. One thing that would be great, IMHO, would be to start putting together a little FAQ, like many other mailing lists have, that gets updated and posted to the list once a month... it could contain answers to the most frequently asked questions--anybody who's tired of answering that register_globals has been turned off in recent versions raise your hand! :-) Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Question
Hi there everyone, Why are so many attachments coming in to the list? Hopefully it's not because somebody has a virus and is infecting people who open them. So don't open attachments unless you are expecting something. Are there any plans to make PHP for windows a full blown programming language that doesn't need to be run through a web browser? That would be so nice in my opinion. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sort by date
Peter Beckman [EMAIL PROTECTED] wrote... : Besides, if they don't search the archives and newsgroups and Google already, why would we believe they'd read the FAQ? There are already lots of FAQs, but even you who argue about that do not know much aboiut. So, an FAQ whether gets incorporated into this mailing list or we answer mostly with the links to FAQs. There is really no other way. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question
Well, you can already do that--just download and install the CGI version. Unless, of course, you meant that you want to write Windows GUI applications, in which case I think someone is working on something like that with PHP-GTK. Oh, the attachments are either quoted messages or patches, for the most part, so nothing particularly ominous. Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! ---BeginMessage--- Hi there everyone, Why are so many attachments coming in to the list? Hopefully it's not because somebody has a virus and is infecting people who open them. So don't open attachments unless you are expecting something. Are there any plans to make PHP for windows a full blown programming language that doesn't need to be run through a web browser? That would be so nice in my opinion. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Question
This isn't the place for discussions of php development, I think php-dev is what you want... but ah, PHP is a full-blown programming language, even under widnows. http://www.php.net/manual/sv/features.commandline.php -- check this page out You can write shell scripts with it, associate windows with php files so double-clicking on a php file will execute it, there's even wrappers for the windows API... http://www.php.net/manual/en/ref.w32api.php, not to mention the windows port of SDL *and* GTK... -- Josh -Original Message- From: Chris Payne [mailto:chris;planetoxygene.com] Sent: Wednesday, November 06, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Question Hi there everyone, Why are so many attachments coming in to the list? Hopefully it's not because somebody has a virus and is infecting people who open them. So don't open attachments unless you are expecting something. Are there any plans to make PHP for windows a full blown programming language that doesn't need to be run through a web browser? That would be so nice in my opinion. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied to my
email also. I solved the problem shortly after posting my question, I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with one mysql result per connection at
a time. Can you explain a little more about that please? I don't think I
fully understand what you mean.
Cheers,
Graeme :)
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 12:29 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question, just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use some
logic to combine the results into an array by a common factor. Just
remember that you can only work with one mysql result per connection at
a time. You *may* (untested!) be able to accomplish what you want to do
with two separate connections, but again, this is seriously overkill. :)
I'd definitely recommend restructuring your talbes as Jason suggested.
-- Josh
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions
similar
to the code below? I've tried a few different ways but I keep getting
Resource ID #4. I need to do this to retrieve an email address from
one
table and retrieve details from another.
Cheers for any tips - I'm stumped with this one,
Graeme :)
$query = SELECT Name, Address FROM users;
$query2 = SELECT EmailAddress From Members;
$result = mysql_query($query);
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result) and $Email =
mysql_fetch_array($result2))
{
echo Name: $details[Name];
echo Address: $details[Address];
echo Email: $Email[EmailAddress];
}
Unless I've missed something you're going about this the wrong way. For
what
you want to do, you should (in general) be able to accomplish it using
just a
single query.
What fields do the tables 'users' and 'Members' contain? There should be
a
field there (like eg. userid) which links the two together. If there
isn't
one then you should seriously restructure your tables so that there is
one.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Cats are smarter than dogs. You can't make eight cats pull a sled
through
the snow.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: Question - thanks
Hi there everyone, Thanks for the response to my question - both the attachments and PHP as a full blown dev language. I know the latter isn't really for this group, but this is the best PHP group I have found and the only one I write in regularly. Thanks again Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql_fetch_array() question
In my experience, (I haven't checked the docs just yet to figure out
exactly why), you can only work with one result id at a time. Every time
you call mysql_query, it resets the result id (I think it frees the
result id automatically so you can send another query before getting the
new result id), so even if you store it in two separate variables, it
will only refrence the last id (which sounds just like what happened in
your initial post). I think this is limited to a given connection, but
I'm not sure.
One of the, I guess you could say, shortcomings of the mysql interface
in php is that you can only execute one query at a time, and I think
this odd result id overwrighting that happens is due to that fact (I
might be wrong, but I think you can execute multiple queries at a time
with perl's DBI module).
I hope that makes more sense :)
-- Josh
-Original Message-
From: Graeme McLaren [mailto:mickel;ntlworld.com]
Sent: Wednesday, November 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied to my
email also. I solved the problem shortly after posting my question,
I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with one mysql result per connection at
a time. Can you explain a little more about that please? I don't
think I
fully understand what you mean.
Cheers,
Graeme :)
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 12:29 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question, just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use some
logic to combine the results into an array by a common factor. Just
remember that you can only work with one mysql result per connection
at
a time. You *may* (untested!) be able to accomplish what you want to
do
with two separate connections, but again, this is seriously overkill.
:)
I'd definitely recommend restructuring your talbes as Jason suggested.
-- Josh
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions
similar
to the code below? I've tried a few different ways but I keep
getting
Resource ID #4. I need to do this to retrieve an email address from
one
table and retrieve details from another.
Cheers for any tips - I'm stumped with this one,
Graeme :)
$query = SELECT Name, Address FROM users;
$query2 = SELECT EmailAddress From Members;
$result = mysql_query($query);
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result) and $Email =
mysql_fetch_array($result2))
{
echo Name: $details[Name];
echo Address: $details[Address];
echo Email: $Email[EmailAddress];
}
Unless I've missed something you're going about this the wrong way.
For
what
you want to do, you should (in general) be able to accomplish it using
just a
single query.
What fields do the tables 'users' and 'Members' contain? There should
be
a
field there (like eg. userid) which links the two together. If there
isn't
one then you should seriously restructure your tables so that there is
one.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
*
/*
Cats are smarter than dogs. You can't make eight cats pull a sled
through
the snow.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_fetch_array() question
That's not true. You can assign them to different variables and it works
fine.
$r1 = mysql_query(select * from main limit 1) or die(mysql_error());
$r2 = mysql_query(select * from apft limit 1) or die(mysql_error());
$row1 = mysql_fetch_array($r1);
$row2 = mysql_fetch_array($r2);
print_r($row1);
echo brhr;
print_r($row2);
---John Holmes...
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: 'Graeme McLaren' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 1:02 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
In my experience, (I haven't checked the docs just yet to figure out
exactly why), you can only work with one result id at a time. Every time
you call mysql_query, it resets the result id (I think it frees the
result id automatically so you can send another query before getting the
new result id), so even if you store it in two separate variables, it
will only refrence the last id (which sounds just like what happened in
your initial post). I think this is limited to a given connection, but
I'm not sure.
One of the, I guess you could say, shortcomings of the mysql interface
in php is that you can only execute one query at a time, and I think
this odd result id overwrighting that happens is due to that fact (I
might be wrong, but I think you can execute multiple queries at a time
with perl's DBI module).
I hope that makes more sense :)
-- Josh
-Original Message-
From: Graeme McLaren [mailto:mickel;ntlworld.com]
Sent: Wednesday, November 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied to my
email also. I solved the problem shortly after posting my question,
I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with one mysql result per connection at
a time. Can you explain a little more about that please? I don't
think I
fully understand what you mean.
Cheers,
Graeme :)
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 12:29 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question, just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use some
logic to combine the results into an array by a common factor. Just
remember that you can only work with one mysql result per connection
at
a time. You *may* (untested!) be able to accomplish what you want to
do
with two separate connections, but again, this is seriously overkill.
:)
I'd definitely recommend restructuring your talbes as Jason suggested.
-- Josh
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions
similar
to the code below? I've tried a few different ways but I keep
getting
Resource ID #4. I need to do this to retrieve an email address from
one
table and retrieve details from another.
Cheers for any tips - I'm stumped with this one,
Graeme :)
$query = SELECT Name, Address FROM users;
$query2 = SELECT EmailAddress From Members;
$result = mysql_query($query);
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result) and $Email =
mysql_fetch_array($result2))
{
echo Name: $details[Name];
echo Address: $details[Address];
echo Email: $Email[EmailAddress];
}
Unless I've missed something you're going about this the wrong way.
For
what
you want to do, you should (in general) be able to accomplish it using
just a
single query.
What fields do the tables 'users' and 'Members' contain? There should
be
a
field there (like eg. userid) which links the two together. If there
isn't
one then you should seriously restructure your tables so that there is
one.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
*
/*
Cats are smarter than dogs. You can't make eight cats pull a sled
through
the snow.
*/
--
PHP Database Mailing List
[PHP-DB] forum test
Hi everyone, I just uploaded my forum and would like to have it field tested by everyone. It'll prob still have some bugs in there. http://seabird.jmtech.ca go to website and then click on forum. please ignore the login in the left top for now, Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql_fetch_array() question
:) see why I love mailing lists! :)
It must have been their logic then, I respectfully retract everything I
said, sorry Graeme! Why do I have to work, I could spend my days
researching this stuff before I post!
Thanks John!
-- Josh
-Original Message-
From: 1LT John W. Holmes [mailto:holmes072000;charter.net]
Sent: Wednesday, November 06, 2002 1:21 PM
To: Josh Johnson; 'Graeme McLaren'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
That's not true. You can assign them to different variables and it works
fine.
$r1 = mysql_query(select * from main limit 1) or die(mysql_error());
$r2 = mysql_query(select * from apft limit 1) or die(mysql_error());
$row1 = mysql_fetch_array($r1);
$row2 = mysql_fetch_array($r2);
print_r($row1);
echo brhr;
print_r($row2);
---John Holmes...
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: 'Graeme McLaren' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 1:02 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
In my experience, (I haven't checked the docs just yet to figure out
exactly why), you can only work with one result id at a time. Every
time
you call mysql_query, it resets the result id (I think it frees the
result id automatically so you can send another query before getting
the
new result id), so even if you store it in two separate variables, it
will only refrence the last id (which sounds just like what happened
in
your initial post). I think this is limited to a given connection, but
I'm not sure.
One of the, I guess you could say, shortcomings of the mysql
interface
in php is that you can only execute one query at a time, and I think
this odd result id overwrighting that happens is due to that fact (I
might be wrong, but I think you can execute multiple queries at a time
with perl's DBI module).
I hope that makes more sense :)
-- Josh
-Original Message-
From: Graeme McLaren [mailto:mickel;ntlworld.com]
Sent: Wednesday, November 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied to
my
email also. I solved the problem shortly after posting my question,
I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with one mysql result per connection
at
a time. Can you explain a little more about that please? I don't
think I
fully understand what you mean.
Cheers,
Graeme :)
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 12:29 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question,
just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use some
logic to combine the results into an array by a common factor. Just
remember that you can only work with one mysql result per connection
at
a time. You *may* (untested!) be able to accomplish what you want to
do
with two separate connections, but again, this is seriously
overkill.
:)
I'd definitely recommend restructuring your talbes as Jason
suggested.
-- Josh
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions
similar
to the code below? I've tried a few different ways but I keep
getting
Resource ID #4. I need to do this to retrieve an email address
from
one
table and retrieve details from another.
Cheers for any tips - I'm stumped with this one,
Graeme :)
$query = SELECT Name, Address FROM users;
$query2 = SELECT EmailAddress From Members;
$result = mysql_query($query);
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result) and $Email =
mysql_fetch_array($result2))
{
echo Name: $details[Name];
echo Address: $details[Address];
echo Email: $Email[EmailAddress];
}
Unless I've missed something you're going about this the wrong way.
For
what
you want to do, you should (in general) be able to accomplish it
using
just a
single query.
What fields do the tables 'users' and 'Members' contain? There
should
be
a
field there (like
Re: [PHP-DB] mysql_fetch_array() question
John is right. In fact one routinely calls two different $result(s) when
coding nested loops:
while( $details = mysql_fetch_array( $result ) ) {
while ( $Email = mysql_fetch_array( $result2 ) )
..
}
}
when executing the next instance of your loop:
while( $details = mysql_fetch_array( $result ) and $Email =
mysql_fetch_array( $result2 ) ),
each mysql_fetch_array will push both pointers (on your two result
resources) by one position.
if your result sets do not have the same number of rows, the shorter one
will choke before the longer one is finished. therefore you will finish the
loop not having called all results from the long resource.
My 0.02 Belgian francs
Ignatius
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: '1LT John W. Holmes' [EMAIL PROTECTED]; 'Graeme McLaren'
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 7:24 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
:) see why I love mailing lists! :)
It must have been their logic then, I respectfully retract everything I
said, sorry Graeme! Why do I have to work, I could spend my days
researching this stuff before I post!
Thanks John!
-- Josh
-Original Message-
From: 1LT John W. Holmes [mailto:holmes072000;charter.net]
Sent: Wednesday, November 06, 2002 1:21 PM
To: Josh Johnson; 'Graeme McLaren'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
That's not true. You can assign them to different variables and it works
fine.
$r1 = mysql_query(select * from main limit 1) or die(mysql_error());
$r2 = mysql_query(select * from apft limit 1) or die(mysql_error());
$row1 = mysql_fetch_array($r1);
$row2 = mysql_fetch_array($r2);
print_r($row1);
echo brhr;
print_r($row2);
---John Holmes...
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: 'Graeme McLaren' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 1:02 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
In my experience, (I haven't checked the docs just yet to figure out
exactly why), you can only work with one result id at a time. Every
time
you call mysql_query, it resets the result id (I think it frees the
result id automatically so you can send another query before getting
the
new result id), so even if you store it in two separate variables, it
will only refrence the last id (which sounds just like what happened
in
your initial post). I think this is limited to a given connection, but
I'm not sure.
One of the, I guess you could say, shortcomings of the mysql
interface
in php is that you can only execute one query at a time, and I think
this odd result id overwrighting that happens is due to that fact (I
might be wrong, but I think you can execute multiple queries at a time
with perl's DBI module).
I hope that makes more sense :)
-- Josh
-Original Message-
From: Graeme McLaren [mailto:mickel;ntlworld.com]
Sent: Wednesday, November 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied to
my
email also. I solved the problem shortly after posting my question,
I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with one mysql result per connection
at
a time. Can you explain a little more about that please? I don't
think I
fully understand what you mean.
Cheers,
Graeme :)
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 12:29 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question,
just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use some
logic to combine the results into an array by a common factor. Just
remember that you can only work with one mysql result per connection
at
a time. You *may* (untested!) be able to accomplish what you want to
do
with two separate connections, but again, this is seriously
overkill.
:)
I'd definitely recommend restructuring your talbes as Jason
suggested.
-- Josh
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB]
RE: [PHP-DB] mysql_fetch_array() question
Of course, you can avoid that problem if you use a join, I guess it all
comes down to code complexity vs SQL complexity.
-- Josh
-Original Message-
From: Ignatius Reilly [mailto:ignatius.reilly;free.fr]
Sent: Wednesday, November 06, 2002 1:38 PM
To: Josh Johnson; '1LT John W. Holmes'; 'Graeme McLaren';
[EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
John is right. In fact one routinely calls two different $result(s) when
coding nested loops:
while( $details = mysql_fetch_array( $result ) ) {
while ( $Email = mysql_fetch_array( $result2 ) )
..
}
}
when executing the next instance of your loop:
while( $details = mysql_fetch_array( $result ) and $Email =
mysql_fetch_array( $result2 ) ),
each mysql_fetch_array will push both pointers (on your two result
resources) by one position.
if your result sets do not have the same number of rows, the shorter one
will choke before the longer one is finished. therefore you will finish
the
loop not having called all results from the long resource.
My 0.02 Belgian francs
Ignatius
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: '1LT John W. Holmes' [EMAIL PROTECTED]; 'Graeme
McLaren'
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 7:24 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
:) see why I love mailing lists! :)
It must have been their logic then, I respectfully retract everything
I
said, sorry Graeme! Why do I have to work, I could spend my days
researching this stuff before I post!
Thanks John!
-- Josh
-Original Message-
From: 1LT John W. Holmes [mailto:holmes072000;charter.net]
Sent: Wednesday, November 06, 2002 1:21 PM
To: Josh Johnson; 'Graeme McLaren'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
That's not true. You can assign them to different variables and it
works
fine.
$r1 = mysql_query(select * from main limit 1) or die(mysql_error());
$r2 = mysql_query(select * from apft limit 1) or die(mysql_error());
$row1 = mysql_fetch_array($r1);
$row2 = mysql_fetch_array($r2);
print_r($row1);
echo brhr;
print_r($row2);
---John Holmes...
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: 'Graeme McLaren' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 1:02 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
In my experience, (I haven't checked the docs just yet to figure out
exactly why), you can only work with one result id at a time. Every
time
you call mysql_query, it resets the result id (I think it frees the
result id automatically so you can send another query before getting
the
new result id), so even if you store it in two separate variables,
it
will only refrence the last id (which sounds just like what happened
in
your initial post). I think this is limited to a given connection,
but
I'm not sure.
One of the, I guess you could say, shortcomings of the mysql
interface
in php is that you can only execute one query at a time, and I think
this odd result id overwrighting that happens is due to that fact (I
might be wrong, but I think you can execute multiple queries at a
time
with perl's DBI module).
I hope that makes more sense :)
-- Josh
-Original Message-
From: Graeme McLaren [mailto:mickel;ntlworld.com]
Sent: Wednesday, November 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied
to
my
email also. I solved the problem shortly after posting my question,
I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with one mysql result per connection
at
a time. Can you explain a little more about that please? I don't
think I
fully understand what you mean.
Cheers,
Graeme :)
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 12:29 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question,
just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
$query2 = SELECT EmailAddress From Members;
$result2 = mysql_query($query2);
while($details = mysql_fetch_array($result2)){
echo Email: $Email[EmailAddress];
}
The results won't come out at the same time, but you could use
some
logic to combine the results into an array by a common factor.
Just
remember that you can only work with one mysql result per
connection
at
a time. You *may* (untested!) be able to
[PHP-DB] Imploding an array?
Hey all, Can't seem to figure out why this won't work: $test = implode(,, $order_index[$i]); When I print_r() the variable I have values so I know that works. Any thoughts on this? Thanks. Aaron
Re: [PHP-DB] Imploding an array?
You sure you want [$i] on that? Is it a 2-dimensional array? On Wed, 6 Nov 2002, Aaron Wolski wrote: Hey all, Can't seem to figure out why this won't work: $test = implode(,, $order_index[$i]); When I print_r() the variable I have values so I know that works. Any thoughts on this? Thanks. Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Imploding an array?
isn't $order_index[$i] only one index? or is it multi dimensional? Aaron Wolski aaronjw@marte To: [EMAIL PROTECTED] kbiz.comcc: Subject: [PHP-DB] Imploding an array? 11/06/2002 02:04 PM Please respond to aaronjw Hey all, Can't seem to figure out why this won't work: $test = implode(,, $order_index[$i]); When I print_r() the variable I have values so I know that works. Any thoughts on this? Thanks. Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Imploding an array?
Does $i have a value? -- Josh -Original Message- From: Rasmus Lerdorf [mailto:rasmus;php.net] Sent: Wednesday, November 06, 2002 2:16 PM To: Aaron Wolski Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Imploding an array? You sure you want [$i] on that? Is it a 2-dimensional array? On Wed, 6 Nov 2002, Aaron Wolski wrote: Hey all, Can't seem to figure out why this won't work: $test = implode(,, $order_index[$i]); When I print_r() the variable I have values so I know that works. Any thoughts on this? Thanks. Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Imploding an array?
Ok...
This is the code I have setup:
for ($i=0;$isizeof($order_index);$i++) {
if ($delete[$i] == 1) {
print_r($order_index[$i]);
$str = implode(,,$order_index[$i]);
echo $str;
}
}
Now..upon the print_r.. The values that ARE there look like 2627
(which is order_index 26 and 27).
Basically I am trying to get the 2627 into a string that looks like:
$str = 26,27; so I can use it in something else.
*shrugs*
I think I wma way off base here *eyes blurry* heeh
Aaron
-Original Message-
From: Rasmus Lerdorf [mailto:rasmus;php.net]
Sent: Wednesday, November 06, 2002 2:16 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Imploding an array?
You sure you want [$i] on that? Is it a 2-dimensional array?
On Wed, 6 Nov 2002, Aaron Wolski wrote:
Hey all,
Can't seem to figure out why this won't work:
$test = implode(,, $order_index[$i]);
When I print_r() the variable I have values so I know that works.
Any thoughts on this?
Thanks.
Aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Imploding an array?
Well, your code will do this:
if delete[7] == 1, you will print_r($order_index[7]) which contains ???
Now from what you say $order_index[7] == 2627;
That's just weird. Whatever it is you are doing is bad.
Regardless, you could do this:
$foo = preg_split(//,$order_index[7]);
Now $foo is an array of [0]=2, [1]=6, [2]=2, [3]=7;
Now you do a while loop:
for ($x=0;$x=count($foo);$x++) {
if (is_odd($x)) { $next = 1; } else { $next = 0; }
$str .= $foo[$x];
if ($next) $str .= ,;
$x++;
}
Or something like that. is_odd may not be a function, but YOU figure out
how to determine if a number is odd.
Peter
On Wed, 6 Nov 2002, Aaron Wolski wrote:
Ok...
This is the code I have setup:
for ($i=0;$isizeof($order_index);$i++) {
if ($delete[$i] == 1) {
print_r($order_index[$i]);
$str = implode(,,$order_index[$i]);
echo $str;
}
}
Now..upon the print_r.. The values that ARE there look like 2627
(which is order_index 26 and 27).
Basically I am trying to get the 2627 into a string that looks like:
$str = 26,27; so I can use it in something else.
*shrugs*
I think I wma way off base here *eyes blurry* heeh
Aaron
-Original Message-
From: Rasmus Lerdorf [mailto:rasmus;php.net]
Sent: Wednesday, November 06, 2002 2:16 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Imploding an array?
You sure you want [$i] on that? Is it a 2-dimensional array?
On Wed, 6 Nov 2002, Aaron Wolski wrote:
Hey all,
Can't seem to figure out why this won't work:
$test = implode(,, $order_index[$i]);
When I print_r() the variable I have values so I know that works.
Any thoughts on this?
Thanks.
Aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] forum test
I'll look into it, thanx, can you access the jump-menu?? Forum should be all the way in the bottom. Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching Mignon Hunter [EMAIL PROTECTED] wrote in message news:1036610707.1915.12.camel;joboo.tic.toshiba.com... I'm using Mozilla. I dont see the word 'forum' I guess your onChange=loadIframeJumpMenu doesnt work ? Or the type of javascript your using isnt supported by Mozilla. BTW the nedstat failed to connect on first try. On Wed, 2002-11-06 at 12:25, Seabird wrote: Hi everyone, I just uploaded my forum and would like to have it field tested by everyone. It'll prob still have some bugs in there. http://seabird.jmtech.ca go to website and then click on forum. please ignore the login in the left top for now, Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL password protection?
Hi all I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? Thanks, William --- William Trappeniers mail at: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL password protection?
I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL password protection?
actually you can make a .php file with your connection info, include it in your .php files at the top and encrypt that one file (they don't need to see it anyway). use a php encoder for the file with your login info in it. -Original Message- From: 1LT John W. Holmes [mailto:holmes072000;charter.net] Sent: Wednesday, November 06, 2002 4:16 PM To: William Trappeniers; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL password protection? I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL password protection?
You could put it anywhere. Stick it in a text file somewhere, fopen() and read the file for the password. Or keep it in a php script outside of the web root if that's the issue, then just include() it when you need to. Of course any file you put it in will have to be readable by whatever user the webserver is running as. -Steve On Wednesday, November 6, 2002, at 04:16 PM, 1LT John W. Holmes wrote: I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL password protection?
Are you sure you can include an encoded file into a non-encoded one? I had forgotten about this option, but if you can find a worthwhile compiler/encoder/etc, then that's a solution. ---John Holmes... - Original Message - From: SELPH,JASON (HP-Richardson,ex1) [EMAIL PROTECTED] To: '1LT John W. Holmes' [EMAIL PROTECTED]; William Trappeniers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 5:30 PM Subject: RE: [PHP-DB] MySQL password protection? actually you can make a .php file with your connection info, include it in your .php files at the top and encrypt that one file (they don't need to see it anyway). use a php encoder for the file with your login info in it. -Original Message- From: 1LT John W. Holmes [mailto:holmes072000;charter.net] Sent: Wednesday, November 06, 2002 4:16 PM To: William Trappeniers; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL password protection? I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL password protection?
Make sure that the encoder you use actually makes string unreadable. Otherwise, you can use a simple trick, like for example XORing the whole string with FF or something similar. -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! ---BeginMessage--- actually you can make a .php file with your connection info, include it in your .php files at the top and encrypt that one file (they don't need to see it anyway). use a php encoder for the file with your login info in it. -Original Message- From: 1LT John W. Holmes [mailto:holmes072000;charter.net] Sent: Wednesday, November 06, 2002 4:16 PM To: William Trappeniers; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL password protection? I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Record IDs: Numeric or String??
Is it more efficient to store record IDs in a MySQL database as an Integer or a String? I like string IDs better because you can create meaningful names, but, not sure if this means the DB has to work harder or not. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Record IDs: Numeric or String??
Numeric IDs are probably a bit faster--although if properly indexed not by much--plus you can use self-numbering columns with them. Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! ---BeginMessage--- Is it more efficient to store record IDs in a MySQL database as an Integer or a String? I like string IDs better because you can create meaningful names, but, not sure if this means the DB has to work harder or not. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL password protection?
And make sure you make sure the webserver will not SERVE that file!!! You see the source, see that you are fopening the file, I'll find it on your system and get it from the web server and I have your password! Make sure the file is NOT in the document root that the web server serves from. You could also just use the file .htpasswd, usually by default web servers will NOT serve any file named that. However, much safer to put it somewhere that the web server cannot see (but your PHP script can). Also, this is just as insecure as the other way to any person with a login on the box your PHP script is in. Usually the script is owned by nobody:nobody or read-write all, in which case all local users can get your password. The nobody method at least keeps no password. Peter On Wed, 6 Nov 2002, Steve Cayford wrote: You could put it anywhere. Stick it in a text file somewhere, fopen() and read the file for the password. Or keep it in a php script outside of the web root if that's the issue, then just include() it when you need to. Of course any file you put it in will have to be readable by whatever user the webserver is running as. -Steve On Wednesday, November 6, 2002, at 04:16 PM, 1LT John W. Holmes wrote: I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Record IDs: Numeric or String??
Always use ints. Also, make sure you actually need an INT before using it: Max Value Unsigned Integer: 4.3 billion or so Unsigned MediumInt: 16.7 million unsigned SmallInt: 65,535 unsigned TinyInt: 255 If you'll only ever have 300,000 rows in a table, use a mediumint. Saves space and sorting time. I use mediumint on almost all tables for primary keys and foreign keys. Peter On Wed, 6 Nov 2002, Monty wrote: Is it more efficient to store record IDs in a MySQL database as an Integer or a String? I like string IDs better because you can create meaningful names, but, not sure if this means the DB has to work harder or not. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL password protection?
The standard apache install filters anything named .ht*. on the web tree. -- Josh -Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: Wednesday, November 06, 2002 6:44 PM To: Steve Cayford Cc: [EMAIL PROTECTED]; William Trappeniers Subject: Re: [PHP-DB] MySQL password protection? And make sure you make sure the webserver will not SERVE that file!!! You see the source, see that you are fopening the file, I'll find it on your system and get it from the web server and I have your password! Make sure the file is NOT in the document root that the web server serves from. You could also just use the file .htpasswd, usually by default web servers will NOT serve any file named that. However, much safer to put it somewhere that the web server cannot see (but your PHP script can). Also, this is just as insecure as the other way to any person with a login on the box your PHP script is in. Usually the script is owned by nobody:nobody or read-write all, in which case all local users can get your password. The nobody method at least keeps no password. Peter On Wed, 6 Nov 2002, Steve Cayford wrote: You could put it anywhere. Stick it in a text file somewhere, fopen() and read the file for the password. Or keep it in a php script outside of the web root if that's the issue, then just include() it when you need to. Of course any file you put it in will have to be readable by whatever user the webserver is running as. -Steve On Wednesday, November 6, 2002, at 04:16 PM, 1LT John W. Holmes wrote: I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? You can't, unless you want to put it in php.ini or a my.conf file... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL password protection?
Also, you can limit access to a specific table in a specific database for a specific user, if it makes sense in your application. -- Josh -Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: Wednesday, November 06, 2002 6:41 PM To: William Trappeniers Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL password protection? Create a user nobody with no password and give that user select, update, delete and insert capabilities in your DB and can only connect from localhost (or a certain host). This way they have to be on localhost in order to gain access to your tables, and only then be able to do what your nobody user can do. Then you need to make sure nobody can gain access to localhost without express permission (i.e. plug all security holes). Why are you showing people your source-code that has your password in it? Peter On Wed, 6 Nov 2002, William Trappeniers wrote: Hi all I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? Thanks, William --- William Trappeniers mail at: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] forum test
Seabird wrote: I'll look into it, thanx, can you access the jump-menu?? Forum should be all the way in the bottom. The jump menu doesn't work. I think you nad a 'name' field for each option... of your select... box. Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching Mignon Hunter [EMAIL PROTECTED] wrote in message news:1036610707.1915.12.camel;joboo.tic.toshiba.com... I'm using Mozilla. I dont see the word 'forum' I guess your onChange=loadIframeJumpMenu doesnt work ? Or the type of javascript your using isnt supported by Mozilla. BTW the nedstat failed to connect on first try. On Wed, 2002-11-06 at 12:25, Seabird wrote: Hi everyone, I just uploaded my forum and would like to have it field tested by everyone. It'll prob still have some bugs in there. http://seabird.jmtech.ca go to website and then click on forum. please ignore the login in the left top for now, Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- From Mozilla and GNU/Linux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL password protection?
One thing I do with Postgres that I'm not sure MySQL supports is Kerberos5 authentication. This way, a user logs in (and they have a user account on the DB) and I use their remote user name and their Kerberos ticket to authenticate them to the DB. That works without having to store a password anywhere on the filesystem. --Dave William Trappeniers wrote: Hi all I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? Thanks, William --- William Trappeniers mail at: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Warning - newby question -- $_GET
Hi, I'm trying to call a script with the ?= after the php script name in the URL, but can't seem to pick up the variable to use in my script... any help would be greatly appreciated :) I'm calling the script with this url: http://localhost/Data/test/dbconnect2c.php?id=TestPage The section of the script i'm using is: $id = $_GET['id']; $sql=SELECT * FROM content where title=$id; $result=mysql_query($sql,$db); Error message returned: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in... Thanks, Gav This e-mail and any attachments are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or of any information they contain, by anyone other than the addressee, is prohibited. If you received this e-mail in error, please notify us immediately by return e-mail or telephone +61 2 9413 2944 and destroy the original message. Thank you. As Email is subject to viruses we advise that all Emails and any attachments should be scanned by an up to-date Anti Virus programme automatically by your system. It is the responsibility of the recipient to ensure that all Emails and any attachments are cleared of Viruses before opening. KSG can not accept any responsibility for viruses that maybe contained here in. Please advise KSG by return Email if you believe any Email sent by our system may contain a virus. It should be noted that most Anti Virus programmes can not scan encrypted file attachments (example - documents saved with a password). Thus extra care should be taken when opening these files. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW). Level 4 54 Neridah StreetPO Box 1290 CHATSWOOD NSW 2067 CHATSWOOD NSW 2057 Ph: +61 2 9413 2944 Fax: +61 2 9413 9901 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning - newby question -- $_GET
did you try echoing the value of $id after you have assigned it? you may find it's because you aren't connected to your database or something and also, i am assuming that you are using a recent install/verison of PHP, because $_GET wasn't available until the last few releases. beau // -Original Message- // From: Gavin Amm [mailto:gavin;ksg.com.au] // Sent: Thursday, 7 November 2002 9:55 AM // To: Php-Db (E-mail) // Subject: [PHP-DB] Warning - newby question -- $_GET // // // Hi, // // I'm trying to call a script with the ?= after the php // script name in the // URL, but can't seem to pick up the variable to use in my script... // any help would be greatly appreciated :) // // I'm calling the script with this url: // http://localhost/Data/test/dbconnect2c.php?id=TestPage // // The section of the script i'm using is: // $id = $_GET['id']; // $sql=SELECT * FROM content where title=$id; // $result=mysql_query($sql,$db); // // Error message returned: // Warning: mysql_fetch_array(): supplied argument is not a // valid MySQL result // resource in... // // // Thanks, // Gav // // // This e-mail and any attachments are intended solely for the // named addressee, // are confidential and may contain legally privileged information. // // The copying or distribution of them or of any information // they contain, by // anyone other than the addressee, is prohibited. If you // received this e-mail // in error, please notify us immediately by return e-mail or // telephone +61 2 // 9413 2944 and destroy the original message. Thank you. // // As Email is subject to viruses we advise that all Emails and // any attachments // should be scanned by an up to-date Anti Virus programme // automatically by // your system. It is the responsibility of the recipient to // ensure that all // Emails and any attachments are cleared of Viruses before // opening. KSG can // not accept any responsibility for viruses that maybe // contained here in. // Please advise KSG by return Email if you believe any Email // sent by our // system may contain a virus. It should be noted that most Anti Virus // programmes can not scan encrypted file attachments (example // - documents // saved with a password). Thus extra care should be taken when // opening these // files. // // Liability limited by the Accountants Scheme, approved under // the Professional // Standards Act 1994 (NSW). // // // // Level 4 // 54 Neridah StreetPO Box 1290 // CHATSWOOD NSW 2067 CHATSWOOD NSW 2057 // // // Ph: +61 2 9413 2944 Fax: +61 2 9413 9901 // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning - newby question -- $_GET
I'm trying to call a script with the ?= after the php script name in the URL, but can't seem to pick up the variable to use in my script... any help would be greatly appreciated :) I'm calling the script with this url: http://localhost/Data/test/dbconnect2c.php?id=TestPage The section of the script i'm using is: $id = $_GET['id']; $sql=SELECT * FROM content where title=$id; $result=mysql_query($sql,$db); Well, for your example, $id is going to equal TestPage, so you are making an invalid query: where title=TestPage. If you echo mysql_error(), it'll probably say something about unknown column TestPage. At the very least, use quotes: where title='$id' Error message returned: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in... This means your query failed. Echo mysql_error() to determine why. Get used to using mysql_error for good debugging. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning - newby question -- $_GET
i wrote a really basic script sucessfully to echo the url variable to the screen... will go from there. thanks beau. EXCELLENT :) The single quotes around the $id variable in the select statement worked wonderfully. thanks John. Gav -Original Message- From: John W. Holmes [mailto:holmes072000;charter.net] Sent: Thursday, 7 November 2002 1:20 PM To: 'Gavin Amm'; 'Php-Db (E-mail)' Subject: RE: [PHP-DB] Warning - newby question -- $_GET I'm trying to call a script with the ?= after the php script name in the URL, but can't seem to pick up the variable to use in my script... any help would be greatly appreciated :) I'm calling the script with this url: http://localhost/Data/test/dbconnect2c.php?id=TestPage The section of the script i'm using is: $id = $_GET['id']; $sql=SELECT * FROM content where title=$id; $result=mysql_query($sql,$db); Well, for your example, $id is going to equal TestPage, so you are making an invalid query: where title=TestPage. If you echo mysql_error(), it'll probably say something about unknown column TestPage. At the very least, use quotes: where title='$id' Error message returned: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in... This means your query failed. Echo mysql_error() to determine why. Get used to using mysql_error for good debugging. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This e-mail and any attachments are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or of any information they contain, by anyone other than the addressee, is prohibited. If you received this e-mail in error, please notify us immediately by return e-mail or telephone +61 2 9413 2944 and destroy the original message. Thank you. As Email is subject to viruses we advise that all Emails and any attachments should be scanned by an up to-date Anti Virus programme automatically by your system. It is the responsibility of the recipient to ensure that all Emails and any attachments are cleared of Viruses before opening. KSG can not accept any responsibility for viruses that maybe contained here in. Please advise KSG by return Email if you believe any Email sent by our system may contain a virus. It should be noted that most Anti Virus programmes can not scan encrypted file attachments (example - documents saved with a password). Thus extra care should be taken when opening these files. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW). Level 4 54 Neridah StreetPO Box 1290 CHATSWOOD NSW 2067 CHATSWOOD NSW 2057 Ph: +61 2 9413 2944 Fax: +61 2 9413 9901 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Warning - newby question -- $_GET
Well, first of all, you have to connect to the database. ?php $db_server = localhost; // Usual server. :P $db_login = USERNAME; $db_pass = USERPASS; mysql_connect($db_server,$db_login,$db_pass); ? And, its not always nesecary to have to type in $_GET['id'] to declare a GET variable. Some server software requires it, I think IIS is the only one, its what I use. And its not required for you to use the 2nd prefex for mysql_query() Just as long as you connected to the DB at the beginning of the script, all you need is mysql_query($sql). That should clear up the error. As for you want to with the $result array, ask if needing help.
[PHP-DB] FW: php J2EE .NET
Hi There is an article on sitepoint.com about benchmarking J2EE and .NET and some controversy over the result http://www.sitepoint.com/newsletters/viewissue.php?fid=3id=3issue=52 Does anybody have experience of php/MySql in comparison with either of the above in terms of efficiency or ultimate performance? Is anybody interested in putting a php/MySql setup through the same benchmarks? Mostly for fun, but might be useful for the 'but Open Source is not up to Enterprise Applications' augment. Peter Mysql query blah.. --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning - newby question -- $_GET
Hi, For some reason the page worked the 1st few times, now I get the error message (after making no changes to the code from when it worked...): (line 5 references the $db = mysql_co... line of code) Warning: Unknown MySQL Server Host 'mysql.db.*.net.au' (2) in /home/.../public_html/public/index2.php on line 5 I've got the following code at the start of my script: (i've replaced username and ** with the appropriate username password...) ?php $db = mysql_connect(mysql.db.*.net.au, username, **); mysql_select_db(kandtsg,$db); ... cheers, Gav This e-mail and any attachments are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or of any information they contain, by anyone other than the addressee, is prohibited. If you received this e-mail in error, please notify us immediately by return e-mail or telephone +61 2 9413 2944 and destroy the original message. Thank you. As Email is subject to viruses we advise that all Emails and any attachments should be scanned by an up to-date Anti Virus programme automatically by your system. It is the responsibility of the recipient to ensure that all Emails and any attachments are cleared of Viruses before opening. KSG can not accept any responsibility for viruses that maybe contained here in. Please advise KSG by return Email if you believe any Email sent by our system may contain a virus. It should be noted that most Anti Virus programmes can not scan encrypted file attachments (example - documents saved with a password). Thus extra care should be taken when opening these files. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW). Level 4 54 Neridah StreetPO Box 1290 CHATSWOOD NSW 2067 CHATSWOOD NSW 2057 Ph: +61 2 9413 2944 Fax: +61 2 9413 9901 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Warning - newby question -- $_GET
Make sure DNS is working and mysql.db.*.net.au resolves. Better yet, use the IP address unless absolutely necessary to use the hostname. Peter On Thu, 7 Nov 2002, Gavin Amm wrote: Hi, For some reason the page worked the 1st few times, now I get the error message (after making no changes to the code from when it worked...): (line 5 references the $db = mysql_co... line of code) Warning: Unknown MySQL Server Host 'mysql.db.*.net.au' (2) in /home/.../public_html/public/index2.php on line 5 I've got the following code at the start of my script: (i've replaced username and ** with the appropriate username password...) ?php $db = mysql_connect(mysql.db.*.net.au, username, **); mysql_select_db(kandtsg,$db); ... cheers, Gav This e-mail and any attachments are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or of any information they contain, by anyone other than the addressee, is prohibited. If you received this e-mail in error, please notify us immediately by return e-mail or telephone +61 2 9413 2944 and destroy the original message. Thank you. As Email is subject to viruses we advise that all Emails and any attachments should be scanned by an up to-date Anti Virus programme automatically by your system. It is the responsibility of the recipient to ensure that all Emails and any attachments are cleared of Viruses before opening. KSG can not accept any responsibility for viruses that maybe contained here in. Please advise KSG by return Email if you believe any Email sent by our system may contain a virus. It should be noted that most Anti Virus programmes can not scan encrypted file attachments (example - documents saved with a password). Thus extra care should be taken when opening these files. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW). Level 4 54 Neridah StreetPO Box 1290 CHATSWOOD NSW 2067 CHATSWOOD NSW 2057 Ph: +61 2 9413 2944 Fax: +61 2 9413 9901 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Archiving A Database
Do you need to archive it forever? Do you need live access to it? If you just need to archive it, read the man page for mysqldump. You can dump specific rows to a file, rename that file dump.2002.05.24, compress it with gzip, and voila, you have all of your data readily available, easily reinserted into your existing live DB. After the dump is complete, just delete those rows out of the DB. Now you have to be sure that the file contains 100% of the data and is accurate. You'll have to figure out how to do that yourself! One way I did it with WWW log files was to make a tmp copy, run a program on it, see if the output had the same number of lines in it, and if it did, delete the tmp copy and replace the original copy with the new copy (IP-DNS translation). In this case you could write a script that parses the newly created dump file in the standard format and, heck, using perl or PHP parse the thing for ),( and see how many you get. If the mysql select gets X rows, and the ),( or ); occurs X-1 times, then you know you got all the rows. (OK, it will be more complex than this, but you get the idea.) One record per file could get ugly real quick, both on the filesystem side and the maintenance side. Doing it by day will allow you to repopulate an entire day back into the DB as needed for billing questions or what not. MySQL will keep the unique ID (assuming it is a number auto_incremented) unique and only use ever higher IDs, not use old ones that no longer exist in the DB at the moment. Once you are done with that Day (or days) of data, you just delete it from the DB, knowing you have a copy of that day on file. I would also advise you to have 2-4 copies of all your backups on both physically different computers as well as physically different locations. I kept a copy of my live DB, backed up every 6 hours, at the data center on other computer, on my computer file server at home, and another one 7 states over. Sure, it's a bit of a pain in the ass, but if the data center goes up in smoke and my file server is hacked on the same day, I still have a copy 7 states over. I just used scp (secure-shell copy) and/or rsync + ssh to keep copies current and up to date on remote machines. Peter On Tue, 29 Oct 2002, Josh Johnson wrote: Does anyone know of speedy methods of periodically archiving and retrieving a database table? I've got a table I'm using to log statistical data, and it's getting 10k+ entries per day. Entries are only logged in the database if the user is authenticated for access, and only once per access session (the user is authenticated, a cookie is set, and the entry is logged. From that point the user is authenticated by verifying the cookie, which expires when the user's browser closes) The data is critical (used for billing and such), but the log viewing script I've written runs slower and slower with each passing day, and at one point the entire table was corrupted due to neglect on our system admin's part (I warned them about the default setting of mysql_max_connections being too low for a site that relied on the DB so heavily and had so much traffic.). The script is a simple front end to several MySQL queries, that retrieve totals for the past hour, day, week, month and grand totals for all clients or a given client. The rest of the site has been unaffected by the log issues. My current approach is to log the data as XML, one record per file, and create a log file that is an index of refrences to each record. I then empty previous data n the database. This works, but is very hard/slow to retrieve specific groups of information, and dumping the database takes a long time as well, which adds the difficulty of ensuring no records are lost. I also haven't yet tackled the issue of combining data from the XML seamlessly with live data from the database. I'm opening the floor to other potential solutions, or war stories from anyone else who's been in this situation before. If there's another approach aside from writing individual flat files, please let me know. I haven't tested it yet, but I think maybe logging all entries/data for a given log period into one file would speed things up, but I worry about the 40 megabyte files that could be potentially created. I'm also open to complete alternatives, since the main use for this data is to generate total accesses per a given factor (client, ip, referrer, etc). Any help is greatly appreciated. I can give any information needed, just ask! Thanks, -- Josh P.S. I did suggest that this issue be tackled when I first installed the system that creates the log, but management didn't think it was worth bothering with at the time. P.P.S. I did look through the archives before I posted, and didn't find anything. Please flame in private if I missed something! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] FW: php J2EE .NET
Well, I know from experience this: PHP 3 and 4.various, sessions enabled on every page (using DB to store) MySQL 3.23.various Apache 1.2.various 300,000 users in the DB 2600 dynamic pages No images or static multimedia content (on this server) PC, Dual 800Mhz 1GB Ram 4 18GB drives, 7200RPM, raided 0/1 (Mirrored) FreeBSD 4.various ~150 queries per second on mysql 1,233,771 page views in 24 hours, all served without issue. Each page ~100K Averaged 424,192 page views per day. That's just my experience. It was adcritic.com at its peak. Peter On Thu, 7 Nov 2002, Peter Lovatt wrote: Hi There is an article on sitepoint.com about benchmarking J2EE and .NET and some controversy over the result http://www.sitepoint.com/newsletters/viewissue.php?fid=3id=3issue=52 Does anybody have experience of php/MySql in comparison with either of the above in terms of efficiency or ultimate performance? Is anybody interested in putting a php/MySql setup through the same benchmarks? Mostly for fun, but might be useful for the 'but Open Source is not up to Enterprise Applications' augment. Peter Mysql query blah.. --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Select Fields
Hi,
Sorry if this is ametuer, but I have been staring at this code for so long, trying to
find out why my selection fields are gathering values, and I cant find the problem.
Thanks,
Tyler
--
?
include './include/vars.php';
include './include/dbconnect.php';
?
html
head
title?= $title ?/title
script languauge=javascript
function totalCost()
{
var form = document.system;
var casing = form.casing.value;
var processor = form.processor.value;
var ram = form.ram.value;
var hdd = form.hdd.value;
var video = form.video.value;
var sound = form.sound.value;
var nic = form.nic.value;
var monitor = form.monitor.value;
var speakers = form.speakers.value;
var interfaces = form.interfaces.value;
var total = casing + processor + ram + hdd + video + sound + nic + monitor + speakers
+ interfaces;
form.price.value = total;
}
/script
/head
body bgcolor=#CBD5DA link=#405266 vlink=#3F593E alink=#3F593E
div align=center
center
table border=0 cellspacing=0 cellpadding=0 width=780
tr
td width=15 height=15img border=0 src=images/corner_tl.gif width=15
height=15/td
td bgcolor=#FF height=15img border=0 src=images/clear.gif width=1
height=1/td
td width=15 height=15img border=0 src=images/corner_tr.gif width=15
height=15/td
/tr
tr
td bgcolor=#FF width=15img border=0 src=images/clear.gif width=1
height=1/td
td bgcolor=#FF
table border=0 width=100% cellpadding=0 cellspacing=0
/tr
tr
td valign=top rowspan=3 bgcolor=#C0C0C0img border=0 src=images/clear.gif
width=10 height=1
/td
td valign=topimg border=0 src=./images/main.png hspace=2 alt=Computer
Service
/td
td valign=top align=right
table name=login border=0 cellpadding=0 cellspacing=0
tr
td bgcolor=#cococo
centerbServices/b/center
/td/tr
trtd
center
? include './include/links.php'; ?
/center
/td/tr
/table
br
/td
/tr
tr
td valign=bottom colspan=2
!---Main Body
h2centerBuild Your Custom System/center/h2
form name=system action=customSystems.php method=post
? $parts = mysql_query(select part,price from parts where type like case;); ?
ul
Case:
select name=casing
?
while($item = mysql_fetch_array($parts))
{
echo option name='$item[part]' value=$item[price]$item[part]/option;
}
?
/select
/ul
div align=rightTotal Cost Of Parts: input type=text name=price size=6/div
/form
!-End Main Body--
/td
/tr
tr
td valign=top colspan=2
!-Empty Cell---
table border=0 cellpadding=5 cellspacing=7
tr
td
/td
td
/td
td valign=top
/td
/tr
/table
/td
/tr
tr
td valign=top bgcolor=#C0C0C0nbsp;
/td
td valign=top bgcolor=#C0C0C0 colspan=2
/td
/tr
/table
/td
td bgcolor=#c0c0c0/td
/tr
tr
td valign=top align=right width=15 height=15img border=0
src=images/corner_bl.gif width=15 height=15/td
td bgcolor=#FF height=15/td
td valign=top align=left width=15 height=15img border=0
src=images/corner_br.gif width=15 height=15/td
/tr
/table
/div
/body
/html
Re: [PHP-DB] Select Fields
Tyler,
You probably need one or two of the following:
1. Put single-quotes around case in your SQL (where type like 'case')
2. Use wild-cards in your where statement (where type like '%case%')
Good luck!
--Dave
On Wed, 2002-11-06 at 23:31, Tyler Whitesides wrote:
Hi,
Sorry if this is ametuer, but I have been staring at this code for so long, trying
to find out why my selection fields are gathering values, and I cant find the problem.
Thanks,
Tyler
--
?
include './include/vars.php';
include './include/dbconnect.php';
?
html
head
title?= $title ?/title
script languauge=javascript
function totalCost()
{
var form = document.system;
var casing = form.casing.value;
var processor = form.processor.value;
var ram = form.ram.value;
var hdd = form.hdd.value;
var video = form.video.value;
var sound = form.sound.value;
var nic = form.nic.value;
var monitor = form.monitor.value;
var speakers = form.speakers.value;
var interfaces = form.interfaces.value;
var total = casing + processor + ram + hdd + video + sound + nic + monitor +
speakers + interfaces;
form.price.value = total;
}
/script
/head
body bgcolor=#CBD5DA link=#405266 vlink=#3F593E alink=#3F593E
div align=center
center
table border=0 cellspacing=0 cellpadding=0 width=780
tr
td width=15 height=15img border=0 src=images/corner_tl.gif width=15
height=15/td
td bgcolor=#FF height=15img border=0 src=images/clear.gif width=1
height=1/td
td width=15 height=15img border=0 src=images/corner_tr.gif width=15
height=15/td
/tr
tr
td bgcolor=#FF width=15img border=0 src=images/clear.gif width=1
height=1/td
td bgcolor=#FF
table border=0 width=100% cellpadding=0 cellspacing=0
/tr
tr
td valign=top rowspan=3 bgcolor=#C0C0C0img border=0
src=images/clear.gif width=10 height=1
/td
td valign=topimg border=0 src=./images/main.png hspace=2 alt=Computer
Service
/td
td valign=top align=right
table name=login border=0 cellpadding=0 cellspacing=0
tr
td bgcolor=#cococo
centerbServices/b/center
/td/tr
trtd
center
? include './include/links.php'; ?
/center
/td/tr
/table
br
/td
/tr
tr
td valign=bottom colspan=2
!---Main Body
h2centerBuild Your Custom System/center/h2
form name=system action=customSystems.php method=post
? $parts = mysql_query(select part,price from parts where type like case;); ?
ul
Case:
select name=casing
?
while($item = mysql_fetch_array($parts))
{
echo option name='$item[part]' value=$item[price]$item[part]/option;
}
?
/select
/ul
div align=rightTotal Cost Of Parts: input type=text name=price
size=6/div
/form
!-End Main Body--
/td
/tr
tr
td valign=top colspan=2
!-Empty Cell---
table border=0 cellpadding=5 cellspacing=7
tr
td
/td
td
/td
td valign=top
/td
/tr
/table
/td
/tr
tr
td valign=top bgcolor=#C0C0C0nbsp;
/td
td valign=top bgcolor=#C0C0C0 colspan=2
/td
/tr
/table
/td
td bgcolor=#c0c0c0/td
/tr
tr
td valign=top align=right width=15 height=15img border=0
src=images/corner_bl.gif width=15 height=15/td
td bgcolor=#FF height=15/td
td valign=top align=left width=15 height=15img border=0
src=images/corner_br.gif width=15 height=15/td
/tr
/table
/div
/body
/html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Select Fields
Thank you putting '%case%' instead of case worked!
- Original Message -
From: David Smith [EMAIL PROTECTED]
To: Tyler Whitesides [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 10:47 PM
Subject: Re: [PHP-DB] Select Fields
Tyler,
You probably need one or two of the following:
1. Put single-quotes around case in your SQL (where type like 'case')
2. Use wild-cards in your where statement (where type like '%case%')
Good luck!
--Dave
On Wed, 2002-11-06 at 23:31, Tyler Whitesides wrote:
Hi,
Sorry if this is ametuer, but I have been staring at this code for so
long, trying to find out why my selection fields are gathering values, and I
cant find the problem.
Thanks,
Tyler
--
?
include './include/vars.php';
include './include/dbconnect.php';
?
html
head
title?= $title ?/title
script languauge=javascript
function totalCost()
{
var form = document.system;
var casing = form.casing.value;
var processor = form.processor.value;
var ram = form.ram.value;
var hdd = form.hdd.value;
var video = form.video.value;
var sound = form.sound.value;
var nic = form.nic.value;
var monitor = form.monitor.value;
var speakers = form.speakers.value;
var interfaces = form.interfaces.value;
var total = casing + processor + ram + hdd + video + sound + nic +
monitor + speakers + interfaces;
form.price.value = total;
}
/script
/head
body bgcolor=#CBD5DA link=#405266 vlink=#3F593E alink=#3F593E
div align=center
center
table border=0 cellspacing=0 cellpadding=0 width=780
tr
td width=15 height=15img border=0 src=images/corner_tl.gif
width=15 height=15/td
td bgcolor=#FF height=15img border=0 src=images/clear.gif
width=1 height=1/td
td width=15 height=15img border=0 src=images/corner_tr.gif
width=15 height=15/td
/tr
tr
td bgcolor=#FF width=15img border=0 src=images/clear.gif
width=1 height=1/td
td bgcolor=#FF
table border=0 width=100% cellpadding=0 cellspacing=0
/tr
tr
td valign=top rowspan=3 bgcolor=#C0C0C0img border=0
src=images/clear.gif width=10 height=1
/td
td valign=topimg border=0 src=./images/main.png hspace=2
alt=Computer Service
/td
td valign=top align=right
table name=login border=0 cellpadding=0 cellspacing=0
tr
td bgcolor=#cococo
centerbServices/b/center
/td/tr
trtd
center
? include './include/links.php'; ?
/center
/td/tr
/table
br
/td
/tr
tr
td valign=bottom colspan=2
!---Main Body
h2centerBuild Your Custom System/center/h2
form name=system action=customSystems.php method=post
? $parts = mysql_query(select part,price from parts where type like
case;); ?
ul
Case:
select name=casing
?
while($item = mysql_fetch_array($parts))
{
echo option name='$item[part]'
value=$item[price]$item[part]/option;
}
?
/select
/ul
div align=rightTotal Cost Of Parts: input type=text name=price
size=6/div
/form
!-End Main Body--
/td
/tr
tr
td valign=top colspan=2
!-Empty Cell---
table border=0 cellpadding=5 cellspacing=7
tr
td
/td
td
/td
td valign=top
/td
/tr
/table
/td
/tr
tr
td valign=top bgcolor=#C0C0C0nbsp;
/td
td valign=top bgcolor=#C0C0C0 colspan=2
/td
/tr
/table
/td
td bgcolor=#c0c0c0/td
/tr
tr
td valign=top align=right width=15 height=15img border=0
src=images/corner_bl.gif width=15 height=15/td
td bgcolor=#FF height=15/td
td valign=top align=left width=15 height=15img border=0
src=images/corner_br.gif width=15 height=15/td
/tr
/table
/div
/body
/html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sort by date
There is a difference between a general, how do I do this question and a specific here's my code, I can't find the bug question. Sometimes people just need a quick answer specific to their code. Also, unfortunately, many times when people want to point to a resource they give the standard RTFM. Believe it or not, many newbies don't always know how to do this!! A polite it's too long to go into on the list, but you can read more about this here with a link is much more helpful. -Lisi At 04:22 PM 11/6/02 +0100, Snijders, Mark wrote: why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date Ok, going out on a limb here... have you tried something like select e.id, title, location, address, contact, category, event_time, urllink, descript, min(event_date) from eventTable e inner join dateTable d on e.id = d.id group by e.id ? Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmer Come visit us at http://www.phparch.com! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] oci function
Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do this. I installed oracle 9i on SUSE linux 8.0. Best Regards Maizar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
