[PHP] Select

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 = @

[PHP] select

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

[PHP] select statement

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

[PHP] Select-List

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

[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 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

[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='$pass'"; and if you can't is there a away around this? Thanks Peter

[PHP] select prob.

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

[PHP] select count

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

[PHP] select count

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

[PHP] select as

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

[PHP] select question

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

RE: [PHP] Select

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

Re: [PHP] Select

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

RE: [PHP] Select

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

RE: [PHP] Select

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

[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 this script OK but no in linux. What's wrong ? @$spojenie = mysql_connect("localhost","user","password"); if (!$spojenie)

[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); \n"; do { printf("Title: %s By: %s | Date: %s Article: %s URL: Click here\n", $myrow["title"], $myrow["nickname"],$myrow["created"],$my

[PHP] SELECT DAYOFYEAR(NOW())

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

[PHP] Select then update

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 =

[PHP] SELECT + PARSE ERROR

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

RE: [PHP] select statement

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

Re: [PHP] select statement

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

Re: [PHP] Select-List

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,

Re: [PHP] 'Select All'

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

Re: [PHP] 'Select All'

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.

Re: [PHP] 'Select All'

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

Re: [PHP] 'Select All'

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:

RE: [PHP] 'Select All'

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

Re: [PHP] 'Select All'

"]; > 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

Re: [PHP] SELECT statement

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

Re: [PHP] SELECT statement

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

RE: [PHP] SELECT statement

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

RE: [PHP] SELECT statement

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

Re: [PHP] SELECT statement

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

RE: [PHP] SELECT statement

: 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=&#

RE: [PHP] SELECT statement

-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&#x

RE: [PHP] SELECT statement

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

Re: [PHP] SELECT statement

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

RE: [PHP] select prob.

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&

Re: [PHP] select prob.

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

RE: [PHP] select prob.

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

RE: [PHP] select prob.

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

RE: [PHP] select prob.

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. >

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

[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" case "bar2" foobar = "fooey2" case "bar3" foobar = "fooey3" case else foobar = "NoBar" End Select How do I do the equivelent in PHP?

[PHP] Select IN array?

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

Re: [PHP] select question

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 > >

RE: [PHP] select question

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

Re: [PHP] select question

"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

Re: [PHP] select problem

;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

Re: [PHP] SELECT * FROM

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

RE: [PHP] SELECT * FROM

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 (

[PHP] Select distinct error!

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

Re: [PHP] SELECT DAYOFYEAR(NOW())

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

Re: [PHP] SELECT DAYOFYEAR(NOW())

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 : >>

Re: [PHP] Select then update

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

Re: [PHP] SELECT + PARSE ERROR

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

Re: [PHP] SELECT + PARSE ERROR

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

Re: [PHP] SELECT + PARSE ERROR

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

Re: [PHP] SELECT + PARSE ERROR

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

Re: [PHP] SELECT + PARSE ERROR

Thanks at All   -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] select+uploading multiple files

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

[PHP] Select list with PHP

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"]

Re: [PHP] Select case equivelent

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" >

RE: [PHP] Select case equivelent

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

Re: [PHP] Select case equivelent

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 >

Re: [PHP] Select case equivelent

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

[PHP] select the max value

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"

RE: [PHP] Select IN array?

> 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

Re: [PHP] select+uploading multiple files

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

Re: [PHP] select+uploading multiple files

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

[PHP] select join table on mysql

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

Re: [PHP] Select list with PHP

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

Re: [PHP] Select list with PHP

> 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

Re: [PHP] Select list with PHP

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

Re: [PHP] Select list with PHP

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

[PHP] select * from nmensagem m, nusuario...

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

RE: [PHP] select the max value

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

Re: [PHP] select the max value

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

Re: [PHP] select the max value

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

[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 the table contains at least one index, the select works fine. My question: Is that supposed

[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. In the sessions table, I have a field $timein (in format F j, Y, g:i a) that gets added whe

Re: [PHP] Select list with PHP/oops!

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

Re: [PHP] select * from nmensagem m, nusuario...

> 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

[PHP] select specified elements from an array

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

Re: [PHP] select in PHP + Sql Server

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

RES: [PHP] select in PHP + Sql Server

); 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

RE: [PHP] select based on time/date

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

Re: [PHP] select based on time/date

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

RE: [PHP] select based on time/date

> > 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

Re: [PHP] select based on time/date

- 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

RE: [PHP] select based on time/date

> > 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

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

RE: [PHP] select based on time/date

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

Re: [PHP] select based on time/date

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

Re: [PHP] select based on time/date

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

RE: [PHP] select based on time/date

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] &

Re: [PHP] select based on time/date

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

RE: [PHP] select based on time/date

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='',

Re: [PHP] select specified elements from an array

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   2   >