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 =
'
EMAIL PROTECTED]
To: Smita 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
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 tabl
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.
http://server1.msn.co.in/msnspecials/cricketdo
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.
http://server1.msn.co.in/msnspecials/cricketdo
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*.
http://join.msn.co
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. since
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 :
Click "?>
i need to pass array using such way. but i dont know how to do that.
can anyone pls help me out for this.
thnx in advance
smita.
___
flict 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
>
>hy, if you
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
hii all...
being new to php and mysql, i dont know can we use CONNECT BY in mysql.
can anyone pls explain with example?
thnx and regds,
smita.
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/
hi all,
in my php script im using in element.
the values for 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,
.
.
.
// some stuff before this to build query
');
echo '
hello all..
in my site, where im using 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. since here,
user can modify/del contents of database, i needed to us
eed to do in
login.php to get 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
>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 -040
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
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
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]>
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 ea
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.
_
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 '%$search_st
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 comparin
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 w
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.
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 t
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.
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
30 matches
Mail list logo
