Need Help with database output

Need Help with database output

am 28.08.2010 13:33:36 von Nagendra Prasad

--e0cb4e8877d777c232048ee09b09
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

I have a database and I want to show it in 3 columns Like

Col1 Col2 Col3
data1 data2 data3
data4 data5 data5
......... ....... ........


I tired using table but its not working. Please help me.

Best,
guru.

--e0cb4e8877d777c232048ee09b09--

Re: Need Help with database output

am 28.08.2010 21:57:05 von Phansys Corp

--0015175cdc38bbb3cd048ee7a285
Content-Type: text/plain; charset=ISO-8859-1

Hi Nagendra!


///...require to $link_resource mysql

$query = 'SELECT Col1, Col2, Col3 FROM table';
$rs_query = mysql_query($query, $link_resource);
$row_rs_query = mysql_fetch_assoc($rs_query);
$total_row_rs_query = mysql_num_rows($rs_query);

if ($total_row_rs_query > 0) {
echo
'

';
do {
echo '';
} while($row_rs_query = mysql_fetch_assoc($rs_query));
echo '
Col1Col2Col3
', $row_rs_query['Col1'], '', $row_rs_query['Col2'],
'
', $row_rs_query['Col3'], '
';
}
mysql_free_result($rs_query);

?>

2010/8/28 nagendra prasad

> Hi All,
>
> I have a database and I want to show it in 3 columns Like
>
> Col1 Col2 Col3
> data1 data2 data3
> data4 data5 data5
> ........ ....... ........
>
>
> I tired using table but its not working. Please help me.
>
> Best,
> guru.
>

--0015175cdc38bbb3cd048ee7a285--

Re: Need Help with database output

am 28.08.2010 21:57:05 von Phansys Corp

--0015175cdc38bbb3cd048ee7a285
Content-Type: text/plain; charset=ISO-8859-1

Hi Nagendra!


///...require to $link_resource mysql

$query = 'SELECT Col1, Col2, Col3 FROM table';
$rs_query = mysql_query($query, $link_resource);
$row_rs_query = mysql_fetch_assoc($rs_query);
$total_row_rs_query = mysql_num_rows($rs_query);

if ($total_row_rs_query > 0) {
echo
'

';
do {
echo '';
} while($row_rs_query = mysql_fetch_assoc($rs_query));
echo '
Col1Col2Col3
', $row_rs_query['Col1'], '', $row_rs_query['Col2'],
'
', $row_rs_query['Col3'], '
';
}
mysql_free_result($rs_query);

?>

2010/8/28 nagendra prasad

> Hi All,
>
> I have a database and I want to show it in 3 columns Like
>
> Col1 Col2 Col3
> data1 data2 data3
> data4 data5 data5
> ........ ....... ........
>
>
> I tired using table but its not working. Please help me.
>
> Best,
> guru.
>

--0015175cdc38bbb3cd048ee7a285--

Re: Need Help with database output

am 30.08.2010 18:14:17 von Nagendra Prasad

--e0cb4e8878d9d28dd9048f0cc21f
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

Thanks for all your replies. I have found what I needed. I used Dreamweaver
to show the database in 3 different columns. However now I don't know how to
add a search engine to it. Right now its showing all the records in my
database in 3 columns. Now I want to put a search engine code so that user
can search data whatever he wants. I see the difference in normal php codes
and Dreamweaver php codes. Please suggest me how to add a search engine
script to the existing 3 column script.

Best,
Guru.

--e0cb4e8878d9d28dd9048f0cc21f--

Re: Need Help with database output

am 30.08.2010 18:14:17 von Nagendra Prasad

--e0cb4e8878d9d28dd9048f0cc21f
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

Thanks for all your replies. I have found what I needed. I used Dreamweaver
to show the database in 3 different columns. However now I don't know how to
add a search engine to it. Right now its showing all the records in my
database in 3 columns. Now I want to put a search engine code so that user
can search data whatever he wants. I see the difference in normal php codes
and Dreamweaver php codes. Please suggest me how to add a search engine
script to the existing 3 column script.

Best,
Guru.

--e0cb4e8878d9d28dd9048f0cc21f--

Re: [PHP-DB] Re: Need Help with database output

