Basile Francesco wrote:
In general, you should not worry about faster query sintax, since mysql
should (but i'm not sure) have an "optimizer" inside wich translate your
sintax query in a "better" efficient one.
Anyway, the "where" statement is perfectly equal to the "join" operator,
it is called
Martin Norland wrote:
Jochem Maas wrote:
I'm not but his original query used JIONs and a LEFT JOIN is (IMHO)
the easiest to understand. I didn't have the presence of mind to
rewrite the query using a simple WHERE clause - hope your tip helps him.
btw: can anyone say if the LEFT JOIN or the alter
Thank you Martin & Richard,
First Richard's question:
I am using the preconfigured binary install package
for Mac OS X 10.3.7 from Marc Liyanage at:
http://www.entropy.ch/
It has support for mysql compiled into it with
the mysql client library ver. 4.1.3beta as
reported by into.php. It does work in
Personally, I would interpolate the $query and $user string like so:
$query = "SELECT credits FROM krypto WHERE user='".$user."' AND
pass='".$pass."'";
Always works for me...
rgd
chris r.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Squeakypants ha scritto:
From a forum that recommended this to me, I changed the query execution to this:
$query = "SELECT credits FROM krypto WHERE user=$user AND pass=$pass";
echo "query = ". $query ."\n";
$result = mysql_query($query);
echo "result = ". $result ."\n";
So now it outputs this:
que
Well, any text elements need single quotes around it for the sql engine to
evaluate it properly
s/b
$query = "SELECT credits FROM krypto WHERE user='$user' AND pass='$pass'";
to give you
query = SELECT credits FROM krypto WHERE user='admin' AND pass=''
bastien
From: Squeakypants <[EMAIL
Squeakypants wrote:
From a forum that recommended this to me, I changed the query execution to this:
$query = "SELECT credits FROM krypto WHERE user=$user AND pass=$pass";
echo "query = ". $query ."\n";
$result = mysql_query($query);
echo "result = ". $result ."\n";
So now it outputs this:
query =
Try this
$query = "SELECT credits FROM krypto WHERE user='$user' AND pass='$pass'";
That should work better then the original query...
Best regards
Andi
Squeakypants schrieb:
From a forum that recommended this to me, I changed the query execution to this:
$query = "SELECT credits FROM krypto WHERE
>From a forum that recommended this to me, I changed the query execution to
>this:
$query = "SELECT credits FROM krypto WHERE user=$user AND pass=$pass";
echo "query = ". $query ."\n";
$result = mysql_query($query);
echo "result = ". $result ."\n";
So now it outputs this:
query = SELECT credits F
Jochem Maas wrote:
I'm not but his original query used JIONs and a LEFT JOIN is (IMHO) the
easiest to understand. I didn't have the presence of mind to rewrite the
query using a simple WHERE clause - hope your tip helps him.
btw: can anyone say if the LEFT JOIN or the alternative WHERE statement
No default support for MySQL in PHP 5. Did you enable it manually?
Rich
-Original Message-
From: Hassan Ebrahimi-Nuyken [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 20, 2005 2:06 PM
To: [email protected]
Subject: [PHP-DB] php5 busts php4 code
Hi,
I am running:
apache 2.0.52
My
In general, you should not worry about faster query sintax, since mysql
should (but i'm not sure) have an "optimizer" inside wich translate your
sintax query in a "better" efficient one.
Anyway, the "where" statement is perfectly equal to the "join" operator,
it is called, in general, "theta-joi
Hassan Ebrahimi-Nuyken wrote:
I am running:
apache 2.0.52
MySQL 4.1.7
php 4.3.9
I have a program for user data entry, retrieval, editing and updating.
Works fine.
When I updated php to 5.0.3:
Data entry works fine (including login with password)
but data requested does not populate populate form an
OR
SELECT b.fldName,
b.fldEmail,
b.fldCountryCode,
d.fldCode as FCode,
b.fldMobile,
a.fldTime as Time,
c.fldUsername as Username
FROM tblSubscribersChoices a
LEFT JOIN tblUser c ON c.fldClientID = a.fldChoice
LEFT JOIN tblSubscribers b ON b.fld
Eve Atley ha scritto:
Platform: Redhat Linux Enterprise WS 3
PHP installed: 4.3.2
MySQL installed: 4.0.21
Apache installed: 2.0.46
When setting up PhpMyAdmin today, I got the error:
Cannot load mysql extension,
Please check PHP configuration
My phpinfo() shows:
'with-mysql=shared,/usr' (yes, the co
Hi,
I am running:
apache 2.0.52
MySQL 4.1.7
php 4.3.9
I have a program for user data entry, retrieval, editing and updating.
Works fine.
When I updated php to 5.0.3:
Data entry works fine (including login with password)
but data requested does not populate populate form anymore.
I have all error re
As an addendum to this,
extension=msyql.so
...is enabled in /etc/php.d/mysql.ini, which the php config states from
which Redhat loads its extensions.
I've also tried:
extension="/usr/lib/php4/mysql.so"
...to no avail.
- Eve
-Original Message-
From: Eve Atley [mailto:[E
Platform: Redhat Linux Enterprise WS 3
PHP installed: 4.3.2
MySQL installed: 4.0.21
Apache installed: 2.0.46
When setting up PhpMyAdmin today, I got the error:
Cannot load mysql extension,
Please check PHP configuration
My phpinfo() shows:
'with-mysql=shared,/usr' (yes, the comma is not a mistak
Jochem Maas ha scritto:
Han wrote:
Hmm,
still no luck. Thanks for the help. I think I'll have to break the
you mean that it still times out? crashes mysql?
maybe the table (tc_countries) is corrupt? try doing a repair.
select up into 2 selects and throw the results of the first into arrays.
Didn'
check the query. make sure you're actually getting $user and $pass
variables. If not, you may need to do:
global $_POST;
$user=$_POST['user'];
$pass=$_POST['pass'];
.
.
.
> Date: Wed, 19 Jan 2005 22:50:49 -0500
> From: Squeakypants <[EMAIL PROTECTED]>
> To: [email protected]
> Subject: Ret
PHP can communicate with flash by passing it xml, or string of data in
key/value pairs...it cannot work inside of flash.
Head over to www.flashkit.com for examples/forums and other info
also see www.phpforflash.com
bastien
From: JeRRy <[EMAIL PROTECTED]>
To: [email protected]
Subject: [PHP-DB]
Hi,
Is it possible to use a PHP script/query in flash?
Just wondering... I have setup some flash on my site.
Wanted to know if I can throw in some PHP in the flash
and if so is it easy ?
What I want to add in the flash is some stats dragged
off a mysql database to appear inside the flash to
s
Squeakypants wrote:
I can't figure this out, it just shows blank...
$user=$_POST['user'];
$pass=$_POST['pass'];
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
You're suppressing the error returned from mysql_select_db with the @
symbol.
On Thu, 20 Jan 2005 14:20, Squeakypants wrote:
> I can't figure this out, it just shows blank...
> $user=$_POST['user'];
> $pass=$_POST['pass'];
>
> mysql_connect($host,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $query = "SELECT credits FROM kry
24 matches
Mail list logo
