[PHP-DB] Re: Free shopping cart
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. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. A good solution might be www.theexchangeproject.com or www.oscommerce.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] catalog system
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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Pear::DB tableInfo problem
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 debugger I traced it down into the mssql.php file and I found that it breaks on the following line: $res[$i]['name'] = @mssql_field_name($id, $i); The error I see in the debuger is: Call to undefined function: mssql_field_name() What may the problem be? Is my installation broken? Am I missing some file or library? Thanks, Avi -- Avi Schwartz Universe-watching, like golf and aging, [EMAIL PROTECTED] promotes humility - William R. Everdell -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ORACLE Stored procedure trouble
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? Regards, A.K. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySql Statement inside a function?
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);
while($nlist = mysql_fetch_array($gnlistres)){
$nlistop = option value=\$nlist[name]\$nlist[name]/option;
$nlistsel = select name=\getname\$nlistop/select;
echo $nlistsel;
}
}
Dave Carrera [EMAIL PROTECTED] wrote in message
news:01c276be$4d93a260$759e27d9;phpdevbox001...
Hi All
I have created a function and insde that function it dose a standard
select, fetch_arry, while loop.
I get a error from mysql saying not a vaild resource but if I take the
statemnet out of the function all works fine and dandy.
Are there things I should be aware of when trying to include mysql
statements inside a function?
I have include my code here if it helps.
function getnames(){
$gnlistsql = select name from $tbn2;
$gnlistres = mysql_query($gnlistsql);
while($nlist = mysql_fetch_array($gnlistres)){
$nlistop = option value=\$nlist[name]\$nlist[name]/option;
$nlistsel = select name=\getname\$nlistop/select;
echo $nlistsel;
}
}
There error is reported back in the while line...
Any help or advice is appreciated as always.
P.S reason for the fuction is that I will call the select a name list a
few times so I thought of making it a function then calling it when
needed.
Thank You
Dave C
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySql and displaying only yesterday's records
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
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 [EMAIL PROTECTED] wrote in message news:656F04F343FC25409463829A15B5FDDC08AFC4;netwake-nt.netwake.de... 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. [No, this was not off-topic] Thomas PS: I (and many others on the list) _like_ to help people with problems when their stuck. But from time to time this list tends to be a nubee-forum. I take time from my projects to read this list (and answer sometimes), just to give back to the community what I got - fast help when _I_ got stuck. Aaron Wolski [mailto:aaronjw;martekbiz.com] wrote: 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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] images
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 plugged into the php site. Does anyone know of any? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] catalog system
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://forums.devshed.com Newbie and advanced topics. Best forum out there, IMO. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] catalog system
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. 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 [EMAIL PROTECTED] wrote in message news:656F04F343FC25409463829A15B5FDDC08AFC4;netwake-nt.netwake.de... 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. [No, this was not off-topic] Thomas PS: I (and many others on the list) _like_ to help people with problems when their stuck. But from time to time this list tends to be a nubee-forum. I take time from my projects to read this list (and answer sometimes), just to give back to the community what I got - fast help when _I_ got stuck. Aaron Wolski [mailto:aaronjw;martekbiz.com] wrote: 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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] catalog system
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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySql and displaying only yesterday's records
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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] catalog system
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Free shopping cart
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 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. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. A good solution might be www.theexchangeproject.com or www.oscommerce.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] images
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 there are already some code for this online that can be plugged into the php site. Does anyone know of any? 1) Please don't hijack other people's threads. If you're posting a new topic, start a new thread! That is -- do not reply to an existing thread! 2) Try searching: www.zend.com www.hotscripts.com www.phpbuilder.com sourceforge.net freshmeat.net -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* bank holiday - system operating credits not recharged */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySql and displaying only yesterday's records
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 whether you have passed a DATETIME field. Try: select TO_DAYS(datetime_field) from table; and/or: select FROM_DAYS(TO_DAYS(datetime_field)) from table; Anyway this is definitely belongs to the MySQL list, not here. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Christoph, please remember that irony is not available between the Canadian and Mexican border you are confusing them again 8) - Alan Cox on linux-kernel */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Legal sql
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 do so. Thanks -- Gerard Samuel http://www.trini0.org:81/ http://dev.trini0.org:81/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Legal sql
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 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 do so.
You're perfectly legal, but have become tangled up in the rules of operator
precedence. In fact MySQL's optimiser probably takes care of it all for you.
Precedence says that if there are multiple operators they will be executed
from left to right, unless one is considered more important than the other,
eg * precedes +, or in your case, AND precedes OR.
To override precedence, or merely to help with readability, one may employ
parentheses - calculations within parentheses are performed first. Thus the
code becomes:
WHERE ( s.word = 'mysql' AND s.wid = sc.wid )
OR ( s.word = 'apache' AND s.wid = sc.wid );
Now one can apply Boolean algebra and rationalise the apparent duplication:
WHERE s.wid = sc.wid
AND ( s.word = 'mysql' OR s.word = 'apache' );
As to which is 'right' and which 'wrong', let me ask: which one do you find
most readable?
Regards,
=dn
--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] displaying flash from db
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
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 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] problem with informix
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. I have a webserver with apache-1.3.22, php 4.0.6 (patched for some security issues), informix ESQL 9.30 and a databaseserver with Informix IDS 7.31. This construction works very fine. As soon as i go to newer versions -- last try : httpd-2.0.43, php-4.2.3, with the same informix configuration the problem appears. Everything went well for about a week -- so it lloks ok, but ... On the databaseserver shared memory gets taken by the php-actions on the webserver and at a certain moment this memory is all used and the server (database) crashes. Is there somebody who has experienced a similar problem or is there somebody who can give some hints in the direction to look for ??? Thanks in advance, Erwin Speybroeck [EMAIL PROTECTED] Neem eens een kijkje op onze website -- www.vrv.be -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] displaying flash from db
*** 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 filesystem (save as an actual file) and then just save a URL in the db to the location of the file. then you either just drop that into your HTML to display it, or if the file is saved outside your DocumentRoot for whatever reason, you would need to send a header to say that you are about to pipe out some flash content (you might need to check the mime-type for your files first to get this right), then use readfile() or similar to read the file and spit out the contents. HTH Beau // -Original Message- // From: Yonatan Ben-Nes [mailto:da;canaan.co.il] // Sent: Tuesday, 22 October 2002 4:25 AM // To: [EMAIL PROTECTED]; [EMAIL PROTECTED] // Subject: [PHP-DB] displaying flash from db // // // 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
