Select Array from MySql

Anon

I want to select 5 differnt guys from my database, but i dont know how can i do any other way. this is only way i know, but i have to write this code very single time i retrive data for each guy.

$result = mysql_query("SELECT * FROM table where id = 2" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."<p align='right'><i>-- " . $row[1];

can you tell me how can i do this easy way please 🙂

Anon

hi girl,

use in clause of mysql.

$result = mysql_query("SELECT * FROM table where id IN (2,3,6,9,10)" , $con);

and that will work.
you will have to loop thru the result to get your 'guys'.

=brij.

Anon

what query should i use if i want to display my guys in 5 different location in one page, for example:

first guy is in header
second guy in in footer
third is in middle
forth is in side
......)

Anon

if you have defined the number code for each of the location, say 1 for header, 2 for footer, and like.

select guys from guytable where location in (1,2,3,4,5) limit 5.

you will get 5 names from the each of the location.

is that what you want ?

first guy is in header
second guy in in footer
third is in middle
forth is in side

Anon

this way i know how to do it, please if you wrote the full script like i have did in below, thank you guys 🙂

Brij wrote:

if you have defined the number code for each of the location, say 1 for header, 2 for footer, and like.

select guys from guytable where location in (1,2,3,4,5) limit 5.

you will get 5 names from the each of the location.

is that what you want ?

first guy is in header
second guy in in footer
third is in middle
forth is in side

Anon

revised code here...

<?
// begin the for loop
for ($i=0 ; $i< mysql_num_rows($result) ; $i++) {
?>

<tr>
<td height="34" valign="top" bgcolor="#CCCCCC" colspan="5">
<?

$guy = '' ;  // better to re-initialize here. it is in the loop..
// use the field here of the guysname.
$guy = mysql_result($result , $i, "guyname") ; // $i is important here.
echo "<p align='right'>-- " . $guy ;

?>
</td>
</tr>
<tr>
<td width="116" height="9"></td>
<td width="52"></td>
<td width="245"></td>
<td width="99"></td>
<td width="82"></td>
</tr>

<?
} // end of the for loop
?>
</table>

from
Brij.

Anon

hi brij

what if i

select *
from table name;

how can i call id number 3 and colum name guys from guystable, but i want to keep that select statment on top and just call it from a result query. how the result query look like for this queation.

thanks for helping me 😉 i really starting to like you

kbrij

the example which i gave you was having select * from table name.

all you need to do is put in the correct fieldname guys in this part of the code here

if the field in the DB is called guys.

$guy = mysql_result($result , $i, "guys") ; // $i is important here.

for the id number 3 put in the id number 3 in the In clause with others.

is that helpful ?

brij.
P.s. can my name go in your guystable ? 🙂)

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. and can you send you picture url so i can store it in my favarite guys database 😉

<table width="594" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="92" valign="top" width="594" bgcolor="#FFCC00">
<p>i love this <?$result = mysql_query("SELECT FROM guystable where id = 12" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."<p align='right'><i>-- " . $row[1]; ?>, <br>
but i sleeped with <?$result = mysql_query("SELECT FROM guystable where id = 10" , $con);
$row = mysql_fetch_row($result);
echo $row[0]."<p align='right'><i>-- " . $row[1]; ?>,<br>
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]."<p align='right'><i>-- " . $row[1]; ?>,<br>
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]."<p align='right'><i>-- " . $row[1]; ?></p>
</td>
</tr>
</table>