[PHP-DB] Re: any ideas?

2003-06-30 Thread Cristian MARIN
Have you print out the query resulted and manually tried in phpMyAdmin? Maybe there is the problem. Anyway, it's better for you to use left join, right join to do what you want to do -- - Cristian MARIN - Developer InterAKT Online (www.interakt.ro)

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-06-30 Thread Lester Caine
(Sorry Greg - Must remember to check return address ;) ) And what about recommending PHP/MySQL as a preferred dev environment? I am currently in the process of several recommendations and wondering if I shouldn't hold off for a while. Maybe its time to bite the bullet and move to PHP/Postgres. Wil

[PHP-DB] Re: ./configure stupidity

2003-06-30 Thread Cristian MARIN
I think it's very good as it is. ./configure actually is almost a standard for every compilation and is not ment to be used by a programmer but by a system admins. Linux is not Windows. If you really want to learn to compile a php create in a day or two a complete line with everything you ever thin

Re: [PHP-DB] non-GPL MySQL licenses & PHP5

2003-06-30 Thread Rasmus Lerdorf
On Tue, 1 Jul 2003, Nabil wrote: > You need to purchase commercial non-GPL MySQL licenses: > > a.. If you distribute MySQL Software with your non open source software, > b.. If you want warranty from MySQL AB for the MySQL software, > c.. If you want to support MySQL development. > So Why it

[PHP-DB] non-GPL MySQL licenses & PHP5

2003-06-30 Thread Nabil
As i read in www.MySQL.com: The software from MySQL AB that you can download from the pages listed below, is licensed under the GNU General Public License (GPL) and is provided "as is" and is without any warranty. You need to purchase commercial non-GPL MySQL licenses: a.. If you distribute My

[PHP-DB] Re: PHP DB Interaction with Javascript?

2003-06-30 Thread jsWalter
"Aaron Wolski" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi All, > > Trying to get my head around something and want to know if it's possible > first. > > Can PHP and Javascript interact to the point of PHP querying a DB to > find out what records are in use as a variable for an

[PHP-DB] Re: MySQL error message...

2003-06-30 Thread Shivanischal A
hi, mysql_query("$command",$mysqlHandle); should actually be mysql_query($command,$mysqlHandle); it works for me. i did not understand rest ur code. but i think should do it. try this and get back if still facing problems. regards, -shiva "Keith Spiller" <[EMAIL PROTECTED]> wrote in message

[PHP-DB] Re: any ideas?

2003-06-30 Thread Shivanischal A
hi, i can think of the following reasons: 1. if its ur query thats failing, then probably the 3 DB tables have columns with the same name. - "and que='checked' order by 'name';" is this without conflict? 2. after ur while loop there is an opening curly brace and no matching closing one. are us

[PHP-DB] Oracle query returning values in sqlplus, but not php.

2003-06-30 Thread Lang Sharpe
Hi all Here is a test version of my script. It queries the data dictionary view ALL_SOURCE. In sqlplus it returns all souce code in the database. In php it returns no rows. The only odd thing about it is that ALL_SOURCE.TYPE is VARCHAR2(12), and 'PACKAGE BODY' is twelve characters long. When I

[PHP-DB] Re: connecting to mySQL - testing server specified does not map to the http://localhost/_MMServerScript/MMHTTPDB.php

2003-06-30 Thread phpWalter
I think de-installing mySQL and PHP might be a bit pre-mature, at least at this point. (This advise is from years of experience trouble shooting this stuff on my different systems. take it as it is given, freely and with a helpful hand. If anyone has issues with this procedure, please advise me wi

Re: [PHP-DB] MySQL error message...

2003-06-30 Thread jeffrey_n_Dyke
mysql knows. this means your query failed, $command resulted in an invalid result set. try adding: or die(mysql_error()); to any call to mysql_query ()so in your code use this: $result = mysql_query("$command",$mysqlHandle) or die(mysql_error()); - and - $resultw = mysql_query("$commandw

[PHP-DB] MySQL error message...

2003-06-30 Thread Keith Spiller
Hello, Does anyone know what would cause this message? Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp\www\bod-rse\bod\menu.php3 on line 49... Here is the code: \n"; $count++; } // IF MENU VALUE == COMMITTEES i

[PHP-DB] Obtaining mysql for php 4.1.2 on Linux

2003-06-30 Thread PHP
Hello, I'm trying to find the mysql.so module for php 4.1.2 on Linux. I don't know which version to use or if mysql is already embedded in the php build. Another option - how do I build php with mysql enabled? Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] setting session variables via a form

2003-06-30 Thread Terry Romine
Not to beat a dead horse, but I have a problem associated with differences between 4.3 and 4.0.6. My local server (Mac OSX) is running 4.3 and has globals off. I designed the code to run with $_SESSION for my log in pages, and they work fine. Then I had to move the files to a client's server an

[PHP-DB] any ideas?

2003-06-30 Thread Addison Ellis
hello and thank you for your time... any ideas why this isn't working? thank you again. best regards, addison $query = "select * from stores,subcategory,category where stores.category = $crow->id and subcategory.category = $crow->id and (stores.city = '$city' and stores.state = '$state')

[PHP-DB] ./configure stupidity

2003-06-30 Thread Nico Sabbi
Hi, I wonder why at compile time ./configure doesn't automatically detect what features are compilable and what not, so as to build in php as much as possible. There isn't even such an option available, with the result that everytime I recompile PHP I end-up missing some group of functions that

[PHP-DB] Re: HELP PLEEASSSEE

2003-06-30 Thread Nadim Attari
> > . > while($row = mysql_fetch_array($result)) > { > ?> > > > . --- USE QUOTES > . while($row = mysql_fetch_array($result)) { ?> . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: PHP help

2003-06-30 Thread Snijders, Mark
think you miss something try this : print_r($_POST); cause from a specific php version (above 4) al lthe form vars are in a special array called ($_POST) (when submitted by a form) so you should do: query="INSERT INTO login VALUES ('$_POST[login]')"; I also removed a " you got one to m

Re: [PHP-DB] Re: PHP help

2003-06-30 Thread Terry Riley
Surely this will fail because $login has not been defined, by use of something like $login = $_REQUEST['login']; I tried the naked code as given, and (as expected) got an error - undefined variable - $login I was under the impression that had to be done for all 'incoming', if it was to be us

[PHP-DB] HELP PLEEASSSEE

2003-06-30 Thread Nabil
I have a form like: . . while($row = mysql_fetch_array($result)) { ?> > http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP help

2003-06-30 Thread Shivanischal A
> My System: > Windows 98 > Apache 1.3.27 > PHP 4 > mysql > > Hello all, I am a PHP beginner and was wondering if I could get some help from some of the more experienced on this list. I have been trying to use an html form (with textboxes, radio buttons, and textareas) to input data into a mysql d

[PHP-DB] Re: PHP help

2003-06-30 Thread JeRRy
PHP file called "addform.php": Okay the line $query is wrong. So I quote... $query="INSERT INTO login VALUES ("'$login')"; You have ("'$login')"; ... Why the " before the '$login? It should be: $query="INSERT INTO login VALUES ('$login')"; Goodluck! http://mobile.yahoo.com.au - Ya

[PHP-DB] Re: PHP help

2003-06-30 Thread Pete Morganic
$query="INSERT INTO login VALUES ('$login')"; have fun Bill Pilgrim wrote: My System: Windows 98 Apache 1.3.27 PHP 4 mysql Hello all, I am a PHP beginner and was wondering if I could get some help from some of the more experienced on this list. I have been trying to use an html form (with