line

Add to any feed reader

Help needed with php and mysql

I am such a beginner but I had gone this far….
Here is the code:

So I’d like to get a $name variable (zipcode) received from a database or any file.
Everytime the url/site refreshes the next or randomly picked zipcode should be the new variable for $name
and the one was just used should be deleted from the database. I guess it’s like an array…
I have a mysql database on my server set up which I have to connect to….help would be nice there too ;) .
I am wondering if I could run the database from my local computer without connecting to any server.

Any help would be great!
(more…)

Re: How to pull a number from a field in a table?

chris hawthorne Wrote:
——————————————————-
> I have a field called "tier" within a table called
> "nuke_users" in a database called "rft".
>
> Can anyone show me a sample query that would allow
> me to pull the number within the field and assign
> it to a variable so I could display it by calling,
> say, $tier; ?

what about the PHP manual? There are lots of examples in there,
check e.g. http://php.net/mysql

> I’m trying this but it just prints the word
> "Array":

Well, th (more…)

End Query with \G instead of ;

You can use \G instead of ; for tables with lots of fields.

mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)

Software Development Tip: Avoid Race Conditions Using Tester-Doer Pattern

One of the patterns that came up today in a code review was the Tester-Doer Pattern. One sees this pattern a lot especially when the ?doer? side of the equation has a pretty decent performance penalty. Essentially, you test a condition to make sure you need to do the ?doer? operation and pay that penalty. Sometimes this can cause race conditions. Read more… (more…)

IIS 7.0 Bit Rate Throttling Makes Video and Audio in Silverlight Rock!

IIS 7.0 Bit Rate Throttling Makes Video and Audio in Silverlight Rock!

by David Hayden ( Microsoft MVP C# ), Filed: IIS 7.0, Silverlight


 


Silverlight is really, really cool and awesome at delivering audio / video.


However, it is the Bit Rate Throttling Module in IIS 7.0 that makes it a reality for delivering audio and video over the web.


Essentially you can throttle the delivery of any file bas (more…)

Next Page »