searching in multidimensional array for a date::
I dont need key 2 with Date value repeted. as u can see, if we get no results, we take the search date, and subtract 1 day
http://www.phpfreaks.com/forums/index.php?topic=176715.0HOME |
I'm queryng mysql database:
$result= mysql_query("SELECT * FROM $table" ,$link);
while ($row = mysql_fetch_array($result)){
And then I try to echo results:
echo "
";
echo $row['size'];
echo $row['age'];
General Discussion of First Page - Page 19 - Webmaster Forums::
form script which publishes results to browser. yorkshirelad. 10-04 Repeted results in query? Elhombrebala. 09-24-2004 06:49 AM. by webrazor. 3. 1,134
http://developers.evrsoft.com/forum/forumdisplay.php?f=79&page=19&order=descHOME |
vB Easy Archive - Microsoft excel misc::
I want the results of a formula to show in cell, NOT THE FORMULA! Disable Query Refresh warning dialog box in Excel 2003. Optimize SumProduct
http://www.msusenet.com/history/forum.php/19-329.htmlHOME |
echo "
";
}
IF my table look like this:
num weight size age
------------------------------------------
1 45 1,60 17
------------------------------------------
2 56 1,78 19
------------------------------------------
3 47 1,67 18
------------------------------------------
I think I should get this:
1,60 - 17
1,78 - 19
1,67 - 18
But I get this bull****:
1,60 - 17
1,60 - 17
1,60 - 17
1,78 - 19
1,78 - 19
1,78 - 19
1,67 - 18
1,67 - 18
1,67 - 18
What I'm doing wrong? :smack:
I'm queryng mysql database:
$result= mysql_query("SELECT * FROM $table" ,$link);
while ($row = mysql_fetch_array($result)){
And then I try to echo results:
Creating a sql table using Email Addresses - SitePoint Forums::
SQL stands for Structured Query Language. do not deliver the speed and results wanted because there are not properly designed.
http://www.sitepoint.com/forums/showthread.php?t=283088HOME |
xeno-canto :: bird songs from the Americas :: ANHIMIDAE::
XML (max. 1000 results; save as .xml file, and open in e.g. Excel (2004 or later) one call, repeted 3 times [options] [discuss] [sono] XC22875
http://www.xeno-canto.org/browse.php?query=ANHIMIDAEHOME |
echo "
";
echo $row['size'];
echo $row['age'];
echo "
";
}
IF my table look like this:
num weight size age
------------------------------------------
1 45 1,60 17
------------------------------------------
2 56 1,78 19
------------------------------------------
3 47 1,67 18
------------------------------------------
I think I should get this:
1,60 - 17
1,78 - 19
1,67 - 18
But I get this bull****:
1,60 - 17
1,60 - 17
1,60 - 17
1,78 - 19
1,78 - 19
1,78 - 19
1,67 - 18
1,67 - 18
1,67 - 18
What I'm doing wrong? :smack:
Code seems no error. Just curious. have you select direct from mysql? like
mysql>select*from yourtable ;
_____________________
free ebook php (http://www.free-itebooks.com/) free ebook programming (http://www.free-itebooks.com/)
You can use GROUP BY:
$result= mysql_query("SELECT * FROM $table GROUP BY size" ,$link);
?>
I think you might have inserted a few extra times while creating the table.
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
Repeted results in query? 
PRINT
Add to favorites