echo queries

[Porkie]

what am    <?php

 

$con = mysql_connect("");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("", $con);

 

 

$count = "SELECT COUNT(id) FROM gg_video";

echo '</td>';

    echo '</tr>';

    echo "Currently['$count'] Videos";

?>

i doing wrong when showing queries?

 

cheers

[Maq]

Do you want to show the query or the returned values?

[Porkie]

returned value please mate,

 

thanks

[Maq]

Try:

 

    $count = "SELECT COUNT(id) FROM gg_video";
    $result = mysql_query($count);
    $row = mysql_fetch_array($result);
    echo '';
    echo '';
    echo "Currently {$row['COUNT(id)']} Videos";

[Porkie]

still shows nothing mate,

 

any reason why?

 

cheers

[will35010]

still shows nothing mate,

 

any reason why?

 

cheers

 

try:

 

    $count = "SELECT COUNT(id) FROM gg_video";
    $result = mysql_query($count);
    $row = mysql_fetch_array($result);
    echo '</td>';
    echo '</tr>';
    echo "Currently ".{$row['COUNT(id)']}." Videos";
[/code

[Porkie]

sorted now cheers everyone

[Maq]

Mind sharing?

[will35010]

Mind sharing?

 

guess he does mind...lol.