Title: Looking for a SQL Query person who's good with PHP as well. Post by: MoreBloodWine on January 05, 2015, 01:18:15 PM Can pay a small bounty upon the successful test of code on my server. I would hope my trust would show me to be an honest person... please check out feedback from haploid23.
Ok, so I already have the connection bit down that connects to the DB and can select it successfully. I need a query that will choose table "cats", now in this table "cats" are two rows... "age" and "added". Well, lets say that in table "cats" we have 5 rows which look as follows...
This is also where the PHP help comes in. The query I need would read this info and the PHP put it in a foreach type of thing so the HTML table data shows each item, like the "mock" table seen above. Basically I just want to pull the info from DB cats and show it in an HTML table. I just need the foreach thing written for me in PHP that displays the pulled DB info in the table td's. Code: <td> I know I probably could have said this all in a much simpler way but I haven't slept yet and wanted to get this posted before I lose what little brain activity I have left lol Edit: It should order descending by the "added" row so the newest entry is always the first td. Ty. Title: Re: Looking for a SQL Query person who's good with PHP as well. Post by: mrflibblehat on January 05, 2015, 02:43:46 PM Does this work, cant test because I'm at work right now.
Code: <html> Title: Re: Looking for a SQL Query person who's good with PHP as well. Post by: MoreBloodWine on January 05, 2015, 03:29:07 PM Does this work, cant test because I'm at work right now. Didn't work but found something that did. Locking thread but still willing to toss you a lil something for trying, PM me your address. Wont be anything big BTW.Code: <html> |