I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but i don't know how to see from which table is that maximum, can anyone help? tnx

Member Avatar
Member Avatar
+0 forum 3

if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename.

Member Avatar
Member Avatar
+0 forum 3

hello :) i'm developing an app in VS 2010 C#, linked with an MS Access Database. i want to use a table name as variable. i have tried: [CODE] string tblname = students; string query = "select * from '" + tblname + "' where rollno=123"; [/CODE] but it's not working :( kindly guide me. thanks :)

Member Avatar
Member Avatar
+0 forum 1

Hello, I have a script that among other things, creates a table with a variable being the table name. This worked fine when i was using the variable "$name". Since then I've realized that i need the table name to be "$merchid" (primary key from previous table. I've used "$newid = mysql_insert_id();" to recall the last auto incremented primary key and this echoes just fine, but when i use $newid in place of $name, in the CREATE TABLE query the darn thing breaks, meaning no table is created. The rest of the form functions properly with this error. Again, this …

Member Avatar
Member Avatar
+0 forum 2

The End.