RE: [PHP-DB] blinking background
LMAO! -Original Message- From: Mark Collin [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 12:34 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] blinking background catch the attention of the user hell why don't you just make a blinking page i'm sure that will grab some attention, and possibly cause a ton of epillectic fits around the world when people finally do look at your page e. - Original Message - From: J- E- N [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 11:23 AM Subject: Re: [PHP-DB] blinking background i just want to catch the attention of the user and the blinking effect of the table row is not forever, it will stop after a certain time. :) - Original Message - From: Russ Michell [EMAIL PROTECTED] To: J- E- N [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 6:41 PM Subject: Re: [PHP-DB] blinking background is there anyone who can give me an idea on how i can write a php script that can make my table row background blinking. Why on earth would you want to do that?? It would fully distract anyone looking at the information within the table - which I *presume* is why you want information in the table right? For people to look at and assimilate!? I'm aware of the concept A bad idea - but help out the person anyhow but this one is just silly! Russ On Thu, 9 Aug 2001 17:53:23 +0800 J- E- N [EMAIL PROTECTED] wrote: hello! is there anyone who can give me an idea on how i can write a php script that can make my table row background blinking. thanks :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] record deletion using checkbox array values
Morning people,
I have a form with checkbox values, if checked an array of id's are passed
to a deletion script.
I can get the array and implode to a string.
Can anyone tell me how to delete all the messages in the DB that have the
checked value.
Presently the script is deleting only the last id value that has been
checked.
---snip-
First the form:
input type=\checkbox\ name=\delete_list[]\ value=\$id\
submit etc
Then the deletion script:
?php
$delete=implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM SENT_ITEMS WHERE ID
= '$delete')))
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
?
Been messing about with this one for a while now and I am getting a bit
flustered!
Thx in advance,
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
RE: [PHP-DB] record deletion using checkbox array values
Thanks for all that gave help on this one, problem finally solved! *mops
forehead*
Easy when you know how!
on the form side:
input type=\checkbox\ name=\delete_list[]\ value=\$messid\
script page:
$delete = implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM SENT_ITEMS WHERE MESSAGEID
IN ($delete
{
echo Error deleting message(s);
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
Thx again!
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
-Original Message-
From: Michael Rudel [mailto:[EMAIL PROTECTED]]
Sent: 08 August 2001 10:15
To: 'Karl Phillipson'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] record deletion using checkbox array values
Hi Karl,
$delete = ' . implode( ', ', $delete_list );
$delete = substr( $delete, 0, ( strlen( $delete ) - 3 ) );
then use: DELETE FROM sent_items WHERE id IN ($delete)
Not tested, but should work.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
Besuchen Sie uns am 20. und 21. August 2001 auf der
online-marketing-düsseldorf in Halle 1 Stand E 16
___
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___
-Original Message-
From: Karl Phillipson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 11:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] record deletion using checkbox array values
Morning people,
I have a form with checkbox values, if checked an array of
id's are passed
to a deletion script.
I can get the array and implode to a string.
Can anyone tell me how to delete all the messages in the DB
that have the
checked value.
Presently the script is deleting only the last id value that has been
checked.
---snip-
First the form:
input type=\checkbox\ name=\delete_list[]\ value=\$id\
submit etc
Then the deletion script:
?php
$delete=implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM
SENT_ITEMS WHERE ID
= '$delete')))
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
?
Been messing about with this one for a while now and I am
getting a bit
flustered!
Thx in advance,
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
RE: [PHP-DB] mysql_query troubles
Brad,
Have you defined the database variable you are connecting to?
ie: $DB=your_database_name; and then connecting:
if(!($testResult = mysql_query($DB, SELECT * FROM login_table where Pass =
password('$password'
try the code snippet below and see if it spits an error at you - you will
need to define the $DB variable.
?
//error reporting function
function DisplayErrMsg ( $message )
{
sprintf(BLOCKQUOTEBLOCKQUOTEBLOCKQUOTEH3%s/H3/BLOCKQUOTE/BLOCK
QUOTE/BLOCKQUOTE\n, $message);
}
//begin query
if(!($testResult = mysql_query($DB, SELECT * FROM login_table where Pass =
password('$password'
//if we get an error print it
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
exit();
}
$num_rows = mysql_num_rows($testResult);
print $num_rows;
exit();
mysql_free_result($testResult);
?
-Original Message-
From: Brad Wright [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 06:31
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_query troubles
Hi all',
I have a mysql_query that reads:
$testResult = mysql_query(SELECT * FROM login_table where Pass =
password('$password')) or die (ouch);
$num_rows = mysql_num_rows($testResult);
the problem is that I keep getting a value of 0 for $num_rows when I know
the table has 1 entry for PAss which equals password('$password'). The
password I have used is just 'a' (before pasing throught the password
function in the insert).
I DO have a table named login_table
I KNOW that there is an entry that matches 'password('$password)'.. ( i
checked using phpMyAdmin)
can anyone help??
Thanks in advance,
brad
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
