Maq

Is this solved?

When I was younger, so much younger than today, I never needed anybody's help in any way.. Help me if you can, I'm feeling down and I do appreciate you being round. Help me, get my feet back on the ground, won't you please, please help me? And now my life has changed in oh so many ways, my independence seems to vanish in the haze. But every now and then I feel so insecure, I know that I just need you like I've never done before.

Where is this 'certain row' coming from...? Regardless, you're going to most need to use a WHERE clause.

OP, you should be using INET_ATOM and INET_NTOA when retrieving and inserting IP addresses.

Can you post the code that does the insert? What data type is the column "IP" in your DB?

What are you trying to do exactly?

Right, so change that line to: $total = mysql_num_rows($query) or die (mysql_error());

So, is this solved now? The error you're receiving is a result of hard coding on this line: $query = mysql_query ($sql) or die ("E0105"); You should not be using or die()'s to handle errors but, you could have changed that line to: $query = mysql_query ($sql) or die (mysql_error()); for a more descriptive error message. You should read this blog post http://www.phpfreaks.com/blog/or-die-must-die to learn more about properly handling errors and exceptions.

Temporarily turn error_reporting to max by placing the following lines directly after your opening PHP tags: ini_set ("display_errors", "1"); error_reporting(E_ALL);

You may want to temporarily turn error reporting to max by adding these two lines directly after your opening php tag: ini_set ("display_errors", "1"); error_reporting(E_ALL);

Do you need help with the PHP, the SQL query or both?

We wouldn't have different forums if that were the case.

You seem to suffer from a mild case of comma sickness.

Remove the comma after NOT NULL.

Assuming you're talking about developing in general, I really don't have a preference. I use w/e keyboard is in front of me. If you feel uncomfortable with your current setting, then you should make the investment in new equipment. Now gaming is a different story...

Don't resurrect ancient threads. Last reply: December 03, 2008, 01:58:35 AM.

You can use the DOM or SimpleXML libraries, along with a bit of XPath to accomplish this.

Hi kasitzboym, please surround your code with tags for readability purposes. As in the data is not displaying? Please elaborate. Before going into depth with your code you can filter out obvious and fatal errors by temporarily setting your error_reporting to max by adding this code to the TOP of your .php files: ini_set ("display_errors", "1"); error_reporting(E_ALL);

Hi KingSpongo, What part do you need help with exactly? There are multiple parts to the overall question. I'm going to assume you're referring to the SQL syntax in which StathisG would be correct if, presumably, 'product_id' is an integer. Otherwise you're going to have to use single quotes around the value.

Look at DOM or simpleXML.

If the value is empty then assign that variable to '%' which is a wild card and will match any value. Of course you'll have to do this in PHP (or w/e you're using).

It means that the column 'user_id' doesn't exist in the table 'tbl_log'. If you disagree then could you please post the structure of that table. (describe tbl_log;)

Would have been helpful if I told you what my environment was like I'm running Ubuntu and viewing in FF 3.0.

I don't see what you're talking about.. they all seem perfectly aligned to me.. The login, search, and your menu bar look unaligned. [attachment deleted by admin]

Your WHERE clause is invalid, please read the manual for proper syntax.