php - how to display other table data in $row = mysql_fetch_row -


i have 3 tables: te_event, te_venue, te_category.

  • te_event table has columns: categoryid, venueid, event description, title, date, price.

  • te_venue table has columns: venueid, venuename , location.

  • te_category has columns: catid , catdesc.

and here sql query:

$sqlevent =" select * te_events                   inner join te_venue on te_events.venueid = te_venue.venueid                   inner join te_category on te_events.catid = te_category.catid                  eventid =" .$id;

if use row[] retrieve data te_events, row[ *number] depends on te_events column.
how retrieve other table data using row[*number]?

note sure if answer question pretty confuse...

once fetch results in $row, contains data 3 tables because that's sql query returns.

so data te_event :

$categoryid = $row['categoryid']; $title= $row['title']; ...

and data te_venue :

$categoryid = $row['venuename']; $location= $row['location']; ...

but ideally should retrieve columns need in code, , alias of them :

$sqlevent =" select *                   te_events.categoryid, te_events.venueid, te_events.`event description` eventdesc, te_events.title, te_events.date, te_events.price,                   te_venue.venuename , te_venue.location,                  te_category.catdesc              te_events               inner join te_venue on te_events.venueid = te_venue.venueid               inner join te_category on te_events.catid = te_category.catid              eventid =" .$id;

also should use parametrized query pass $id , prevent sql injection.


Comments

Post a Comment

Popular posts from this blog

sql - can we replace full join with union of left and right join? why not? -

can replace full join union of left , right join? if no,why? 'yes' if t1 , t2 sets (no duplicated rows), otherwise answer 'no'. create table t1 (i int); create table t2 (i int); insert t1 values (1); insert t1 values (2); insert t1 values (2); insert t2 values (3); full join select * t1 full join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 (null) 3 union select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 (null) 3 union all select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 2 2 2 2 (null) 3
Read more

javascript - Parallax scrolling and fixed footer code causing width issues -

i bolted bits of code. 1 parallax scrolling, , other piece of fixed footer code found here: http://codepen.io/madshaakansson/pen/cgjch though after bolting , fixing few issues, have problem different widths. header different width footer, , main content doesnt span whole width of page. have tried adjusting width of content css 100%, made main content span whole width, ended breaking footer. i not sure need change make these different bits of code work together. advice appreciated. my attempt: http://codepen.io/dingerzat/pen/qgbwkk html /*global define: false */ function init() { window.addeventlistener('scroll', function(e) { var distancey = window.pageyoffset || document.documentelement.scrolltop, shrinkon = 300, header = document.queryselector("header"); if (distancey > shrinkon) { classie.add(header, "smaller"); } else { if (classie.has(header, ...
Read more

iOS: Performance of reloading UIImage(name:...) -

i have tableview , each row has icon. 90% of rows have same icon. in cellforrowatindexpath method load image assets folder this: var cellimage = uiimage(named: "myimage") does pose performance problem? os somehow smart enough it's same image each time? better if loaded image once , saved in class variable , assigned each time? uiimage 's named: api does kind of caching. if @ uiimage's documentation , states: use init(named:in:compatiblewith:) method (or init(named:) method) create image image asset or image file located in app’s main bundle (or other known bundle). because these methods cache image data automatically, recommended images use frequently.
Read more