Search found 8 matches
- Tue Feb 24, 2009 5:20 pm
- Forum: PHP - Code
- Topic: Simple Join Question
- Replies: 6
- Views: 279
Re: Simple Join Question
Thank you, very much. I was about to get it to work using the left join.
- Tue Feb 24, 2009 4:48 pm
- Forum: PHP - Code
- Topic: Simple Join Question
- Replies: 6
- Views: 279
Re: Simple Join Question
Anybody want to shed some light on this for me?
- Tue Feb 24, 2009 8:26 am
- Forum: PHP - Code
- Topic: Simple Join Question
- Replies: 6
- Views: 279
Re: Simple Join Question
Can I get any more input on this?
- Mon Feb 23, 2009 11:15 am
- Forum: PHP - Code
- Topic: Simple Join Question
- Replies: 6
- Views: 279
Re: Simple Join Question
I would like to show the all of the content from table blog and within that While loop of pulling that information, display the number of Comments which have a blogid equal to that of the blogid from the first table. I think this is what you mean. SELECT blog.blogid, blogtitle, blogpost, blogdate, ...
- Sun Feb 22, 2009 9:54 pm
- Forum: PHP - Code
- Topic: Simple Join Question
- Replies: 6
- Views: 279
Simple Join Question
I seem to be having a lot of trouble with joining two tables. I know there has to be a way to do this in one query. This is for a very rudimentary blog that I am playing around with for some more practice. Table1 - blog - blogid - blogtitle - blogpost - date Table2 - blogcomments - commentid - blogi...
- Thu Feb 05, 2009 10:30 am
- Forum: PHP - Code
- Topic: Passing Variables with SQL and Php
- Replies: 4
- Views: 221
Re: Passing Variables with SQL and Php
I have this code now for my issue.php and where I would like my software name to display, I am receiving just the word "array". My table layout is as follows: troubleshooting: softwareid, softwarename softwareissue: softwareid, issueid, issuename My index.php displays the softwarename from...
- Wed Feb 04, 2009 9:40 pm
- Forum: PHP - Code
- Topic: Passing Variables with SQL and Php
- Replies: 4
- Views: 221
Re: Passing Variables with SQL and Php
Index.php <?php $con = mysql_connect("SERVER","USERNAME","PASSWORD"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("DBNAME", $con); $result = mysql_query("SELECT * FROM troubleshooting"); echo "<table border='...
- Wed Feb 04, 2009 9:29 pm
- Forum: PHP - Code
- Topic: Passing Variables with SQL and Php
- Replies: 4
- Views: 221
Passing Variables with SQL and Php
Hello. I have tried searching older posts but could not find a threat applicable to my question. I am setting up a troubleshooting page to get a good jump into php and sql. I am having some trouble, though, passing variables. I want the visitor to access index.php where they will be greeted with num...