php - My system is fetching data from a wrong table -

-

Instead of receiving data from the DOC_PROGRESS table, it continues to retrieve data from

table I need data from both tables but I think I am doing it wrong. My query is down, by the way. Please help me 
  (from the selection "dd as JOIN doc_progress AS dp ON dd.p_id = dp.p_id WHERE (dd.p_id = '". $ _ Session [' currentUser ']. "') And (dp.progress =' ​​read ')");   
  & lt ;? Php $ select1 = "doc_progress" as the ASD DP JOIN DOC DD ON dd.p_id = dp.p_id WHERE (dd.p_id = ''. $ _ Session ['current user']. "") And (dp .progress = 'unread'); $ Sql ​​= mysql_query ($ select1) or die (mysql_error ()); while ($ row2 = mysql_fetch_array ($ sql)) {? & Gt; & lt; tr square = " Strange Grade X ">   echo $ row2 ['date_created']? & Gt; & lt; / td> & lt; td & gt; & lt; a Href = "" & gt; & lt ;? php echo "& lt; B & gt; ". $ Line2 [[document_title ']." & Lt; / P & gt; ";? & Gt; & lt; / a & gt; & lt; / TD & gt; & lt; TD & gt; & lt ;? php echo $ row2 ['status']? & Gt ;  & lt; td & gt; & lt ;? php echo $ row2 ['progress'];? & Gt; & lt; / td> & lt; td & gt; & lt;    
  
 Use it  
  ("SELECT DD. *, DP. * DD inner join doc-progress DP on document. DD.p_id = DP.p_id where DD.p_id = '". $ _ Session [' Current User '].' 'And DP, Progress =' ​​Read '");

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

c# - How to check if a certain method/class/API exists in Xamarin iOS? -

-
After the it is recommended to check for a specific API like this IsiOS7 bool public stable {Returns UIDevice.CurrentDevice.CheckSystemVersion (7, 0); }} If (Util.IsiOS7) {// call iOS 7 API} and {// iOS 6.1 or earlier API call} The same should go for iOS 8. Now I have read that you should check whether there is a certain method or class exists rather than checking the version. Here comes the RespondsToSelector that should be something like this if (RespondsToSelector (new selector ("edgesForExtendedLayout"))) EdgesForExtendedLayout = UIRectEdge.None. But how will one examine if a whole class exists like UIAlertController ? In Objective-C, there is no NSClassFromString I have seen in some such purpose - if ([UIAlertController class]) {// ...} Will such a move happen? type type = type Gettype ("UIAlertController"); If (type! = Null) {// iOS 8 API} other {// iOS 7 or lower} How will this happen in C #? Or to check for UIAlertController...
Read more