On Oct 6, 2008, at 12:00 AM, Hemant Patel wrote:
Hi...ALL...
With Regads,
Hemant Patel
Namaste Hemant :-)
(I as in Uttar Kashi for 7 years.)
I am sure you all are quite aware of this, but in India 16,000,000 is
written 160,00,000.
-Govinda
--
PHP General Mailing List (http://www.php.net/
Hi...ALL...
With Regads,
Hemant Patel
At 6:24 AM +0800 12/3/07, Crayon Shin Chan wrote:
It was also helped by the fact that the OP, who is
apparently, renowned for programming in rocks since the time before
binary was invented, ought to know list etiquette better than most.
That's "world renowned", if you please. :-)
But just to
On Sunday 02 December 2007, Daniel Brown wrote:
> There are a great deal of highly-intelligent people on this list, so why
> not take advantage of that resource?
I do, that's why I'm on the list.
> So until you've been around enough to truly earn your right to
> tell someone far more accomp
On Saturday 01 December 2007, chris smith wrote:
> Considering the rest of the off-topic questions that regularly get
> asked on this list it's a bit much to single out this one particular
> post.
I didn't single it out, it just happened to be at the top of the pile at
the the time. It was also h
On Nov 30, 2007 11:53 PM, Crayon Shin Chan
<[EMAIL PROTECTED]> wrote:
> You ought to know by now that there is the php-db list. Even so your
> question doesn't belong even there because it has zilch to do with php,
> but it is still slightly more appropriate to post there than here.
Put on you
On Nov 30, 2007 10:00 PM, tedd <[EMAIL PROTECTED]> wrote:
> At 2:00 PM +1100 11/30/07, Chris wrote:
> >>Out of curiosity, what SQL server (and version) are you using? I
> >>currently have MySQL 5.0.33 on my dev box and I had no problem with the
> >>query I gave you. Perhaps it's a version issue. Th
At 11:07 PM -0600 11/30/07, Jay Blanchard wrote:
The Oracle of PHP - 6 Degrees of Separation
I joined PHP to Oracle, Kevin Bacon and temperature all in one shot.
Sounds like an omelette. :-)
Tedd, what did you want to know about joins?
I think I got it -- at least for the problem that wa
chris smith wrote:
> On Dec 1, 2007 3:53 PM, Crayon Shin Chan <[EMAIL PROTECTED]> wrote:
>> On Saturday 01 December 2007, tedd wrote:
>>> At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote:
On Friday 30 November 2007, tedd wrote:
> I'm trying to understand joins,
Ask on a database re
Jay Blanchard wrote:
> [snip]
> If you try you can probably make a connection from php to everything
> under
> the sun, doesn't mean everything under the sun is an appropriate topic
> for this list.
> [/snip]
>
> The Oracle of PHP - 6 Degrees of Separation
>
> I joined PHP to Oracle, Kevin Bac
Crayon Shin Chan wrote:
> On Friday 30 November 2007, Jochem Maas wrote:
>
...
>
> So let me get this straight, only paid up members of the old boys club are
> allowed to make off-topic posts? The rest can lump it?
if by the rest you mean you, then yes, absolutely, please crawl back under the
On Dec 1, 2007 3:53 PM, Crayon Shin Chan <[EMAIL PROTECTED]> wrote:
> On Saturday 01 December 2007, tedd wrote:
> > At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote:
> > >On Friday 30 November 2007, tedd wrote:
> > >> I'm trying to understand joins,
> > >
> > >Ask on a database related list.
>
>
> -Original Message-
> From: tedd [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 01, 2007 2:09 AM
> To: Crayon Shin Chan; php-general@lists.php.net
> Subject: Re: [PHP] Join question
>
> At 12:53 PM +0800 12/1/07, Crayon Shin Chan wrote:
> >On Saturday 0
At 12:53 PM +0800 12/1/07, Crayon Shin Chan wrote:
On Saturday 01 December 2007, tedd wrote:
At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote:
>On Friday 30 November 2007, tedd wrote:
>> I'm trying to understand joins,
>
>Ask on a database related list.
Really?
Really.
No langua
[snip]
If you try you can probably make a connection from php to everything
under
the sun, doesn't mean everything under the sun is an appropriate topic
for this list.
[/snip]
The Oracle of PHP - 6 Degrees of Separation
I joined PHP to Oracle, Kevin Bacon and temperature all in one shot.
Ted
On Friday 30 November 2007, Jochem Maas wrote:
> my guess it took less time to search for 'Crayon' in his mail archive
> than it took you to write the sentence.
Is not so much the actual time taken but rather that he had the free time
at all.
> aparently Rob wasn't saying this ... but I would,
On Friday 30 November 2007, Robert Cummings wrote:
> I'm sorry, allow me to rephrase... in the past 5 months you've made 2
> on-topic useful posts, with the rest either being on-topic for an
> off-topic thread, or completely off-topic. I see no point in saying
> more, I've made my point.
I know y
On Saturday 01 December 2007, tedd wrote:
> At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote:
> >On Friday 30 November 2007, tedd wrote:
> >> I'm trying to understand joins,
> >
> >Ask on a database related list.
> Really?
Really.
> No language lives in a vacuum, mate. Especially, a web langu
At 10:21 AM +0800 11/30/07, Crayon Shin Chan wrote:
On Friday 30 November 2007, tedd wrote:
I'm trying to understand joins,
Ask on a database related list.
--
Crayon
Really?
No language lives in a vacuum, mate. Especially, a web language.
IMO, one of the major attributes that make PHP tr
At 9:52 AM -0500 11/30/07, Daniel Brown wrote:
On Nov 29, 2007 11:17 PM, Robert Cummings <[EMAIL PROTECTED]> wrote:
Rob,
The version difference is probably right on the nose. If I
remember correctly, you couldn't do that in the long-popular 3.23,
which *gasp!* is still used by some web
At 2:00 PM +1100 11/30/07, Chris wrote:
Out of curiosity, what SQL server (and version) are you using? I
currently have MySQL 5.0.33 on my dev box and I had no problem with the
query I gave you. Perhaps it's a version issue. There really shouldn't
be a problem updating a table that also occurs in
That it is, Steve. That it is.
And because of the occasion, I feel justified in celebrating by top-posting.
TFGIF!
On Nov 30, 2007 12:58 PM, Steve Edberg <[EMAIL PROTECTED]> wrote:
> At 10:30 AM -0500 11/30/07, Daniel Brown wrote:
> >On Nov 30, 2007 10:22 AM, Jochem Maas <[EMAIL PRO
At 10:30 AM -0500 11/30/07, Daniel Brown wrote:
On Nov 30, 2007 10:22 AM, Jochem Maas <[EMAIL PROTECTED]> wrote:
Daniel Brown wrote:
> I was tempted to flame Tedd just because he's Tedd. ;-P
lol. but then the guy was programming Rocks(tm) way before I was
born, that has to count for so
Daniel Brown wrote:
> On Nov 30, 2007 10:22 AM, Jochem Maas <[EMAIL PROTECTED]> wrote:
>> Daniel Brown wrote:
>>> I was tempted to flame Tedd just because he's Tedd. ;-P
>> lol. but then the guy was programming Rocks(tm) way before I was
>> born, that has to count for something :-)
>
>
>
On Nov 30, 2007 10:22 AM, Jochem Maas <[EMAIL PROTECTED]> wrote:
> Daniel Brown wrote:
> > I was tempted to flame Tedd just because he's Tedd. ;-P
>
> lol. but then the guy was programming Rocks(tm) way before I was
> born, that has to count for something :-)
Please keep all replies on t
tedd <[EMAIL PROTECTED]> wrote:
> Hi gang:
>
> I found why the JOIN didn't work for me in this instance, which was I
> needed to create a third table and JOIN what I needed in that table
> from the other two.
>
> My problem was that I was trying to alter one of the tables in the
> JOIN.
On Nov 29, 2007 11:17 PM, Robert Cummings <[EMAIL PROTECTED]> wrote:
> On Fri, 2007-11-30 at 14:00 +1100, Chris wrote:
> > > Out of curiosity, what SQL server (and version) are you using? I
> > > currently have MySQL 5.0.33 on my dev box and I had no problem with the
> > > query I gave you. Perhaps
On Nov 30, 2007 8:08 AM, Jochem Maas <[EMAIL PROTECTED]> wrote:
> Crayon Shin Chan wrote:
> > On Friday 30 November 2007, Robert Cummings wrote:
> >
> >> That's an amusing statement. I took a peek back in time and noticed
> >> that in the past 5 months you've only made two on-topic useful posts to
Crayon Shin Chan wrote:
> On Friday 30 November 2007, Robert Cummings wrote:
>
>> That's an amusing statement. I took a peek back in time and noticed
>> that in the past 5 months you've only made two on-topic useful posts to
>> the PHP General list-- and they were both for the same thread.
>
> If
On Fri, 2007-11-30 at 13:49 +0800, Crayon Shin Chan wrote:
> On Friday 30 November 2007, Robert Cummings wrote:
> > > Or are you saying that one needs to make a lot of on-topic posts to
> > > build up credit in order to be able to make off-topic posts?
> >
> > No, I'm merely pointing out the hypocr
On Friday 30 November 2007, Robert Cummings wrote:
> > Or are you saying that one needs to make a lot of on-topic posts to
> > build up credit in order to be able to make off-topic posts?
>
> No, I'm merely pointing out the hypocrisy.
That would only be true if I had been making off-topic posts. B
On Fri, 2007-11-30 at 14:00 +1100, Chris wrote:
> > Out of curiosity, what SQL server (and version) are you using? I
> > currently have MySQL 5.0.33 on my dev box and I had no problem with the
> > query I gave you. Perhaps it's a version issue. There really shouldn't
> > be a problem updating a tab
On Fri, 2007-11-30 at 11:00 +0800, Crayon Shin Chan wrote:
> On Friday 30 November 2007, Robert Cummings wrote:
>
> > That's an amusing statement. I took a peek back in time and noticed
> > that in the past 5 months you've only made two on-topic useful posts to
> > the PHP General list-- and they
Out of curiosity, what SQL server (and version) are you using? I
currently have MySQL 5.0.33 on my dev box and I had no problem with the
query I gave you. Perhaps it's a version issue. There really shouldn't
be a problem updating a table that also occurs in the select query since
the select quer
On Friday 30 November 2007, Robert Cummings wrote:
> That's an amusing statement. I took a peek back in time and noticed
> that in the past 5 months you've only made two on-topic useful posts to
> the PHP General list-- and they were both for the same thread.
If you have that much free time on yo
On Fri, 2007-11-30 at 10:21 +0800, Crayon Shin Chan wrote:
> On Friday 30 November 2007, tedd wrote:
> > I'm trying to understand joins,
>
> Ask on a database related list.
That's an amusing statement. I took a peek back in time and noticed that
in the past 5 months you've only made two on-topic
On Friday 30 November 2007, tedd wrote:
> I'm trying to understand joins,
Ask on a database related list.
--
Crayon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thu, 2007-11-29 at 18:43 -0500, tedd wrote:
> Hi gang:
>
> I found why the JOIN didn't work for me in this instance, which was I
> needed to create a third table and JOIN what I needed in that table
> from the other two.
>
> My problem was that I was trying to alter one of the tables in the
Hi gang:
I found why the JOIN didn't work for me in this instance, which was I
needed to create a third table and JOIN what I needed in that table
from the other two.
My problem was that I was trying to alter one of the tables in the
JOIN. While that might be possible it didn't appear so in
At 4:11 PM -0500 11/29/07, Robert Cummings wrote:
Grep? Loop? A single query will suffice. Also, he doesn't mention
wanting to clobber the passwords in table1 when the username does
already exist.
Cheers,
Rob.
Table1 passwords and logins are not populated. I want to take those
appearing in Ta
On Thu, 2007-11-29 at 15:47 -0500, Wolf wrote:
> tedd <[EMAIL PROTECTED]> wrote:
> > Hi gang:
> >
> > I'm trying to understand joins,
> >
> > Here's the situation. I have two tables (user1, user2) in one database:
> >
> > The common field between the two tables is "username". I want to tak
On Nov 29, 2007 3:41 PM, tedd <[EMAIL PROTECTED]> wrote:
> Hi gang:
Hi, Tedd.
> PS: Side note -- will safe_mode ON cause problems with this?
Negative. I can't see any reason to even think so. All safe_mode
does is check the UID/GID of the script to make sure it matches that
of the targ
On Thu, 2007-11-29 at 15:41 -0500, tedd wrote:
> Hi gang:
>
> I'm trying to understand joins,
>
> Here's the situation. I have two tables (user1, user2) in one database:
>
> The common field between the two tables is "username". I want to take
> fields "login" and "password" from user2 and popu
tedd <[EMAIL PROTECTED]> wrote:
> Hi gang:
>
> I'm trying to understand joins,
>
> Here's the situation. I have two tables (user1, user2) in one database:
>
> The common field between the two tables is "username". I want to take
> fields "login" and "password" from user2 and populate the
Hi gang:
I'm trying to understand joins,
Here's the situation. I have two tables (user1, user2) in one database:
The common field between the two tables is "username". I want to take
fields "login" and "password" from user2 and populate the same fields
in user1.
Currently, the table user1 h
At 1:22 PM + 11/8/06, Kris Leech wrote:
I have an SQL query which has a simple join, this works and is fine
the fields from the secondary table are added to the returned array.
But what happens if I add another JOIN to a table which has fields
which are the same name? Is there any way to ha
clive wrote:
1. This is a SQL question and not a php one.
2. select a.name as aname, b.name as bname, c.name as cname where
a.id=b.id and a.id=c.id from a,b,c
oops beer gone to my head, the from should come before the where as most
of you I'm sure know.
--
PHP General Mailing List (http://
Kris Leech wrote:
I have an SQL query which has a simple join, this works and is fine the
fields from the secondary table are added to the returned array. But
what happens if I add another JOIN to a table which has fields which are
the same name? Is there any way to have PHP prefix the key's
(
I have an SQL query which has a simple join, this works and is fine the
fields from the secondary table are added to the returned array. But what
happens if I add another JOIN to a table which has fields which are the
same name? Is there any way to have PHP prefix the key's (fieldnames) of
the
I have an SQL query which has a simple join, this works and is fine the
fields from the secondary table are added to the returned array. But
what happens if I add another JOIN to a table which has fields which are
the same name? Is there any way to have PHP prefix the key's
(fieldnames) of the
Several methods are supported by mysql, here is the one I like,
select * from table1 a, table2 b where a.col1 = b.col1
In this case the a and b are "aliases" of table1 and table2 respectively
and the notation a.col1 and b.col1 refers to column "col1" in table1 and
table2 respectively. You can
Kevin Murphy wrote:
This is probably basic, but I can't seem to find the answer. Is there a
way to specify in a join a specific column when the two tables have
columns with the same name?
Something like:
$row['table1.id'] vs $row['table2.id']
yes. http://dev.mysql.com/doc/ is a good plac
This is probably basic, but I can't seem to find the answer. Is there
a way to specify in a join a specific column when the two tables have
columns with the same name?
Something like:
$row['table1.id'] vs $row['table2.id']
--
Kevin Murphy
Webmaster: Information and Marketing Services
Wester
On Thu, 2004-11-11 at 11:03 +0600, Hasin Hayder wrote:
> Hi all,
> We starts a great user forum for PHP users. We gurantee the urgent
> solution of your problem regarding PHP, MySQL and It's extensions.
> Visit our group and be a proud member of our group
>
> visit: http://groups.yahoo.com/group/p
On Thursday 11 November 2004 05:03, Hasin Hayder wrote:
> We starts a great user forum for PHP users. We gurantee the urgent
> solution of your problem regarding PHP, MySQL and It's extensions.
> Visit our group and be a proud member of our group
>
> visit: http://groups.yahoo.com/group/phpexperts
Hi all,
We starts a great user forum for PHP users. We gurantee the urgent
solution of your problem regarding PHP, MySQL and It's extensions.
Visit our group and be a proud member of our group
visit: http://groups.yahoo.com/group/phpexperts
Thank you all
--Evelin
--
PHP General Mailing List (h
--
Philip J. Newman.
Head Developer
[EMAIL PROTECTED]
+64 (9) 576 9491
+64 021-048-3999
--
Friends are like stars
You can't allways see them,
but they are always there.
--
Websites:
PhilipNZ.com - Design.
http://www.philipnz.com/
[EMAIL PROTECTED]
Philip's Domain // Internet Proje
Hello:
My name is Charles Cedeno. I am now focusing in one online
opportunity.I have tried several of these opportunities full of hype
promising us thousands of dollars every month. I would get all excited and
run to my family and friends with another "Great Money Maker ". It is a
sad fac
>
> > > -Original Message-----
> > > From: lallous [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, October 07, 2002 6:09 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP] join() , can do that fast?
> > >
> > > Hello,
> > >
Thanks John,
sorry I didn't see the new join()'s parameters you provided, I only noticed
the new '%s' .
Elias,
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Lallous wrote:
> John, what you said would simply produce:
>var x = ['str1,str2,str3']
> and not as I want:
> var x = ['str1','str2','str3']
Elias,
did you actually tried that? Because it does produce what you want...
produces:
x=['str1','str2','str3']
Grtz Erwin
--
PHP General Mai
:002101c26de2$982bf7d0$7c02a8c0@coconut...
>
>
> > -Original Message-
> > From: lallous [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 07, 2002 6:09 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] join() , can do that fast?
> >
> >
> -Original Message-
> From: lallous [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 07, 2002 6:09 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] join() , can do that fast?
>
> Hello,
>
>
> I have:
> $x = array('str1','str2',
Hello,
I have:
$x = array('str1','str2','str3');
I want to convert that array to a valid javascript syntax as:
var x = ['str1','str2','str3']
I can do this in PHP:
echo sprintf("x=[%s]", join(',', $x));
but that would produce:
x = [str1, str2, str3]
is there is a fast way (other than doing
Hello
I'm using PHP4 and MySQL on Apache webserver.
I have a table valled "liste" with names of some people, and a table
called "postnummer" with zip-codes and citynames.
My select should join the adress and zip from one table with the
cityname from the other table.
But my join-line does not wor
mysql causeing the errors
>
> $result = mysql_query($query) or die(mysql_error());
> - Original Message -
> From: "Henning" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 18, 2002 5:12 PM
> Subject: [PHP] Join - problem
>
Don't include the ; in your query, for one thing.
---John Holmes...
- Original Message -
From: "John Wards" <[EMAIL PROTECTED]>
To: "Henning" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 11:26 AM
Subject:
ember 18, 2002 5:12 PM
Subject: [PHP] Join - problem
> Hello
> I'm using PHP4 and MySQL on Apache webserver.
> I have a table valled "liste" with names of some people, and a table
> called "postnummer" with zip-codes and citynames.
> My select should join the ad
Hello
I'm using PHP4 and MySQL on Apache webserver.
I have a table valled "liste" with names of some people, and a table
called "postnummer" with zip-codes and citynames.
My select should join the adress and zip from one table with the
cityname from the other table.
But my join-line does not work.
Hi all. Never mind my previous post. I fixed my SQL statements by using
"AS" statements.
For example:
SELECT calendar.ID AS calendar_ID,calendar.Calendar_Title AS
Calendar_Title,calendar.Add_To_Scroller AS calendar_Add_To_Scroller...
That worked like I wanted it to.
Thanks!
mto
--
Mich
You need to either alias the columns i.e. career.id as careerid or rename your columns
i.e. change the id to careerid & calendarid. The second option would be best because
that way your columns are descriptive.
HTH
Clint
-- Original Message --
From: Mich
Hi,
I'm having a little trouble with this join statement I'm working on. What I
*think* is happening is that PHP is getting confused with the "ID" field
that is the same for the three different tables. When I go through the
result set, you can see that the field "ID" gets used a couple of times
On Sun, 9 Sep 2001 13:34, Dana Holt wrote:
> I have a query that uses a LEFT JOIN, but the two tables have some
> columns with the same name. How can I tell the columns from each table
> apart? It seems that the "joined" table overwrites the values from the
> other table.
>
> Anyone know?
>
> Tha
On 09-Sep-2001 Dana Holt wrote:
>
> I have a query that uses a LEFT JOIN, but the two tables have some columns
> with the same name. How can I tell the columns from each table apart? It
> seems that the "joined" table overwrites the values from the other table.
>
If the column is part of the j
I have a query that uses a LEFT JOIN, but the two tables have some columns
with the same name. How can I tell the columns from each table apart? It
seems that the "joined" table overwrites the values from the other table.
Anyone know?
Thanks.
--
Dana Holt / [EMAIL PROTECTED]
--
PHP Genera
Sorry everone but I 'm having a hard time with joins
How do I add this clause:
users.uid = selection.user_uid from table selection
to this query:
$sql = "SELECT users.uid, users.username
FROM users LEFT JOIN picks
ON users.uid = picks.user_id
WHERE picks.user_id IS NULL
Thank You.
--
On 25 Feb 2001 00:20:37 -0800, Keith Spiller <[EMAIL PROTECTED]> wrote:
> Line 284$result =3D mysql_query("SELECT q.questid, q.question, =
Try changing this to something like
$result = mysql_query("SELECT ...") or die(mysql_error());
and seeing what error is being returned by MySQL.
In article <030601c09f05$2b9e6e70$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Keith Spiller") wrote:
> Can anyone tell me why this:
> Line 282mysql select db("centraldb",$db);
> Line 283$qorder++;
> Line 284$result = mysql query("SELECT q.questid, q.question, q.answer,
> q.qord
Can anyone tell me why this:
Line 282mysql_select_db("centraldb",$db);
Line 283$qorder++;
Line 284$result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder,
q.depart, q.catid,
q.active, q.global, q.adate, q.author, q.authoremail, q.askemail,
c.
79 matches
Mail list logo
