[PHP-DB] Learning curve mysql--mssql

2005-07-25 Thread Joseph
Does anyone have an idea what the learning curve is going from using php/mysql--php/mssql? I am applying for a position which uses MS SQL Servers for a DB and ASP.NET (god forbid) for a front end and my only experience is WAMP. While I can convert over to php from ASP.NET, I am stuck with

[PHP-DB] Nestling Array in PHP from MySql

2008-04-09 Thread A. Joseph
Well i need a little ideal on nestling this php array. This what i want to do. Have you heard of online clubing? http://www.disneytreasures.biz/ This how it works, 1) (*Agent*) You bring 3 persons (first you as an agent or officer) 2) The 3 person you brought, brings 3 persons each 3) Again

[PHP-DB] Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019

2008-04-09 Thread A. Joseph
The question is. Some nestled calculation. How did club freedom did the calculation, or how will the database structure looks like? *The example is -: * *Joseph* gave birth to *John*, *James,* and *Johnson* *John* gave birth to* Peter*, *Matter*, and *Potter* James gave birth to Juliana, Justin

[PHP-DB] Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019

2008-04-09 Thread A. Joseph
The question is. Some nestled calculation. How did club freedom did the calculation, or how will the database structure looks like? *The example is -: * *Joseph* gave birth to *John*, *James,* and *Johnson* *John* gave birth to* Peter*, *Matter*, and *Potter* James gave birth to Juliana, Justin

[PHP-DB] Date calculation from MySql table

2008-04-12 Thread A. Joseph
I want to calculate the registed users today Also total users this week Total users this month Total users this year The Mysql table has a row of INT(11) with time() value inserted. I did something like this $today = strtotime(+1 day) Then $sql = SELECT COUNT(*) FROM table WHERE dateReg =

[PHP-DB] Generating random numbers

2008-04-16 Thread A. Joseph
What is the best way to generating random numbers and you are sure that the script will never generate the generated ones? I`m using mysql database, but this out of SQL AUTO_INCREMENT stuff, I need a real random generator that will never generate what has been generated.

[PHP-DB] Designing An API with PHP/MySql

2008-04-18 Thread A. Joseph
How can I design a system that let other people modify record from another server? Like I have registered member on my site, people can use external application to check if the (1) user is registered (2) user is online (3) update user profile on mysite Like the myspace.com stuff, I saw I

[PHP-DB] Array Display

2008-05-06 Thread A. Joseph
Please i knew this not the best place to post this message but i ain`t gat no option i need fast help on this I have a Array and data are grouped according to level, so want to display everybody on same level in same HTML row os if you are on level 0 then you first, to the next people on level

[PHP-DB] Array Display

