Okay here is the full code. Now I got this code off a friend! In this first
section to display the data that is grabbed from the db.
?php
$db = mysql_connect(localhost, user, pass);
mysql_select_db(db_select,$db);
$result = mysql_query(SELECT `nickname` FROM tipping
WHERE 1
JeRRy wrote:
Okay here is the full code. Now I got this code off a friend! In this first
section to display the data that is grabbed from the db.
?php
$db = mysql_connect(localhost, user, pass);
mysql_select_db(db_select,$db);
$result = mysql_query(SELECT `nickname` FROM
Hi,
Okay I played with the code a bit and ended up with this, it does NOT produce
errors but it's not doing anything. Connects to the db but does not do the
mail out. Maybe I missed something said before, but here you go, the link
below with the code. (it's probably basic)
JeRRy wrote:
Hi,
Okay I played with the code a bit and ended up with this, it does NOT
produce errors but it's not doing anything. Connects to the db but does
not do the mail out. Maybe I missed something said before, but here you
go, the link below with the code. (it's probably basic)
JeRRy wrote:
Hi,
Okay I played with the code a bit and ended up with this, it does NOT
produce errors but it's not doing anything. Connects to the db but does
not do the mail out. Maybe I missed something said before, but here you
go, the link below with the code. (it's probably basic)
Okay, but still not working...
is NULL the same as ' '? Or does NULL have to be the inserted value in the
db?
J
Chris [EMAIL PROTECTED] wrote:
JeRRy wrote:
Hi,
Okay I played with the code a bit and ended up with this, it does NOT
produce errors but it's not doing
JeRRy wrote:
Okay, but still not working...
is NULL the same as ' '? Or does NULL have to be the inserted value in
the db?
Null means unknown - so completely different to ' ' or ''.
How was your table created?
What do you get if you run that query through phpmyadmin:
select username
Hi,
Ahh okay I thought NULL was blank. Okay I understand, therefore, hehe, I
fixed it.
snip
$query = select username from round3 where misc='';
fixed it, the email got sent.
Had to change a few strings also to match my database which I was not aware
of. Forgot
JeRRy wrote:
Hi,
Ahh okay I thought NULL was blank. Okay I understand, therefore, hehe,
I fixed it.
snip
$query = select username from round3 where misc='';
fixed it, the email got sent.
Had to change a few strings also to match my database which I was not
aware of. Forgot it
Okay I have the emails to work now, thanks so much Chris. But now I have
encountered another problem, I hope you don't mind helping, I am obviously
missing again something basic. Basic than before.
I have this code:
$result = mysql_query(SELECT `nickname` FROM tipping
WHERE 1
)) {
-Original Message-
From: JeRRy [mailto:[EMAIL PROTECTED]
Sent: Monday, April 10, 2006 2:37 AM
To: Chris
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] grabbing data and auto email set users
Hi,
Okay I played with the code a bit and ended up with this, it does NOT
produce errors but it's
JeRRy wrote:
Okay I have the emails to work now, thanks so much Chris. But now I
have encountered another problem, I hope you don't mind helping, I am
obviously missing again something basic. Basic than before.
I have this code:
$result = mysql_query(SELECT `nickname` FROM tipping
WHERE
JeRRy wrote:
Hi,
No code here unless required.
I run this tipping site. All user details are in a table called tipping which stores their id, username, password, email address, score and others.
Than I have tables round 1 through to round 22. (all seperate tables)
This
Hi,
I used the following but got this error:
Fatal error: Call to undefined function: db_fetch() in
/home/tassie/public_html/tipping/admin/check.php on line 7
Any help please?
J
$query = select * from users;
$result = mysql_query($query);
while($row =
JeRRy wrote:
Hi,
I used the following but got this error:
*Fatal error*: Call to undefined function: db_fetch() in
*/home/tassie/public_html/tipping/admin/check.php* on line *7*
As I said:
db_query will depend on your database (ie mysql_query or pg_query or
Hi,
Okay I must be missing something here.
I changed it to mysql_query and no errors produce however no emails are
sent either. After cross-checking back and fourth with my db the entries are
correct.
A connection is made and establlished. maybe I need to place some eror
JeRRy wrote:
Hi,
Okay I must be missing something here.
I changed it to mysql_query and no errors produce however no emails
are sent either. After cross-checking back and fourth with my db the
entries are correct.
A connection is made and establlished. maybe I need to place some eror
17 matches
Mail list logo
