Go Back   CodingForums.com > Search Forums

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 25 of 500
Search took 0.23 seconds.
Search: Posts Made By: iLLin
Forum: MySQL 08-01-2008, 10:32 PM
Replies: 1
Views: 640
Posted By iLLin
Ok solved my first issue but I might as well get...

Ok solved my first issue but I might as well get more complicated. Here is my query so far that allows me to sort by whats in common:


SELECT profile_general.first_name,...
Forum: Other Databases 08-01-2008, 10:08 PM
Replies: 3
Views: 1,011
Posted By iLLin
I would make your "groups" (classifications)...

I would make your "groups" (classifications) dynamic. Therefore if you have add new ones in the future it will automatically add them to each page. This can be done with either the database, or...
Forum: MySQL 08-01-2008, 09:06 PM
Replies: 1
Views: 640
Posted By iLLin
Advanced Sorting (Procedure?)

Basically what I am trying to do is do some advanced sorting by what a user has in common with another user. I will try to as simple as possible.

Doing a search for users with a name that starts...
Forum: PHP 01-04-2008, 06:25 PM
Replies: 4
Views: 829
Posted By iLLin
Add a trailing slash to your $uploaddir.

Add a trailing slash to your $uploaddir.
Forum: PHP 01-03-2008, 08:38 PM
Replies: 4
Views: 829
Posted By iLLin
whats your $uploaddir look like that? Trailing...

whats your $uploaddir look like that? Trailing slash, no trailing slash?

What does your form look like?
Forum: PHP 01-03-2008, 08:25 PM
Replies: 3
Views: 823
Posted By iLLin
It is helpful as I am doing "state" not "city"...

It is helpful as I am doing "state" not "city" and my verification relies on a point system just as spam does. Verify their email address, there state matches the ip state, the phone matches the...
Forum: PHP 01-03-2008, 03:08 PM
Replies: 2
Views: 1,991
Posted By iLLin
Whats your problem/error you are receiving?

Whats your problem/error you are receiving?
Forum: PHP 01-03-2008, 03:05 PM
Replies: 3
Views: 823
Posted By iLLin
Performing web services without affecting page load...

Ok let me explain that ;)

What I am doing is having a consumer fill out a registration form. That form is say for a estimate on home remodeling. Ok they fill out their form with the basic...
Forum: HTML & CSS 05-31-2007, 04:30 PM
Replies: 3
Views: 665
Posted By iLLin
Anyone have any ideas?

Anyone have any ideas?
Forum: PHP 05-31-2007, 02:16 PM
Replies: 8
Views: 631
Posted By iLLin
YOu should turn on error reporting and good...

YOu should turn on error reporting and good practice is to die out all your queries whether your a pro or a beginner.

this is your problem

$qry="SELECT * FROM Users WHERE UserName=".$usr." AND...
Forum: HTML & CSS 05-31-2007, 12:14 AM
Replies: 6
Views: 906
Posted By iLLin
1900x1200 ...

1900x1200

http://www.lgwebproduction.com/tmp/trinity-ss.jpg
Forum: PHP 05-30-2007, 05:39 PM
Replies: 27
Views: 1,881
Posted By iLLin
Ok so this is a edit page of a users profile? ...

Ok so this is a edit page of a users profile?

You will need to select * there information anyway and when you do you will just replace the $_POST['mineral_country'] with the users value you got...
Forum: PHP 05-30-2007, 05:06 PM
Replies: 27
Views: 1,881
Posted By iLLin
<?php //open conn db $query_country_name =...

<?php
//open conn db

$query_country_name = "select CountryName from tluCountries";
$search_country_name = mysql_query($query_country_name)or die(mysql_error());

while ($rowN =...
Forum: HTML & CSS 05-30-2007, 04:56 PM
Replies: 3
Views: 665
Posted By iLLin
Need some css help with a dropdown menu

I have been fighting with this menu for a while now. It works in Firefox and it was working in IE7 (not sure as I haven't checked in while) but it doesn't work in IE6.

I would post up all the...
Forum: PHP 05-30-2007, 12:09 AM
Replies: 68
Views: 2,791
Posted By iLLin
Sure this I know will work. //Get the...

Sure this I know will work.


//Get the date and hour, 72 hours ago
$minus = strtotime("-72 hours");
$date = date("Y-m-d H:i:s", $minus);

$query = "DELETE FROM tblogin WHERE activated = 'N'...
Forum: PHP 05-29-2007, 11:43 PM
Replies: 68
Views: 2,791
Posted By iLLin
Only you would do a DELETE FROM instead of SELECT...

Only you would do a DELETE FROM instead of SELECT *
Forum: PHP 05-29-2007, 11:23 PM
Replies: 4
Views: 682
Posted By iLLin
http://www.php.net and then do a search for array...

http://www.php.net and then do a search for array sort. You will be amazed at the results.
Forum: PHP 05-29-2007, 11:18 PM
Replies: 68
Views: 2,791
Posted By iLLin
So your deleting all rows that are not activated...

So your deleting all rows that are not activated from today?
Forum: PHP 05-29-2007, 11:03 PM
Replies: 68
Views: 2,791
Posted By iLLin
What is the date your looking for>?

What is the date your looking for>?
Forum: PHP 05-29-2007, 11:00 PM
Replies: 68
Views: 2,791
Posted By iLLin
You wouldn't it would replace all your code with...

You wouldn't it would replace all your code with that one query. Obviously you will put in some code to get whatever date you want to delete from but thats it.
Forum: PHP 05-29-2007, 10:46 PM
Replies: 68
Views: 2,791
Posted By iLLin
Not as "field names" the $certain_date is a...

Not as "field names" the $certain_date is a value. Ok lets say for instance you want to delete ALL records that are not activated since yesterday

$query = "DELETE FROM tblogin WHERE activated =...
Forum: PHP 05-29-2007, 10:43 PM
Replies: 27
Views: 1,881
Posted By iLLin
Ok lets clean this up as your doing things...

Ok lets clean this up as your doing things multiple times. I am taking this as your working code.


<?php
//open conn db

$mineral_country = array();
$query_country_name = "select CountryName...
Forum: PHP 05-29-2007, 10:30 PM
Replies: 68
Views: 2,791
Posted By iLLin
$query = "DELETE FROM tblogin WHERE $activated =...

$query = "DELETE FROM tblogin WHERE $activated = 'N' AND $DateJoined <= $when";


Did I use variables in my query for field names? And your $when is a timstamp where as your DatJoined field is...
Forum: PHP 05-29-2007, 10:16 PM
Replies: 68
Views: 2,791
Posted By iLLin
You don't need to do a select * and loop through...

You don't need to do a select * and loop through your results. Just do ONE query to delete out all the old records after the time you specify, or before the time you specify. You basically just...
Forum: PHP 05-29-2007, 10:14 PM
Replies: 6
Views: 740
Posted By iLLin
$sql3 = "SELECT DISTINCT ArtistN FROM artdata...

$sql3 = "SELECT DISTINCT ArtistN FROM artdata WHERE Approved Like 'yes' ORDER BY ArtistN ASC";
$result3 = mysql_query($sql3);
$numRows3 = mysql_num_rows($result3);
$Artistnumarray = array();
for...
Showing results 1 to 25 of 500

 
Forum Jump

All times are GMT +1. The time now is 12:27 PM.