multiple mysql queries into one php two-dimensional array -

I'm refactoring my code and just a snag. The first query in the code below receives tab_ID of the latest submitted tabs. The second query gets the details of each tab In my old way of doing this, I embed PHP and HTML and it was actually a totally mess. Right now I want to merge 2 questions in 1 and / or load it into an array.

Ask for free and / or masculine

  function get_newest_tabs () {$ db_open; $ Sql ​​= "SELECT tab_id, song_id, user_id from FROM tab, time_added DESC by ORDER". "LIMIT 15"; $ Result = mysql_query ($ sql) or die ("Error - Latest tab function:" .mysql_error ()); {$ (= $; $ I & lt; mysql_num_rows ($ result); $ i ++) {$ tab_id = mysql_result ($ result, $ i, "if mysql_num_rows ($ result) & gt; 0) Tab_id "); $ Db_open; $ Sql ​​= "SELECT tabs.tab_id, tabs.tab_version, tabs.number_of_hits, artist.artist_name, users.user_alias, songs.song_name, tabs, users, artists, where songs tabs.time_added tabs.tab_id = '". $ Tab_id '' And tab.giser_id = users.user_id and tab SAGIID = songs.Cong_ID and songs.artist_id = artist Cartist_aidi "; $ Result2 = mysql_query ($ sql) or die (" Error - i3p mysql-4: ".mysql_error ()); if (mysql_num_rows ($ result2) == 1) {$ song_name = mysql_result ($ result 2, 0, "songs.song_name"); $ Artist_name = mysql_result ($ result 2, 0, "artist.artist_name"); $ User_alias = mysql_result ($ result 2, 0, "users.user_alias"); $ Tab_version = mysql_result ( $ result 2, 0, "tabs.tab_version"); $ Number_of_hits = mysql_result ($ result 2, 0, "tabs.number_of_hits"); $ Time_added = mysql_result ($ result 2, 0, "tab. Taim_ added");} }}}  

I recommend selection from multiple tables instead of using Join Would you like to tab tabi May include receiving.

  tabs.tab_id, tabs.song_id, tabs.user_id, tabs.tab_version, tabs.number_of_hits, artist.artist_name, users.user_alias, songs.song_name , left tabs.time_added tab users.user_id = tabs.user_id users Join Join tabs.time_added left DESC songs.song_id = tabs.song_id left on artist.artist_id = songs.artist_id order 15   
 Then you can do a loop like: 
 
  while ($ line = mysql_fetch_array ($ result)) {$ tab [$ line ['Tab_id']] = $ line; }  
 
 Unless you have a user / song / artist per tab, you will find an array of your data. 
   
 




  











Popular posts from this blog




c# - ListView onScroll event -



-



February 15, 2010








    I am programming a simple C # application, and I need a Scallow event on the list view. So I inherited the original ListView class created in ListviewEx witch. I found out how to locate the scroll message from WinAPI and I modified the WndProc method. Now I have this WndProc:    protected override zero WndProc (Ref message message) {base.WndProc (Ref I); If (m.msg == WM_VSCROLL) {onScroll (This, New EventArgs ()); }}    But the problem is, I do not know how to know about scrolling information. This data should be in wParam, but there is a LOWORD macro ++ like in C in C # and I switch to find the criteria like SB_ below, SB_ENDSCROLL, SB_PAGEUP etc.   there any way Need to change the LOWORD macro from C #?   Or any other way to find the necessary parameters about scrolling?      You can define the WParam constants as the following:    Private const int WM_HSCROLL = 0x114; Private Constant WM_VSCROLL = 0x115; Private contact int SBHOZZ = 0; Private Consultant SB_VERT = 1; Private Con...





Read more





PHP - get image from byte array -



-



September 15, 2015








    I am trying to create a back-end for my mobile application. I am sending the content of an image in the body of the HTTP request (output stream) as a byte array, I want to read this stream of bytes in PHP scripts and take back an image.   Can anyone tell me how can I do this?   Thank you.       You can obtain the request body    $ body = Reading from file_get_contents ('php: // input');    What you do with that data Depending on you, you can write the data in a file as you mentioned that this is image data, you can drop the data into the object can do. Another option is to use and load the image.     





Read more





Linux Terminal Problem with Non-Canonical Terminal I/O app -



-



January 15, 2014








    I have a small app written in C to run on Linux. Part of the app accepts user-input from keyboard , And it uses non-canonical terminal mode so that it can respond to each keystroke.    The section of the code that accepts input is a simple task that is called repeatedly in the loop:    char get_input () {char C = 0; Int res = reading (input_tamille, & amp; c, 1); If (RSS == 0) 0 returns; If (res == -1) {/ * snip error handling * /} return c; }    It reads a letter from the terminal if there is no input within a given time limit, (c_cc [VTIME] value in the vocabulary structure), read () 0 And get_input () is called again   It all works very well, I have recently discovered that if you run this app in a terminal window, and then the app Close the terminal window without ending, the app will not exit Received, but CPU intensive launches into an infinite loop, where the read () returns 0 without waiting continued.   So how can I get out of the apple if it runs from the terminal win...





Read more























Powered by Blogger



Theme images by Michael Elkan























Unknown




Visit profile











Archive











September 2015200


August 2015213


July 2015198


June 2015193


May 2015185


April 2015210


March 2015189


February 2015213


January 2015204


September 2014183






August 2014196


July 2014214


June 2014177


May 2014197


April 2014198


March 2014215


February 2014188


January 2014182


September 2013187


August 2013199


July 2013180


June 2013229


May 2013210


April 2013194


March 2013213


February 2013201


January 2013201


September 2012197


August 2012189


July 2012216


June 2012209


May 2012220


April 2012205


March 2012185


February 2012213


January 2012207


September 2011228


August 2011187


July 2011198


June 2011216


May 2011191


April 2011234


March 2011183


February 2011199


January 2011188


September 2010208


August 2010196


July 2010201


June 2010189


May 2010193


April 2010187


March 2010200


February 2010184


January 2010203



Show more
Show less








Report Abuse