Go Back   CodingForums.com > Search Forums

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 25 of 76
Search took 0.23 seconds.
Search: Posts Made By: rgEffects
Forum: PHP 05-07-2013, 07:49 PM
Replies: 2
Views: 166
Posted By rgEffects
Any ideas about another way to sort this list...

Any ideas about another way to sort this list alphabetically and display only last names starting with a specific letter?
Forum: PHP 05-03-2013, 06:50 PM
Replies: 2
Views: 166
Posted By rgEffects
Sorting and displaying a large member list

I have a database of 2500 members. Right now the membership list is sorted by last name and there are only two options to display the list. The entire list as a table or 20 records at a time.

I'd...
Forum: PHP 05-03-2013, 02:30 PM
Replies: 5
Views: 159
Posted By rgEffects
Thanks. That's a much easier solution than I was...

Thanks. That's a much easier solution than I was using.
Forum: PHP 05-03-2013, 12:51 AM
Replies: 5
Views: 159
Posted By rgEffects
41391 shows up in the table. I'd like to convert...

41391 shows up in the table. I'd like to convert it on the way to the table if possible. Haven't figured a way to get 41391 to echo as 04/27/2013
Forum: PHP 05-02-2013, 10:16 PM
Replies: 5
Views: 159
Posted By rgEffects
excel date format to sql date

I have a bunch of data in excel spreadsheets where the date column is returning a number. For example 04/27/2013 in an excel column formatted as date returns 41391 when imported into a mysql...
Forum: PHP 04-17-2013, 04:25 PM
Replies: 2
Views: 321
Posted By rgEffects
I would host somewhere else due to bandwidth and...

I would host somewhere else due to bandwidth and streaming issues. Unless you've got deep pockets and a very powerful dedicated server farm hosting videos on your own server will choke the system...
Forum: PHP 04-05-2013, 07:55 PM
Replies: 2
Views: 156
Posted By rgEffects
If I add LIMIT 1 I only get one record which is...

If I add LIMIT 1 I only get one record which is exactly what limit 1 is supposed to do.

This is what I get without the Limit 1 added:
Bob, 23 Main street
Bob, 45 Elm street
Ted, 32 Second...
Forum: PHP 04-04-2013, 03:46 PM
Replies: 2
Views: 156
Posted By rgEffects
To limit to most recent entry when query looks at two tables

I have a members table and a personal info table. Each time personal info is updated a new record is added that references the memberID so that we have a record of all of changes and can recover bad...
Forum: PHP 03-22-2013, 04:37 PM
Replies: 2
Views: 324
Posted By rgEffects
There are lots of tree structures out there that...

There are lots of tree structures out there that should work for you. Here's one that I use all the time. The reference to the class is a style sheet that I use to create drop down lists so you can...
Forum: PHP 02-13-2013, 04:46 AM
Replies: 4
Views: 331
Posted By rgEffects
Thanks for the help. I had tried something...

Thanks for the help. I had tried something similar but missed that I needed to include all three instances. Here is the working code:
<?php
$currentUserID = $row_currentUserRS['id'];
$parentid =...
Forum: PHP 02-12-2013, 11:54 PM
Replies: 4
Views: 331
Posted By rgEffects
I read through the manual you referred to and...

I read through the manual you referred to and searched the web but I can't seem to figure out how to add a parameter in the right way. Any suggestions?
Forum: PHP 02-12-2013, 09:12 PM
Replies: 4
Views: 331
Posted By rgEffects
Disappearing variable in recursive tree code

I'm setting up a menu structure using a recursive menu tree that works just fine. I want to be able to restrict the items in the menu by userID. I have some code that delivers the current users...
Forum: PHP 02-01-2013, 02:13 AM
Replies: 8
Views: 538
Posted By rgEffects
So what kind of code sets up this time limit?

So what kind of code sets up this time limit?
Forum: PHP 01-30-2013, 01:56 PM
Replies: 3
Views: 243
Posted By rgEffects
I usually put the error reporting and the...

I usually put the error reporting and the redirect right after the form like this:
</form>
<?php
if ($_POST && $errors) {
echo '<ul>';
foreach ($errors as $error) {
echo "<li>$error</li>";...
Forum: PHP 01-30-2013, 01:38 PM
Replies: 3
Views: 226
Posted By rgEffects
I was way over thinking this problem I ended up...

I was way over thinking this problem I ended up simplifying the code substantially and just dropping it to the bottom of the php that runs before the HTML starts. The code that works is amazingly...
Forum: PHP 01-29-2013, 11:45 PM
Replies: 3
Views: 226
Posted By rgEffects
Thanks for the suggestion. I put it in and it...

Thanks for the suggestion. I put it in and it redirects every user to the new page... I must be missing something. Not having very good luck with this so far. // ======= same as above
if...
Forum: PHP 01-29-2013, 09:00 PM
Replies: 3
Views: 226
Posted By rgEffects
Redirect users based on their access level.

I have a users table with id(primary key), userName, password, and access fields. I've set up the log-in to pass userName, password and access to a session variable to validate the user.

There...
Forum: PHP 01-29-2013, 06:17 AM
Replies: 2
Views: 276
Posted By rgEffects
I got this solved. It took a bit of searching but...

I got this solved. It took a bit of searching but I finally got it. Here's the successful code. I hope it benefits someone else. It works well for a breadcrumb trail back up a PHP tree structure....
Forum: PHP 01-28-2013, 10:02 PM
Replies: 2
Views: 276
Posted By rgEffects
Reverse Tree Structure - locating parent records

I've got a table that contains file names and I've set up a query that generates an unordered list. The table has a record id (id) File Name and parentID. This all works perfectly.

Now I need to...
Forum: PHP 01-25-2013, 11:54 PM
Replies: 3
Views: 278
Posted By rgEffects
That did it. Never would have guessed that I'd...

That did it. Never would have guessed that I'd have to put in WHERE content.linkID IS NULL and I didn't find anything like that in 40 minutes of searching...

Thanks again.
Forum: PHP 01-25-2013, 09:50 PM
Replies: 3
Views: 278
Posted By rgEffects
Query two tables where columns are not equal

I have set up a content recordset and a links recordset. A link name is included in the links recordset. It's easy to write a query that compares the list of possible link names to the content and...
Forum: PHP 01-25-2013, 12:48 AM
Replies: 5
Views: 290
Posted By rgEffects
Ok, so release would go here: <?php ...

Ok, so release would go here:
<?php
$parentid = 0; // assuming that 0 is the main category.
get_sub_cats2($parentid);
function get_sub_cats2($parentid) {
...
Forum: PHP 01-24-2013, 08:23 PM
Replies: 5
Views: 290
Posted By rgEffects
So if I'm following your post correctly right...

So if I'm following your post correctly right after the last closing bracket in the sample code I should add the free command. It would look like this:
<?php
$parentid = 0; // assuming...
Forum: PHP 01-24-2013, 08:11 PM
Replies: 3
Views: 206
Posted By rgEffects
Thanks for the confirmation that I'm not doing...

Thanks for the confirmation that I'm not doing something that's going to get me in trouble. It's just so much easier to keep track of the 40 or so components of this site if they are put in includes...
Forum: PHP 01-24-2013, 03:54 PM
Replies: 5
Views: 290
Posted By rgEffects
When to free sql results?

For a lot of my web designs I'll run a bunch of queries on the same page. I usually run the queries before any HTML and retrieve the $row_someRS['someField'] inside the HTML to echo information on...
Showing results 1 to 25 of 76

 
Forum Jump

All times are GMT +1. The time now is 08:34 AM.