hi all,
can anyone pls help me out to make the query like.. if two tables have some
comman records then how to find records from one table that are not in
another table.
eg...
i have one table room type master (room_type_m)
fields : room_type_id, room_type_name and other details
and another
Manohar [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] how to get records from one table that are not in
another table
Date: Sun, 27 Jul 2003 09:44:04 -0400
Smita Manohar wrote:
can anyone pls help me out to make the query like.. if two tables have
some comman records then how to find
heyy...
i put second condition (after AND) in the wrong place.. it should be after
LEFT JOIN ON
not after WHERE... following is the correct query...
SELECT A.room_type_id, room_type_desc FROM room_type_m A LEFT JOIN
hotel_room_type_d B ON A.room_type_id = B.room_type_id AND B.hotel_id =
hello all,
im writting code for discussion forum. can any one give any idea about how
to show online status of members on and off ?
- smita.
_
Get ball by ball action on your desktop.
hello all,
im writting code for discussion forum. can any one give any idea about how
to show online status of members on and off ?
- smita.
_
Get ball by ball action on your desktop.
hii all,
im not able to acess value of form variables in session. page needs to
refresh. register_globles if set to ON.
pls help me out.
regards,
smita
_
Add photos to your e-mail with MSN 8. Get 3 months FREE*.
hiii all,
i've posted this question some days back. but didnt find answer. so posting
it again.
in my phpscript, some users are allowed to del/modify contents of the
database. for this they have been provided login name and password, after
user loggs into the secure area, session starts.
hello all,
im having variable $item_id_v = 100
when i want to pass this value to the page item_maint.php i use the
statement :
?php echo A HREF=\item_maint.php?item_id=$item_id_v\ Click /A ?
i need to pass array using such way. but i dont know how to do that.
can anyone pls help me out for
bit hard coded. but could solve the conflict problem for
php array and javascript.
i got the clue from : http://www.php.net/manual/en/language.types.array.php
thanks to php.net
smita.
From: To: Smita Manohar , Subject: Re:[PHP-DB] php and javascript Date:
Thu, 26 Sep 2002 8:17:39 +0300
hii all,
in my php script, im havin one form, in which having checkboxes. values for
which are coming from database, and i want to do some action for checked
vales. so i create array of that checkbox.
now i want to include one link for Check All which helps user to check all
boxes in single
hi all,
in my php script im using SELECT in FORM element.
the OPTION values for SELECT tag are coming from database. and the
situation in my code is that, those values i need to pass as a hidden value
thru form.
im doing it as,
FORM method=post action=act_modify.php
.
.
.
SELECT NAME=item_v
//
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. This means before
it done??
thanks in advance :-)
smita.
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
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
Jim, Mike :
thanks for reply.
getting desire result with strtotime.
John,
yess u r right.
sometimes in my script date is coming from database. in that case, use of
DATE_FORMAT() is the best option.
thanks
smita.
From: Ford, Mike [LSS] [EMAIL PROTECTED]
To: 'Smita Manohar
hii
im using php script with mysql. i want to hide the script from the admin or
from the person who has privileges to access all the data. bcos i use ftp to
upload the files. and i don't want anyone should be able to view the source.
is it possible to do so?
thnx and regds,
smita.
hii
i have one form in which i print records from mysql database. while
displyaing those records i display one checkbox with each record. i want the
user should select the checkbox corresponding to the record which s/he wants
to delete.
i display those records after running one query. hence
im accepting input using form (method post). the variables which are passed
thru post method are available in the file whitch i specify for action. but
i want those variables in other file. how to make them global to be accessed
from any file??
thnx and regds,
smita
hiii
im using php with mysql. i have one table for which i want to display tree
structure.
for eg. table is like this...
person_id name parent_id
1 shyam 0
2 rohit 1
3 nikita 1
4 ram
hiii..
i want page no. and next prev links while displaying search result. the
script which im using presently, needs to run the search query 2 times for
each search operation.
first time it finds all the records matching the query string,
ie, select * from table where field like
hii
im using php with mysql 3.23
in my script im accepting text input and want to compare it with the field
which is of the type blob.
trying with following query.
SELECT * from table where fieldname LIKE '% $textinupt %'
but it is giving case sensitive result bcos the field which im
hello,
in my script i want to compare input date with date stored in database and
want the result for date = input date and sometime for date = input date.
it didn't work for = and = operators. i also tried using between but it
didn't give desire result :-(
is there any other comparison
im using query SELECT * FROM table WHERE field LIKE '% $variable %'
with this, i want it should not be case sensitive, and should not
distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case
sensitive result.
what can i do to overcome this ? pls suggest any other possible
for this?
thnx and regards,
smita.
From: Dejan Rajic Reply-To: Dejan Rajic To: Smita Manohar CC:
[EMAIL PROTECTED] Subject: Re: [PHP-DB] how to store formated text in
database Date: Mon, 19 Aug 2002 07:20:51 +0200
This is CorpseEater's reply on your message send to him on 8/19/2002 :
Well, there has been
i'm using php with mysql. some tables in database have date fields for which
i have not set any default value. while displaying the values from tables,
if any record has null value for date field then it displays 0-00-00.
what i need to do to display null value or spaces instead of zeros.
hii
i'm using php with my sql. i wanted to take date input in the dd-mm-yy
format from user. is there any function to convert this accepted input into
-mm-dd format to store in database ?
thnx and regards
_
Send and receive
hello,
i'm using php with sql i wanted to store text in database along with
formatting, so that when i retrieve it, it should be printed with all the
formatting which is used while storing the value in database. is there any
function as such for this stuff?
thnx and regards,
smita.
27 matches
Mail list logo