wrong again, forgot the grouping,
this is the right sql:
$sql = "SELECT p.id,
p.$town,
p.$zip,
p.$phone,
p.$description
count(m.*) praxdocs
FROM $p
i rethought the sql and found, that the column parxdocs wont contain the
number of doctors per praxis.
this would only be done if there are more than one doctor with the same
name, surename and title in one praxis.
but you can do this instead
// now you'll get the number of doctors per praxis
$sq
typo in the querystring, this should work, i suppose
$queryString = "SELECT count(m.*) parxdocs
m.$sureName,
m.$preName,
m.$title,
ok, here we go.
you normaly say this i suppose:
while ($row = mysql_fetch_array($result) {
//your html inserts here
}
if you'd use oracle, i'd suggest using a cursor, but you're using MySql, so
you probably have to do it a bit different:
(Not tested, could contain some errors!!!)
// you'll
4 matches
Mail list logo