Search found 9 matches

by Shiki
Tue Jan 27, 2009 4:23 pm
Forum: PHP - Code
Topic: Whats wrong with this code
Replies: 2
Views: 215

Re: Whats wrong with this code

I don't see it in your code but I'm going to guess $mysqli already exists since you're using it and its prepare() function. The error may have been because $stmt is FALSE and is not an object. Most probably because there's an error in your sql statement. You could check if this is the cause by putti...
by Shiki
Wed Jan 21, 2009 12:38 pm
Forum: PHP - Code
Topic: postback in php
Replies: 6
Views: 242

Re: postback in php

Right. What Burrito said is what you could do. Forward it to a page without the parameters: Say, this is your original url: http://www.something.com/update.php?deleteid=1 In update.php, after your code processes the deleleteid parameter, you can forward it to a clean page: header('Location: update.p...
by Shiki
Wed Jan 21, 2009 12:26 pm
Forum: PHP - Code
Topic: If/Else Across Two Tables
Replies: 9
Views: 586

Re: If/Else Across Two Tables

Ok. I think there should be a way to link the tables in the first place. And, you could opt to use two queries. First query for: SELECT Category FROM classifieds Then the second query for the specific table (links_rea, links_auto, etc.) depending on the value of Category. I guess this means you can ...
by Shiki
Tue Jan 20, 2009 4:32 pm
Forum: PHP - Code
Topic: If/Else Across Two Tables
Replies: 9
Views: 586

Re: If/Else Across Two Tables

You mean there's an initial SELECT

SELECT Category FROM classifieds

But depending on the value of 'Category', you want to include additional data either from links_rea or links_auto in the returned resultset?
by Shiki
Tue Jan 20, 2009 12:59 pm
Forum: PHP - Code
Topic: postback in php
Replies: 6
Views: 242

Re: postback in php

What exactly do you mean (or want)? Care to explain more?
by Shiki
Tue Jan 20, 2009 12:57 pm
Forum: PHP - Code
Topic: If/Else Across Two Tables
Replies: 9
Views: 586

Re: If/Else Across Two Tables

What's the foreign key that connects a links_rea record to a classifieds record?
by Shiki
Thu Jan 08, 2009 4:45 pm
Forum: Databases
Topic: Database Design Best Practices
Replies: 1
Views: 335

Database Design Best Practices

Hi,

Can anyone please recommend any good site that caters to database design practices? Topics like the best way to store "product tags" in a db or something along that line.

Thanks!
by Shiki
Sun Dec 21, 2008 1:23 pm
Forum: Javascript
Topic: Generating HTML -- Javascript vs PHP
Replies: 2
Views: 643

Re: Generating HTML -- Javascript vs PHP

Thank you for the reply. That looks like a good idea.
by Shiki
Fri Dec 19, 2008 11:34 pm
Forum: Javascript
Topic: Generating HTML -- Javascript vs PHP
Replies: 2
Views: 643

Generating HTML -- Javascript vs PHP

Hi, I have this scenario (eCommerce) where I need to update a list of items in a table through AJAX every time the user changes some controls. The items can go up to around 20 in the table and each item (<td>) would contain the item's image, description, and 3 or more color thumbnails for selecting ...