arrays

Richardtagger

hey, i have this query that gets the info and echos it into a table i rows. This works fine except one of the columns i want from another table. So far i have this:

/// the simple search
$sql = mysql_query("SELECT * FROM projects LIMIT $max_results");
$color1 = "#FFFFFF";
$color2 = "#F2F2F2";
$row_count = 0;

while ($projects = mysql_fetch_array($sql)) {  

  $id = $projects["id"];
  $title =  $projects["name"]; 
  $daysleft =  $projects["daysleft"];
  $started = $projects["date"];
  if ($daysleft == "1") {
  $ends = "1 Day";
  } else {
  $ends = "$daysleft days";
  }
  $row_color = ($row_count % 2) ? $color1 : $color2;
  $skillssql = mysql_query("SELECT skill FROM projectskills WHERE project='$id'") or die(mysql_error());
  $skills = mysql_fetch_array($skillssql);
 echo " <tr align='center' class='style14'>
              <td bgcolor='$row_color'>$id</td>
              <td bgcolor='$row_color' align=\"left\"><a 

href='http://xx.xx.xx/project.php?id=$id
' target='_blank' style='color:#9E0309' class='style31'>$title</a></td>

          <td bgcolor='$row_color' 
align=\"left\">$skills</td>

          <td bgcolor='$row_color' 
align=\"left\">$started</td>
			  <td 
bgcolor='$row_color' 
align=\"left\">$ends</td>

        </tr>
";
 $row_count++; 

}

This puts the word "Array" in the skills column. I need the list of skills which are on different rows in a different table. I would have thought ya need some sort of while and fetch array but i cant figure it out. thanx in advance.

Installer

Are you expecting only one result from the projectskills query? If so, then you could change

<td bgcolor='$row_color' align=\"left\">$skills</td>

<td bgcolor='$row_color' align=\"left\">$skills['skill']</td>

and that should do it.

Richardtagger

no multiple, sorry. There are say ten rows with a skill per row and they have the ID column which links it to the projects table.

Installer

Then the code I posted should work. (With the escape slashes in the right places, of course. The forum software doesn't always display them correctly.)

BuzzLY

If you have multiple skills in the $skills array, then you need to loop through them to display them all. Take a look at the [man]foreach[/man] construct. If you only need to display one of the skills, then use Installer's code.

If you have an array $myarray, simply echoing $myarray will return "Array." To display the values inside the array, you must refer to each value specifically. You should RTFM about arrays , since you'll need to use them in PHP a LOT 🙂

NOTE: Notice how there is a horizontal scroll bar to read this thread? It's because your code stretches too long. Try editing your post and shrinking that down a bit...

Richardtagger

i know how to use for each in an array but this is too complicated for me... could i have some help please....

Installer

In the projectskills table, is each id unique, or may the same one be found in more than one row?

If by "no multiple" you meant that they're unique, then please tell us what happens when you run the script with the code I posted earlier. As far as I can see, it should work. (Again, be sure the double quotes are escaped.)