php-general Digest 20 Oct 2001 20:32:09 -0000 Issue 946
Topics (messages 71674 through 71702):
PHP and Unicode
71674 by: indrek siitan
71676 by: indrek siitan
Re: Re:Date->TimeStamp
71675 by: James, Yz
71677 by: Daniel Harik
XSLT error functions
71678 by: Vikram Vaswani
71699 by: Christian Stocker
Re: Expat o DOM?
71679 by: Daniele Baroncelli
71680 by: Daniele Baroncelli
Re: Annotated PHP Manual
71681 by: DL Neil
PHP/CGI problem: #!/path/php at top of CGI script appears in output
71682 by: Philippe
71685 by: Dave Goodrich
auth-loginform will not be parsed ?
71683 by: Ronald Weinrich
Upgrade problems php3 - php4
71684 by: sgibbs.vt.globalhealth.org
Re: Can I have If...Else inside a For Loop???
71686 by: ~~~i LeoNid ~~
71696 by: Brad Melendy
Desparate... rebuild gone wrong
71687 by: php
71689 by: php
Re-send (Download the whole directory using PHP)
71688 by: Mark Lo
71690 by: Christopher William Wesley
71694 by: Dave Goodrich
strip HTML
71691 by: Gary
71695 by: James, Yz
71698 by: Gary
71700 by: Jack Dempsey
Re: [PHP-INST] Re: [PHP] PHP/CGI problem: #!/path/php at top of CGI script appears in
output
71692 by: Stefan Siefert
Posted this a few day ago, really need help :S (arrays)
71693 by: Roy van Pelt
php hosting
71697 by: Heidi Belal
How do i retrieve the records that are NOT linked?
71701 by: Simon Kimber
71702 by: Jack Dempsey
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Hi,
has anyone seen any Unicode support routines available anywhere for PHP?
the manual only documents utf8_encode() and utf8_decode(), that by
the documentation convert ISO-8859-1 strings to UTF8 and back.
but i also need support for other codepages (ISO-8859-*, KOI8-R
and others). I only need xx > UTF-8 encoding.
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
<___/ www.mysql.com
Hi,
> has anyone seen any Unicode support routines available anywhere for PHP?
disregard the question. found iconv support right after sending this mail :)
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
<___/ www.mysql.com
Hi Daniel,
Try this:
<?
function DateToTimestamp($datetime) {
list ($date, $time) = explode(" ", $datetime);
list ($year, $month, $day) = explode("-", $date);
list($hour, $minute, $second) = explode(":", $time);
$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
return $timestamp;
}
echo DateToTimestamp("2001-10-20 14:05:15");
?>
Should work ok.
James
"Daniel Harik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I've tried this code:
>
> $timea = explode(" ",$timepostsed);
> $timea1 = explode("-",$timea[0]);
> $timea2 = explode(":",$timea[1]);
> $timestamp =
> mktime($timea2[0],$timea2[1],$timea2[2],$timea1[1],$timea1[2],$timea1[0]);
>
>
> But it return "-1"
>
Thank You
Hi all,
Am working with the XSLT functions in PHP. I'm trying to trap errors with
the xslt_error() functions - however, the function generates no output even
if I deliberately introduce errors into the XSLT sheet.
Same goes for the openlog() function. Any one have any ideas how I can use
these to generate and log errors?
Finally, I don't think the Sablot engine which ships with 4.0.6 supports
all the features of the XSLT spec. Any clues on where I can find a list of
supported items?
TIA,
Vikram
In <[EMAIL PROTECTED]>, Vikram Vaswani
wrote:
> Hi all,
>
> Am working with the XSLT functions in PHP. I'm trying to trap errors
> with the xslt_error() functions - however, the function generates no
> output even if I deliberately introduce errors into the XSLT sheet.
>
> Same goes for the openlog() function. Any one have any ideas how I can
> use these to generate and log errors?
as far as i know, ext/sablot from 4.0.6 doesn't really support the error
function. you have to wait for 4.1.0 and the new ext/xslt extension,
which does support that just fine.
> Finally, I don't think the Sablot engine which ships with 4.0.6 supports
> all the features of the XSLT spec. Any clues on where I can find a list
> of supported items?
http://www.gingerall.com
chregu
Salve,
Vorrei cominciare il nuovo sviluppo del mio sito in XML.
C'e' qualcuno che mi sa dire la reale differenza in velocita' tra i parser
Expat e DOM?
Inoltre, e' davvero rischioso sviluppare in DOM, considerando che il modulo
e' sperimentale e in teoria potrebbe cambiare?
Saluti
Daniele Baroncelli
Sorry, for this message in Italian. It should have been addressed to the
Italian Php newsgoup.
Daniele
"Daniele Baroncelli" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Salve,
>
> Vorrei cominciare il nuovo sviluppo del mio sito in XML.
>
> C'e' qualcuno che mi sa dire la reale differenza in velocita' tra i parser
> Expat e DOM?
>
> Inoltre, e' davvero rischioso sviluppare in DOM, considerando che il
modulo
> e' sperimentale e in teoria potrebbe cambiare?
>
>
>
> Saluti
>
>
> Daniele Baroncelli
>
>
> Khalid Hazmi wrote:
> > How I can download the current Annotated PHP Manual???
> There is no such thing... AFAIK.
=> Yasuo Ohgaki
Yasuo: Yes there is (and VERY useful it is too), check out the range of PHP
documentation available from
http://www.php.net/docs.php
Khalid: Unlike some other packages I don't think there's a zipped-up,
ready-for-download version. I presume this is
because the online version is always 'the latest' - but I don't know how often they
update it (maybe that's somewhere on
the page I just quoted!?) You could try something called a "webwhacker" to download
the web of pages that make up the
manual...
=dn
Hi,
I'll synthetize the problem with the response I have givven to Curt.
I've FreeBSD 4.2/Apache 1.3.9/PHP 4.0.6
I've installed PHP in Apache, it works very well
I need to have too PHP 4.0.6 in CGI mode (With Suexec but I don't think it's
the problem) but I've a problem.
In CGI mode, the path of PHP is always written at the top of the result
I'll take for example this script which is in the cgi-bin with the execute
mod (755), the extension is .cgi :
----
#!/usr/local/bin/php
<?
print "Hello World";
?>
----
When the file is called by the browser, the result is :
----
#!/usr/local/bin/php
Hello World
----
Does someone know the problem and the solution ?
Have I forgotten something ?
I think that's a misconfiguration in PHP
Thanks for your help
Philippe
It's not you. I just built a bare cgi version of php, nothing but
'./configure' and got the same result.
I used this simple script to be sure I was in fact running the cgi binary
and it showed I was.
info.cgi
#!/usr/local/bin/php
<?php
phpinfo();
?>
I got the correct info page, but with the #!/usr/local/bin/php at the top
as you stated. Odd, but I've never used the cgi version so other than
confirming your problem I am afraid I'm no help.
DAve
On Sat, Oct 20, 2001 at 03:31:06PM +0000, Philippe wrote:
> Hi,
> I'll synthetize the problem with the response I have givven to Curt.
>
> I've FreeBSD 4.2/Apache 1.3.9/PHP 4.0.6
> I've installed PHP in Apache, it works very well
> I need to have too PHP 4.0.6 in CGI mode (With Suexec but I don't think it's
>
> the problem) but I've a problem.
>
> In CGI mode, the path of PHP is always written at the top of the result
>
> I'll take for example this script which is in the cgi-bin with the execute
> mod (755), the extension is .cgi :
>
> ----
> #!/usr/local/bin/php
> <?
> print "Hello World";
> ?>
> ----
>
> When the file is called by the browser, the result is :
> ----
> #!/usr/local/bin/php
> Hello World
> ----
>
> Does someone know the problem and the solution ?
> Have I forgotten something ?
>
> I think that's a misconfiguration in PHP
>
> Thanks for your help
>
> Philippe
>
>
> --
> 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 administrators, e-mail: [EMAIL PROTECTED]
>
--
My other computer is your Windows machine...
Hello All
I try to implement a authsystem like.
1.) in php.ini I call prepend.php to initial db_mysql.inc ct_sql.inc
session.inc auth.inc perm.inc user.inc
local.inc.php page.inc.php
2.) in local.inc.php I have the class My_Auth where I create a
$tpl new EasyTemplate("loginform.inc.php")
in the index.html I make a <a href="pages/site2.php">index</a> in
pages/site2.php I have
<?php page_open(array("sess" => "Example_Session", "auth" => "My_Auth"));
?>
(session works)
my problem is the loginform.inc.php will not be parsed I try to put the
loginform.inc.php in every path below docRoot
Tia
Ron
Our ISP is trying to upgrade php and mysql versions on our website. The
current site works fine using MySQL 3.22.20a and PHP3.
We are able to upload, modify and create new database records with no
problem using webforms to enter test and html.
Now that we are trying to upgrade to MySQL 3.23.36 and PHP4, the uploads,
modifying and creating of new records with text and html no longer works.
Originally, the ISP thought apostrophes were the cause of the new problem
-they tried to adjust for that but it hasn't helped.
Are there any obvious changes in versions that would cause a problem? I'm
not sure I've provided enough info to help you help me - I can provide some
of the code if there isn't an obvious change that I just don't know about.
Thank you!
Shawna
On Fri, 19 Oct 2001 21:46:29 -0700 impersonator of [EMAIL PROTECTED] (Brad
Melendy) planted &I saw in php.general:
>AAAAaaaaarrrrrrgggghhhhh! I don't think I can say much else. Thanks so
>much for pointing that out David. ;-)
>
>.....Brad
>
>
>"David Pearson" <[EMAIL PROTECTED]> wrote in message
>003101c1591a$e00ec290$320110ac@david">news:003101c1591a$e00ec290$320110ac@david...
>> Could it be the semi colon at the end of the 'if' line, at '... $nChar =
>> 45); { ...' ? Looks like the if statement ends there, the ' { print
>> "OK."; } ' is a block on it's own and the 'else' is now out of context.
>>
>> -----Original Message-----
>> From: Brad Melendy [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, October 19, 2001 8:03 PM
>> To: [EMAIL PROTECTED]
>> Subject: [PHP] Can I have If...Else inside a For Loop???
>>
>>
>> Hi All,
>> I'm stumped. I've got the following code:
>>
>> <?php
>> if(isSet($domain))
>> {
>> for ( $counter=0; $counter <= strlen($domain); $counter++ )
>> {
>> $nChar = ord(strtolower(substr($domain, $counter, 1)));
>> if (($nChar > 47 And $nChar < 58) or ($nChar > 96 And $nChar < 123) or
>> $nChar = 45);
I'd also ^^put == here, or you NEVER get to else{ anyway
Hmmmm..... dunno about that. It's returning the results I'd expect as it is
now. If I pass a string with characters that don't match the IF's criteria,
I'm getting the ELSE statement's results. Thanks though.
....Brad
"~~~I Leonid ~~" <[EMAIL PROTECTED]> wrote in message
3bd15547.14743496@localhost">news:3bd15547.14743496@localhost...
> On Fri, 19 Oct 2001 21:46:29 -0700 impersonator of [EMAIL PROTECTED] (Brad
> Melendy) planted &I saw in php.general:
>
> >AAAAaaaaarrrrrrgggghhhhh! I don't think I can say much else. Thanks so
> >much for pointing that out David. ;-)
> >
> >.....Brad
> >
> >
> >"David Pearson" <[EMAIL PROTECTED]> wrote in message
> >003101c1591a$e00ec290$320110ac@david">news:003101c1591a$e00ec290$320110ac@david...
> >> Could it be the semi colon at the end of the 'if' line, at '... $nChar
=
> >> 45); { ...' ? Looks like the if statement ends there, the ' { print
> >> "OK."; } ' is a block on it's own and the 'else' is now out of context.
> >>
> >> -----Original Message-----
> >> From: Brad Melendy [mailto:[EMAIL PROTECTED]]
> >> Sent: Friday, October 19, 2001 8:03 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: [PHP] Can I have If...Else inside a For Loop???
> >>
> >>
> >> Hi All,
> >> I'm stumped. I've got the following code:
> >>
> >> <?php
> >> if(isSet($domain))
> >> {
> >> for ( $counter=0; $counter <= strlen($domain); $counter++ )
> >> {
> >> $nChar = ord(strtolower(substr($domain, $counter, 1)));
> >> if (($nChar > 47 And $nChar < 58) or ($nChar > 96 And $nChar < 123)
or
> >> $nChar = 45);
> I'd also ^^put == here, or you NEVER get to else{ anyway
Hi,
I have been toying with my php builds (on linux), and upgraded my mcrypt
library
and subsequently killed php.
make[1]: Entering directory `/usr/src/1/php4/Zend'
/bin/sh ../libtool --silent --mode=compile
gcc -DHAVE_CONFIG_H -I. -I. -I../main -I../TSRM -g -O2 -prefer-non-pic -s
tatic -c -o zend_language_parser.lo `test -f zend_language_parser.c || echo
'./'`zend_language_parser.c
zend_language_parser.c: In function `zendparse':
zend_language_parser.c:3088: Internal error: Segmentation fault.
Please submit a full bug report.
See <URL:http://bugzilla.redhat.com/bugzilla/> for instructions.
make[1]: *** [zend_language_parser.lo] Error 1
make[1]: Leaving directory `/usr/src/1/php4/Zend'
make: *** [all-recursive] Error 1
have tried new cvs, ./buildconf etc
Any tips?
sean
Sorry,
wrong list....
Hi Sir,
I have been asking this for so many times, and I never get a reply
for this !!! Please help me. I would like to know how to download the
whole directory using PHP. Can anyone supply me some sources code for this.
I am greatly appreciate for your help.
Best Regards,
Mark Lo
On Sun, 21 Oct 2001, Mark Lo wrote:
> I have been asking this for so many times, and I never get a reply
> for this !!! Please help me. I would like to know how to download the
> whole directory using PHP. Can anyone supply me some sources code for this.
I see a few reasons why you won't get an answer to your question:
1) you didn't ask a well-formed question. your question was vague.
2) you didn't provide any information about your setup or environment.
3) you didn't ask for help. you asked for code.
4) you didn't demonstrate that you're trying to come up with your
own solution, and need some help to make your solution work.
You're free to make such inqueries, but we're also free to ignore them.
(Most people regard your type of inquery as rude, and delete them.)
If you remedy the conditions mentioned above, I'm sure people on the list
would be glad to help.
g.luck,
~Chris /"\
\ / September 11, 2001
X We Are All New Yorkers
/ \ rm -rf /bin/laden
If you mean use PHP to download a directory of your choosing...
You could send the url to wget or lynx. This would make it easy to pass
flags as well such as dir level to get, follow links, recursive Y/N, etc.
Never done it but I think exec is what you want.
DAve
On Sun, Oct 21, 2001 at 12:54:32AM +0800, Mark Lo wrote:
> Hi Sir,
>
> I have been asking this for so many times, and I never get a reply
> for this !!! Please help me. I would like to know how to download the
> whole directory using PHP. Can anyone supply me some sources code for this.
>
> I am greatly appreciate for your help.
>
>
> Best Regards,
>
>
> Mark Lo
>
>
>
> --
> 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 administrators, e-mail: [EMAIL PROTECTED]
>
--
My other computer is your Windows machine...
Hello All,
How would I strip all HTML before the info in inserted to MySQL? The
info is sent with a form. We Have one person that insist on using HTML.
TIA
Gary
The easiest way would be to use strip_tags(), though you could craft your
own regular expression.
http://www.php.net/strip_tags
James
"Gary" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello All,
> How would I strip all HTML before the info in inserted to MySQL? The
> info is sent with a form. We Have one person that insist on using HTML.
>
> TIA
> Gary
>
Thanks James:
I had figured that part out (should of said so). What is happening is
a form is passing the stuff to another page that does the DB UPDATE. The
form action is
<form name=\"cform\" method=\"post\" action=\"update.php\">.
Where I am lost is where to put the strip_tags() like
action=strip_tages("update.php");
Gary
Yz James wrote:
> The easiest way would be to use strip_tags(), though you could craft your
> own regular expression.
>
> http://www.php.net/strip_tags
>
> James
>
> "Gary" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>>Hello All,
>> How would I strip all HTML before the info in inserted to MySQL? The
>>info is sent with a form. We Have one person that insist on using HTML.
>>
>>TIA
>>Gary
>>
>>
>
>
once you get the data in your update.php file, do this
$stripped = strip_tags($data_field_name);
you can also specifiy tags to be left in.....read the website page for more
info
jack
-----Original Message-----
From: Gary [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 20, 2001 3:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: strip HTML
Thanks James:
I had figured that part out (should of said so). What is happening is
a form is passing the stuff to another page that does the DB UPDATE. The
form action is
<form name=\"cform\" method=\"post\" action=\"update.php\">.
Where I am lost is where to put the strip_tags() like
action=strip_tages("update.php");
Gary
Yz James wrote:
> The easiest way would be to use strip_tags(), though you could craft your
> own regular expression.
>
> http://www.php.net/strip_tags
>
> James
>
> "Gary" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>>Hello All,
>> How would I strip all HTML before the info in inserted to MySQL? The
>>info is sent with a form. We Have one person that insist on using HTML.
>>
>>TIA
>>Gary
>>
>>
>
>
--
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 administrators, e-mail: [EMAIL PROTECTED]
Hi @all..
I'm not sure if this can fix (or explain) your problem (cause I didn't tried
it in lack of time) but theoretical it could be :).
I think you only need the #!/usr/local/bin/php if you would like to run
scripts from the bash, or as a "real" cgi. But I think, there could be
another solution .. compile your php as cgi like you did and add these lines
in your httpd.conf
ScriptAlias /php/ "/usr/local/bin/"
AddType application/x-httpd-php .php .phtml .cgi
Action application/x-httpd-php "/php/php"
This should also launch the cgi - version of php, but doesn't requires the
#! line in the scripts. I'm not sure, but it should work.
Hope this helps you,
Stefan Siefert
----- Original Message -----
From: Dave Goodrich <[EMAIL PROTECTED]>
To: Philippe <[EMAIL PROTECTED]>
Cc: php-general <[EMAIL PROTECTED]>; php-install
<[EMAIL PROTECTED]>
Sent: Saturday, October 20, 2001 6:05 PM
Subject: [PHP-INST] Re: [PHP] PHP/CGI problem: #!/path/php at top of CGI
script appears in output
> It's not you. I just built a bare cgi version of php, nothing but
> './configure' and got the same result.
>
> I used this simple script to be sure I was in fact running the cgi binary
> and it showed I was.
>
> info.cgi
> #!/usr/local/bin/php
> <?php
> phpinfo();
> ?>
>
> I got the correct info page, but with the #!/usr/local/bin/php at the top
> as you stated. Odd, but I've never used the cgi version so other than
> confirming your problem I am afraid I'm no help.
>
> DAve
>
> On Sat, Oct 20, 2001 at 03:31:06PM +0000, Philippe wrote:
> > Hi,
> > I'll synthetize the problem with the response I have givven to Curt.
> >
> > I've FreeBSD 4.2/Apache 1.3.9/PHP 4.0.6
> > I've installed PHP in Apache, it works very well
> > I need to have too PHP 4.0.6 in CGI mode (With Suexec but I don't think
it's
> >
> > the problem) but I've a problem.
> >
> > In CGI mode, the path of PHP is always written at the top of the result
> >
> > I'll take for example this script which is in the cgi-bin with the
execute
> > mod (755), the extension is .cgi :
> >
> > ----
> > #!/usr/local/bin/php
> > <?
> > print "Hello World";
> > ?>
> > ----
> >
> > When the file is called by the browser, the result is :
> > ----
> > #!/usr/local/bin/php
> > Hello World
> > ----
> >
> > Does someone know the problem and the solution ?
> > Have I forgotten something ?
> >
> > I think that's a misconfiguration in PHP
> >
> > Thanks for your help
> >
> > Philippe
> >
> >
> > --
> > 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 administrators, e-mail: [EMAIL PROTECTED]
> >
>
> --
> My other computer is your Windows machine...
>
>
>
> --
> PHP Install 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]
>
>
Hello there...
The problem is that I can only add one value into the array...
Anyone knows what I'm doing wrong here....(First project by the way!!)
=====================================================
<?php
session_start();
session_register("offer");
// Make a new offer if it doesn't exist yet
if (!is_array($offer))
{
$offer = array(array('pid' => '', 'pname' => '', 'pqty' => ''));
$nrItems = 0;
}
// Get variables from products.php
$productID=trim(${"pid"});
$productName=trim(${"productName"});
// Add product to offer
if ($productID!="")
{
$nrItems = $nrItems + 1;
for ($i=0; $i<$nrItems; $i=$i+1)
{
if ($offer[$i]['pid']=="")
{
$productQTY = 1;
$offer[$i]['pid'] = $productID;
$offer[$i]['pname'] = $productName;
$offer[$i]['pqty'] = $productQTY;
}
}
}
//if there are no items in the offer, print a message
if ($offer[0]['pid']=="")
{
echo "No items in the offer"."<br>\n";
var_dump($offer)."<br>\n";
echo "<a href=producten.php>back</a>";
}
//else print the contents of the offer
else
{
for ($i=0; $i<$nrItems; $i=$i+1)
{
echo "The offer:"."<br>\n";
var_dump($offer)."<br>\n";
echo "The offer contains items: ";
echo $nrItems."<br>\n";
echo $offer[$i]['pid']."<br>\n";
echo $offer[$i]['pname']."<br>\n";
echo $offer[$i]['pqty']."<br>\n";
echo "<br>\n";
echo "<a href=producten.php>back</a>";
echo "<br>\n";
}
}
======================================================
THNX in advance
Anybody know of good reliable hosting that supports
php, and has a control panel to go with it?
thanks,
Heidi
=====
Heidi Belal
ICQ# 32127109
A bus stops at a bus station.
A train stops at a train station. On my desk
I have a work station...
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
Hi All,
Are there any MySQL "gurus" who can help me solve this problem?
I have three tables... users, categories and category_user_rights....
"categories" contains:
ID,
parent_ID,
name
"users" contains:
username,
password,
name,
etc....
"category_user_rights" contains:
username,
category_ID
How do I pull everything out of "categories" that a given user DOES NOT have
rights to? ie. every record from "categories" that does not have a record
in "category_user_rights" linking it to a username such as "fred"
Any help on this would be greatly appreciated!
Thanks!
Simon Kimber
if i understand you correctly, perhaps this:
select * from categories a,category_user_rights b where a.name!=b.username;
jack
"categories" contains:
ID,
parent_ID,
name
"users" contains:
username,
password,
name,
etc....
"category_user_rights" contains:
username,
category_ID
How do I pull everything out of "categories" that a given user DOES NOT have
rights to? ie. every record from "categories" that does not have a record
in "category_user_rights" linking it to a username such as "fred"
Any help on this would be greatly appreciated!
Thanks!
Simon Kimber
--
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 administrators, e-mail: [EMAIL PROTECTED]
