Megan — Sat, 28 Apr 2007 14:33:01 +0000

Thanks for explaining that! It makes much more sense now.

pr0gr4mm3r — Sat, 28 Apr 2007 03:37:20 +0000

brady.k;218489 wrote: Haha I meant verify my reasons as to why you have to do it that way. But ok.

Well, Megan was printing the $sql variable like it was a string. In this case, $sql was a Result Set. That could be similar to a variable that references a database connection or file stream. You can't print it (or if you do, weird output will result), you have to send it through methods (such as mysql_fetch_row, mysql_fetch_assoc, mysql_fetch_array, etc).

brady.k — Sat, 28 Apr 2007 03:06:47 +0000

Haha I meant verify my reasons as to why you have to do it that way. But ok.

pr0gr4mm3r — Sat, 28 Apr 2007 01:40:36 +0000

brady.k;218479 wrote: If you have a query like that, you need to "structuralize" (I'm not sure what the official word is for it) the data.

For example:

$sql = mysql_query("SELECT name, email FROM wherever LIMIT 5"); while ($qry = mysql_fetch_array($sql)) { $actual_name = $qry['name']; // actual name data for this row $actual_email = $qry['email']; // actual email data for this row }
'

Again, I'm not sure of the exact reasons, but I think it's similar in method to 'pointers' in C. It returns the location of what you're looking for, and then you have to pull the actual data out of that memory location.

(Anyone want to verify this?)

That looks right.

brady.k — Fri, 27 Apr 2007 23:55:52 +0000

If you have a query like that, you need to "structuralize" (I'm not sure what the official word is for it) the data.

For example:

$sql = mysql_query("SELECT name, email FROM wherever LIMIT 5");

while ($qry = mysql_fetch_array($sql)) {
     $actual_name = $qry['name'];  // actual name data for this row
     $actual_email = $qry['email'];   // actual email data for this row
}

Again, I'm not sure of the exact reasons, but I think it's similar in method to 'pointers' in C. It returns the location of what you're looking for, and then you have to pull the actual data out of that memory location.

(Anyone want to verify this?)

benf — Fri, 27 Apr 2007 22:32:36 +0000

What was the problem because im getting the same problem?

demonhale — Thu, 26 Apr 2007 01:23:29 +0000

Megan;218377 wrote: Nevermind, I think I figured it out. Wasn't using it right (my brain is in no condition to be doing programming today!)

Mine too... This week I might be experiencing a programmers block... add to that, that I officially have an RSI on my right hand for too much mousing around... PT's do have cures for those actually, but I still have it though...

Megan — Wed, 25 Apr 2007 19:46:45 +0000

Nevermind, I think I figured it out. Wasn't using it right (my brain is in no condition to be doing programming today!)