Forum: SQL

Hi All What's the most efficient way to see if a table contains more than 30 rows? Obviously "select count(*) > 30" will work but will this count every row before doing the comparison? I suspect it does and was wondering if there was a better way. I'm using SQL Server 2008. Thanks ...

Don't know too much about MySQL but I have managed to create a SIGN UP form and was able to save the input to a database. NOW, I need to know how I should add the databases for the CONTACT FORM and LOGIN FORM. Should I use the same database for all the forms and just add tables? Should...

Hello, I want to create a trigger for the following table : This is my code : CREATE TABLE INVOICE ( Invoice_id number CONSTRAINT Invoice_id_pk PRIMARY KEY,

I was recomended to use the code as bellow to check if one of the condition not selected for example what if somebody will select just Mark=toyota and will leave empty Model and Year. $where = array(); $whereclause = ''; if (!empty($mark)) { $where = "a.mark = '$mark'"; } if...

Hi Good day! I have 2 tables for my dtr database. first the employees where all the data of employee was save. employees fields: EmployeeID Lastname

According to what i had read, mysqli is an alternative to the standard mysql but it is an optional choice.. however i noted that some methods are deprecated in normal mysql, such this:http://php.net/manual/en/function.mysql-fetch-array.php... So, this means that mysqli will totally replace...

So, im new around here and not quite sure if this should go in the php or the sql seeing is how its a bit of both, but my questions pertains to why my perpare statment doesnt work. Onto the question. My first prepare statments for the select works as should. The result is returned properly. So if...

Hi everyone. I have list of postcodes. And what i'm trying to do is get a listing of similar poscodes only. My Code: $postcode1 = ereg_replace('', '', $postcode); SELECT * FROM coverparked WHERE postcode LIKE '$postcode1%' ORDER BY postcode

Ok, so I've pinpointed the problem to this spot: $query = "INSERT INTO project(`id`, `name`, `summary`, `client_id`, `detail`, `link`, `scope`, `type`, `progress`, `status`) VALUES (NULL, 'Project Title', 'Summary of Project', '2', 'Details', NULL, 'Scope Example', 'project type', NULL, 1)" ...

Hello, Need some help because i haven't done any programing in years and need to solve some small problem i've fixed before but i have no idea how i did it back then. In mysql, i have a table where one column (set as date, also primary key) is prefilled with all dates of the year (standard...