Click here to Skip to main content
15,882,055 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
QuestionPHP CODES TO DISPLAY SLIDING IMAGES Pin
Member 1034654419-Oct-13 11:12
Member 1034654419-Oct-13 11:12 
AnswerRe: PHP CODES TO DISPLAY SLIDING IMAGES Pin
Peter Leow4-Nov-13 1:52
professionalPeter Leow4-Nov-13 1:52 
QuestionAvailable username on all pages after login Pin
msz90013-Oct-13 6:03
msz90013-Oct-13 6:03 
AnswerRe: Available username on all pages after login Pin
Ringunger24-Oct-13 21:11
Ringunger24-Oct-13 21:11 
QuestionHow to Play multiple Videos in single player page ? Pin
mAzeem228-Oct-13 22:49
mAzeem228-Oct-13 22:49 
Questionphp search form having 2 input fields and single submit button Pin
marshalericson8-Oct-13 7:59
marshalericson8-Oct-13 7:59 
Questionphp Pin
BipinVekariya25-Sep-13 2:12
BipinVekariya25-Sep-13 2:12 
QuestionPHP call to mysqli_query returns null (as expected) but I don't seem to be able to detect it Pin
Jonathan Davies9-Sep-13 6:22
Jonathan Davies9-Sep-13 6:22 
My SELECT query works fine when I've got records. Whether there are no records, or not in the result set I get a warning
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given
I've tested the result agains
FALSE, NULL, null
(both null and NULL seem to be used in examples and the manual)and calling
is_null($result)
but I don't pick it up. Why? I just want to be able to differ between technical failure and return of zero records.
PHP
$query = 'SELECT CommentId, ParentId, Subject, Name, DATE_FORMAT(TimeStamp,"%k::%i %d-%m-%Y (GMT)"), Comment FROM commentdata WHERE ArticleId = ' . $ArticleId . ' ORDER BY COALESCE ( ParentId, CommentId)';
        
       
        $result = mysqli_query($connect, $query);
        
        if(TRUE == $result)
        {
            echo 'TRUE returned on query for data: ' . mysqli_error($connect) . '<br/>';
        }
                                
        if(FALSE == $result)
        {
            echo 'FALSE returned on query for data: ' . mysqli_error($connect) . '<br/>';
            mysqli_close($connect);
            die("Connection closed after FALSE returned on query for data: " . mysqli_error($connect));
        }
        
        if(NULL == $result))
        {
            echo 'NULL returned on query for data: ' . mysqli_error($connect) . '<br/>';
            mysqli_close($connect);
            die("Connection closed after NULL returned on query for data: " . mysqli_error($connect));
        }
        
        if(null == $result))
        {
            echo 'null returned on query for data: ' . mysqli_error($connect) . '<br/>';
            mysqli_close($connect);
            die("Connection closed after null returned on query for data: " . mysqli_error($connect));
        }
        
        if(is_null($result))
        {
            echo 'NULL returned on query for data: ' . mysqli_error($connect) . '<br/>';
            mysqli_close($connect);
            die("Connection closed after NULL returned on query for data: " . mysqli_error($connect));
        }
                
        /* determine number of rows in result set */
        $rowcount = mysqli_num_rows($result);


modified 10-Sep-13 10:03am.

QuestionMYSQL to XML using PHP Pin
wolf7777726-Aug-13 22:27
wolf7777726-Aug-13 22:27 
QuestionUsing .net webservice data in php Pin
Andile.M20-Aug-13 0:35
Andile.M20-Aug-13 0:35 
QuestionIntitialize a session variable after onclick event is fired Pin
pandu web dev11-Aug-13 23:16
pandu web dev11-Aug-13 23:16 
AnswerRe: Intitialize a session variable after onclick event is fired Pin
Kaivan Alimohammadi23-Aug-13 10:25
Kaivan Alimohammadi23-Aug-13 10:25 
GeneralRe: Intitialize a session variable after onclick event is fired Pin
pandu web dev26-Aug-13 3:28
pandu web dev26-Aug-13 3:28 
QuestionContact form - Bootstrap Error Validation Pin
bigcdh4-Aug-13 8:13
bigcdh4-Aug-13 8:13 
AnswerRe: Contact form - Bootstrap Error Validation Pin
Peter_in_27808-Aug-13 15:42
professionalPeter_in_27808-Aug-13 15:42 
AnswerRe: Contact form - Bootstrap Error Validation Pin
vbmike23-Aug-13 9:12
vbmike23-Aug-13 9:12 
GeneralRe: Contact form - Bootstrap Error Validation Pin
bigcdh23-Aug-13 9:22
bigcdh23-Aug-13 9:22 
QuestionPHP find all occurrences of string in file Pin
MicahC5-Jul-13 6:44
MicahC5-Jul-13 6:44 
AnswerRe: PHP find all occurrences of string in file Pin
Graham Breach5-Jul-13 21:20
Graham Breach5-Jul-13 21:20 
GeneralRe: PHP find all occurrences of string in file Pin
MicahC7-Jul-13 19:52
MicahC7-Jul-13 19:52 
GeneralRe: PHP find all occurrences of string in file Pin
MicahC10-Jul-13 5:56
MicahC10-Jul-13 5:56 
QuestionNot much traffic here is there..... Pin
Erudite_Eric16-Jun-13 23:40
Erudite_Eric16-Jun-13 23:40 
AnswerRe: Not much traffic here is there..... Pin
Ali Al Omairi(Abu AlHassan)7-Jul-13 22:18
professionalAli Al Omairi(Abu AlHassan)7-Jul-13 22:18 
QuestionCounting Menu Items & Determining If First/Last Pin
NickBogi7-Jun-13 13:20
NickBogi7-Jun-13 13:20 
AnswerGot It Working Pin
NickBogi10-Jun-13 8:29
NickBogi10-Jun-13 8:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.