No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
7 Posted Topics
Ok this is what my table structure looks like: username varchar(20) eadd varchar(40) for email addresses bday varchar(4) everyone is posting mmdd emailques varchar(2) they answer yes or no I want my query statement to tell me what birthdays are today and as a bonus email them on their birthday. …
Here is my code: [code] if ($num = $i) { echo ("<p align='left'>It's everyone's unbirthday today!</p><br>") } else { while ($i < $num) { [B]$name=[/B]mysql_result[B]($result,$i,[/B][COLOR=green]"[/COLOR]username[COLOR=green]"[/COLOR][B]);[/B] [B]$day=[/B]mysql_result[B]($result,$i,[/B][COLOR=green]"[/COLOR]bday[COLOR=green]"[/COLOR][B]);[/B] [B]$city=[/B]mysql_result[B]($result,$i,[/B][COLOR=green]"[/COLOR]lpcity[COLOR=green]"[/COLOR][B]);[/B] [B]$email=[/B]mysql_result[B]($result,$i,[/B][COLOR=green]"[/COLOR]emailques[COLOR=green]"[/COLOR][B]);[/B] echo [COLOR=green]"[/COLOR]<br>[COLOR=green]Username: $name[/COLOR]<br>[COLOR=green]Birthday: $day[/COLOR]<br>[COLOR=green]City From: $city[/COLOR]<br>[COLOR=green]On Emailing?: $email[/COLOR]<br><br><hr><br>"; $i++; } echo("<p align='center'><font face='Arial' size='[COLOR=green]3[/COLOR]' color='#FF0000'>If your information is wrong please email [email protected] …
Here is a piece of a redirect from one of my pages: [QUOTE] [COLOR=#008000]//insert new record [/COLOR][B]$pfw_result[/B] [B]=[/B] mysql_query[B]($pfw_strQuery);[/B] [B][COLOR=#0000f0]if[/B][/COLOR] [B](!$pfw_result)[/B] [B]{[/B] die[B]([/B][COLOR=#008000]'Invalid query: '[/COLOR] [B].[/B] mysql_error[B]());[/B] [B]}[/B] mysql_close[B]($pfw_link);[/B] echo[B]([/B][COLOR=#008000]"[/COLOR]<p align='center'><font face='Arial' size='[COLOR=#0000f0]3[/COLOR]' color='#FF0000'>[COLOR=#008000]Congrats, you are on the list![/COLOR]</font></p>[COLOR=#008000]"[/COLOR][B]);[/B] include[B]([/B][COLOR=#008000]"footer.html"[/COLOR][B]);[/B] [COLOR=#800000]?>[/COLOR] [COLOR=#800000][/quote][/COLOR] [COLOR=#800000]The last part just gives them a closing …
I want to be able to enter an employee number from my system and have it delete. I have a form that prompts the user to enter an employee number. That seems to be working fine. <html><TD WIDTH="29%" HEIGHT="60"><DIV ALIGN="LEFT"><BR>Input the Reference, to make sure we have the right one:<BR><BR><FONT …
[quote=eldoc;329320]Hi My hosting company no longer permits connection to any port other than standard ones and I am in the middle of a project that is best solved via sockets (I think). I use a mysql database and connect to it via php. I need 4 people to use client …
Here is my code I need help with: [code] mysql_connect[B]($host,$username,$password);[/B] [B]@[/B]mysql_select_db[B]($database)[/B] [B]or[/B] die[B]([/B] [COLOR=#008000]"Unable to select database"[/COLOR][B]);[/B] [B]$query[/B] [B]=[/B] [COLOR=#008000]"SELECT DISTINCT info647_crse . crsdesc , info647_crse . crsprice FROM info647_emp JOIN info647_reg USING ( empno ) JOIN info647_off USING ( offerno ) JOIN info647_crse USING ( crsno ) WHERE empno …
i need some help this script isn't working for me can anyone here help? This is a school project i am working on. The error code myscript gives me is at the while statement not sure what is up. [www.johnpedroza.com/policetrainer/iinvoice.php](http://www.johnpedroza.com/policetrainer/iinvoice.php) <? @$empno = ($_POST['empno']); include("iinvoice1.php"); @$host = "****"; @$username = …
The End.