sybase_num_rows() - mal will's, mal nicht
Moin,
vorweg gleich mal der Code:
PHP-Code:
<label for='table'>Tabellen mit Triggern</label>
<select name='table' id='table' class='long' onchange='submit_form1()'>
<?php
$conn=connect('sybase', 'asd', 'qwe', '123', 'master');
$result1=sybase_query("SELECT name
FROM sysdatabases
ORDER BY LOWER(name) ASC", $conn);
$i=0;
while (list($db_name)=sybase_fetch_row($result1)) {
$result2=sybase_query("SELECT name
FROM $db_name..sysobjects
WHERE type='U' AND
(deltrig>0 OR
instrig>0 OR
updtrig>0)
ORDER BY LOWER(name) ASC", $conn);
if (sybase_num_rows($result2)>0) { // <-- ZEILE 26 <--
echo " <optgroup label='$db_name (".sybase_num_rows($result2).")'>n";
while (list($object_name)=sybase_fetch_row($result2)) {
$selected = @$_GET['table']=="$db_name..$object_name" ? " selected='selected'" : '';
echo " <option value='$db_name..$object_name'$selected>$object_name</option>n";
$i=1;
}
echo " </optgroup>n";
}
}
?>
</select><br /><br />
Die Fehlermeldung: "<b>Warning</b>: sybase_num_rows(): supplied argument is not a valid Sybase result resource in <b>/var/www/webface/request_ase_drop_trigger.php</b> on line <b>26</b>
Selbstverständlich...
...besteht die Verbindung zum Server
...ist der Query ($result2) korrekt
...wird in Zeile 27 die korrekte(!) Zahl OHNE(!) Fehlermeldung angezeigt
Vorschläge, Ideen, Sonstiges?
Danke
Carsten |