I have 2 tables as follows:
product table
| product_id | name | category_id
| 1| coffee| 2
| 3| orange|1
| 5| mango|1
| 2| tea |2
and
category table
|category_id | category_name |
|2| drinks
Graeme , Terry :
thnx for reply :) now some picture is clear in my head regarding session
handling. i did the stuff as u suggested. but getting error msg as ,
Warning: Cannot send session cache limiter - headers already sent (output
started at c:\phpdev\www\mediawatch\mast_maint.php:9) in
c:\phpd
You must call session_start() _before_ any output is sent to the
browser. This means before or any other output at all.
---John Holmes...
> -Original Message-
> From: Smita Manohar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 18, 2002 6:09 AM
> To: [EMAIL PROTECTED]
> Subject
Try:
SELECT C.category_name, SUM( IF( ISNULL( P.product_ID ),0, 1) ) AS total
FROM category AS C LEFT JOIN product AS P
ON C.category_ID = P.category_ID
GROUP BY C.category_ID
Ignatius
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL
hi,
could u guys help me on how i should configure postgresql support in php. thanks.
roslyn
-
Do you Yahoo!?
Yahoo! News - Today's headlines
Hello, Shoulder.
You wrote 18 ñåíòÿáðÿ 2002 ã., 5:20:55:
Do you mean random row?
So, try this
$query = "SELECT * FROM table ORDER BY RAND() LIMIT 1";
$result = mysql_query($query);
etc...
StSF> Hi all,
StSF> How can I select one random column from a MySQL table?
StSF> Thanks, Taj
cd /usr/local/php4.2.x
./configure --with-pgsql --others_options
[]'s
On Wed, 18 Sep 2002, roslyn jose wrote:
>
> hi,
>
> could u guys help me on how i should configure postgresql support in php. thanks.
>
> roslyn
>
>
>
> -
> Do you Yahoo!?
> Yahoo! News -
hi,
thanks for that reply, but the other_options, i need to configure it for gd, apache,
postgresql and a few others and also each of these have differnt versions, so whats
the exact command i need to follow. thanks
roslyn
-
Do you Yahoo!?
Yahoo! News - Toda
http://www.php.net/manual/en/install.apache.php
http://www.php.net/manual/en/installation.php#install.general
http://www.php.net/manual/en/install.linux.php
http://www.boutell.com/gd/manual1.8.4.html
...
./configure --with-pgsql --with-apache=/path/to/apache --with-gd=/opt/gd
[]'s
On Wed, 18 Se
Does anyone know a good way to have the file function timeout quickly if it cannot
find the file requested? I've tried set_time_limit (5) but for some reason it still
sits for about 30 seconds before failing. Thanks.
<>< Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, v
Hallo everybody,
I do have a little problem and can't come up with an answer. Can somebody
help me?
I would like to use two variables in a function, $database_viva and $viva.
$database_viva = "test";
$username_viva = "";
$password_viva = "";
$viva = mysql_pconnect($hostname_viva, $usern
hello all...
in my phpscript user posts news text. they copy it from other sites (news
sites) can paste in the form and submit. the script stores that news in
blob field in mysql table.
when i display that news in page say, news.php i want it should be displyed
in the font which was in the or
Hello,
New PHP (long time PERL user) here. I am using an Access database -
yeah I know Access is crap, but I have no choice. Anyway, it seems that
this magic backslash thing is unavoidable. As I understand it, I can shut
it off at the .ini level, but I am running this app on a hosted s
I wrote a block of javascript code, what is the easiest way to hide my
codes?
Thank you.
Bo
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
There are javascripts out there to disable the View Source option when the
user right clicks on your page. Disables for the whole page though, not just
a section of your code. Search here:
http://search.internet.com/www.javascriptsource.com
Thing is, scripts like those are easily defeated and the
www.php.net/stripslashes
Adam
On Wed, 18 Sep 2002, Jason Vincent wrote:
> Hello,
>
> New PHP (long time PERL user) here. I am using an Access database -
> yeah I know Access is crap, but I have no choice. Anyway, it seems that
> this magic backslash thing is unav
create a seperate file myJavaScript.php and inside that file have something like this:
my javaScript functions
Then in your page use
This works really well!!!
<>< Ryan
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 12:
http://www.php.net/manual/en/reserved.variables.php#reserved.variables.server
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 1:11 PM
To: Ryan Jameson (USA)
Subject: RE: [PHP-DB] how to hide my code?
Ryan,
Where can I find info
Hi I am a programmer and I just started using PHP4.
I have noticed that when I retreive values from a view into an
associated array using OCI8, I array will not carry the correct field name
For example if I create a view like :
create or replace view view_specimen_details
as SELECT a.ITEM_C
So what does set_magic_quotes_runtime(0) do then??? Will it shut off the
automatic backslashing of single quotes at run time or not? (it certainly
doesn't seem to)
Anyone?
J
on 9/18/02 8:55 PM, Jason Vincent at [EMAIL PROTECTED] appended the
following bits to my mbox:
> So what does set_magic_quotes_runtime(0) do then??? Will it shut off the
> automatic backslashing of single quotes at run time or not? (it certainly
> doesn't seem to)
If I recall correctly, that o
Aaron Wolski wrote:
> Hi All,
>
> Couple questions on logic and perhaps a useable solution to visitor
> tracking.
>
> My firm has redesigned a site for a cliet. In this new site we are also
> exploring some Search Engine placement and bidding techniques to
> seriously bolster his activity and bu
>From: "John Holmes" <[EMAIL PROTECTED]>
>Reply-To: <[EMAIL PROTECTED]>
>To: "'Smita Manohar'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
>Subject: RE: [PHP-DB] RE: regarding session
>Date: Wed, 18 Sep 2002 06:58:17 -0400
>
>You must call session_start() _before_ any output is sent to the
>browser
thanks !
its working fine now.
but again one question. (simple one , but i couldnt find the answer ) :-(
after user logs in, on each page i check whether valid session has been
created. if not, then i wish to redirect to the login page. doing as,
if(!session_is_registered("UserID"))
{
heade
24 matches
Mail list logo
