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 krypto WHERE
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.
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
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: php-db@lists.php.net
Subject: Returns
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.
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
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
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
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
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
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
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-join and in
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: php-db@lists.php.net
Subject: [PHP-DB] php5 busts php4 code
Hi,
I am running:
apache 2.0.52
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
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 FROM krypto
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
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 = SELECT
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 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:
query =
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
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
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
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, in
23 matches
Mail list logo