quick sql select?

Anon

hi,

is there a way to do a quick select? with that i mean writing something like:

There is <?=select("select count(*) from table)?> rows in this table.

instead of writing the full mysql_query, mysql_fetch_row etc, when you know for sure that the result will have one row and one column.

Anon

I think you are out of luck... The only solution I can think of is writing a function to do it, or maybe you find an already writen one

Andreas bernhardsen
Graficonn

Anon

Here is a script that you could use... I don't know if it fits you need but anyway... It's not wery complex. It doesn't print the names of the fields but it's something to buid from...

How to use:
Put the script into a file called "quickselect.php" or something like that and call it by doing something like this

<?php
$table = 'myTable';
include("quickselect.php);
?>

You need to have already opened a mysql connection and chosen a database. And you also need to close the mysql connection in the end.

--- Begin Script ---

<?php
print "<br>Showing table $thetable<br>";
$result = mysql_query("SELECT * FROM $thetable"); // get all entrys
$numfld = mysql_num_fields($result);
print '<table border=1>';
while($row = mysql_fetch_row($result)) // next row
{
$i = 0;
print '<tr>';
while($numfld > $i) // next field
{
print "<td>$row[$i]</td>"; // print field
$i++;
}
}
print '</tr></table>';

--- End Script ---

Andreas Bernhardsen
Graficonn

Anon

hm, that's not what I meant.

Ah well... gotta write my own 🙂

<?php
function qsel($select)
{
$res = mysql_query ($select);
$answer = mysql_fetch_row ($res);
return $answer[0];
}
?>

Rather unfortunate that tere is no similar function already included in PHP. Would be quite handy.