Search Results

Showing results 1 to 12 of 12
Search took 0.01 seconds.
Search: Posts Made By: buddylee17 ; Forum: MySQL and child forums
Forum: MySQL Apr 2nd, 2009
Replies: 6
Views: 630
Posted By buddylee17
Well, if the uid is a numeric datatype, you could use:

SELECT COUNT(uid) FROM tracking WHERE uid = $trackuid

If not numeric, you'll have to surround with quotes:

SELECT COUNT(uid) FROM...
Forum: MySQL Apr 2nd, 2009
Replies: 1
Views: 435
Posted By buddylee17
I will restrain from lecturing on normalization (http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html). I assume you've probably never heard of it but I'd highly recommend looking...
Forum: MySQL Apr 2nd, 2009
Replies: 6
Views: 630
Posted By buddylee17
Count is an aggregate function. It's not going to return anything from the database. It's only going to count the number of records matching your criteria and return the total.
Forum: MySQL Jan 10th, 2009
Replies: 3
Views: 535
Posted By buddylee17
You could start off with basic data validation. Pumping all of the fields into the db without checking even one of them? That's just asking for injection.
Forum: MySQL Oct 7th, 2008
Replies: 5
Views: 1,024
Posted By buddylee17
Post the code and error messages.
Forum: MySQL Aug 19th, 2008
Replies: 2
Views: 578
Posted By buddylee17
Do you have phpmyadmin? If so, create a table with the appropriate rows, save the excel file as a csv, and import to the table.
Forum: MySQL Aug 19th, 2008
Replies: 1
Views: 1,160
Posted By buddylee17
Yes, the best way is to just save the image path. You can save the image into the database as a blob but, most say it's a bad idea. Have a read here (http://www.phpriot.com/articles/images-in-mysql)...
Forum: MySQL Aug 11th, 2008
Replies: 3
Views: 677
Posted By buddylee17
Forum: MySQL Aug 11th, 2008
Replies: 3
Views: 677
Posted By buddylee17
Datetime is in the YYYY-MM-DD HH:MM:SS format so, Friday, August 28, 2015 at 8:00PM would be:
2015-08-28 20:00:00
Forum: MySQL Jul 29th, 2008
Replies: 6
Solved: MySql Vs Oracle
Views: 2,499
Posted By buddylee17
Yes, Oracle is a beast and a memory hog. My favorite comparison was made by Charles Phillips, President of Oracle:
"We're both in the transportation business," Mr Phillips said. "We have a 747, and...
Forum: MySQL Jul 27th, 2008
Replies: 6
Solved: MySql Vs Oracle
Views: 2,499
Posted By buddylee17
You shouldn't compare the two. It's like comparing a school bus (Oracle) to a Corvette (MySql). Oracle can deliver tons of data in a reasonable amount of time consistently. MySql can deliver smaller...
Forum: MySQL Jun 20th, 2008
Replies: 2
Views: 791
Posted By buddylee17
Could be wrong but I think this will require some type of middleware like PHP to communicate between them.
Showing results 1 to 12 of 12

 


About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC