You are here: Re: How do I simplify this SELECT query? « All PHP « IT news, forums, messages
Re: How do I simplify this SELECT query?

Posted by Simon on 09/28/92 11:44

$sql_query = "SELECT column4 FROM $table WHERE entry = 4";
$dd = 0;
while ($row = mysql_fetch_row($result)) {
$column4[$dd] = $row['column4'];
$dd++;


<endlesstide@gmail.com> wrote in message
news:1144483472.431452.152910@v46g2000cwv.googlegroups.com...
> $sql_query = "SELECT * FROM $table WHERE entry = 4";
>
> // now put all the data into arrays
> $dd = 0;
> while ($row = mysql_fetch_row($result)) {
> $column4[$dd] = $row[3];
> $dd++;
>
>
> I am trying to simplifly this query -- I don't want to select * from
> the table, I want to only get data from column called "column4". I
> know the next part putting into the arrays is redundent. I just want a
> single record. Is running a select * going to add lots of overhead to
> the server?
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация