Search found 17 matches

by Sniper007
Fri May 21, 2004 11:30 pm
Forum: Databases
Topic: Executing SQL queries from the DOS prompt
Replies: 3
Views: 360

Alternate Solution

Thanks, but I think I'm going to execute lines off of php.exe using CLI... Then just use whatever .php files I want that contain the SQL commands.

Code: Select all

C:\swamp\php\cli\php.exe -f C:\swamp\www\myphp.php
by Sniper007
Fri May 21, 2004 4:58 pm
Forum: Databases
Topic: Stumped by no column values
Replies: 8
Views: 695

You're right!

SON OF A B$#@&!
There it is, right infront of me.

:oops:

ALL HAIL FEYD AND TIM!!!
by Sniper007
Fri May 21, 2004 2:59 pm
Forum: Databases
Topic: Stumped by no column values
Replies: 8
Views: 695

Advice Taken, Results Posted

The print_r($row) returns this (concerning the OutPut value): ...Bronze Dagger [1] => 1 [Output] => 1 [2] => Black Smith... But when I do an echo RIGHT after that print_r command, it doesn't show ANY value for the output! I'm stumped. Here's my code now (with suggestions incorporated): $sql = 'SELEC...
by Sniper007
Thu May 20, 2004 10:53 pm
Forum: Databases
Topic: Stumped by no column values
Replies: 8
Views: 695

Stumped by no column values

$sql = 'SELECT * FROM Recipies WHERE 1'; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)){ $RItemName = $rowї'ItemName']; $ROutPutX = $rowї'OutPut']; ... When I echo $ROutPutX; it puts out nothing. I get no error, and I have DOZENS of other columns...
by Sniper007
Thu May 20, 2004 7:57 pm
Forum: PHP - Code
Topic: Executing PHP code from a command line
Replies: 1
Views: 874

Executing PHP code from a command line

Is there any way to execute a chunk of PHP code (to alter an SQL database I have) using a command line? Like, is there some php.exe I can run with some parameters or something?
by Sniper007
Wed May 19, 2004 12:25 pm
Forum: Databases
Topic: Executing SQL queries from the DOS prompt
Replies: 3
Views: 360

Executing SQL queries from the DOS prompt

Please, be gentle on me. I'm spoiled by phpMyAdmin. I've never had to run a command from the DOS prompt before... I am wondering how / if there is a way to run SQL commands and queries from the DOS prompt in WinXP. Specifically, a LOAD DATA INFILE command. What exactly is the syntax, for a command l...
by Sniper007
Wed May 19, 2004 8:49 am
Forum: PHP - Code
Topic: Comparing timestamps: Finding the oldest
Replies: 6
Views: 603

Great! Thanks!

"I love all you guys!! ...Especially you... aaaaahhh... AHAHAHAHA!"

-Tommy Boy
by Sniper007
Tue May 18, 2004 9:25 pm
Forum: PHP - Code
Topic: Comparing timestamps: Finding the oldest
Replies: 6
Views: 603

Comparing timestamps: Finding the oldest

If I had 10 variables that were holding 10 different timestamps, and I wanted to compare them to find out which variable had the oldest timestamp, how would I go about that?
by Sniper007
Sun May 16, 2004 10:43 am
Forum: Databases
Topic: CRAZY phpMyAdmin Behavior with SQL
Replies: 7
Views: 950

Cache Size

My Temp Internet Files allowance is 625 Megs.

...Looking into MySQL Front.
by Sniper007
Sun May 16, 2004 12:08 am
Forum: Databases
Topic: Replace from a file Syntax
Replies: 2
Views: 352

Slowly but surely

Alright, here's what I did: I changed the two of the three column datatypes from TEXT to VARCHAR (the third column is datatype INT) so that I could create one index that had all three column fields in it. For some reason, I was not able to create a multiple column index when the fields were of datat...
by Sniper007
Sun May 16, 2004 12:08 am
Forum: Databases
Topic: CRAZY phpMyAdmin Behavior with SQL
Replies: 7
Views: 950

Tried I-net cache settings - no luck

Yes, that was one of the first things I tried, but unfortunately it didn't work. It's getting so bad where I don't even know what is in my database anymore. Tables are showing up that I deleted... But when I try to delete them again phpMyAdmin tells me it's not there... NO CRAP its not there! WHY AR...
by Sniper007
Sat May 15, 2004 11:31 pm
Forum: Databases
Topic: CRAZY phpMyAdmin Behavior with SQL
Replies: 7
Views: 950

CRAZY phpMyAdmin Behavior with SQL

Alright, I was able to ignore it at first, but NOW it's really starting to get on my NERVES. I can create a table just fine in my database. And when I try to make CHANGES to the STRUCTURE of the table, they take effect... but the the changes are not always DISPLAYED under the STRUCTURES tab in phpMy...
by Sniper007
Sat May 15, 2004 9:25 pm
Forum: PHP - Code
Topic: HTML Forms not passing data to PHP
Replies: 5
Views: 671

THANK YOU!!! It worked!
:D

The only quirk is that I needed to type in the full web address to the action.php file. Otherwise it kept on displaying as a text document in my browser, showing all the code.
by Sniper007
Fri May 14, 2004 5:37 pm
Forum: Databases
Topic: Replace from a file Syntax
Replies: 2
Views: 352

Replace from a file Syntax

I'm trying to use the replace function to do exactly what is described in the manual. The twist is that I want to replace the rows with data that is in a text file. The manual seems only to indicate how to replace one row at a time: REPLACE їLOW_PRIORITY | DELAYED] їINTO] tbl_nam...
by Sniper007
Fri May 14, 2004 5:11 pm
Forum: PHP - Code
Topic: HTML Forms not passing data to PHP
Replies: 5
Views: 671

HTML / PHP Form code

Alright, here it is, straight out of the PHP manual: <form action="action.php" method="post"> Your name: <input type="text" name="name" /> Your age: <input type="text" name="age" /> <input type="submit" /> </form> There is nothing...