php - A mysql query from multiple tables without anything in common -


edit: sorry guys, didn't knew can 3 select queries on same page that, thought limit 1 query/page , not 1 type of query/page. i've solved problem dividing multiple queries, question still remain (just out of curiosity): possible query multiple tables without when clause connects tables and without getting cartesian product?

thanks replies, many "divide multiple queries" replies made me "what if...is easy?" :). original question below:

i'm pretty new mqsql , ran obnoxious cartesian product. i'm trying query 3 tables don't have column in common (actually there connection between second , third table, ignore it). i've got tables t1(c1,c2,c3), t2(c4,c5), t3(c6,c7) , like:

$query="select * t1, t2, t3"; $request=  mysql_query($query); $row = mysql_fetch_array($query); $i=0; while ($row = mysql_fetch_array($request)) {     $array1[$i]=$row['c1'];     $array2[$i]=$row['c2'];     $array3[$i]=$row['c3'];     $array4[$i]=$row['c4'];     $array5[$i]=$row['c5'];     $value6=$row['c6'][1];     $value7=$row['c7'][1];     $i++; }

all want arrays 1-7 on same php page (without adding framesets/frames ecc.)? i've tried breaking in multiple queries after guy's example http://www.dev-explorer.com/articles/multiple-mysql-queries didn't work.

edit: example data

table1:

---------------------------- fruit_id | f_name | f_color ---------------------------- 1        | apple  | red 2        | banana | yellow

table2:

---------------------------- player_id | player_name ---------------------------- 1         | john 2         | scott 3         | mike 4         | george

table3:

---------------------------- other_id | other_name ---------------------------- 1        | alex

i want able in same page arrays $fruit_id values ['1','2'], $f_name ['apple','banana'], $f_color ['red','green'], $player_id['1','2','3','4'] ecc..

it not have mysql, long arrays.

  1. what doing in example performing cartesian product of 3 tables. means every combination of tuples contained in 3 tables displayed.

    this not looking for, should have @ joins, limit number of rows.

    mysql supports set operations union if want venture in more complicated , nested queries. advice sticking joins

  2. if data not connected in way, try issuing multiple queries (without trying fit 1 single sql statement), , output data manually in whichever form want display them.

whithout more information you're doing, cannot give other advice


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions
Read more