Thanks for the reply. The parentheses are noted.
Meantime, I did some reading and came up with this ->
SELECT sc.col1 FROM search s, search_content sc WHERE s.word IN
('apache', 'mysql') AND s.wid = sc.wid
Thanks for the tip.
DL Neil wrote:
Gerard,
Im looking for another opinion on an sql
Gerard,
> Im looking for another opinion on an sql statement.
> SELECT sc.col1 FROM search s, search_content sc WHERE s.word = 'mysql' >
AND s.wid = sc.wid OR s.word = 'apache' AND s.wid = sc.wid;
> I had to use "s.wid = sc.wid" twice in the sql for the query to work
> properly. Is this the legal
*** APOLOGIES FOR CROSS POSTING ***
I haven't done this directly, but I imagine the process would be similar to
working with images, and the same restrictions/rules of thumb would apply
regarding storing them in the db versus storing them on the filesystem, i.e.
store the flash files in the filesy
Im looking for another opinion on an sql statement.
SELECT sc.col1 FROM search s, search_content sc WHERE s.word = 'mysql'
AND s.wid = sc.wid OR s.word = 'apache' AND s.wid = sc.wid;
I had to use "s.wid = sc.wid" twice in the sql for the query to work
properly. Is this the legal, correct way to
I'd go back to apache 1.3.27 and php-4.2.3 if I were you and see if that
fixes your problem.
I run Informix, PHP, and Apache on a server and have had no problems.
Adam
On Mon, 21 Oct 2002, Erwin Speybroeck wrote:
> Hi,
>
> I'm struggling with a problem for quite some tim
On Monday 21 October 2002 22:07, lallous wrote:
> TO_DAYS() applied on datetime field is returning different values on
> different times but same date!
>
> How can I pass to TO_DAYS() only the DATE part of my datetime field?
As far as I can tell, TO_DAYS() does only use the DATE part regardless wh
On Monday 21 October 2002 22:33, Edward Peloke wrote:
> I am attempting to create a page on my website which will allow users to
> upload images. I will need to rename and resize the image and then grab
> the location of the image and place it in the mysql db in a varchar field.
>
> I have been to
try to find it here
http://www.hotscripts.com/
-jen
- Original Message -
From: Tjoumaidis Anastasios <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 21, 2002 2:54 PM
Subject: [PHP-DB] Re: Free shopping cart
> Tony S. Wu wrote:
> > I need to write a shopping car
Greetings,
I'm looking for a cataloging system. I've found some but they all deal with
e-commerce, which I don't want. I'm trying to catalog items by country,
then by catagories, then by items. I've been to all the regular download
sites but no luck :(
any help would be grateful
sparks
--
Hi all!
I'm trying to display a flash which is stored at my db (postgresql).
to retrieve the information i created a file named show_swf.swf with this content:
and i call this file at the code of the flash (i've bolded and underline the places
where i called the file):
function flash_code_
> Given a datetime field in a MySql database, how can i list all the
records
> that are dated back to yesterday or to 'N' days in the past?
SELECT * FROM your_table WHERE TO_DAYS(date_column) =
TO_DAYS(CURRENT_DATE) - N
Where N is how many days you want to go back.
---John Holmes...
--
PHP D
Doesn't seem so. Wannabes/Leechers never die. They haven't really understood
what this media ought to be.
Most of the time it's faster (and wiser) to switch brain on for at least ten
minutes, rather than surfing beginner's guides for hours. Otherwise get
yourself some training day(s).
Really.
[N
I'll build you one, $70/hr US. :-)
<>< Ryan
-Original Message-
From: Sparks [mailto:alex@;paychoice.com]
Sent: Monday, October 21, 2002 7:29 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] catalog system
Greetings,
I'm looking for a cataloging system. I've found some but they all deal with
Sorry, didn't want to be that offensive. It just comes through from time to
time.
Thomas
Sparks [mailto:alex@;paychoice.com] wrote:
>
> Yes, I've been trying to learn what I need. Yes, I've surfed the
> newbie/wanna be places. I just asked if anyone knew of one,
> not asking to
> build it for
Agreed!
It sure is.
Aaron
-Original Message-
From: John W. Holmes [mailto:holmes072000@;charter.net]
Sent: Monday, October 21, 2002 12:51 PM
To: 'Sparks'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] catalog system
> If someone will point me to the Nubee-forum, I will gladly go.
http://fo
Well how exactly are you using this DB?
Are you using a 'blob' type format to actually write the flash binary to
the database, or are you using it to keep track of where it is in the
filesystem?
-J
Yonatan Ben-Nes wrote:
Hi all!
Does anyone know where can i find some information about display
I am attempting to create a page on my website which will allow users to
upload images. I will need to rename and resize the image and then grab the
location of the image and place it in the mysql db in a varchar field.
I have been told there are already some code for this online that can be
plug
Yes, I've been trying to learn what I need. Yes, I've surfed the
newbie/wanna be places. I just asked if anyone knew of one, not asking to
build it for me. Thought I'd try and learn from one and make my own.
If someone will point me to the Nubee-forum, I will gladly go.
Wannabe
"Thomas Lamy"
Hello,
Given a datetime field in a MySql database, how can i list all the records
that are dated back to yesterday or to 'N' days in the past?
Thanks,
Elias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I think you have forgotten that the variable $tbn2 is not available in your
function, unless you include it into your function, using the "global"
statement.
Try this code:
function getnames(){
global $tbn2;
$gnlistsql = "select name from $tbn2";
$gnlistres = mysql_query($gnlistsql);
whil
Hi all!
Does anyone know where can i find some information about displaying flash from a db?
I'm breaking my head over it, searching at newsgroups, searching at the net,
addressing newsgroups but still nothing!
Help b4 im cutting my hands off!!!
With hopes to be saved :P
Yonatan Ben-Nes
Hello, friends.
I got a problem working with ORA functions in PHP. I need to request ORACLE
stored procedure with two params. First is some kind of "table type" (i can
get exact english name of this termin if need) - e.g. this parameter is
table :-/. What is this, and how I can bind this in PHP?
Hi,
I am running under Linux and using freetds to connect to a DB on MS
SQL-Server. In general it works very well, except when I try to use the
tableInfo() function to retrieve information from a result set as in:
print_r($result->tableInfo());
The page aborts at this call. Using the Zend de
Build you own.
Does no one want to 'work' for their projects these days?
*shrug*
Aaron
-Original Message-
From: Sparks [mailto:alex@;paychoice.com]
Sent: Monday, October 21, 2002 9:29 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] catalog system
Greetings,
I'm looking for a cataloging
Tony S. Wu wrote:
I need to write a shopping cart for my friend's website.
I thought modifying a free one for my need would be easier.
Sorry for asking question like this.
But I've done the search on google and all I could find weren't free.
Can anyone provide me some links?
Thanks a lot.
Tony S.
25 matches
Mail list logo