am 30.08.2010 18:16:30 von Phpster

On Mon, Aug 30, 2010 at 12:14 PM, nagendra prasad
wrote:
> Hi All,
>
> Thanks for all your replies. I have found what I needed. I used Dreamweaver
> to show the database in 3 different columns. However now I don't know how to
> add a search engine to it. Right now its showing all the records in my
> database in 3 columns. Now I want to put a search engine code so that user
> can search data whatever he wants. I see the difference in normal php codes
> and Dreamweaver php codes. Please suggest me how to add a search engine
> script to the existing 3 column script.
>
> Best,
> Guru.
>

I suggest you google for search engine script and start from there

--

Bastien

Cat, the other other white meat

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Need Help with database output

am 30.08.2010 18:16:30 von Phpster

On Mon, Aug 30, 2010 at 12:14 PM, nagendra prasad
wrote:
> Hi All,
>
> Thanks for all your replies. I have found what I needed. I used Dreamweaver
> to show the database in 3 different columns. However now I don't know how to
> add a search engine to it. Right now its showing all the records in my
> database in 3 columns. Now I want to put a search engine code so that user
> can search data whatever he wants. I see the difference in normal php codes
> and Dreamweaver php codes. Please suggest me how to add a search engine
> script to the existing 3 column script.
>
> Best,
> Guru.
>

I suggest you google for search engine script and start from there

--

Bastien

Cat, the other other white meat

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Need Help with database output

am 30.08.2010 19:01:01 von Vinay Kannan

--0016364d3207cbfcf6048f0d6848
Content-Type: text/plain; charset=ISO-8859-1

Whats Dreamweaver php codes. It automatically does the coding ?? Never even
knew about such a thing

Thanks,
Vinay

On Mon, Aug 30, 2010 at 9:44 PM, nagendra prasad
wrote:

> Hi All,
>
> Thanks for all your replies. I have found what I needed. I used Dreamweaver
> to show the database in 3 different columns. However now I don't know how
> to
> add a search engine to it. Right now its showing all the records in my
> database in 3 columns. Now I want to put a search engine code so that user
> can search data whatever he wants. I see the difference in normal php codes
> and Dreamweaver php codes. Please suggest me how to add a search engine
> script to the existing 3 column script.
>
> Best,
> Guru.
>

--0016364d3207cbfcf6048f0d6848--

Re: [PHP-DB] Re: Need Help with database output

am 30.08.2010 19:01:01 von Vinay Kannan

--0016364d3207cbfcf6048f0d6848
Content-Type: text/plain; charset=ISO-8859-1

Whats Dreamweaver php codes. It automatically does the coding ?? Never even
knew about such a thing

Thanks,
Vinay

On Mon, Aug 30, 2010 at 9:44 PM, nagendra prasad
wrote:

> Hi All,
>
> Thanks for all your replies. I have found what I needed. I used Dreamweaver
> to show the database in 3 different columns. However now I don't know how
> to
> add a search engine to it. Right now its showing all the records in my
> database in 3 columns. Now I want to put a search engine code so that user
> can search data whatever he wants. I see the difference in normal php codes
> and Dreamweaver php codes. Please suggest me how to add a search engine
> script to the existing 3 column script.
>
> Best,
> Guru.
>

--0016364d3207cbfcf6048f0d6848--

Re: [PHP-DB] Re: Need Help with database output

am 30.08.2010 19:28:59 von Nagendra Prasad

--000e0cd28da6f28daf048f0dcd6e
Content-Type: text/plain; charset=ISO-8859-1

yep if you want to make a slight changes like some color or some space
change you can always use the code tab in the Dreamweaver :). I fee very
easy to change minor codes in the coding tab rather then using menus and
stuff :)

--000e0cd28da6f28daf048f0dcd6e--

Re: [PHP-DB] Re: Need Help with database output

am 30.08.2010 19:28:59 von Nagendra Prasad

--000e0cd28da6f28daf048f0dcd6e
Content-Type: text/plain; charset=ISO-8859-1

yep if you want to make a slight changes like some color or some space
change you can always use the code tab in the Dreamweaver :). I fee very
easy to change minor codes in the coding tab rather then using menus and
stuff :)

--000e0cd28da6f28daf048f0dcd6e--