[Wolves] LIST - Meeting at "The Moon Under Water" (Matt)
Matthew Steer
matthewsteer at impactapplications.com
Tue Jul 9 12:14:26 UTC 2013
Hi Guys, I should attend this meeting if ok, I would like to talk about the Cyber Security Challenge (https://cybersecuritychallenge.org.uk/) if that is acceptable.
Wednesday 10 Jul 2013 - 7:30 pm - 23:00 pm
53-55 Lichfield St
Wolverhampton
West Midlands
WV1 1EQ
http://www.openstreetmap.org/?lat=52.58683&lon=-2.12416&zoom=17&layers=B000FTF
Eat, Drink and talk Linux
Goes:
.---- Ron Wellsted
...---... Dave Morley
...-- Iain Cuthbertson
....- Ad
.....-Matt (1st time)
Late/Maybe:
NoGoes:
-----Original Message-----
From: wolves-bounces at mailman.lug.org.uk [mailto:wolves-bounces at mailman.lug.org.uk] On Behalf Of wolves-request at mailman.lug.org.uk
Sent: 09 July 2013 13:00
To: wolves at mailman.lug.org.uk
Subject: Wolves Digest, Vol 488, Issue 1
Send Wolves mailing list submissions to
wolves at mailman.lug.org.uk
To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/wolves
or, via email, send a message with subject or body 'help' to
wolves-request at mailman.lug.org.uk
You can reach the person managing the list at
wolves-owner at mailman.lug.org.uk
When replying, please edit your Subject line so it is more specific than "Re: Contents of Wolves digest..."
Today's Topics:
1. LIST - Meeting at "The Moon Under Water" (Ron Wellsted)
2. Re: LIST - Meeting at "The Moon Under Water" (Dave Morley)
3. Re: LIST - Meeting at "The Moon Under Water" (Iain Cuthbertson)
4. Re: LIST - Meeting at "The Moon Under Water" (Adam Sweet)
5. PHP Sql select losing a row (Wayne Morris)
6. Re: PHP Sql select losing a row (David Goodwin)
----------------------------------------------------------------------
Message: 1
Date: Mon, 08 Jul 2013 15:13:03 +0100
From: Ron Wellsted <ron at wellsted.org.uk>
To: Wolverhampton Linux User Group <wolves at mailman.lug.org.uk>
Subject: [Wolves] LIST - Meeting at "The Moon Under Water"
Message-ID: <51DAC8EF.4060101 at wellsted.org.uk>
Content-Type: text/plain; charset=ISO-8859-1
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Wednesday 10 Jul 2013 - 7:30 pm - 23:00 pm
53-55 Lichfield St
Wolverhampton
West Midlands
WV1 1EQ
http://www.openstreetmap.org/?lat=52.58683&lon=-2.12416&zoom=17&layers=B000FTF
Eat, Drink and talk Linux
Goes:
.---- Ron Wellsted
Late/Maybe:
NoGoes:
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/
iEYEARECAAYFAlHayOkACgkQ8lOfTmhjD3MxqgCfRi3yA5JvHrIvHY5cpnFFoaHE
blIAnRsR9xxCkxMaZweao1L6URl+D5Iz
=k8MC
-----END PGP SIGNATURE-----
------------------------------
Message: 2
Date: Mon, 08 Jul 2013 15:16:17 +0100
From: Dave Morley <davmor2 at davmor2.co.uk>
To: wolves at mailman.lug.org.uk
Subject: Re: [Wolves] LIST - Meeting at "The Moon Under Water"
Message-ID: <51DAC9B1.8050601 at davmor2.co.uk>
Content-Type: text/plain; charset=ISO-8859-1
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 08/07/13 15:13, Ron Wellsted wrote:
> Wednesday 10 Jul 2013 - 7:30 pm - 23:00 pm 53-55 Lichfield St
> Wolverhampton West Midlands WV1 1EQ
>
> http://www.openstreetmap.org/?lat=52.58683&lon=-2.12416&zoom=17&layers
> =B000FTF
>
>
>
> Eat, Drink and talk Linux
>
> Goes: .---- Ron Wellsted
...---... Dave Morley
>
> Late/Maybe:
>
>
> NoGoes:
>
>
>
- --
You make it, I'll break it!
I love my job :)
http://www.ubuntu.com
http://www.canonical.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/
iEYEARECAAYFAlHayaoACgkQT5xqyT+h3OhIvQCfThV8f4zpO380unLAqfOdJ6K/
HWYAnR4vDyRQ3fkwE3+8Eyad21Hgyuf3
=4mlq
-----END PGP SIGNATURE-----
------------------------------
Message: 3
Date: Mon, 08 Jul 2013 15:49:53 +0100
From: Iain Cuthbertson <iain at cuth.eu>
To: wolves at mailman.lug.org.uk
Subject: Re: [Wolves] LIST - Meeting at "The Moon Under Water"
Message-ID: <51DAD191.7030700 at cuth.eu>
Content-Type: text/plain; charset=ISO-8859-1
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 08/07/13 15:16, Dave Morley wrote:
> On 08/07/13 15:13, Ron Wellsted wrote:
>> Wednesday 10 Jul 2013 - 7:30 pm - 23:00 pm 53-55 Lichfield St
>> Wolverhampton West Midlands WV1 1EQ
>
>> http://www.openstreetmap.org/?lat=52.58683&lon=-2.12416&zoom=17&layer
>> s=B000FTF
>
>>
>
>
>> Eat, Drink and talk Linux
>
>> Goes: .---- Ron Wellsted
> ...---... Dave Morley
...-- Iain Cuthbertson
>
>> Late/Maybe:
>
>
>> NoGoes:
>
>
>
>
>
> _______________________________________________ Wolves LUG mailing
> list Homepage: http://www.wolveslug.org.uk/ Mailing list:
> Wolves at mailman.lug.org.uk Mailing list home:
> https://mailman.lug.org.uk/mailman/listinfo/wolves
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/
iQEcBAEBAgAGBQJR2tGOAAoJELCAdbQXOalfvbQH/2E2Ngor2ZjktYVup9KdNcM6
3/+PtU/iQWSQa1Qxnxac5LeQ1/OIsHVMhu0nSCNouZiammA0GKHKggbaGYGhL59A
IjQouIKyK1MOlM/UhU241SwKZ0D2B6XFr8Ti3SwQfmsJeOVjY136rTODQ4h/2peD
c3a6kIGA+NvtriGoSqghgFF6odtXHcIln/lM9QGkuqPEh8C1v0Y2MPwhf4Fnnkxd
a4cbJHEEcLMbe2LDafxrD/a7x026ovgdyxNjdhR1kPKQG6wuHhwpKdUw398ChL0I
5z5IiGQasKyQM0k3J0uL9yF0qOCU8Bq1IF7qmbJSVI0Bw+oEgnjA1K+zm0SaRGc=
=g/oj
-----END PGP SIGNATURE-----
------------------------------
Message: 4
Date: Tue, 09 Jul 2013 10:29:06 +0100
From: Adam Sweet <adam at adamsweet.org>
To: wolves at mailman.lug.org.uk
Subject: Re: [Wolves] LIST - Meeting at "The Moon Under Water"
Message-ID: <51DBD7E2.60800 at adamsweet.org>
Content-Type: text/plain; charset=ISO-8859-1
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Wednesday 10 Jul 2013 - 7:30 pm - 23:00 pm
53-55 Lichfield St
Wolverhampton
West Midlands
WV1 1EQ
http://www.openstreetmap.org/?lat=52.58683&lon=-2.12416&zoom=17&layers=B000FTF
Eat, Drink and talk Linux
Goes:
.---- Ron Wellsted
...---... Dave Morley
...-- Iain Cuthbertson
....- Ad
Late/Maybe:
NoGoes:
Regards,
Adam Sweet
- --
http://blog.adamsweet.org/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/
iEYEARECAAYFAlHb1+IACgkQRi1ZcmvD37cjmQCggXGtRSGnKVT51f0k3o+7pvlO
RTkAoJsUmkHamJr/iDhN1MbUjslZX27X
=C6g3
-----END PGP SIGNATURE-----
------------------------------
Message: 5
Date: Tue, 09 Jul 2013 11:46:34 +0100
From: Wayne Morris <waynelists at machx.co.uk>
To: Wolverhampton Linux User Group <wolves at mailman.lug.org.uk>
Subject: [Wolves] PHP Sql select losing a row
Message-ID: <51DBEA0A.5010102 at machx.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi,
I have the following select which loses one row from the database - ie it produces 4 rows instead of the correct 5.
And ideas what I am doing wrong?
$queryz = "SELECT *
FROM property
WHERE postcode like '%$postcodevoid%' and let = '1'
";
$resultz = mysql_query($queryz);
$num_rows = mysql_num_rows($resultz); $rowz = mysql_fetch_array($resultz);
for($i=1; $i <= $num_rows; $i++)
while($rowz = mysql_fetch_array($resultz)) {
print("<TABLE border=\"1\" cellspacing\"0\" cellpadding=\"0\" width=100%
style=\"font-size: 10pt\">\n");
print("<TD width=10% wrap style=\"wrap: 1 solid
#800000\">".$rowz["address1"]." </td> ". " ");
print("<TD width=5% wrap style=\"wrap: 1 solid
#800000\">".$rowz["address2"]." </td>");
print("<TD width=5% wrap style=\"wrap: 1 solid
#800000\">".$rowz["postcode"]." </td>");
}
cheers
------------------------------
Message: 6
Date: Tue, 9 Jul 2013 12:01:06 +0100
From: David Goodwin <david at codepoets.co.uk>
To: Wolverhampton Linux User Group <wolves at mailman.lug.org.uk>
Subject: Re: [Wolves] PHP Sql select losing a row
Message-ID: <EE632BF6-B8BC-4E27-8AF1-1800D2052718 at codepoets.co.uk>
Content-Type: text/plain; charset=windows-1252
On 9 Jul 2013, at 11:46, Wayne Morris <waynelists at machx.co.uk> wrote:
> Hi,
>
> I have the following select which loses one row from the database - ie it produces 4 rows instead of the correct 5.
> And ideas what I am doing wrong?
Yes.
>
> $queryz = "SELECT *
> FROM property
> WHERE postcode like '%$postcodevoid%' and let = '1'
>
> ";
>
1. Using silly variable names.
2. Probably writing code that's vulnerable to SQL injection. Please make sure you run $postcodevoid = mysql_real_escape_string($postcodevoid) or the equivalent.
> $resultz = mysql_query($queryz);
> $num_rows = mysql_num_rows($resultz);
> $rowz = mysql_fetch_array($resultz);
>
> for($i=1; $i <= $num_rows; $i++)
>
3. Wrapping the while loop in a for loop ?. and starting that loop count at 1, instead of 0.
>
> while($rowz = mysql_fetch_array($resultz)) {
>
> print("<TABLE border=\"1\" cellspacing\"0\" cellpadding=\"0\" width=100% style=\"font-size: 10pt\">\n");
> print("<TD width=10% wrap style=\"wrap: 1 solid #800000\">".$rowz["address1"]." </td> ". " ");
> print("<TD width=5% wrap style=\"wrap: 1 solid #800000\">".$rowz["address2"]." </td>");
> print("<TD width=5% wrap style=\"wrap: 1 solid #800000\">".$rowz["postcode"]." </td>");
> }
You probably just want :
//...
mysql_connect(?.);
mysql_select_db(?.);
// ?.
$postcode = mysql_real_escape_string($_GET['postcode']); /* I presume */
$query = "SELECT * FROM property WHERE postcode like '%$postcode%' AND let = '1'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
echo "??.blah bah blah {$row['address1']} blah blah blah {$row['address2']} ?. \n";
}
David.
------------------------------
_______________________________________________
Wolves mailing list
Wolves at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/wolves
End of Wolves Digest, Vol 488, Issue 1
**************************************
More information about the Wolves
mailing list