can some one show me this easy way

Anon

this is what i want to do, each guys name need to be in sparate table with differnet text next to there names. i have put a example in below for you to see. please can you show me this doing someother easy way

<table width="594" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="92" valign="top" width="594" bgcolor="#FFCC00">
i love this <?$result = mysql_query("SELECT FROM guystable where id = 12" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."-- " . $row[1]; ?>, 
but i sleeped with <?$result = mysql_query("SELECT FROM guystable where id = 10" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."-- " . $row[1]; ?>, 
and i also hade sex with this guy name <?$result = mysql_query("SELECT FROM guystable where id = 15" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."-- " . $row[1]; ?>, 
i just wish i hade sex with <?$result = mysql_query("SELECT FROM guystable where id = 1" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."-- " . $row[1]; ?>
</td>
</tr>
</table>

leatherback

Something like this maybe? I am not sure how much control you need on the guy name etc. You might have to add an other index, besides the ID, which you can use to sort the names/

<?
$Query = "Select * from guystable where id=12 or id=10 or id=15 or id=1 order by id";

$result=mysql_query($Query);

while $row= mysql_fetch_Array($result)
{
$Guys = $row[GuyName]
}

I slept with <? $Guys[0] ?>
I will dine with <? Guys[1] ?>

cordex

laughs One of the more original examples I've seen.

Okay, try this. First create a new table. You could call this one tblGuyStatus. Give it at least two fields (AutoID, StatusText). Have the AutoID field be the primary key Then, place the different status texts in there ("I slept with ", "Thank God I didn't sleep with ", "Why won't anyone sleep with " ... ad infinitum). Also put whatever formatting you like in this field.
Now, add a field (I'll call it StatusID) to your guystable for the status. The status number will refer to an entry in the tblGuyStatus field.

How are you selecting which guys you want to print? That could affect how the code is written.

One example could look something like this:

<?php
// Assuming we have the guys' IDs in a comma separated string
$guystring_st = "1,5,15,6,20";

$guy_array = explode(",", $guystring);
$sel_st = "SELECT guystable., tblGuyStatus. FROM guytable LEFT JOIN guystable.StatusID=tblGuyStatus.AutoID";
$sel_rs = mysql_query($sel_st);
while($sel_ar = mysql_fetch_array($sel_rs))
{
if(in_array($sel_ar[id]))
{
"-- $sel_ar[StatusText] . $sel_ar[name] ."";
}
}

That what you're looking for?

Anon

but i want it to use one table, so it wont be hard way, i want it easy way, for example i want to put data like this in field.

echo " i ike this guy name" $guyname.[fieldname].[rownumber];

how can i do this example in php

cordex

But ... I was showing you the easy way. Okay, to do it the other "easy" way:

How about using a function?

function getguy($field, $id)
{
  $sel_st = "SELECT * FROM guytable WHERE id=$id";
  $sel_rs = mysql_query($sel_st);
  $sel_ar = mysql_fetch_array($sel_rs);
  return($sel_ar[$field]);
}

// to use this function:
echo " I want to run this guy down with a car: " getguy('Name','5') ." ";
// where Name is the name field and 5 is the id.

Make sense?

There are dozens of ways you could handle this, though, so if you don't like this idea, keep asking. I'm sure you'll find someone that can find a way you'll like.