2008-05-06 Thread A. Joseph
[section_level] = 1 [4] = Joseph Abah [section_name] = Joseph Abah ) [1] = Array ( [0] = 1009956 [section_id] = 1009956 [1] = 5 [section_left] = 5 [2] = 8 [section_right] = 8 [3] = 2

[PHP-DB] Re: Array Display

2008-05-07 Thread A. Joseph
The display will look like 1 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 Everybody on level 1 will be on same row and so on On 5/7/08, A. Joseph [EMAIL PROTECTED] wrote: Please i knew this not the best place to post

[PHP-DB] Recommended web developers

2008-06-24 Thread A. Joseph
Which company in India or USA can you recommend to design a complex website for my company. The site will be a social site, will include, Blog, Articles, Shops, Music, Movie, Directory, Pre-paid card system, Culture and Tourism, downloads, file upload and sharing The site is just like yahoo, but

Re: [PHP-DB] Recommended web developers

2008-06-24 Thread A. Joseph
, A. Joseph [EMAIL PROTECTED] wrote: Which company in India or USA can you recommend to design a complex website for my company. The site will be a social site, will include, Blog, Articles, Shops, Music, Movie, Directory, Pre-paid card system, Culture and Tourism, downloads, file upload

[PHP-DB] I want to remove the last comma

2008-08-12 Thread A. Joseph
This the script $dir = images; $d = opendir($dir); $out = var tinyMCEImageList = new Array(\n; while(false != ($entry = readdir($d))) { if(preg_match(/(.jpg|.gif|.png)$/, $entry) != false) { $out .= ['{$entry}', '{$dir}/{$entry}'],\n; } } $out .= );\n; This the out put var

[PHP-DB] Multi-level marketing system

2008-08-14 Thread A. Joseph
I want to develop a multilevel marketing system, please can someone give me a good starting point, or if you know a system developed for such, tell me. It will be a hierarchical structure. But members will need to earn money on some level Thank U.

[PHP-DB] Random content from MySql DB

2008-08-26 Thread A. Joseph
I`m creating a small application that let users take test online, the user will login and visit the test page, questions and answers are stored in MySql database, i want to display each randomly without repeating. test must to completed between some specific amount of time or else the

[PHP-DB] Matrix programming

2008-09-23 Thread A. Joseph
Gersten onShore Networks Internal Developer http://www.onshore.com Joseph Crawford wrote: read up on register_globals. It is a security risk because if i do http://domain.com/file.php?plugins_directory=/directory/ it can reset your variable. the best way to do that is to make

[PHP-DB] Modify Query, or sift through results?

2001-06-27 Thread Joseph Koenig
I've got a script that searches a db every night and sends out e-mail if it finds something a person would be interested in, based on criteria they gave us. The problem is that I have one field that stores regions of the country in a very unpleasant way. It stores them as: Northeast;West;South

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Joseph Koenig
at 08:54:04AM -0500, Joseph Koenig wrote: I've got a script that searches a db every night and sends out e-mail if it finds something a person would be interested in, based on criteria they gave us. The problem is that I have one field that stores regions of the country in a very unpleasant

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-29 Thread Joseph Koenig
and what not. Hopefully someone else has learned something too :) Joe Jason Stechschulte wrote: On Wed, Jun 27, 2001 at 08:54:04AM -0500, Joseph Koenig wrote: I've got a script that searches a db every night and sends out e-mail if it finds something a person would be interested in, based

[PHP-DB] Page loading

2001-12-14 Thread Christopher Joseph
Apologies for xposting. Also for irrelevence I have three different php applications running on my web site in thre different directories. All display the pages correctly when I point my browser at them. I have just installed a fourth in a directory at the same subdirectory level as the others

[PHP-DB] PHP - MSSQL

2002-09-20 Thread Joseph Szobody
. What I don't know, is how easy it is for VB to talk to MySQL. Anyone have experience with either way? I know PHP fairly well, but I'm not too sure about the installation/compiling/etc process to get odbc working. Any tips or advice would be appreciated. Thanks! Joseph -- PHP Database

[PHP-DB] PHP, dates, and MySQL data comparisons

2002-10-01 Thread Joseph Szobody
, Joseph -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread Fabien JOSEPH
, $inout but it's the same error Please help me !!! Fabien JOSEPH -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] OCIBindByName with Oracle 8i17 problem ?!

2002-11-04 Thread Fabien JOSEPH
, $inout but it's the same error Please help me !!! Fabien JOSEPH -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] OCIBindByName with Oracle 8i17 problem ?!

2002-11-05 Thread Fabien JOSEPH
Thies C. Arntzen wrote: On Mon, Nov 04, 2002 at 06:16:04PM +0100, Fabien JOSEPH wrote: I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17

Re: [PHP-DB] OCIBindByName with Oracle 8i17 problem ?!

2002-11-07 Thread Fabien JOSEPH
Thies C. Arntzen wrote: On Mon, Nov 04, 2002 at 06:16:04PM +0100, Fabien JOSEPH wrote: I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17

Re: [PHP-DB] PHP and Sendmail

2003-03-16 Thread Joseph Szobody
Chris, Check out this PHP class. It's pretty impressive. http://phpmailer.sourceforge.net/ Joseph Chris Payne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi there, I have an SMTP server on here (Imail) - how would I use it with PHP? Any tips to send a quick email as a test

[PHP-DB] mysqld ending at start up

2003-03-28 Thread Joseph Bannon
The mysql support list is slow, so I though I would post here since I know this list is more active. MySQL shuts down when I start it up... Starting mysqld daemon with databases from/home/mysqldb 030328 09:29:32 mysqld ended __ Do you Yahoo!?

RE: [PHP-DB] mysqld ending at start up

2003-03-28 Thread Joseph Bannon
Usually means you have an error in your my.cnf file. Is the my.cnf file a new thing with mysql because I heard about it for the first time today? Is there a way to configtest the my.cnf file like there is with apache? Thanks, J __ Do you

[PHP-DB] Re: removing a # from a string

2003-07-02 Thread Joseph Szobody
How would I remove a # from a string? I want #2 to be 2. $str = #2; $str = str_replace(#,,$str); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Failed Install

2003-10-22 Thread Joseph Allard
This what I got when I tried to install the PHP Forum: Warning: main(./config.php) [function.main]: failed to create stream: Permission denied in /home/content/j/i/g/jigger/html/common.php on line 111 Warning: main() [function.main]: Failed opening './config.php' for inclusion

[PHP-DB] Help installing phpmysearch

2003-10-28 Thread Joseph Allard
I was trying to install phpmysearch but I get this error instead : On your system must have Curl compiled in PHP! - Please check www.php.net how you can do this. Set in your php.ini allow_call_time_pass_reference to On. Well, the problem is that it already says, ON! So, what is the actual

[PHP-DB] PHP2 Forum Crashed

2003-10-28 Thread Joseph Allard
Now, I two seperate problems with two different websites. My PHP2 Forum crashed along with the rest of my website --www.dutchspecialops.com. I called GoDaddy.Com, my host provider and they said that the problem was with us not with their server. However, my web designer insist that it is a parse

Re: [PHP-DB] Help installing phpmysearch

2003-10-29 Thread Joseph Allard
mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Joseph Allard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 3:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Help installing phpmysearch I was trying to install phpmysearch but I get this error instead

[PHP-DB] PHP's Oracle interface

2004-04-19 Thread Joseph Burch
. Has anyone run onto this or similar problems? Thanks, Joseph Burch ITC-UNIX Systems University of Virginia -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] functions via event handlers

2004-09-06 Thread Joseph Crawford
the closest you could come is to make javascript functions call php pages basically redirects that would call the php functions. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] PHP 5 Error Handling

2004-09-14 Thread Joseph Crawford
the actual line number of the line that is the error? the $this-command(NoSuchCommand\n); line. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PHP 5 Error Handling

2004-09-15 Thread Joseph Crawford
can use the info to print to the logs or the screen or ... G. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Joseph Crawford [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14

[PHP-DB] Re: [nyphp-talk] Socket Errors

2004-09-17 Thread Joseph Crawford
be able to connect to the account. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [nyphp-talk] Socket Errors

2004-09-17 Thread Joseph Crawford
be able to connect to the account. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [nyphp-talk] Socket Errors

2004-09-17 Thread Joseph Crawford
be able to connect to the account. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] unsubscribe me

2004-09-22 Thread Joseph Crawford
Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Joseph Crawford
on the activate column 0-1 Is that done through an update mechanism ? Stuart --- Joseph Crawford [EMAIL PROTECTED] wrote: what i did is i used php to create a random string of numbers and letters about 15 chars long, then i store this in the db, and in the email i make the link

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Joseph Crawford
, don't I need the userid or something? or just that it exists in the database? Thank you, Stuart --- Joseph Crawford [EMAIL PROTECTED] wrote: what i did is i used php to create a random string of numbers and letters about 15 chars long, then i store this in the db

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Joseph Crawford
-- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Capturing a sql query

2004-09-29 Thread Joseph Crawford
the results and form the email. Let me take a look at one of these sites to see what exactly you want and can give a better explanation. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] I have a query

2004-09-29 Thread Joseph Crawford
} $result = null; $data = null; this would return a row containing everything you want and would allow you to loop through the rows so you can display them or whatever -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database

Re: [PHP-DB] Capturing a sql query

2004-09-29 Thread Joseph Crawford
for it will basically save these into a database record and use a cron job to pull the latest matches and send the emails. also it just uses those keywords when you use that agent on thier site. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST

Re: [PHP-DB] String handling

2004-09-30 Thread Joseph Crawford
$string = '10001'; if((int)$string) 1) { echo 'Yep it is'; } -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Capturing a sql query

2004-10-01 Thread Joseph Crawford
Not so much that it is bad but you might be storing data you dont need to, all you really need to store are the keywords the person has searched for. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List

Re: [PHP-DB] Capturing a sql query

2004-10-01 Thread Joseph Crawford
why do you need more than a varchar? the persons keywords shouldnt be that much text for each agent maybe PHP+Programming+Vermont -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] which DB to use?

2004-10-01 Thread Joseph Crawford
i am not a fan of microsoft go with mysql :) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Session Objects, Dynamic Parameters

2004-10-04 Thread Joseph Crawford
it as one string, my question is how can i get this to think it is different arguments, i keep getting errors like this mysql error: Unknown MySQL Server Host ''localhost', 'database', 'user', '**'' (-1) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247

Re: [PHP-DB] Re: [users@httpd] November 2, 2004

2004-11-01 Thread Joseph Crawford
Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on a national mailinglist only. i am sorry but i do care, if you do not care about voting you dont care if the war comes to the US. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact

Re: [PHP-DB] php v jsp

2004-11-20 Thread Joseph Crawford
organized way to use PHP when working in a team environment. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Optimize Query Output

2004-11-20 Thread Joseph Crawford
the display really has nothing to do with SQL but rather your php output format. you would use php to display the data however you want it formatted. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http

Fwd: [PHP-DB] Data from a pull down menu

2004-12-10 Thread Joseph Crawford
-- Forwarded message -- From: Joseph Crawford [EMAIL PROTECTED] Date: Fri, 10 Dec 2004 16:00:33 -0500 Subject: Re: [PHP-DB] Data from a pull down menu To: [EMAIL PROTECTED] well are you looking for an automatic page refresh when a name is selected? If so you need to look

Re: [PHP-DB] Re: sessions

2004-12-11 Thread Joseph Crawford
. - gwavasig -- -- ShenKong (shenkong(at)php.net) -- http://www.openphp.cn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED

Re: [PHP-DB] to many addresses

2004-12-27 Thread Joseph Crawford
one thought might be to check thier data for Str, St etc... and have it automatically replace with Street. Another would be to reload the page and give them suggestions on what to use, if they do Rd, have a drop down with Road, Street, Avenue etc.. so they can choose the correct one. -- Joseph

Re: [PHP-DB] Site optimization

2004-12-28 Thread Joseph Crawford
i was wondering this as well :D are there any tools out there to simulate high traffic on your web server say where you specify how many users hit the site at one time and the tool actually hits your server that many times? -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP

Re: [PHP-DB] Getting total results

2004-12-28 Thread Joseph Crawford
this is a good method, however i created a paging class in php 5 and i believe i still have it here locally in php 4 i will get the link soon :D -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Getting total results

2004-12-28 Thread Joseph Crawford
one per page. the php 4 version i will need to zip up locally here and will post it @ http://codebowl.dontexist.org/pager_php4.zip -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting total results

2004-12-28 Thread Joseph Crawford
php 4 version is posted, let me know if you like it or not. Please keep in mind it is a very basic class, you could extend this in many ways, especially to make the nav bar do something like 1 2 3 4 25 26 27 28 -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP

Re: [PHP-DB] Getting total results

2004-12-29 Thread Joseph Crawford
actually, i was not doing anything with it because it was just the class. The way i use it is that i would store the object in a session variable for use accross pages :D -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Joseph Crawford
Jason, can you explain why stripslashes should not be used on data taken from the db? when you store data in the db i thought it was good practice to addslashes, when you retrieve from the db, you will need to use stripslashes to remove the extra \ -- Joseph Crawford Jr. Codebowl Solutions

Re: [PHP-DB] most popular places

2005-02-25 Thread Joseph Crawford
to get into the details you could do seperate queries for the members, pictures, reports and store them as such $citites[$city]['members'] etc... -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] How to programmatically finding freetds.conf location?

2005-03-12 Thread Joseph Crawford
you could execute the exec command in php and run a locate freetds.conf or whereis freetds.conf or find freetds.conf, i believe whereis only locates binary files not sure though. read up on exec here http://us2.php.net/manual/en/function.exec.php -- Joseph Crawford Jr. Codebowl Solutions

Re: [PHP-DB] Test

2005-03-21 Thread Joseph Crawford
/) To unsubscribe, visit: http://www.php.net/unsub.php -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting information on ICQ

2005-05-07 Thread Joseph Crawford
i am sorry but what does this have to do with PHP? -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] addslashes + stripslashes + mysql question

2005-05-16 Thread Joseph Crawford
you might want to check to see if magic quotes GPC is turned on, if it is then you are adding slashes twice. You can either turn it off or do not use addslashes ;) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] Limiting Results

2005-05-19 Thread Joseph Crawford
You could always try the LIMIT keyword :) select a.college, a.state, a.cd http://a.cd/, b.rep from a, b where a.state = al and a.cd http://a.cd/ = 3 or a.state = az and a.cd http://a.cd/ = 1 and a.state = b.state and a.cd http://a.cd/ = b.cd http://b.cd/ LIMIT 50 -- Joseph Crawford Jr

Re: [PHP-DB] registration form with activation code sent to user

2005-06-16 Thread Joseph Crawford
the user as confirmed. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] registration form with activation code sent to user

2005-06-16 Thread Joseph Crawford
['email'] then check the database for the users email and make sure the code matches the one in the database. If it does mark them as confirmed and let them proceed, if not well do nothing. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] Delivery reports about your e-mail

2005-07-01 Thread Joseph Crawford
i am getting those too, seems i talked to gmail and users are spoofing other gmail accounts ;( not sure how we stop this or if we even can. -- Joseph Crawford Jr. Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

[PHP-DB] Fwd: Code Optimization Help

2005-09-20 Thread Joseph Crawford
-OpenDataSource($this-mm_data_dir.'/ds.doc'); $this-obj-ActiveDocument-MailMerge-Execute(); $this-obj-ActiveDocument-SaveAs($this-mm_data_dir.'/'.$template.'.doc'); $this-Close(); $this-Quit(); $this-Release(); } } ? [EMAIL PROTECTED] -- Joseph Crawford Jr. Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL

Re: [PHP-DB] URL Forwarding in PHP...

2005-09-26 Thread Joseph Crawford
header(Location: http://www.php.net/;); note that this cannot be set once any output has been sent to the browser. atleast not without using output buffering. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Searching remote web sites for content

2005-10-22 Thread Joseph Crawford
in the admin area that you push to check and return the results in a nice table. You would not want this check to run with every page load as curl could be time consuming depending on the speed of the site you are checking. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671

Re: [PHP-DB] Re: Subject: Searching remote web sites for content

2005-10-22 Thread Joseph Crawford
why do all that, if you know the address of the page that the link will reside on just curl that page for the results and preg_match that. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Suggestions please!

2005-11-22 Thread Joseph Crawford
out of the box and no security measures were implemented, i did this just to show an example ;) In my system i have user permissions and group permissions, i load the group permissions then override with the user permissions. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc

Re: [PHP-DB] Debugging

2005-12-02 Thread Joseph Crawford
zend studio client/server work hand in hand and are the best debugging tools i have found ;) install zend studio server on the web server and use the zend studio client locally to debug. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] getting rows by an ID field or by another field in a table

2005-12-06 Thread Joseph Crawford
, date, subject FROM journal LIMIT 20); echo 'table'; echo 'trtdSubject/tdtdDate/td/tr'; while($entry=mysql_fetch_array($res)) { echo 'trtda href=details.php ?id='.$entry['id'].''.$entry['subject'].'/a/tdtd'.$entry['date'].'/td/tr'; } echo '/table'; -- Joseph Crawford Jr. Zend Certified Engineer

Re: [PHP-DB] Google Style Search Results

2005-12-07 Thread Joseph Crawford
why not use substr? $preview = substr($string, 0, 50) .'...'; it will probably cut off in the middle of a word, but you can use strpos and check to see if the char is a space to get to the point you want. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021

Re: [PHP-DB] Quick question

2005-12-08 Thread Joseph Crawford
ini_set('max_execution_time', 9600); that's how you set the max_execution_time, i would assume the rest follow the same format. notice the time is in seconds. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

[PHP-DB] Emails Bouncing

2005-12-08 Thread Joseph Crawford
The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address. grisu.itxnet.local #5.1.1 Thanks, -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021

Re: [PHP-DB] Classes and Includes

2005-12-13 Thread Joseph Crawford
include_once('database.php'); -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] PHP4 and Constructor

2007-10-03 Thread Joseph Crawford
the constructor for the Class? Tek -- Joseph Crawford Jr. Zend Certified Engineer http://www.josephcrawford.com/ 1-315-820-4244 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Recommended web developers

2008-06-24 Thread Joseph Crawford
parade. Hopefully you just left out a 0 or two... Ken On Tue, Jun 24, 2008 at 10:00 AM, A. Joseph [EMAIL PROTECTED] wrote: Which company in India or USA can you recommend to design a complex website for my company. The site will be a social site, will include, Blog, Articles, Shops, Music, Movie

Re: [PHP-DB] Im new to this but...

2008-09-02 Thread Joseph Crawford
entries, etc about SQL Injection and how to cleanse your data before throwing a user submitted value at your database. Thanks, Joseph Crawford On Sep 2, 2008, at 3:05 PM, Chris Hale wrote: I have: Apache 2.0.59 MySQL 5.0.41 PHP 4.4.7 5.2.5 and this is my program: ?php session_start

Re: [PHP-DB] how is this line a security risk?

2008-09-23 Thread Joseph Crawford
read up on register_globals. It is a security risk because if i do http://domain.com/file.php?plugins_directory=/directory/ it can reset your variable. the best way to do that is to make PLUGINS_DIR a constant define('PLUGINS_DIR', '/directory/'); Joseph Crawford On Sep 23, 2008, at 12:58

[PHP-DB] Win32 system administrator gpedit.msc

2008-10-10 Thread Abah Joseph
Hi everybody... i`m not a prof in english so please read and understand me.. Thank u. Using the win32 python module can we perform every tasks like *gpedit.msc?* i will like to automate tasks like enabling or disaple some of the windows functions. with my basic experince, you can perform

[PHP-DB] Can MySql handle Large data?

2008-11-17 Thread Abah Joseph
I want to quickly ask if MySql can handle large data like 10 – 20 million rows in one database (e.g member table) The question came to my mind is, How did large website like Yahoo handle such data? Sure. Yahoo users may be more than 20 millions users or so. Users will have -permission table

[PHP-DB] Post/Read tutorial at Tuwana.com

2008-12-05 Thread Abah Joseph
Post your article/tutorial on www.tuwana.com, is a new forum that brings together world programmers and hackers.

[PHP-DB] help me JOIN 3 tables.

2009-01-13 Thread Abah Joseph
I have this SQL SELECT e1.*, l1.* FROM e1 INNER JOIN l1 WHERE e1.entre_active = 'Y' AND l1.entreID = e1.entre_id The above query works but i want to add the one below SELECT SUM(a1.adp_amount) as amount FROM a1 WHERE a1.adp_loanID = e1.loanID; the last part of the query is to SUM the part

[PHP-DB] Help with Web services (facebook, myspace)

2009-01-21 Thread Abah Joseph
Hello PHP people, I`m looking for facebook and myspace API that will enable user to login on my site using their facebook and myspace id. if this is not possible, can i find something closer like, user will be able to perform some activities from my site like inviting facebook/myspace friends,

Re: [PHP-DB] Help with Web services (facebook, myspace)

2009-01-21 Thread Abah Joseph
I just saw something on pear.net http://pear.php.net/package/Services_Facebookmaybe it will work. On Wed, Jan 21, 2009 at 10:27 PM, Chris dmag...@gmail.com wrote: Abah Joseph wrote: Hello PHP people, I`m looking for facebook and myspace API that will enable user to login on my site using

[PHP-DB] Authenticating user using a web service

2009-01-23 Thread Abah Joseph
Well, I have asked this question before but it seems people don`t understood me, my intension is to have a second login option like, user may choose to login with they facebook/myspace/etc id or the local id (my site) on my site, I want a situation whereby anyone can choose to register or use an

[PHP-DB] Role Based Access Control and Role Based Security

2010-01-25 Thread Abah Joseph
Hi list, thank to the wonderful people on this list. I am planning a system that require access to the system based on Role, i love the implementation in SMF(www.simplemachines.org) that every modules can define there own role and but i don`t know how. Users will be in group like Administrator,

[PHP-DB] Module positioning

2010-09-06 Thread Abah Joseph
Sorry if i`m posting on the wrong list. i have used joomla and prestashop open source application and enjoy the way modules are position, prestashop uses HOOK to position modules inside the template while in joomla you define position name and place the module inside the position, in my own

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-14 Thread Abah Joseph
create a file with phpinfo() and make sure mysqli is listed in the loaded modules On Tue, Jun 14, 2011 at 12:07 PM, Niel Archer n...@chance.now wrote: Hello everyone, I am in the process of learning php and I was trying to connect to a mysql database on my own computer(localhost). I

[PHP-DB] installing MySQL with PHP4.0.3pl1

2001-02-13 Thread Paulson, Joseph V. \Jay\
Hello everyone- I'm trying to get MySQL to work with php, however I'm running php on a WinNT box and I was wondering if I needed to install MySQL in a specific location on the hard drive? The reason I as is that when I try to connect to a database I create in MySQL in php it doesn't find any

  1   2   >