HELP - Arrary Function

[Clambert73]

Hi all,

First let me say I tried to search around for this but I did not find anything so if I repeat something..just point me in the right direction 🙂

Second..any help I receive is appreciated very much...

Now the question I have is relatively simple in my mind, but i just cant seem to make it happen lol.

What i want to do is call the information from my mysql database (with the fetch_array) and somehow figure out how to store that information into seperate variables instead of where it will just all print at once. The problem i am having is sorting - so I want to call on them one by one and place them the way I want to..i know that sounds long a tedious..but I lead a very boring life LOL Any help appreciated 🙂

Christina

[ScubaKing22]

You could use mysql_result. It gives you a lot of control but is one of the slower functions:

<?
$query="SELECT*FROM table";
$result=mysql_query($query);
$rows=mysql_num_rows($result);
$i=0;
while ($i<$rows){
$var=mysql_result($result,$i,"column name");
++$i;
}
?>

This allows you to name each variable and allow you to use it during the loop. Just place some code above the closing } and you could display or do just about anything else.

[Clambert73]

Thank you so very much! I will give that shot in a few minutes... Im not totally new but this has been racking my brain all day and with three php books I couldn't figure it out lol Thanks for the info!

Christina

[Clambert73]

Ok well here is a stupid question...i guarantee it is lol

Will this code snippet allow for more than column name or will I need to do that for each one.. 🙂

[ScubaKing22]

Definitely; just add another $var=mysql_result($result,$i,"column") and replace column with the name of the column.

[Clambert73]

One more dumb question then I leave you be...

Let me give example of what I am doing...my husband runs an online baseball league..I have a database of the draft picks.

I am trying to put them in the table IN ORDER..but we all now how ascending orders can go with numbers - it doesnt lol The fields I have are:

Round
Pick
Team

I query the pick and team where the round is equal to 1 (sorry i spelled that out lol) so there are 26 results to the team and picks..will those all sort out with that variable name or should it be an array of some sort?

I will leave you alone someday LOL

[ScubaKing22]

Sorry but your question is a little confusing. But as I understand it, this would be the code you want:

<?php
mysql_connect(host,username,password);
mysql_select_db(database);
$query="SELECT*FROM table_name WHERE round='1' ORDER BY team ASC";   //ORDER BY team ASC will do the sorting (A-Z) DESC will do (Z-A)
$result=mysql_query($query);
$rows=mysql_num_rows($result);
mysql_close();
$i=0;
while ($i<$rows)
{
$pick=mysql_result($result,$i,"pick");
$team=mysql_result($result,$i,"team");
//PLACE CODE HERE FOR DISPLAY
++$i;
}
?>

[Clambert73]

The reason I was saying about the sort thing is the "pick" field has number data from 1-26 when it sorts it sorts like this:

1
10
11
12
etc etc etc so what I was trying to do is draw the results out where i could put them in a table by variable..i am sure I am making absolutely no sense LOL but in essence it would be like

$var1 = $pick1
$var2 = $pick2

etc etc there are 26 of those and team names... so i did not know how the mysql_fetch_array handled the arrays and the data to retrieve the data 🙂 Not making any sense am I lol

This might make more sense:

http://www.simleaguecentral.com/classic/draftorder.php

[ScubaKing22]

I understand this corrected code should be what you need:

<?php 
mysql_connect(host,username,password); 
mysql_select_db(database); 
$query="SELECT*FROM table_name WHERE round='1' ORDER BY pick ASC";   //ORDER BY team ASC will do the sorting (A-Z,1-10) DESC will do (Z-A,10-1) 
$result=mysql_query($query); 
$rows=mysql_num_rows($result); 
mysql_close(); 
$i=0; 
while ($i<$rows) 
{ 
$pick=mysql_result($result,$i,"pick"); 
$team=mysql_result($result,$i,"team"); 
//PLACE CODE HERE FOR DISPLAY 
++$i; 
} 
?>

Then where it says PLACE CODE here just echo out $pick and $team and they will be in order by pic from 1-26. Hope that helps 🙂

[Clambert73]

Well thanks for the info..but it sorts it wrong sigh LOL

here take a look and you will see what I am talking about the numbers.

http://www.simleaguecentral.com/classic/test.php

it sorts is as

1
10
11
12
13
14
15
16
17
18
19
2
20 and so on and so on

this is what i used____________________________________

<?php
$sql = "SELECT round, pick, team FROM draft WHERE round = '1' ORDER BY pick ASC";
$connection = mysql_connect("localhost", "username", "password");
$db = mysql_select_db("bpuvtwqf_webcontent", $connection);
$sql_result = mysql_query($sql, $connection);

if (!$sql_result)
{
echo "There is no information or there was an error";
}
$rows=mysql_num_rows($sql_result);

mysql_close();

$i=0;

while ($i<$rows)

{

$pick=mysql_result($sql_result,$i,"pick");

$team=mysql_result($sql_result,$i,"team");

echo "<tr><td width='80' height='19'><div align='left'>$pick</div></td><td width='722' height='19'><div align='left'>$team</div></td></tr>";

++$i;

}

?>

[ScubaKing22]

Try:

<?
//CONNECT STUFF HERE
$query="SELECT*FROM draft WHERE round='1' ORDER BY 'pick' ASC";
$result=mysql_query($query);
$rows=mysql_num_rows($result);
$i=0;
while ($i<$rows){
$pick=mysql_result($result,$i,"pick");
$team=mysql_result($result,$i,"team");
echo "<tr><td width='80' height='19'><div align='left'>$pick</div></td><td width='722' height='19'><div align='left'>$team</div></td></tr>";
++$i;
}
?>

This should work; it's what I use for ordering numbers. BTW
Theres really no need for that IF statement since the while loop won't execute if there are no rows.

[Clambert73]

isnt that the same code? lol or maybe I just dont know... im bout ready to give up and just tell them tough deal with it and read LOl

[ScubaKing22]

Its almost the same; there are some quotes and a few minor things added. Hey, at this point anything is worth a try, right? 😉

[Clambert73]

YUP you said it lol I will try anything...im on the mysql site seeing if anyone else has this sort issue - if I happen to find anything I will let you know LOL

[Clambert73]

well nope... i have failed LOL i am gonna dig through mysql site ugh i hate doing that lol and see what I can find! Thanks for the help - you have been most gracious

[ScubaKing22]

Thats what this forum is for - help! 😃

[Clambert73]

Oky doky ...I got it figured out...wasnt even my original code problem... see go ahead smack me on the head..i deserve it...

If i would have originally put an auto increment number in the table then it would have held the values the original way they were entered which was in order..then it would have kept that order..so DUH on me... I added a numbered index to Dbase and wala it works!

http://www.simleaguecentral.com/classic/draftorder.php