Re: [php-list] MySql problems

2008-10-12 Thread Daniel Israel
On Oct 11, 2008, at 1:08 PM, chellieclk wrote: Hi Everyone. I am having a bit of a mysterious error that I cannot find a solution to. I can manually assign a value to $uid and everything works. With a var though, I keep getting an error about mysql _query not having a valid resource.

[php-list] Re: mysql LIMIT / COUNT

2008-10-12 Thread bryan_is_south
--- In php-list@yahoogroups.com, [EMAIL PROTECTED] wrote: Hi all, I have a quick question. If I am getting a small range of results using the mysql LIMIT function then how can I tell how many results there would have been if I didn't use LIMIT with the same query? Thanks. --- The

[php-list] New database modeling

2008-10-12 Thread Junior Grossi
Hi all, I've read the book 'Practical Web 2.0 Applications with PHP' and in that book the author uses a different database modeling. I'll give you an example, if you have a 'users' table with a lot of columns like, first name, last name, country, food, etc... He suggests that you create 2 tables,

Re: [php-list] New database modeling

2008-10-12 Thread Wade Smart
Grossi [EMAIL PROTECTED] 20081012 1306 GMT-6 I have something similar lately and it too relied heavily on objects (which I have to admit I have not really got into - though I should) and it looked like it would definitely help out in certain situations. But Im not sure I understand what you said

Re: [php-list] New database modeling

2008-10-12 Thread Daniel Israel
On Oct 12, 2008, at 11:09 AM, Wade Smart wrote: 20081012 1306 GMT-6 I have something similar lately and it too relied heavily on objects (which I have to admit I have not really got into - though I should) and it looked like it would definitely help out in certain situations. But Im

[php-list] Zend_Controller_Router_Route question

2008-10-12 Thread Junior Grossi
Hi all, I want to change my url site... I have http://mysite.com/posts/show?id=1234 I want to change to http://mysite.com/posts/some-title-name I have looked the Zend site and I think that I have to do this: $route = new Zend_Controller_Router_Route( 'posts/:title', array(

Re: [php-list] New database modeling

2008-10-12 Thread Pete
In message [EMAIL PROTECTED], Wade Smart [EMAIL PROTECTED] writes Junior Grossi wrote: This will add another row on 'users_profile' table: Ah, that makes more sense. Hu. Im going to get that book because that looks like it would be super helpful. :) Wade Not sure that I like the idea.

[php-list] mysql LIMIT/COUNT again

2008-10-12 Thread listgroups08
Hi, I am using the following query to get results from a mysql database. $query = 'SELECT * FROM Assignments, Classes, Instructors, Departments'; $query .= ' WHERE Assignments.ClassID = Classes.ClassID'; $query .= ' AND Classes.DepartmentID = Departments.DepartmentID'; $query .= ' AND