Forum: SQL

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

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...

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...

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...

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

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,

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 ...