Selecting tables

[Morsusy2k]

Okay so I would need to select all tables with prefix 'c' and list their names in php.

This is how far i've come:

<?php	include 'source/connect.php';	$sql3 = "SHOW TABLES FROM mydb LIKE 'c%'";	$result3 = mysql_query($sql3) or die ("Could not access DB: " . mysql_error());	while ($row3 = mysql_fetch_assoc($result2))	{	echo $row3;        //echoes nothing,how could I echo the table name?	}?>

Also I would like if that could be done for only first 10 tables. (Only 10 tables select).

Edited October 23, 2013 by Morsusy2k

[justsomeguy]

Use fetch_array instead of fetch_assoc and then get $row3[0]. If you want to exit the loop after so many iterations then keep a counter and use break to exit the loop.

[Morsusy2k]

Hehe that was easy,thanks bunch