Why don't you use mysql_fetch_assoc() instead? You can address your fields
directly, as in:
while($row_FOTOS=mysql_fetch_assoc($result))
{
echo "height='384' />";
echo "height='384' />";
}
Alternatively, you can specify which fields you want in your SQL statement:
$sql = "SEL
Hello everyone
First, I thank you all for the help on the past week.
I could do the finder... thank you very much.
Now... I must print images from the product. But the data about the product
is in a table and the pictures are in other table.
The picture table has 12 columns, the first tw
Hello,
Can anyone from the lists please tell me why this bit of code is not
picking up on the first record in the database? If the 'id' I'm looking
for is '1' it doesn't populate the _SESSION variables. Any 'id' greater
then '1' will populate the _SESSION variables.
$q = "SELECT * FROM emplo
Hey thanks Mike
that surly made a difference.
Earl
'
- Original Message -
From: "Ford, Mike [LSS]" <[EMAIL PROTECTED]>
To: "'Earl'" <[EMAIL PROTECTED]>; "PHP-DB" <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 6:13 AM
> -Original Message-
> From: Earl [mailto:[EMAIL PROTECTED]
> Sent: 04 June 2003 22:04
> To: PHP-DB
>
> FYI
> this was beginning to bug me out... so I decided to try the
> trim function
> and walla... it worked.
>
> Thanks for ya'll assistance.
I was going to say this even before yo
FYI
this was beginning to bug me out... so I decided to try the trim function
and walla... it worked.
Thanks for ya'll assistance.
---
$eventQuery=ifx_query('select * from event'
.' where e_date >= today '
'3';
$s_lt='ML';
$t_lt='TM';
}
else
$r_away['sport']='4';
$r_home['sport']='4';
$s_lt='ML';
$t_lt='TM';
$r_away['rotation']=$cols['out_id'];
$r_home['rotation
y['sport']='3';
$r_home['sport']='3';
$s_lt='ML';
$t_lt='TM';
}
else
$r_away['sport']='4';
$r_home['sport']='4';
$s_lt='ML';
$t_lt='TM';
$r_away['rotation']=$cols['out_id'];
$r_home['rota
;sport']='2';
$s_lt='PS';
$t_lt='TP';
}
elseif ($cols['s_acro']=='B')
{
$r_away['sport']='3';
$r_home['sport']='3';
$s_lt='ML';
$t_lt='TM';
}
else
$r_a
Hey guys, I've got a problem with this piece of code
it is skipping the contents of the if and elseif statements and only printing the else
values, even though the if or one of the elseif statements might be true.
what could possibly be the problem??
--
I would appreciate some help with the following code. I have presented a
user with a table of session workshops for a conference. There is a select
list called "rank", and the value is the workshop letter and number with the
user's ranking, e.g. "B12-1 B12-2, B12-3" for each workshop.
The following
if(category = 'bla')
Maybe you shouldn't be using a constant if it's going to be changing each
time the page loads.
---John Holmes...
- Original Message -
From: "Shachar Tal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 23
-- Original Message -
> From: "Jason Wong" <[EMAIL PROTECTED]>
> Newsgroups: php.db
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, January 23, 2003 11:54 AM
> Subject: Re: [PHP-DB] While + Function
>
>
>> On Thursday 23 January 2003 06:04, S
en, I want
to check what it is, like
if constant(category) = "bla" {
}
whats the syntax for checking the value of it?
thanks
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
Newsgroups: php.db
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 2
On Thursday 23 January 2003 06:04, Shahar Tal wrote:
> Hello all!
>
> I got one page, with this code:
>
> echo insert_results();
> ?>
>
> Which grabs the data I send from another page, on that function.
> Here is the important part of the function while code:
>
> while ($row = mysql_fetch_array($r
Hello all!
I got one page, with this code:
Which grabs the data I send from another page, on that function.
Here is the important part of the function while code:
while ($row = mysql_fetch_array($result)){
function insert_results () {
extract($row);
echo "bla";
}
}
Ok, this
TECTED];
> [EMAIL PROTECTED]
> Subject: [PHP-DB] while...if statements???
>
> Does anyone know why this isn't working?? What I am trying to do is
> display
> photos from a database based on each month. This part works fine when I
> set
> it to the current
Does anyone know why this isn't working?? What I am trying to do is display
photos from a database based on each month. This part works fine when I set
it to the current month of December (today) as that is when I uploaded the
photos.
However, when I manually set the date to a month that has n
Richard,
What can one say? Too late? Too long looking at it? Reading too quickly?
or in the immortal wordsof Charlie Brow " AUUGH!"
Thanks a million and love your signature.
Miles Thompson
At 03:30 PM 2/21/01 +, [EMAIL PROTECTED] wrote:
> while( $row = mysql_fetch_array( $result ) )
Remove the semi-colon after your while() statement.
> -Original Message-
> From: Miles Thompson [mailto:[EMAIL PROTECTED]]
> Sent: 21 February 2001 15:01
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] while loop driving me crazy
>
>
> I've used a similar str
BDY.RTF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
I've used a similar structure hundreds of times, but the following isn't
working:
$result = mysql_query($sql,
$db);
if( !$result ) { echo "No result code in SQL send. ";
}
if( mysql_num_rows( $result ) >= 1
)
{
echo "Rows fetched: ", mysql_num_rows( $result ),
"";
while( $row = m
22 matches
Mail list logo
