how do I search two-dimiensional results set array

[NotGiven]

Here's the pertinent code to get the SQL results. It is generated by
dreamweaver adn I'm trying to learn to code php so I don't depend on DW to
do it for me.

$query_rsSummary = "SELECT sid, Count(wid) FROM plotting GROUP BY sid";
$rsSummary = mysql_query($query_rsSummary, $tableG) or die(mysql_error());
$row_rsSummary = mysql_fetch_assoc($rsSummary);
How do I search the array to see if a certain "sid" has an entry in the
array?

Thanks!

[steve]

"NotGiven" wrote:

Here’s the pertinent code to get the SQL results. It is
generated by
dreamweaver adn I’m trying to learn to code php so I don’t
depend on DW to
do it for me.

$query_rsSummary = "SELECT sid, Count(wid) FROM plotting GROUP BY
sid";
$rsSummary = mysql_query($query_rsSummary, $tableG) or
die(mysql_error());
$row_rsSummary = mysql_fetch_assoc($rsSummary);
How do I search the array to see if a certain "sid" has an entry in the
array?

Thanks!

There is an example here for searching multi-dim arrays
http://us4.php.net/manual/en/function.array-search.php

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-search-d...ict144404.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=483158

[Tim Van Wassenhove]

In article <4l*******************@bignews5.bellsouth.net>, NotGiven wrote:

Here's the pertinent code to get the SQL results. It is generated by
dreamweaver adn I'm trying to learn to code php so I don't depend on DW to
do it for me.

$query_rsSummary = "SELECT sid, Count(wid) FROM plotting GROUP BY sid";
$rsSummary = mysql_query($query_rsSummary, $tableG) or die(mysql_error());
$row_rsSummary = mysql_fetch_assoc($rsSummary);
How do I search the array to see if a certain "sid" has an entry in the
array?

Why would you do the searching if you can let MySQL do the searching for
you?

Get yourself a book on databases (sql) and read all you can on the WHERE
clause ;)

--
Tim Van Wassenhove <http://home.mysth.be/~timvw>

[NotGiven]

This is not really a SQL problem. I need the fuill result set. I just
needed to figure out how to loop through the result set in the php code to
display results for each main ID. I'll post the solution a little later.
"Tim Van Wassenhove" <eu**@pi.be> wrote in message
news:2p************@uni-berlin.de...

In article <4l*******************@bignews5.bellsouth.net>, NotGiven wrote:

Here's the pertinent code to get the SQL results. It is generated by
dreamweaver adn I'm trying to learn to code php so I don't depend on DW to do it for me.

$query_rsSummary = "SELECT sid, Count(wid) FROM plotting GROUP BY sid";
$rsSummary = mysql_query($query_rsSummary, $tableG) or die(mysql_error()); $row_rsSummary = mysql_fetch_assoc($rsSummary);
How do I search the array to see if a certain "sid" has an entry in the
array?

Why would you do the searching if you can let MySQL do the searching for
you?

Get yourself a book on databases (sql) and read all you can on the WHERE
clause ;)

--
Tim Van Wassenhove <http://home.mysth.be/~timvw>

[CJ Llewellyn]

"NotGiven" <no****@nonegiven.net> wrote in message
news:4l*******************@bignews5.bellsouth.net. ..

Here's the pertinent code to get the SQL results. It is generated by
dreamweaver adn I'm trying to learn to code php so I don't depend on DW to
do it for me.

$query_rsSummary = "SELECT sid, Count(wid) FROM plotting GROUP BY sid";
$rsSummary = mysql_query($query_rsSummary, $tableG) or die(mysql_error());
$row_rsSummary = mysql_fetch_assoc($rsSummary);
How do I search the array to see if a certain "sid" has an entry in the
array?

You may find aliases invaluable, especially when working with group by
functions:-

$query_rsSummary = "SELECT sid, Count(wid) AS c_wid FROM plotting GROUP BY
sid";
$rsSummary = mysql_query($query_rsSummary, $tableG) or die(mysql_error());

http://www.php.net/manual/en/functio...etch-assoc.php

while($row = mysql_fetch_assoc($rsSummary))
{
if($row['sid'] == 'whatever')
{
printf("SID %s occurs %s times in this data",
$row['sid'],
$row['c_wid']);
}
}

[Samu]

If you just need to know if the data requested is present at all you
could try this: http://us4.php.net/manual/en/function.in-array.php

t samu

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-search-d...ict144404.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=483159