Search found 21 matches

by THEMADGEEK
Thu Feb 26, 2004 12:16 pm
Forum: PHP - Code
Topic: Javascript (window.open) with a PHP Variable
Replies: 1
Views: 429

Javascript (window.open) with a PHP Variable

I am attempting to open a new window using javascript while passing a PHP variable to that window. I've tried several different ways to no avail. Here is my latest try... <script language="JavaScript" type="text/javascript"> <!-- function popUpCenteredWindow() &#123; var win2...
by THEMADGEEK
Thu Feb 12, 2004 10:35 am
Forum: Databases
Topic: COUNT Query NOT working
Replies: 6
Views: 832

OK That cleared up the whole 'date' part of my query. Thanks, for some reason I was swapping the month and day. Duh... Moving on, I still get wierd numbers returned when I do counts. I have a page where I want to count rows with different requirements. I have saved each query in it's own file then I...
by THEMADGEEK
Wed Feb 11, 2004 10:50 am
Forum: Databases
Topic: COUNT Query NOT working
Replies: 6
Views: 832

Still didn't work. However I think I've narrowed the problem down and it may be in the database itself rather than the code. Everything works except the date... I currently have the field type set as 'date' and it auto-formats as "2004-02-11" and it seems that when I do a < or > than a dat...
by THEMADGEEK
Tue Feb 10, 2004 4:59 pm
Forum: Databases
Topic: COUNT Query NOT working
Replies: 6
Views: 832

For some reason that returns a blank screen...
by THEMADGEEK
Tue Feb 10, 2004 3:07 pm
Forum: Databases
Topic: COUNT Query NOT working
Replies: 6
Views: 832

COUNT Query NOT working

I am trying to do a COUNT on records that match a certain criteria and I keep getting a "0" and I know there are at least 2 that match. Here it is, I can't see what's wrong I've used this formula before with different specifications. FYI - $today = date(Y-m-d); $sql = "SELECT COUNT(ga...
by THEMADGEEK
Tue Jan 27, 2004 5:39 pm
Forum: PHP - Code
Topic: display image as variable
Replies: 9
Views: 911

Thanks guys! Done...
by THEMADGEEK
Tue Jan 27, 2004 5:30 pm
Forum: PHP - Code
Topic: Can it be done? build a JS array with PHP?
Replies: 2
Views: 279

Sorry to be a nincompoop but you lost me at "$arr =" lol Where does the $arr = array("one","two","three","four","five"); come from? I need to be able to add and remove arrays dynamically so when parks and fields are added/removed it updates...
by THEMADGEEK
Tue Jan 27, 2004 12:04 pm
Forum: PHP - Code
Topic: Can it be done? build a JS array with PHP?
Replies: 2
Views: 279

Can it be done? build a JS array with PHP?

I am attempting to build a JS array using PHP output from a database to build the actual lines of the array. Everything is actually working so far except for two things. Here's an example (pertinent info) of the final JS array I want to build: <script language=JavaScript> var 1Array = new Array(&quo...
by THEMADGEEK
Mon Jan 26, 2004 9:26 pm
Forum: PHP - Code
Topic: display image as variable
Replies: 9
Views: 911

Thanks Toast-Man that did it. I totally spaced the single quote string thing... obviously!

Thanks again!
by THEMADGEEK
Mon Jan 26, 2004 5:57 pm
Forum: PHP - Code
Topic: display image as variable
Replies: 9
Views: 911

That's not it, that was a typo when I put it in the forum... Let me go a little deeper... This is supposed to place a checkmark (image) in a calendar day when that day has been selected in the database (all that is working properly). So after I query the db I set the variable and do the if statement...
by THEMADGEEK
Mon Jan 26, 2004 5:33 pm
Forum: PHP - Code
Topic: display image as variable
Replies: 9
Views: 911

display image as variable

I am trying to display an image when a certain value = True but I am having no luck it displays the $variable_name not the image. What am I doing wrong? $image = "<img src="../images/checkmark.gif">"; if ($d1 == "y") &#123; $m1 = '$image; &#125; echo "$m1&q...
by THEMADGEEK
Wed Jan 21, 2004 1:43 pm
Forum: Databases
Topic: Truncated MySQL Values
Replies: 1
Views: 335

Truncated MySQL Values

I am building a database and am currently having a time with the output being truncated. If I look in the database itself everything is great but when I do any output it truncates at any space. For instance the field full_name has 'Joe User' and gets returned as 'Joe' or phone numbers get returned a...
by THEMADGEEK
Tue Jan 20, 2004 3:01 pm
Forum: PHP - Code
Topic: Pleas check this query code I can't see what's wrong
Replies: 2
Views: 592

Pleas check this query code I can't see what's wrong

Here is a query I am working on that pulls data from 2 different tables and sorts out the results without duplicating the division field. I can't tell what's wrong. Maybe I've been looking at it too long... <? require("includes/connect.inc"); $connection = mysql_connect("$DbHostName&q...
by THEMADGEEK
Thu Jan 15, 2004 5:59 pm
Forum: PHP - Code
Topic: [SOLVED] Nested variables that return another variable
Replies: 6
Views: 697

That did it markl999!

Thanks so much both of you...

:D
by THEMADGEEK
Thu Jan 15, 2004 5:21 pm
Forum: PHP - Code
Topic: [SOLVED] Nested variables that return another variable
Replies: 6
Views: 697

LOL why am I not surprised... I've been doing the same thing and I'm working on it! I probably am going about it longhand as that is my luck Here's some snippets to maybe help get rid of the pink elephant... Here is what I am getting out of the DB: while ($row = mysql_fetch_array($result)) &#123...