Search found 8 matches

by llabeoll
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.
by llabeoll
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?
by llabeoll
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?
by llabeoll
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, ...
by llabeoll
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...
by llabeoll
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...
by llabeoll
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='...
by llabeoll
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...