[PHP-DB] Re: Free shopping cart

2002-10-21 Thread Tjoumaidis Anastasios
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

RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
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

[PHP-DB] Pear::DB tableInfo problem

2002-10-21 Thread Avi Schwartz
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

[PHP-DB] ORACLE Stored procedure trouble

2002-10-21 Thread dr. Agon
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?

[PHP-DB] Re: MySql Statement inside a function?

2002-10-21 Thread Hp
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);

[PHP-DB] MySql and displaying only yesterday's records

2002-10-21 Thread lallous
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

Re: [PHP-DB] catalog system

2002-10-21 Thread Sparks
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

[PHP-DB] images

2002-10-21 Thread Edward Peloke
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

RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
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.

Re: [PHP-DB] catalog system

2002-10-21 Thread Thomas Lamy
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 me.

RE: [PHP-DB] catalog system

2002-10-21 Thread Ryan Jameson (USA)
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

RE: [PHP-DB] MySql and displaying only yesterday's records

2002-10-21 Thread John W. Holmes
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

[PHP-DB] Having problems with displaying flash from db

2002-10-21 Thread Yonatan Ben-Nes
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: ? $conn = pg_connect (dbname=name user=doumind password=hmmmno); $filename = $_GET['filename']; $sql = select bin_data

[PHP-DB] catalog system

2002-10-21 Thread Sparks
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 --

Re: [PHP-DB] Re: Free shopping cart

2002-10-21 Thread J-E-N
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 cart for

Re: [PHP-DB] images

2002-10-21 Thread Jason Wong
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 told

Re: [PHP-DB] MySql and displaying only yesterday's records

2002-10-21 Thread Jason Wong
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

[PHP-DB] Legal sql

2002-10-21 Thread Gerard Samuel
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

Re: [PHP-DB] Legal sql

2002-10-21 Thread Gerard Samuel
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

[PHP-DB] displaying flash from db

2002-10-21 Thread Yonatan Ben-Nes
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

[PHP-DB] Re: displaying flash from db

2002-10-21 Thread Jason Young
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

[PHP-DB] Re: [PHP] problem with informix

2002-10-21 Thread Adam Williams
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 time.

RE: [PHP-DB] displaying flash from db

2002-10-21 Thread Beau Lebens
*** 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