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)
(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
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
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
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
"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
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
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
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
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
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
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
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,
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
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')
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
>
> .
> 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
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
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
I have a form like:
.
.
while($row = mysql_fetch_array($result))
{
?>
>
http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> 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 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
$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
23 matches
Mail list logo