[SOLVED] array help

[dennismonsewicz]

Code:

 

<?php

/*ini_set ("display_errors", "1");
error_reporting(E_ALL);*/

include "includes/sql.php";

$id = 24;

$query = mysql_query("SELECT * FROM added_projects WHERE id = '$id'")or die(mysql_error());

$results = mysql_fetch_object($query);

$checkbox_qry = mysql_query("SELECT * FROM has_had_projects WHERE project = '" . $results->project . "'")or die(mysql_error());

$field = mysql_num_fields($checkbox_qry);

	for($i = 0; $i < $field; $i++) {
		$names = mysql_field_name($checkbox_qry, $i);
		$title .= trim($names) . "<br />";
	}
	echo $title;

?>

 

How would I delete the first two entries in the array?

[KevinM1]

http://www.php.net/manual/en/function.array-slice.php

[dennismonsewicz]

well the problem is, is that there is no array here so array_slice() does not work...

 

 

[KevinM1]

well the problem is, is that there is no array here so array_slice() does not work...

 

What variable are you trying to truncate?

[dennismonsewicz]

the $title var

 

Its showing the id and project field (which are the first two columns in the DB table)... I am wanting to not show these in the list

[KevinM1]

the $title var

 

Its showing the id and project field (which are the first two columns in the DB table)... I am wanting to not show these in the list

 

Couldn't you merely start your for-loop with $i = 2?

[dennismonsewicz]

wow its amazing the things you learn on this forum! LOL! thanks it works!

 

Here is the code for those who want to know how it works:

 

<?php

/*ini_set ("display_errors", "1");
error_reporting(E_ALL);*/

include "includes/sql.php";

$id = 24;

$query = mysql_query("SELECT * FROM added_projects WHERE id = '$id'")or die(mysql_error());

$results = mysql_fetch_object($query);

$checkbox_qry = mysql_query("SELECT * FROM has_had_projects WHERE project = '" . $results->project . "'")or die(mysql_error());

$field = mysql_num_fields($checkbox_qry);

	for($i = 2; $i < $field; $i++) {
		$names = mysql_field_name($checkbox_qry, $i);
		$title .= $names . "<br />";
	}
	echo $title;

?>

[kenrbnsn]

If you don't want to use the first two columns, don't ask for them in your query. Instead of

<?php
$checkbox_qry = mysql_query("SELECT * FROM has_had_projects WHERE project = '" . $results->project . "'")or die(mysql_error());
?>

do

<?php
$checkbox_qry = mysql_query("SELECT list,the,fields,you,want FROM has_had_projects WHERE project = '" . $results->project . "'")or die(mysql_error());
?>

Replacing "list,the,fields,you,want" with the real field names.

 

Ken