Call one row, one column. Possible?

[error_22]

Hi,

I just have a question in general, is it possible to call a row from a table?

Example:

Lets say I have a table with 3 columns (id, title, content) and i have 10 rows.

Now, if I want to call the title in row 10, how would I do that? I know its possible to do the following:

$sql = "SELECT * FROM `table_name` WHERE `title` = 'some_value_here'";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
	echo $row[title];
}

I dont want to do that though, because Im looking to call several rows at the same time, but I need a way to separate them. I was hoping for something like this (this is not working though):

$sql = "SELECT * FROM `table_name`";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
	echo $row[10][title];
}

Is this possible? Thanks in advance
Niklas

[devinemke]

error_22 wrote:

if I want to call the title in row 10, how would I do that?

$result = mysql_query('SELECT title FROM table_name WHERE id = 10') or exit(mysql_error());
echo mysql_result($result, 0);

[error_22]

as I said, Im looking to call several rows, ts just that I want to separate them in some way. The above query is useless if I want to call row 9. It just seems so stupid to have several queris, one for each row, dont you think?

Thanks for replying though.

[devinemke]

error_22 wrote:

as I said, Im looking to call several rows, ts just that I want to separate them in some way. The above query is useless if I want to call row 9. It just seems so stupid to have several queris, one for each row, dont you think?

yes, it is stupid. however your original question (and the subject line of this thread) was about calling 1 field from 1 row. that is precisely what my example above does. if you wish to call multiple fields from mulriple rows then loop thru the result set:

$result = mysql_query('SELECT id, title FROM table_name') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['id'] . ' = ' . $row['title'] . '<br>';
}

[error_22]

Yes that was my original question, with some slight modification:

myself wrote:

I dont want to do that though, because Im looking to call several rows at the same time, but I need a way to separate them. I was hoping for something like this (this is not working though):

Now, your solution will as you said make a loop. All rows will be called. Still, that is not what Im looking for. Im looking to call one single row, and the opportunity to call the next row using the same query. is that possible?

I thought my above example showed you what I want?

$sql = "SELECT * FROM `test`";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{	
echo $row['1']['id'];
echo $row['2']['id'];
}

As i think, the above code would call whatever is in the column"id" on row 1 and 2. Is there a way to achieve this?

Thanks for taking the time.

[devinemke]

error_22 wrote:

Im looking to call one single row, and the opportunity to call the next row using the same query. is that possible?

this still does not make sense to me. you cannot call a single row and then multiple rows from the same query. if you wish to grab several rows then you must run the query and then loop thru the result set.

[error_22]

ok lets take an example where I would need this:

We have a table, lets call it test and it has 2 columns in it (id, content). there are 4 rows. now, i want to separate the information in the 4 rows, because I want to display the information in different areas of my page. take this html code for exampel:

<table>
<tr>
<td>ROW-1-HERE</td>
<td>ROW-2-HERE</td>
</tr>
<tr>
<td>ROW-3-HERE</td>
<td>ROW-4-HERE</td>
</tr>
</table>

In the above example, what PHP code/query would I need?

[bradgrafelman]

I would use the modulo operation to see what iteration of 2 the loop current row number is. Hard to explain, but it'd be something like this:

echo "<table>\n";
$i = 1;

while($row = mysql_fetch_assoc($result)) {

if($i % 2 == 1)
	echo "<tr>\n";

echo "<td>" . $row['id'] . "</td>\n";

if($i % 2 == 0)
	echo "</tr>\n";

$i++;

}

echo '</table>';