Re: [PHP-DB] supplier - consumer website scripts available?
Denis, Go have a look at www.hotscripts.com. They've got all kinds of ready-made systems for different combinations of programming languages and database solutions. Good Luck! Mikael On Mar 06, 2004, at 17:01, Denis L. Menezes wrote: Hello friends. I am in a hurry to make a website where suppliers can advertise their products and services and customers can place their requirements so the requirements can be matched with the service providers. Also vistors should be able to seekf suppliers and customers. Can anyone tell me where I could find a ready made scripts program that does the above? Thanks denis -- 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] Forum Script
Hello friends. I am currently trying to develop a forum system. All is going well, but I was wondering if there woud be a way to do something that I'm already doing that might be more efficient. First I'll give you some background... I am using php 4 and mysql 4. I have a database setup, and I have a table set up for forum posts. I have fields for which board it was posted on and which (if any) post it was a reply to. If it wasn't a reply, that field will be left blank. For these fields, I use a unique ID system, which makes an ID based on the poster and when it was posted. Now when I display them, I make a table for the subject (head), author, last post, number of replies etc. I make it do a SELECT query and it gets the results and displays them. Now the problem I come into is with the number of replies. Currently while it's doing the WHILE loop, it performs another query for each post, checking how many posts have there reply field set to the post's current ID. That works fine, but it means I'm doing (up to) 21 queries per page, which I would guess is alot. I was wondering if there would be a way I could get the number of replies as a column in my first query (where I get the forum posts). Or maybe there's a more effective way by getting the number of replies first. I don't really want to store the number of replies in the database, if I can. If I'm not being clear or I'm not using proper netiquette, I appologize, I'm new to this (mailing lists). Any help would be appreciated! -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Forum Script
Hello Marcjon, Sunday, March 7, 2004, 6:12:49 PM, you wrote: ML If I'm not being clear or I'm not using proper netiquette, I appologize, ML I'm new to this (mailing lists). Any help would be appreciated! Nothing wrong at all, but it'd much easier for us if you could post your MySQL tables so we can see the relationship between them and see what fields you have, etc. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem Connecting
Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. I am trying to get phpMyAdmin to login into the database. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Forum Script
Marcjon Louwersheimer wrote: Hello friends. I am currently trying to develop a forum system. All is going well, but I was wondering if there woud be a way to do something that I'm already doing that might be more efficient. .. it might be worthwhile having a looking at and playing with the code of one of the many PHP based forum systems. many of the problems you have/will come accross will probably have been solved in some way already (whether its a good solution is upto you to decide!) .. Currently while it's doing the WHILE loop, it performs another query for each post, checking how many posts have there reply field set to the post's current ID a simple way would be to make one extra SQL call (in addition to the one for the post details) which does a count for every distinct reply_id SELECT reply_id, COUNT(*) AS cnt FROM topic_table and use this result for the count info instead of making a DB call for every row in the original resultset. you could load an array with the count data ala (this would be done with a loop over the mysql result): $countData = array(); $countData[ $row['reply_id'] ] = $row['cnt']; .. etc and then when you loop over the actual topic data you can get the count for the current topid by doing the following: echo $countData[ $currentTopicId ]; -- my SQL maybe incorrect Or maybe there's a more effective way by getting the number of replies first. I don't really want to store the number of replies in the database, if I can. If I'm not being clear or I'm not using proper netiquette, I appologize, I'm new to this (mailing lists). Any help would be appreciated! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem Connecting
Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. sounds like you need to set a password in the phpMyAdmin config file for the root user (as defined in MYSQL) because obviously logging in with an empty password doesn't work. I am trying to get phpMyAdmin to login into the database. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem Connecting
That was already done!!! I knew that. It is still doing it. MySQL in installed in a window XP machine. What else is there?? ~WILL~ Jochem Maas wrote: Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. sounds like you need to set a password in the phpMyAdmin config file for the root user (as defined in MYSQL) because obviously logging in with an empty password doesn't work. I am trying to get phpMyAdmin to login into the database. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem Connecting
I might add that I can access the database through C: prompt. ~WILL~ Will wrote: That was already done!!! I knew that. It is still doing it. MySQL in installed in a window XP machine. What else is there?? ~WILL~ Jochem Maas wrote: Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. sounds like you need to set a password in the phpMyAdmin config file for the root user (as defined in MYSQL) because obviously logging in with an empty password doesn't work. I am trying to get phpMyAdmin to login into the database. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem Connecting
When I bring up \mysql\bin\mysqladmin status proc is says that the user is ODBC, is that right?? Should I have another user in there?? Please help!! :) ~WILL~ Will wrote: I might add that I can access the database through C: prompt. ~WILL~ Will wrote: That was already done!!! I knew that. It is still doing it. MySQL in installed in a window XP machine. What else is there?? ~WILL~ Jochem Maas wrote: Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. sounds like you need to set a password in the phpMyAdmin config file for the root user (as defined in MYSQL) because obviously logging in with an empty password doesn't work. I am trying to get phpMyAdmin to login into the database. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] JPGRAPH, problem...
I did resolve my problem about the graphic X,Y, very interesting, but CAN NOT include the image in the middle of a text, it say that can not start nothing befor the ?php please if you have did something with this library and solve this problem, let me know how. Thanks. Cheers. Carlos. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem Connecting
I GOT IT YEAH! Thanks everyone. ~WILL~ Will wrote: When I bring up \mysql\bin\mysqladmin status proc is says that the user is ODBC, is that right?? Should I have another user in there?? Please help!! :) ~WILL~ Will wrote: I might add that I can access the database through C: prompt. ~WILL~ Will wrote: That was already done!!! I knew that. It is still doing it. MySQL in installed in a window XP machine. What else is there?? ~WILL~ Jochem Maas wrote: Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. sounds like you need to set a password in the phpMyAdmin config file for the root user (as defined in MYSQL) because obviously logging in with an empty password doesn't work. I am trying to get phpMyAdmin to login into the database. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Encode/Decode question
Good afternoon. I am running MySQL version 3.23.55-nt and do not have SSL of any kind complied. The question I have is this: I am using a combination of several values to build up a 'key' string. Is the ENCODE/DECODE combination using this method a good enough encryption to allow the storing of credit card #'s or would AES emcryption be better? Thanks for any information to guide me in this issue. Robin Kopetzky From Trash to Treasure Auction - coming soon www.fttta.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Using results for next query
Hi People, Am needing a little help on the following scenario. Selecting user_id from one table for all entries that match the required criteria. Now I want to use the user_id's that are returned by the previous query in another to obtain more information from another table. Basically using the results of one query to become the critera for another query and do this for all the responses from the first query. Any assistance would be greatly appreciated. Cheers, Shannon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php