Hi,
I'm having a problem with my Select statement. This is what i'm doing:
$connection = @mysql_connect("l", "c", "c") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select
database.");
$sql =" SELECT *
FROM table_1
";
$result = @
Hello !
I have a php program running under linux that conects into a Sql server 7
under win2k.
When I make a select in a table that doesn't contain any index, my select
returns no results. Otherwise, when the table contains at least one index,
the select works fine.
My question: Is that supposed
Hi all,
I want to select some records with e.g. ID's 1,3,7 and 8
How can this be done best?
is it: SELECT * FROM myTable WHERE ID=1,3,7,8 ??
thx. Wilbert
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
[EMAIL PROTE
Hi,
How can I check how many options has been selected from a select list? I
tried in many ways, but it returns the last option selected.
DragosB
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
I'm having somewhat of a problem :(
I have my banks of checkboxes, all named 'mycheckbox[]' with the values as
different IDs. The user happily checks a few of them and my scripts happily
process the resulting arrays.
But... how do I get Javascript to do a 'select all' on them?? I cant a
Hi,
Can you have a SELECT statement (using mysql) that goes something like
$sql="SELECT id && email FROM table WHERE user='$user' and pass='$pass'";
and if you can't is there a away around this?
Thanks
Peter
Hi all,
I'm in trouble checking client's value passed via a web form ...
In a web form I usally use for the input's name a array var like this:
Select your country
---
United State
United Kingdom
and to generally check if some value is missing I use a simple routine
like th
Hi people
question about query when I use this:
"select result, count(result) as choice group by result order by choice desc;"
How do I print "choice" in my page when the query return value back to me?
any help is appreciated
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than rea
Hi people
question about query when I use this:
"select result, count(result) as choice group by result order by choice desc;"
How do I print value stored under "choice" in my page when the query return value back
to me?
any help is appreciated
cheers
Jack
[EMAIL PROTECTED]
"There is nothing mor
Greets:
I have a bit of php code that looks for a matching user/pass in a mysql
table. There are three user/pass phrases in the table along with a an email
that corresponds to each user/pass pair. Is there any way to construct a
query that will do both the matching of the user/passes and also th
How would I word a query to see what tables exist in a db that begin with
box
for example include
boxTABLE1
boxTABLE2
boxTABLE3
but exclude
sphereTABLE1
I'm basically trying lo populate a list box with the tables beginning with
box in PHP.
Matt "Trollboy" Wiseman
www.shoggoth.net/trollboy/troll
www.enta.net
Tel 01952 428969 Mob 07968 524175
PGP Key available, send blank email to [EMAIL PROTECTED]
-Original Message-
From: Jeremy Morano [mailto:[EMAIL PROTECTED]]
Sent: 14 August 2001 15:53
To: [EMAIL PROTECTED]
Subject: [PHP] Select
Hi,
I'm having a problem with my Select stat
Jeremy Morano wrote:
>
> ...
>
> $data=mysql_fetch_row($result);
> $count=$data[0];
>
> echo $count;
>
> Yet the only result I get is the first value of the first
> column.
>
Of course, and $data[1] is the first value of second column, etc.
If you want to get all result, use w
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07968 524175
PGP Key available, send blank email to [EMAIL PROTECTED]
-Original Message-
From: Jeremy Morano [mailto:[EMAIL PROTECTED]]
Sent: 14 August 2001 15:53
To: [EMAIL PROTECTED]
Subject: [PHP] Select
Hi
so you don't have to hardcode the columns. It's up to you.
Johan Alfredeen
pongworld.com
-Original Message-
From: Jeremy Morano [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 8:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Select
Hi,
I'm having a problem with my Selec
I have mysql in redhat linux and apache 1.3.20 with module php 4.0.6
but I have error in my select, connect to the database is ok. In apache and
mysql uder windows
working this script OK but no in linux.
What's wrong ?
@$spojenie = mysql_connect("localhost","user","password");
if (!$spojenie)
Hello all,
I have a designing a website of which people can submit news to, this works
fine. Just on the main page I have the following code (snippet);
\n";
do {
printf("Title: %s By: %s |
Date: %s Article: %s URL: Click here\n", $myrow["title"],
$myrow["nickname"],$myrow["created"],$my
Hi! I'm storing a date in this format :
2002-01-13 11:08:40
-mm-dd hh:mm:ss
This is great because it gives me the date and the time, which I need.
I want to compare this date from the database to the current DAYOFYEAR()
but when I do this
select DAYOFYEAR('2002-01-13 11:08:40')
I get this
Hi all!
Just wondering, If I have a query like:
$query = "SELECT name FROM users";
$ret = mysql_query($query);
while(list($name) = mysql_fetch_row($ret)) or die("Error: ".mysql_error());
print ("your name is $name);
$query_update ["name"] = ("UPDATE my_other_table set name = $name");
$result =
Hy,
I try to do a SELECT but when I test my code I
Have a parse error.
If someone can explain to me why.
Code:
$db = mysql_connect(newsmanga_db);$req =
"SELECT * FROM dvds WHERE nomdvd='".$nom."".$i"' "; /// PARSE ERROR IN
THIS LINE$res=mysql_query($req, $db);while ($ligne = mysql_fetc
Nothing to do with PHP...
SELECT * FROM myTable WHERE ID IN (1,3,7,9);
If you're using MySQL, read the manual:
http://www.mysql.com/documentation/mysql/bychapter/
---John Holmes...
> -Original Message-
> From: Wilbert Enserink [mailto:[EMAIL PROTECTED]]
> Sent: Thursday
On Thursday 16 May 2002 19:19, Wilbert Enserink wrote:
> Hi all,
>
>
> I want to select some records with e.g. ID's 1,3,7 and 8
> How can this be done best?
>
> is it: SELECT * FROM myTable WHERE ID=1,3,7,8 ??
Is this a PHP question?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
O
Hi,
On Wed, 5 Jun 2002, DragosB wrote:
> How can I check how many options has been selected from a select list? I
> tried in many ways, but it returns the last option selected.
Let's say your select box code is similar to this:
...
in PHP form,
Shane,
is this meant for initial settings of the form only or as a button, or some
such, to allow someone to select all the boxs?
chuck
- Original Message -
From: "Shane Wright" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 17, 2001 6:54 PM
I know *exactly* what you mean, the solution (took me at least an hour) is attached.
have fun,
bvr.
On Mon, 17 Dec 2001 17:54:42 +, Shane Wright wrote:
>Hi
>
>I'm having somewhat of a problem :(
>
>I have my banks of checkboxes, all named 'mycheckbox[]' with the values as
>different IDs.
right" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, December 17, 2001 6:54 PM
> Subject: [PHP] 'Select All'
>
> > Hi
> >
> > I'm having somewhat of a problem :(
> >
> > I have my banks of checkboxes, all n
Oh, one more thing.. The latest MSIE suddenly doesn't seem to support the function to
be named 'selection' . change that and it'll work ;)
bvr.
>
>
>I know *exactly* what you mean, the solution (took me at least an hour) is attached.
>
>have fun,
>bvr.
>
--
PHP General Mailing List (http:
right [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 4:55 AM
To: [EMAIL PROTECTED]
Subject: [PHP] 'Select All'
Hi
I'm having somewhat of a problem :(
I have my banks of checkboxes, all named 'mycheckbox[]' with the values as
different IDs. The user happi
"];
> len = ele.length;
> for (i = 0; i < len; i++)
> ele[i].checked = type;
> }
>
>
>
>
>
>
>
>
>
>
> Martin
>
>
> -Original Message-
> From: Shane Wright [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, De
Assuming you want to select both id and email from table, use commas :
SELECT id,email FROM ...
Also, check out this basic SQL tutorial :
http://www.sqlcourse.com/
It's fairly useful.
regards,
Philip
On Tue, 13 Feb 2001, Peter Houchin wrote:
> Hi,
>
> Can you have a SELECT stateme
On Tue, 13 Feb 2001 16:00, Peter Houchin wrote:
> > Hi,
>
> Can you have a SELECT statement (using mysql) that goes something like
>
> $sql="SELECT id && email FROM table WHERE user='$user' and
> pass='$pass'";
>
> and if you can't is there a away around this?
>
> Thanks
>
> Peter
In SQL queries
ok I've changed my code to
$sql = "SELECT id, email FROM users WHERE user='$user' and pass='$pass'";
but still no joy can any one suggest why?
(& Yes email is a field in the table)
Peter
> Hi,
>
> Can you have a SELECT statement (using mysql) that goes something like
>
> $sql="SELECT
A possible way to find out :
$result = mysql_query($sql) or die(mysql_error());
Does it say anything? mysql_error() is your friend, it can be printed
anywhere within the script and will print the last mysql error. So
perhaps :
print mysql_error();
Right before the query or ...
Regar
On Tue, 13 Feb 2001 16:20, Peter Houchin wrote:
> ok I've changed my code to
>
> $sql = "SELECT id, email FROM users WHERE user='$user' and
> pass='$pass'"; but still no joy can any one suggest why?
>
> (& Yes email is a field in the table)
>
> Peter
>
> > Hi,
> >
> > Can you have a SELECT stateme
: Peter Houchin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 2:30 PM
To: PHP MAIL GROUP
Subject: [PHP] SELECT statement
Hi,
Can you have a SELECT statement (using mysql) that goes something like
$sql="SELECT id && email FROM table WHERE user='$user' and pass=
-Original Message-
From: Peter Houchin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 2:51 PM
To: PHP MAIL GROUP
Subject: RE: [PHP] SELECT statement
ok I've changed my code to
$sql = "SELECT id, email FROM users WHERE user='$user' and pass='$pass
ebmaster
");
// if successful then do this
if ($num == 1) {
include "quote2.php"; //has a hidden field referencing the user & the email
address .. user shows up but again email does not
}
?>
-Original Message-
From: Philip Olson [mailto:[EMAIL PROTEC
L PROTECTED]\">webmaster
>
> ");
> // if successful then do this
> if ($num == 1) {
>
>
>
> include "quote2.php"; //has a hidden field referencing the user & the email
> address .. user shows up but again email does not
> }
>
&g
Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-Original Message-
From: Netbrain di M.L. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 03, 2001 10:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP] select prob.
Hi all,
I'm in trouble checking client&
On Saturday 03 February 2001 17:23, PHPBeginner.com wrote:
> then, why don't you instead have it NULL, like:
>
>
> Select your country
> ---
if no "value" is specified, the text in the field is taken as
value, i.e. $form['country'] == "Select your country" etc
--
Christian
x
On Sun, 4 Feb 2001, PHPBeginner.com wrote:
> then, why don't you instead have it NULL, like:
>
>
> Select your country
> ---
> United State
> United Kingdom
>
>
>
> then if it's empty it will be skipped ... I think ... I've never done so ...
>
> Ciao allo zio e la
nner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-Original Message-
From: Netbrain di M.L. [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 04, 2001 3:34 AM
To: PHPBeginner.com
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] select prob.
x
On Sun, 4 Feb 2001, PHPBeginner.com
EMAIL PROTECTED]
> www.phpbeginner.com
>
>
>
>
> -Original Message-
> From: Netbrain di M.L. [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 04, 2001 3:34 AM
> To: PHPBeginner.com
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP] select prob.
>
no prob,
--max
-Original Message-
From: Netbrain di M.L. [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 04, 2001 3:44 AM
To: PHPBeginner.com
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] select prob.
Yes, it seems a good solution :)
thanks again
max
---
Please Help
I have a list of conditions I want to test against.
In ASP, I would do:
Select Case foo
case "bar1"
foobar = "fooey"
case "bar2"
foobar = "fooey2"
case "bar3"
foobar = "fooey3"
case else
foobar = "NoBar"
End Select
How do I do the equivelent in PHP?
I have an array of id numbers ($catids). I would like to select from the
mysql database all records where cid is in that array.
This syntax fails:
select * from categories
where cid in $catids
What is the correct way to do this? It can be done outside of a loop, can't
it?
c
--
PHP General Mai
In MySQL you can do this:
$sql = "SHOW TABLES LIKE 'box%'";
$r = mysql_query($sql);
// then loop through the tables and populate
--Joe
On Tue, Apr 17, 2001 at 07:49:11PM -0400, Matt TrollBoy Wiseman wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
>
On 17-Apr-01 Matt \"TrollBoy\" Wiseman wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
> for example include
> boxTABLE1
> boxTABLE2
> boxTABLE3
> but exclude
> sphereTABLE1
>
> I'm basically trying lo populate a list box with the tables beginning with
"Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]> wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
> for example include
> boxTABLE1
> boxTABLE2
> boxTABLE3
> but exclude
> sphereTABLE1
>
> I'm basically trying lo populate a list box with the tables beginning
;Php-General" <[EMAIL PROTECTED]>
Sent: 2001. augusztus 15. 11:28
Subject: [PHP] select problem
> I have mysql in redhat linux and apache 1.3.20 with module php 4.0.6
> but I have error in my select, connect to the database is ok. In apache and
> mysql uder windows
> working th
ECTED]>
Sent: Wednesday, August 29, 2001 10:55 AM
Subject: [PHP] SELECT * FROM
> Hello all,
> I have a designing a website of which people can submit news to, this
works
> fine. Just on the main page I have the following code (snippet);
>
> $db = mysql_connect("localhost&quo
o: '[EMAIL PROTECTED]'
Subject: [PHP] SELECT * FROM
Hello all,
I have a designing a website of which people can submit news to, this works
fine. Just on the main page I have the following code (snippet);
Any help would be gratefully apreciated!
Kind Regards
Tarrant Costelloe (
Hi,
I' m trying to execute a "select distinct" command on a table and I get the
following error:
ERROR 1022: Can't write, duplicate key in table 'pmall'
My table is about 2,7 MBytes.
Does anybody knows what's wrong?
I use MySQL 3.23.40 on a Solaris 7 (intel) machine.
Sofoklis
--
PHP General M
This doesn't appear to be a PHP question. Are you sure you are on the
right list?
On Sun, 13 Jan 2002, sundogcurt wrote:
> Hi! I'm storing a date in this format :
>
> 2002-01-13 11:08:40
> -mm-dd hh:mm:ss
>
> This is great because it gives me the date and the time, which I need.
> I want to
I am a dork!
And you answered that almost before I sent it, you're like Mighty Mouse
on Ginseng!
[EMAIL PROTECTED] wrote:
>This doesn't appear to be a PHP question. Are you sure you are on the
>right list?
>
>On Sun, 13 Jan 2002, sundogcurt wrote:
>
>>Hi! I'm storing a date in this format :
>>
You need to put {} in the while function like this
while {
do this
}
$query = "SELECT name FROM users";
$ret = mysql_query($query);
while(list($name) = mysql_fetch_row($ret)) or die("Error: ".mysql_error()) {
print ("your name is $name);
$query_update["name"] = ("UPDATE my_other_table set
At 02:23 PM 4/8/2002 +0200, you wrote:
>Hy,
>
>I try to do a SELECT but when I test my code I Have a parse error.
>If someone can explain to me why.
>
>Code:
>
>$db = mysql_connect(newsmanga_db);
>$req = "SELECT * FROM dvds WHERE nomdvd='".$nom."".$i"' "; /// PARSE
>ERROR IN THIS LINE
Your miss
Hi
the error appears because of the comas erroned syntaxis.
why don't u try something easire as that :
$varalacon = $nom."".$i; (i don't know if there is a space or not...in
bold)
$req = "SELECT * FROM dvds WHERE nomdvd='$varalacon' ";
Hope it helps
SR
Jérome Moisy a écrit :
> Hy, I try to d
On Mon, 8 Apr 2002, [iso-8859-1] Jérome Moisy wrote:
> Hy,
>
> I try to do a SELECT but when I test my code I Have a parse error.
> If someone can explain to me why.
>
> Code:
>
> $db = mysql_connect(newsmanga_db);
> $req = "SELECT * FROM dvds WHERE nomdvd='".$nom."".$i"' "; /// PARSE ERROR IN T
At 08.04.2002 14:23, you wrote:
>Hy,
>
>I try to do a SELECT but when I test my code I Have a parse error.
>If someone can explain to me why.
>
>Code:
>
>$db = mysql_connect(newsmanga_db);
>$req = "SELECT * FROM dvds WHERE nomdvd='".$nom."".$i"' "; /// PARSE
>ERROR IN THIS LINE
Try this :
$req
Thanks at All
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi everybody!
I'm new in the list.
I'll help anybody if I can =)
by now I have a little trouble ;-)
I have to create a php page where users can upload many files
the idea is that users could select many files by holding down
the shift key... with this I can avoid to put many input tags in my
Hello:
I'm trying to create dinamic color SELECT lists with php. I have my
database set up as follows:
Paint = good
bucket = good
weight = 100kg
Colors = green, blue, red
and here is my php:
while ($row = mysql_fetch_array($sql_result)) {
echo"";
echo $row["paint"];
echo"";
echo $row["bucket"]
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 2:07 PM
Subject: [PHP] Select case equivelent
> I have a list of conditions I want to test against.
> In ASP, I would do:
>
> Select Case foo
> case "bar1"
> foobar = "fooey"
>
See the "switch" statement.
http://www.php.net/manual/en/control-structures.switch.php
Kirk
> -Original Message-
> From: Allen May [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 12:07 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Select case equivel
On Wednesday 04 April 2001 20:07, you wrote:
> I have a list of conditions I want to test against.
> In ASP, I would do:
>
> Select Case foo
> case "bar1"
> foobar = "fooey"
> case "bar2"
> foobar = "fooey2"
> case "bar3"
> foobar = "fooey3"
> case else
>
On 05 Apr 2001 11:53:21 +0200, Christian Reiniger wrote:
switch ($foo) {
case "bar1":
$foobar="fooey";
break;
default:
$foobar = "NoBar";
}
> > I have a list of conditions I want to test against.
> > In ASP, I would do:
> > How do I do the equivelent in PHP?
> Try reading the m
Hi all
Is this the corerct way of selecting the max value in a table?
"select * from score where MAX(scorevalue)"
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
> I have an array of id numbers ($catids).
> This syntax fails:
> select * from categories
> where cid in $catids
Never mind. I was being stupid. For the record, one needs to implode(",",
$catids) and then use that in the WHERE statement, i.e. "where cid in
($catids)"
c
--
PHP General Mailin
Hi fitiux
I'm sure the list will correct me if I'm wrong, but what you're talking about
isnt possible, at least not in this way.
This isn't a limitation of PHP - its a limitation of the HTML form element
that handles the uploads.
You could consider a client-side applet to achieve the result a
Hi Shane.. :-)
thankyou for your help..
I was wondering myself about that.. and I surfed the net for many days just searching
for a solution...
but now I know what it is the limitation.. thanks again. =)
I think as you say.. consider a client-side applet.
best regards from Chile
--Patricio
hi i have to select this :
$t2=mysql_db_query($db, "SELECT radacct.UserName,sum(radacct.AcctSessionTime)
as t1,usergroup.GroupName ".
"from radacct LEFT JOIN usergroup ON
radacct.UserName=usergroup.UserName where".
"usergroup.GroupName='unlimited' AND
radacct.AcctStartTime>='200
At 3:24 PM -0700 2/3/01, Gerry wrote:
>Hello:
>
>I'm trying to create dinamic color SELECT lists with php. I have my
>database set up as follows:
>
>Paint = good
>bucket = good
>weight = 100kg
>Colors = green, blue, red
>
>and here is my php:
>
>while ($row = mysql_fetch_array($sql_result)) {
>ech
> while ($row = mysql_fetch_array($sql_result)) {
> echo"";
> echo $row["paint"];
> echo"";
> echo $row["bucket"];
> echo"";
> echo"http://www.\" method=\"POST\">";
> $Color = $row["Color"];
> if ($Color == $Color) {
Here is one problem: You can't use $Color for the current color you are
printi
This worked!
But, I get this color selection increment on each subsequent menu where
the colors from the row above mix with the ones below and so on. Assume
that the numbers are the actual colors:
Select a color:
first menu1 next menu-> 1 next menu-> even longer
ittle time: http://chatmusic.com/volunteer.htm
- Original Message -
From: Gerry <[EMAIL PROTECTED]>
To: Richard Lynch <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 10:23 AM
Subject: Re: [PHP] Select list with PHP
> This worked!
> But, I
Something is not working here:
select * from nmensagem m, nusuario u, nprefuser p where
m.cdpreferencia=p.cdpreferencia and p.flag=1;
With "m.cdpreferencia=p.cdpreferencia" I should get just the values there
exists on m.preferencia and p.cdpreferencia?
thanks,
Augusto
--
PHP General Mailin
SELECT MAX(scorevalue) FROM score
Will display the maximum value of your scorevalue column.
Sincerely,
Craig Vincent
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrator
Hi
try:
select * from score order by scorevalue DESC LIMIT 1
or if your db supports sub selects:
select * from score where scorevalue=(select MAX(scorevalue) from score)
Tom
At 03:38 PM 21/05/01 -0500, Jacky wrote:
>Hi all
>Is this the corerct way of selecting the max value in a table?
>"selec
select max(scorevalue) from score;
- Original Message -
From: "Jacky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 2001. május 21. 22:38
Subject: [PHP] select the max value
Hi all
Is this the corerct way of selecting the max value in a table?
"se
Hello !
I have a php program running under linux that conects into a Sql server 7
under win2k.
When I make a select in a table that doesn't contain any index, my select
returns no results. Otherwise, when the table contains at least one index,
the select works fine.
My question: Is that supposed
I am using sessions on my site and have noticed that people often don't
click the "logout" button -- something which I need them to do in order to
clear their session from the db and update some site stats. In the sessions
table, I have a field $timein (in format F j, Y, g:i a) that gets added whe
Well I messed up... I forgot to add the final ";} at the bottom of my
sample code but here it is. sorry!
Gerry wrote:
>
> This worked!
> But, I get this color selection increment on each subsequent menu where
> the colors from the row above mix with the ones below and so on. Assume
> that the nu
> select * from nmensagem m, nusuario u, nprefuser p where
> m.cdpreferencia=p.cdpreferencia and p.flag=1;
>
> With "m.cdpreferencia=p.cdpreferencia" I should get just the values there
> exists on m.preferencia and p.cdpreferencia?
No, because you have a record for every single nusario, since you
hello,
I'd like to know if there is a more elegant and smoother way to retrieve some array
elements with given keys and put them into an other array.
Yes, I can write a function like the following, but maybe I missed some new PHP
awesome feature or array function which does this job.
So, is the
ECTED]>
To: <[EMAIL PROTECTED]>
cc:
Subject: [PHP] select in PHP + Sql Server
Hello !
I have a php program running under linux that conects into a Sql server 7
under win2k.
When I make a select in a table that doesn't contain any index, my select
returns no results. Otherwise, when
);
echo ($datetime . "" );
echo ($source . "" );
}
[]s
Marcos
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviada em: Thursday, September 13, 2001 6:33 AM
Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Assunto: Re: [PHP] sel
2001 5.47
To: [EMAIL PROTECTED]
Subject: [PHP] select based on time/date
I am using sessions on my site and have noticed that people often don't
click the "logout" button -- something which I need them to do in order
to clear their session from the db and update some site stats. I
heers,
> Maxim Maletsky
> PHPBeginner.com
>
>
>
>
> -Original Message-
> From: Jason Dulberg [mailto:[EMAIL PROTECTED]]
> Sent: martedì 25 settembre 2001 5.47
> To: [EMAIL PROTECTED]
> Subject: [PHP] select based on time/date
>
>
> I am using sessions on my site and
> > Sent: martedì 25 settembre 2001 5.47
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] select based on time/date
> >
> >
> > I am using sessions on my site and have noticed that people often don't
> > click the "logout" button -- something which
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 2:35 PM
Subject: RE: [PHP] select based on time/date
> I had a look at the DATE_FORMAT info on the mysql doc
>
> select * from sessions where $timein + interval 1 hour <= now();
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 2:35 PM
Subject: RE: [PHP] select based on time/date
select * from logged_in where date_add(time_in,interval 1 hour) <= now()
-jack
-Original Message-
From: Jason Dulberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 6:08 PM
To: Sheridan Saint-Michel; [EMAIL PROTECTED]
Subject: RE: [PHP] select based on time/date
I tr
To: 'Jason Dulberg'; 'Sheridan Saint-Michel'; [EMAIL PROTECTED]
> Subject: RE: [PHP] select based on time/date
>
>
> select * from logged_in where date_add(time_in,interval 1 hour) <= now()
>
> -jack
>
> -Original Message-
> From: Jason Du
TECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 5:08 PM
Subject: RE: [PHP] select based on time/date
> I tried basically what you have but I got an error:
>
> $sql="select * from logged_in where time_in + interval 1 hour <= now()";
> $result
f the date types.
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 6:24 PM
Subject: RE
u again for your time. I've learned alot from this.
__
Jason Dulberg
Extreme MTB
http://extreme.nas.net
> -Original Message-
> From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]]
> Sent: September 26, 2001 9:38 AM
> To: Jason Dulberg; [EMAIL PROTECTED]
&
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 12:44 PM
Subject: RE: [PHP] sel
2001 1:59 PM
> To: Jason Dulberg; [EMAIL PROTECTED]
> Subject: Re: [PHP] select based on time/date
>
>
> Timestamp only sets itself to Now() if it isn't explicitly set (or set to
> NULL). So try this:
>
> $out = "UPDATE logged_in SET session='',
t; <[EMAIL PROTECTED]>
To: "Gyozo Papp" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 2001. május 23. 00:14
Subject: Re: [PHP] select specified elements from an array
> On Wed, May 23, 2001 at 12:06:42AM +0200, Gyozo Papp wrote :
> > function array_part($fromar
1 - 100 of 121 matches
Mail list logo