Quick MySQL Question...

[LMS16]

Ok so it sounds nooby but...

How would I fetch the number of rows from a database, if I wanted to see how many rows include the word "admin" within its tables.?

Its hard to explain lol but I wanna see how many tables have the word "admin" in them? Can someone help me with the mysql query please?

I thought it would be some like

mysql_num_rows(mysql_query("SELECT '$username' FROM `table`"));
But obvs not... HELP? lol,

Thanks lol :)

Lew.

[Johno]

It would probably be something like:



$query = mysql_query("SELECT * FROM `table` WHERE `whatever the row is` = `Admin`");
$query = mysql_num_rows("$query");Not entirely sure but, hope that helps :)

[LMS16]

No I mean Ive got a table and it has different tables inside that such as "tta, ttb, ttc ect..." and I want to find how many of those tables have the users username in it so for example, "tta='admin', ttb='admin'" so the number of rows would be 2...

Lew.

[Blob]

Could try



<?php
$query = mysql_query("SELECT * FROM `table`");

$count = 0;
while( ( $fetch = mysql_fetch_assoc( $query ) !== false )
{
foreach( $fetch as $key => $value )
{
( $value == "admin" ) ? $count++: false;
}
}

echo $count;
?>


Try that.

[Johno]

This might help if you are trying to select the same named column from multiple tables, http://stackoverflow.com/questions/409705/mysql-selecting-data-from-multiple-tables-all-with-same-structure-but-different :)

[LMS16]

Hmmm,, basically I'm making a timetable script and I want to be able to tell the user how many shows they have booked that week...

Anyone care to explain in a little more details cos me minds gone blank and I cant think of a way... S:S:S:S

Lew.