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
How about:
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
instead of your line 6 and 7?
And why are you going back to db_query on line 9 instead of staying with
mysql_query?
Also, you might want to check $num_rows = mysql_num_rows($result);
instead of
line 10 $has_tipp
$cols = 2;
echo "";
while ($rows = mysql_fetch_array($result))
{
if (($cols % 2) == 0 ){ echo ""; }
echo "".$rows['something']."";
$c++;
}
echo "";
bastien
From: Mark Bomgardner <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Php-Db
Subject: [PHP-DB] Result set in different column
I am trying to work through some display logic where I want to display a
results set from a database query into to columns in a table, but I
can't see to get it correct.
Example; I want to loop through the months of the year and display them
like this;
JanuaryFebru
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
ORDE
JeRRy wrote:
Hi,
Ahh okay I thought NULL was blank. Okay I understand, therefore, hehe,
I fixed it.
$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 actuall
Hi,
Ahh okay I thought NULL was blank. Okay I understand, therefore, hehe, I
fixed it.
$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
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 from
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:
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)
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)
http://
12 matches
Mail list logo