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

Matlab: Transfer variable from GUI to Base Workspace and new Variables (Static Workspace, Script, Creating new Variables) -

-
I am developing a GUI for the current script, which expects some straight values ​​in the base workspace. The GUI will move users' values ​​to the base-workspace and then the script will start and close itself immediately. It sounds very easy and has values ​​that run with Essenin and Evelyn, but I work for days with the problem that if the script takes the values ​​of my post, then I get a message: Try to add var_name View MATLAB programming for static workspace details, see restrictions on assigning at variables. What's the problem? The GUI is closed and the script will use the base-workspace without restriction. How can this be done? The script is untouchable (not mine) and this base expects variables in the workspace, so the GUI is moving the value in the workspace and nothing else. A stable workspace is not required Workspaces will be free of any restrictions. To summarize: I want to delete "Static" in the "static workspace" Specifies the...
Read more