DaniWeb Forum Index > Search Forums

Search Results

•

Showing results 1 to 2 of 2
Search took 0.00 seconds. Search: Posts Made By: Suomedia ; Forum: MySQL and child forums

Save these search results for 24 hours

Forum: MySQL

Mar 27th, 2008

Replies: 7

Solved: Queries and sub-queries

Views: 1,151

Posted By Suomedia

Re: Queries and sub-queries

If your script works but takes forever, you probably need to add indexes to your tables.

Matti Ressler
Suomedia

Forum: MySQL

Mar 22nd, 2008

Replies: 3

Solved: Returning a number with COUNT

Views: 653

Posted By Suomedia

Re: Returning a number with COUNT

A common way to do it is this:

$data = mysql_query('SELECT * FROM `bus_basic` ORDER BY `name` ASC ')
or die(mysql_error());

Print "<table cellpadding=3>";
$count = 0;
while($info =...

Showing results 1 to 2 of 2