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
|