[RESOLVED] PHP Display a row if exists in mysql table

[wassup789]

Hello! I want to display 1 row if a certain text exists in a column.

Please help out thank you 😃

If you still dont understand its like this:

id |title |name
1  |Hi    |Wassup
2  |Woh|Blah

Then in php it only shows a row that in the column "id" has the number 2.

THE DISPLAY WOULD BE

2|woh|blah

==========
Please help 🙂

[leatherback]

select * from TABLE where COLUM = 2

[wassup789]

leatherback;10985220 wrote:

select * from TABLE where COLUM = 2

Ahh i see. Thanks but how do i output it seperatly

For example:

$title1 = AMYSQLROW;
$title2 = ANOTHERMYSQLROW;
echo "Title: $title1";
echo "<br>Title #2 $title2";

Please help thanks 🙂

[bradgrafelman]

Output what separately? Unless you're using something like MySQLi's fetchAll() method, data from the result set is normally retrieved row-by-row (e.g. in a while() loop that repeatedly calls [man]mysql_fetch_assoc/man or something similar).

[wassup789]

bradgrafelman;10985233 wrote:

Output what separately? Unless you're using something like MySQLi's fetchAll() method, data from the result set is normally retrieved row-by-row (e.g. in a while() loop that repeatedly calls [man]mysql_fetch_assoc/man or something similar).

what i mean is how to i output all the columns but each column is a variable.

[bradgrafelman]

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

echo $row['col1'];
echo $row['col2'];
// ....
echo $row['colN'];
}

[wassup789]

bradgrafelman;10985235 wrote:

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

echo $row['col1'];
echo $row['col2'];
// ....
echo $row['colN'];
}

oh thanks! But i have one more question, how do i add

if(mysql_num_rows(mysql_query($sel)) >= 1)

to it?

[leatherback]

$query = "SELECT something FROM somewhere WHERE condition ";
$store_array = array();

$result = mysql_query($query);

if($result)
  { 
  $numrows = mysql_num_rows($result);
  while ($row = mysql_fetch_assoc($result)
    {
    echo $row['colum1'];
    echo $row['colum2'];
    $store_array[] = $row['colum3'];
    }
  print_r($store_array);
  }

[wassup789]

Thanks!