Trouble running a select query against a database, when I know the connection is working, and the da

I am trying to simply just loop through a set of records to spit out

Re: Trouble running a select query against a database, when

On 13 April 2010 09:36, Jacob Kruger wrote:
> if ($arr.count > 0)

Try ...

if (mysql_num_rows($arr) > 0)

--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database, when I know the connection is working, and th

------=_NextPart_000_00BC_01CADAFE.2DCA9540
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks.

Will try it out - think the .count is just related to $arr being sort of =
an array of records - and think I got it out of the PHP tutorial from =
w3schools.com, and it's worked on other pages.

Anyway, the following does now seem to work fine:

$qry =3D mysql_query($sql);
if (mysql_num_rows($qry) > 0)
{
echo "

";
while($row =3D mysql_fetch_array($qry))
{
echo "
• " . $row['LinkName'] . " - " . $row['LinkDescription'] . " - =
  ";
  echo "" . =
  $row['LinkURL'] . "
";
}
echo "

Re: Trouble running a select query against a database,when I know the connection is working, and the

On 4/13/2010 9:36 AM, Jacob Kruger wrote:
> $qry = mysql_query($sql);
> $arr = mysql_fetch_array($qry);
> if ($arr.count > 0)
> {
> echo "

";
> while($row = mysql_fetch_array($arr))

You retrieve a row, check if it has any elements, then attempt to
retrieve the next row, using the array you just created as the argument.
You should be using $qry as the argument, but you're skipping over the
first row.

Toby

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database, when

On 13 April 2010 10:40, Jacob Kruger wrote:
> Thanks.
>
> Will try it out - think the .count is just related to $arr being sort of =
an array of records - and think I got it out of the PHP tutorial from w3sch=
ools.com, and it's worked on other pages.
>
> Anyway, the following does now seem to work fine:
>
> $qry =3D mysql_query($sql);
> if (mysql_num_rows($qry) > 0)
> {
> echo "

";
> while($row =3D mysql_fetch_array($qry))
>  {
> echo "
• " . $row['LinkName'] . " - " . $row['LinkDescription'] . " - ";
  > echo "" . $row['Lin=
  kURL'] . "
";
>  }
> echo "

Re: Trouble running a select query against a database, when

On 13 April 2010 11:00, Toby Hart Dyke wrote:
> On 4/13/2010 9:36 AM, Jacob Kruger wrote:
>>
>> $qry =3D mysql_query($sql);
>> $arr =3D mysql_fetch_array($qry);
>> if ($arr.count > 0)
>> {
>> echo "

";
>> while($row =3D mysql_fetch_array($arr))
>
> You retrieve a row, check if it has any elements, then attempt to retriev=
e
> the next row, using the array you just created as the argument. You shoul=
d
> be using $qry as the argument, but you're skipping over the first row.
>
>  Toby
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Good catch Toby.

--=20
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213474=
731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database, when I know the connection is working, and th

Yup, figured that one out as well.

Thanks

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "Toby Hart Dyke"
To: "Jacob Kruger"
Cc:
Sent: Tuesday, April 13, 2010 12:00 PM
Subject: Re: [PHP-WIN] Trouble running a select query against a database,
when I know the connection is working, and the data is there


> On 4/13/2010 9:36 AM, Jacob Kruger wrote:
>> $qry = mysql_query($sql);
>> $arr = mysql_fetch_array($qry);
>> if ($arr.count > 0)
>> {
>> echo "

";
>> while($row = mysql_fetch_array($arr))
>
> You retrieve a row, check if it has any elements, then attempt to retrieve
> the next row, using the array you just created as the argument. You should
> be using $qry as the argument, but you're skipping over the first row.
>
> Toby
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5024 (20100413) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5024 (20100413) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database, when I know the connection is working, and th

Thanks - will definitely be setting errors to show all as well - in old days
with classic ASP, it was around the first server settings change you
implemented to test/develop things.

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "Richard Quadling"
To: "Jacob Kruger"
Cc:
Sent: Tuesday, April 13, 2010 12:01 PM
Subject: Re: [PHP-WIN] Trouble running a select query against a database,
when I know the connection is working, and the data is there


On 13 April 2010 10:40, Jacob Kruger wrote:
> Thanks.
>
> Will try it out - think the .count is just related to $arr being sort of
> an array of records - and think I got it out of the PHP tutorial from
> w3schools.com, and it's worked on other pages.
>
> Anyway, the following does now seem to work fine:
>
> $qry = mysql_query($sql);
> if (mysql_num_rows($qry) > 0)
> {
> echo "

";
> while($row = mysql_fetch_array($qry))
> {
> echo "
• " . $row['LinkName'] . " - " . $row['LinkDescription'] . " - ";
  > echo "" .
  > $row['LinkURL'] . "
";
> }
> echo "

Re: Trouble running a select query against a database, when I know the connection is working, and th

Thanks.

Figured it out, and also know shouldn't just copy and paste too much code as
such...

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "Toby Hart Dyke"
To: "Jacob Kruger"
Cc:
Sent: Tuesday, April 13, 2010 12:00 PM
Subject: Re: [PHP-WIN] Trouble running a select query against a database,
when I know the connection is working, and the data is there


> On 4/13/2010 9:36 AM, Jacob Kruger wrote:
>> $qry = mysql_query($sql);
>> $arr = mysql_fetch_array($qry);
>> if ($arr.count > 0)
>> {
>> echo "

";
>> while($row = mysql_fetch_array($arr))
>
> You retrieve a row, check if it has any elements, then attempt to retrieve
> the next row, using the array you just created as the argument. You should
> be using $qry as the argument, but you're skipping over the first row.
>
> Toby
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5026 (20100413) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5026 (20100413) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database, when I know the connection is working, and th

Thanks.

Will be honest, and while have played around with PHP etc., have never
really done much with it in terms of going into production as such anyway,
so, yes, will need to learn/figure out how to do things the best way, etc.

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "Jean Delefrati"
To: "Jacob Kruger"
Sent: Wednesday, April 14, 2010 10:29 PM
Subject: Re: [PHP-WIN] Trouble running a select query against a database,
when I know the connection is working, and the data is there


You should try add some "or"(s) in your script - so, if an error
ocurred, you can kill your script.

Like this:

$qry = mysql_query($sql) or die("An error ocurred: " . mysql_error());

Of course you shouldn't put the mysql_error() in the final code, for
security issues, just replace by one better message to your users.

[ ]'s!

Jean Rafael

2010/4/13 Jacob Kruger :
> Thanks.
>
> Figured it out, and also know shouldn't just copy and paste too much code
> as
> such...
>
> Stay well
>
> Jacob Kruger
> Blind Biker
> Skype: BlindZA
> '...fate had broken his body, but not his spirit...'
>
> ----- Original Message ----- From: "Toby Hart Dyke"
> To: "Jacob Kruger"
> Cc:
> Sent: Tuesday, April 13, 2010 12:00 PM
> Subject: Re: [PHP-WIN] Trouble running a select query against a database,
> when I know the connection is working, and the data is there
>
>
>> On 4/13/2010 9:36 AM, Jacob Kruger wrote:
>>>
>>> $qry = mysql_query($sql);
>>> $arr = mysql_fetch_array($qry);
>>> if ($arr.count > 0)
>>> {
>>> echo "

";
>>> while($row = mysql_fetch_array($arr))
>>
>> You retrieve a row, check if it has any elements, then attempt to
>> retrieve
>> the next row, using the array you just created as the argument. You
>> should
>> be using $qry as the argument, but you're skipping over the first row.
>>
>> Toby
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus
>> signature database 5026 (20100413) __________
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>>
>>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature
> database 5026 (20100413) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5029 (20100414) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 5029 (20100414) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database,when I know the connection is working, and the

On 04/14/2010 08:48 PM, Jacob Kruger wrote:
> Thanks.
>
> Will be honest, and while have played around with PHP etc., have never
> really done much with it in terms of going into production as such
> anyway, so, yes, will need to learn/figure out how to do things the
> best way, etc.
>
> Stay well
>
> Jacob Kruger
> Blind Biker
> Skype: BlindZA
> '...fate had broken his body, but not his spirit...'
And while you are trying to learn good habits look at SQL Injection
attacks. Using something like $_REQUEST['id'] in a query is just asking
for it. Many of the PHP and MySQL tutorials I have seen barely mention
this problem, if at all.

Consider if someone had sent your script a URL like this:
scipt.php?id='';DELETE FROM table tblLinks;
If the user running the mysql_query() function had the rights to delete
rows on the tblLinks table, the tblLinks table would be empty.

Cheers,
James

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Trouble running a select query against a database, when I know the connection is working, and th

I know - used to deal with/handle SQL injection prevention quite a bit in
old days - and think have already got one or two code samples for
counteracting it in PHP/MySQL, and they would generally be kept in functions
in a general include file, to be included in all database accessing pages,
and I would also generally not make too much use of querystring/get data
passing in that sense either, but anyway...

One of the workarounds looked into in the past was where it would also just
look like a standard link on a page, but where it would actually do a
form of hidden form submission where hidden fields would be set with certain
values, either dynamically hard coded, or set using javascript etc., which
could also be worked around by submitting a form from another source, but it
really also depended on the target production environment since while I know
there are automated robotic SQLInjection implementations out there, they
would still also be more likely to target websites that generate more
traffic as such, etc. etc.

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message -----
From: "James Crow"
To:
Sent: Thursday, April 22, 2010 5:27 PM
Subject: Re: [PHP-WIN] Trouble running a select query against a database,
when I know the connection is working, and the data is there


> On 04/14/2010 08:48 PM, Jacob Kruger wrote:
>> Thanks.
>>
>> Will be honest, and while have played around with PHP etc., have never
>> really done much with it in terms of going into production as such
>> anyway, so, yes, will need to learn/figure out how to do things the best
>> way, etc.
>>
>> Stay well
>>
>> Jacob Kruger
>> Blind Biker
>> Skype: BlindZA
>> '...fate had broken his body, but not his spirit...'
> And while you are trying to learn good habits look at SQL Injection
> attacks. Using something like $_REQUEST['id'] in a query is just asking
> for it. Many of the PHP and MySQL tutorials I have seen barely mention
> this problem, if at all.
>
> Consider if someone had sent your script a URL like this:
> scipt.php?id='';DELETE FROM table tblLinks;
> If the user running the mysql_query() function had the rights to delete
> rows on the tblLinks table, the tblLinks table would be empty.
>
> Cheers,
> James
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5051 (20100422) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5051 (20100422) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php