[SOLVED] Displaying mysql statement

[chmpdog]

Hello,

 

I was wondering if anyone could teach me how to display the following mysql statement:

 

select * where allowed='no';

 

Normally this would be easy but there are multiple values with no.

 

Thankyou

[BLaZuRE]

Do you mean you only want to get one result?  If so, try using LIMIT:

SELECT * FROM `table` WHERE `allowed`='no' LIMIT 1

[chmpdog]

no, but thanks. I figured it out

<?php

$query = "SELECT id FROM table WHERE name = 'some name'";
// and if you wanted no more than 3 rows:
// $query = "SELECT id FROM table WHERE name = 'some name' LIMIT 3";

// Perform Query
$result = mysql_query($query);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
    echo $row['id'];
}

// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>