Posts by reZo

Atlantis, the city of the ancients from the Pegasus galaxy!

/me watches to much Stargate

Nah, properly some where in the US. Haven't been out of this city very much in my life, and never out of the country, New Zealand.

Your true political self:
You are a

Social Liberal
(73% permissive)

and an...

Economic Liberal
(30% permissive)

You are best described as a:

Democrat (30e/73s)

You exhibit a very well-developed sense of Right and Wrong and believe in economic fairness.

You should check out SimpleXML from http://php.net/. Since it's the official PHP website, they have examples and such on different functions and usages of the class of SimpleXML. Well, it comes in class and function form, so have fun!

http://nz.php.net/SimpleXML

Description:

The problem is with the SQL. In tbl_comment.comment_mreference, I have made this column varchar(60). It can either contain an integer value, or an alphanumeric value. If it's an integer value, an admin would be logged in and it would have inserted there auto_increment member number into tbl_comment.comment_mreference. If it's a alphanumeric value, it will mean that a guest is posting a comment.

Purpose:

I'm using this for my blog. For the commenting system.

At the moment:

I'm getting the following output:

---------------

one by test
Posted by,

two by rezo
Posted by, reZo

three by rezo
Posted by, reZo

four by kube
Posted by, kube

---------------

Now, this is all correct apart from the top entry. This entry has "test" as the value of it's tbl_comment.comment_mreference row. Therefore, it does not need to match any member ID into the tbl_register.register_number row for the corresponding member ID.

I can't seem to figure out a way to check if the value in tbl_comment.comment_mreference is alphnumeric or has an integer value.

Some of tbl_comment:

mysql> SELECT comment_mreference, comment_heading FROM tbl_comment;
+--------------------+-----------------+
| comment_mreference | comment_heading |
+--------------------+-----------------+
| test | one by test |
| 1 | two by rezo |
| 1 | three by rezo |
| 2 | four by kube |
+--------------------+-----------------+
4 rows in set (0.39 sec)

Some …