On Thu, Aug 1, 2013 at 6:33 PM, iccsi wrote:
> Thanks for the information and help,
> The query can solve server side, but client side, user might select any
> one dropdown, for example, user might select manager from drop down without
> choose Department dropdown.
>
> For this case, application
Thanks for the information and help,
The query can solve server side, but client side, user might select any one
dropdown, for example, user might select manager from drop down without
choose Department dropdown.
For this case, application needs inject data for supervisor and lower level,
Tha
On 7/31/2013 9:37 PM, iccsi wrote:
I have 5 SELECT for Department, Manager, supervisor, Group Leader and
Employees
I want to every SELECT list narrow down for an upper SELECT.
For example, once user select Department then all Manager, Supervisor,
Group Leader and Employee list will be narrow down
I found another solution myself.
Thanks four your answer Robert.
""João Cândido de Souza Neto"" <[EMAIL PROTECTED]> escreveu na
mensagem news:[EMAIL PROTECTED]
> Hi everyone,
>
> I´m not sure if it´s the right place to get such answer, but if someone
> know, please, help me.
>
> In a select
Curt Zirzow wrote:
There is a pecl extension that you can register, custom
superglobals although it comes with some extra stuff as well:
http://php.net/runkit
I wish it would be a part of core distribution. Would be extremely useful.
--
PHP General Mailing List (http://www.php.net/)
To unsub
On Thu, Nov 10, 2005 at 05:21:51PM -0500, Ben Ramsey wrote:
> On 11/10/05 4:48 PM, Richard Lynch wrote:
> >Here's an idea... Quite possibly half-baked.
> >
> >Suppose PHP had a superglobal $_CLEAN which was an empty array.
> >
> >Further suppose it was documented in the manual as *the* place to pu
On Thu, November 10, 2005 4:21 pm, Ben Ramsey wrote:
> On 11/10/05 4:48 PM, Richard Lynch wrote:
> The only issue I see with building in a superglobal to the language
> (or
> this extension) is that it doesn't force the user to instantiate the
> empty array at the top of the script. This could make
On 11/10/05 4:48 PM, Richard Lynch wrote:
Here's an idea... Quite possibly half-baked.
Suppose PHP had a superglobal $_CLEAN which was an empty array.
Further suppose it was documented in the manual as *the* place to put
your scrubbed data.
This rather small and hopefully inexpensive change (
On Wed, November 9, 2005 7:15 pm, Chris Shiflett wrote:
> Ben Ramsey wrote:
>> $clean = array();
>> $sql = array();
Here's an idea... Quite possibly half-baked.
Suppose PHP had a superglobal $_CLEAN which was an empty array.
Further suppose it was documented in the manual as *the* place to pu
M wrote:
$clean['pass'] = md5((ini_get('magic_quotes_gpc') ?
stripslashes($_POST['pass']) : $_POST['pass']));
or users with quotes in their password won't be able to log in.
This is best handled in one place, so that it's easier to maintain and
less likely to be overlooked. In the examples pr
Chris Shiflett wrote:
Ben Ramsey wrote:
$clean = array();
$sql = array();
Glad to see someone spreading this habit. :-) Thanks, Ben.
if (ctype_alnum($_POST['pass']))
{
$clean['pass'] = $_POST['pass'];
}
I think it's fine to cheat a bit with the password and trust the output
forma
Ben Ramsey wrote:
$clean = array();
$sql = array();
Glad to see someone spreading this habit. :-) Thanks, Ben.
if (ctype_alnum($_POST['pass']))
{
$clean['pass'] = $_POST['pass'];
}
I think it's fine to cheat a bit with the password and trust the output
format of md5():
$clean['pass
On 11/9/05 6:21 PM, Ross wrote:
What is the correct syntax for
$query = "SELECT * FROM login where username='$_POST['username']' AND pass
='$_POST['pass']'";
Thought this would work.
R.
The correct syntax in this case is actually:
$query = "SELECT * FROM login where username='{$_POST['u
This should work
Please select a site to visit
http://www.google.com";>Google
http://www.yahoo.com";>Yahoo
http://www.microsoft.com";>MS
On Wed, 19 Jan 2005 22:23:52 +0100, Jochem Maas <[EMAIL PROTECTED]>
wrote:
Ricky Morley wrote:
Like this. Here's the html code. I'm sure you can conve
Ricky Morley wrote:
Like this. Here's the html code. I'm sure you can convert to the
appropriate PHP
this is totally not PHP but...
shouldn't that be something like:
which is evil and crude, but does 2 things: uses the selectedIndex to
get the value of the selection options and only sets t
Like this. Here's the html code. I'm sure you can convert to the
appropriate PHP
http://www.google.com";>Google
http://www.yahoo.com";>Yahoo
http://www.microsoft.com";>MS
On Wed, 19 Jan 2005 20:10:25 +0200, William Stokes <[EMAIL PROTECTED]>
wrote:
Hello,
Hope someone can give some d
Louie Miranda wrote:
now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted);
ERROR : Invalid use of group function
WHERE dateposted = max(dateposted);
Perhaps ( works in Firebird :) )
--
Lester Cain
now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted);
ERROR : Invalid use of group function
hmm? seems, not to be working at all.
On Tue, 27 Jul 2004 14:43:58 +0800, Louie Miranda <[EMAIL PROT
ok, just removed the distinct syntax
On Mon, 26 Jul 2004 23:51:43 -0500, mos <[EMAIL PROTECTED]> wrote:
> At 10:45 PM 7/26/2004, you wrote:
> >if I understand you correctly, this should do it.
> >
> >select distinct office, max(dateposted)
> >from table
> >group by office
>
>
> Just one more thi
SELECT * FROM foo_table WHERE field_foo <> some_value
The above will select all from foo_table except where field_foo is equal to
some value.
HTH
Craig
"Phpu" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
Is there any way to select all entries in the database except one ent
Sure!
';
$sqlu = "SELECT id,user,name ';
$sqlu .= "FROM users ';
$sqlu .= "ORDER BY user ASC";
$name_result = mysql_query($sqlu);
while($rowu=mysql_fetch_array($name_result)){
echo '';
echo $rowu[user];
echo '' . "\n";
}
echo
?>
Walter
--
PHP General Mail
Dave Carrera wrote:
> Hi List,
>
> How do I select data from 24 table in my database.
>
> Each one is identical in structure layout being
>
> Id,name,list
>
> I want to select where like $_POST[var] from a form all of the tables
> but I am having trouble :(
>
> I thought making a var string like
>
First, this is a MySQL Question, next time you better send your request
to a list which covers your type of question.
use tablename.fieldname in your WHERE clause if you have fields with the
same name.
-- red
Dave Carrera wrote:
Hi List,
How do I select data from 24 table in my database.
Each o
[EMAIL PROTECTED] (Bruce Levick) wrote in
[EMAIL PROTECTED]:">news:[EMAIL PROTECTED]:
If you want to access the data in an array try $row['field']
> I am connecting to mysql and all works well there. I query a table
> "Illustrations" ($query = "SELECT * FROM Illustrations";), and want to
> print
> Print "$row[titletext]";
> Print "$row[img]";
check if the img field in the returned row even has a value or try:
$row[0] and $row[1] instead of $row['titletext'] and $row['img']
-Peter
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
evet koyabilirsin
degerini bastan verdigin bir degiskenle :
bla bla
>display first
her defasindaselected olan degisecekse ...
display first or".$baskadegisken; ?>
bla bla
kolay gelsin
--
PHP General Mailing List (http://www.php.net/)
To unsubscri
Can you be a bit more clearer with your question?
"Meltem Demirkus" <[EMAIL PROTECTED]> wrote in message
011c01c257f0$c4499780$5583@hiborya">news:011c01c257f0$c4499780$5583@hiborya...
> Hi,
>
> Can I put the "selected" option of select box later by using php?
>
> thanks
>
>
--
PHP
This happens when a tag is not within a block in
netscape 4.. if the select isn't meant to be part of a form, and is just
for navigation (javascript onchange or whatever), then just do
...
Mike
Edwin Boersma wrote:
> Hi,
>
> I'm developing a website for multiple browsers. In Netscape 4.xx
The most common couse of this problem is that your query generated an mysql
error. To find out what the error is use this instead:
> $t2=mysql_db_query($db, "SELECT
radacct.UserName,sum(radacct.AcctSessionTime)
> as t1,usergroup.GroupName ".
>"from radacct LEFT JOIN usergroup ON
> radac
I'm guessing the table is messed up...
Back up your database, and try running those ISAM check utilities that MySQL
provides to verify database integrity.
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-
Whoops. Hit send too soon.
It could just be that your table is too darn big for select distinct on the
hardware you have...
What's your disk space like on MySQL's "data" drive?
df -h
You'll need to figure out which partition holds MySQL's data directory, and
see how much free space is there.
Hi James!
On Sun, 15 Jul 2001, James Tan wrote:
> dear chris,
>
> mysql does not support 'in' clause at the momment...
> the only way to this is to use the loop to generate the sql syntax..
> orr.. use the implode function... to join the array into 1 string separated by
> the first parameter...
dear chris,
mysql does not support 'in' clause at the momment...
the only way to this is to use the loop to generate the sql syntax..
orr.. use the implode function... to join the array into 1 string separated by
the first parameter...
$catsql = implode("or cid=", $catids);
$catsql = ((strlen(c
33 matches
Mail list logo
