Search found 9 matches
- 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...
- 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...
- 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 ...
- 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?
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?
- 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?
- 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?
- 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!
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!
- 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.
- 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 ...