TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Showing results 1 to 15 of 15
Search took 0.26 seconds.
Search: Posts Made By: buggabill
Forum: General 09-25-2008, 05:33 PM
Replies: 7
Views: 810
Posted By buggabill
Something like this should do the trick for...

Something like this should do the trick for you:

<?php
foreach($items as $item) {
echo '<li>'.$item.'</li>'."\n";
}
?>


-- or depending on the style you use
Forum: General 09-22-2008, 12:01 PM
Replies: 17
Views: 1,185
Posted By buggabill
Hi Brook. Take a look at this thread...

Hi Brook. Take a look at this thread (http://www.talkphp.com/general/3136-people-directly-downloading-files.html). I found a pretty nice script to do what you are looking for.
Forum: MySQL & Databases 09-11-2008, 05:16 PM
Replies: 2
Views: 744
Posted By buggabill
Those were my thoughts exactly. Properly...

Those were my thoughts exactly. Properly designed tables will scale WAY better than tables for each user.

I personally normalize most of my database stuff. In your example having a user table, an...
Forum: Absolute Beginners 08-22-2008, 12:28 PM
Replies: 2
Views: 1,124
Posted By buggabill
It looks like a data type issue. Take a look at...

It looks like a data type issue. Take a look at the docs for MySQL's TIMESTAMP (http://dev.mysql.com/doc/refman/5.0/en/datetime.html) datatype.



I typically store unix timestamps as an INT.
Forum: General 08-20-2008, 12:41 PM
Replies: 6
Views: 1,046
Posted By buggabill
In MySQL you could write a query like the...

In MySQL you could write a query like the following:


SELECT fieldwithdupes, Count(fieldwithdupes) AS NumOccurances
FROM atable
WHERE fieldwithdupes
IN (SELECT fieldwithdupes
FROM atable AS...
Forum: Absolute Beginners 08-11-2008, 06:33 PM
Replies: 2
Views: 1,118
Posted By buggabill
It looks like you will need to reset the record...

It looks like you will need to reset the record pointer for $sidePanelPages like so:


<?php

try{
// Get the categories
$query = "
SELECT DISTINCT `category`
FROM...
Forum: General 07-17-2008, 02:45 PM
Replies: 5
Views: 646
Posted By buggabill
I found a nice little script over here ...

I found a nice little script over here (http://www.zubrag.com/scripts/download.php)that helps with this too.
Forum: Absolute Beginners 07-10-2008, 08:24 PM
Replies: 4
Views: 1,129
Posted By buggabill
If you are looking for Access-like (ADO) calls in...

If you are looking for Access-like (ADO) calls in PHP, the neatest thing I have seen (but not tried) is talked about here: ADODB, best php database abstraction class...
Forum: MySQL & Databases 06-06-2008, 04:35 PM
Replies: 4
Views: 1,058
Posted By buggabill
BTW... I made my way over to the snipply site...

BTW...
I made my way over to the snipply site that I saw from your other posts. I like the idea. I am joining now.
Forum: MySQL & Databases 05-23-2008, 02:23 PM
Replies: 3
Views: 1,067
Posted By buggabill
I just thought of another way, but it would...

I just thought of another way, but it would require that a result came back from your query. You could dump the first row of the result into an array using mysql_fetch_assoc...
Forum: MySQL & Databases 05-23-2008, 01:52 PM
Replies: 3
Views: 1,067
Posted By buggabill
I do not really know of a way to get the...

I do not really know of a way to get the structure of a recordset, but you can get the structure of the tables involved by using the SHOW COLUMNS...
Forum: Member Introductions 02-06-2008, 04:42 PM
Replies: 8
Views: 840
Posted By buggabill
Welcome to the mix!

Welcome to the mix!
Forum: Absolute Beginners 02-05-2008, 07:23 PM
Replies: 16
Views: 864
Posted By buggabill
I personally use double quotes and they seem to...

I personally use double quotes and they seem to work for me. One thing that looks a bit weird is the table name. Is that correct?

$query = 'UPDATE althlete SET
compare
$query = 'UPDATE athlete...
Forum: Absolute Beginners 01-29-2008, 02:47 PM
Replies: 8
Views: 880
Posted By buggabill
Hi codefreek. What, if any, error message are...

Hi codefreek. What, if any, error message are you receiving?

One thing I notice right away is that your form's HTML is within the <?php ?> tag.

This will fix that:

<?php
include...
Forum: MySQL & Databases 01-28-2008, 05:35 PM
Replies: 6
Views: 1,185
Posted By buggabill
My suggestion: Create the item table like Alan...

My suggestion: Create the item table like Alan says, and then you could have a different table for each item type containing item properties. Having multiple property tables may help keep the table...
Showing results 1 to 15 of 15

 

All times are GMT. The time now is 06:34 PM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design